Coding References

Setup docker in Linux Mint 20

2020-11-24T22:49:00.005-08:00

Setup docker in Linux Mint 20 ( Command sequence)

===============================

sudo apt-get update

sud apt-get upgrade

sudo apt install docker.io -y

sudo systemctl start docker

sudo systemctl enable docker

sudo systemctl status docker

sudo reboot

sudo systemctl status docker # ensure that the docker is running after reboot

docker -v

sudo docker run hello-world

sudo apt install docker-compose -y

docker-compose -v

docker container ls

#(if you get permission error execute the following commands)

sudo groupadd docker

sudo gpasswd -a ${USER} docker

su - $USER

sudo reboot

docker container ls

Fedora Development Machine .net core + angular 9

2020-07-08T01:55:00.002-07:00

Things to do after installing fedora 32 for .net core and Angular 9 development

Install build-essential `sudo dnf install make automake gcc gcc-c++ kernel-devel`
Install node version manager (https://github.com/nvm-sh/nvm) and install nvm eg: `nvm install 12.18.2`
Install visual studio code and plugins (https://mycodingreferences.blogspot.com/2020/07/visual-studio-code-plugins-for-angular.html)
Install .net core https://docs.microsoft.com/en-gb/dotnet/core/install/linux-fedora && https://docs.microsoft.com/en-gb/dotnet/core/install/linux-fedora#fedora-32-
Now Install .net tool for entity framework `dotnet tool install --global dotnet-ef`
Install bash-gitprompt ref here -> https://github.com/magicmonty/bash-git-prompt
install xclip
Generate keypair for ssh access to github / bitbucket issue command `ssh-keygen ` and generate key pair , `cat id_rsa.pub` and copy public key and update gitbub ssh public key ref :: https://support.atlassian.com/bitbucket-cloud/docs/set-up-an-ssh-key/ or https://docs.github.com/en/github/authenticating-to-github/generating-a-new-ssh-key-and-adding-it-to-the-ssh-agent
Update bashrc file with `ssh-add ~/.ssh/id_rsa`
Install gitg / git-cola
npm install -g @angular/cli

Visual Studio Code Plugins for Angular + .net core development

2020-07-08T00:34:00.003-07:00

My typical VSCode / VSCodium plugins


Angular files -> https://marketplace.visualstudio.com/items?itemName=alexiv.vscode-angular2-files
Angular language service -> https://marketplace.visualstudio.com/items?itemName=Angular.ng-template
Angular Snippets -> https://marketplace.visualstudio.com/items?itemName=johnpapa.Angular2
Angular2-Switcher -> https://marketplace.visualstudio.com/items?itemName=infinity1207.angular2-switcher
Auto close tag -> https://marketplace.visualstudio.com/items?itemName=formulahendry.auto-close-tag
Auto rename tag ->https://marketplace.visualstudio.com/items?itemName=formulahendry.auto-rename-tag
Prettier
Bracket Pair Colorizer2 ->  https://marketplace.visualstudio.com/items?itemName=CoenraadS.bracket-pair-colorizer-2
Indent-rainbow -> https://marketplace.visualstudio.com/items?itemName=oderwat.indent-rainbow
Nuget Gllery  https://marketplace.visualstudio.com/items?itemName=patcx.vscode-nuget-gallery
TSList plugin https://marketplace.visualstudio.com/items?itemName=ms-vscode.vscode-typescript-tslint-plugin
https://marketplace.visualstudio.com/items?itemName=msjsdiag.debugger-for-chrome

Fedora 32 Setting up Citrix workspace client

2020-07-08T00:23:00.002-07:00

Installing and settingup citrix workspace on Fedora 32 in case you are facing issues with certificate error (SSL Error 61: You have not chosen to trust 'Certificate Authority)

Download the latest version of citrix workspace app for linux form here https://www.citrix.com/en-au/downloads/workspace-app/linux/workspace-app-for-linux-latest.html
Direct download lik -> https://downloads.citrix.com/17904/ICAClient-rhel-20.06.0.15-0.x86_64.rpm?__gda__=1594195198_18044945221df16b768c3db047809453
Open termial and navigate to `Downloads` folder and issue the command `sudo rpm -i ICAClient-rhel-13.10.0.20-0.x86_64.rpm`
Download Server certificate -> (GoDaddy Secure Server Certificate (Intermediate Certificate) - G2) download .crt format https://ssl-ccp.godaddy.com/repository/gdig2.crt
Open up terminal and issue the command and navigate to `Downloads` folder and issue the command `sudo su` make the commandline as root user
followed by copying the certificate as admin user to citrix certificate store `cp gdig2.crt /opt/Citrix/ICAClient/keystore/cacerts`
and then issue the command /opt/Citrix/ICAClient/util/ctx_rehash

references :: https://support.citrix.com/article/CTX231524

Docker Commands

2017-09-02T17:04:00.000-07:00

Basic Docker Commands

Commands:
- docker run <Image> (Create container from an image and start container). With every docker run docker will will create new copies of container from image and run it . For example, if you issue docker run 3 times then 3 identical docker containers will get created and running on top of docker.
- docker start <name|id> (start only)
- docker stop <name|id>(stop the container with the
- docker ps [-a include stopped containers] (List all the containers )
- docker rm <name|id> (removes/deletes a container)

partition by clause

2012-10-23T03:48:00.001-07:00

An example using using partition by clause

References :http://msdn.microsoft.com/en-us/library/ms189461.aspx

The following example shows using the OVER clause with ROW_NUMBER function to display a row number for each row within a partition. The ORDER BY clause specified in the OVER clause orders the rows in each partition by the column Category. The ORDER BY clause in the SELECT statement determines the order in which the entire query result set is returned.

Question : I need to get one item each from a category

Answer:
select* from
(
select

row_number() over(partition by Category order by ItemName) AS IDv,*

from
(

select 'Apple' ItemName,'Fruits'Category
UNION ALL
select 'Banana' ItemName,'Fruits'Category
UNION ALL
select 'Turnip' ItemName,'Vegs'Category
UNION ALL
select 'Tomato' ItemName,'Vegs'Category
UNION ALL
select 'Eggplant' ItemName,'Vegs'Category
) A
)B where b.idv=1

Ubuntu Software Center Crashing

2012-09-28T21:20:00.001-07:00

Symptom : Ubuntu Software center is unable to open and provide some internal error/unresolved error

You would see the following error message

E:Encountered a section with no Package: header, E:Problem with MergeList /var/lib/apt/lists/sg.archive.ubuntu.com_ubuntu_dists_precise_main_binary-i386_Packages, E:The package lists or status file could not be parsed or opened.'

Where : sg would be the country, will be us,ca in case of USA or Canada respectively in case of respective countries .

You could refer the thread : http://ubuntuforums.org/showthread.php?t=1750755

Following solved my issues

# First delete all of the previously available listings
sudo rm /var/lib/apt/lists/* -vf

# And then use apt-get to rebuild your package listings
sudo apt-get update

Probing element in app.config + Post build event to copy multiple files

2012-07-13T00:28:00.000-07:00

Probing is quite good to arrange assemblies in case if you have lots of private libraries referred to your executables and which are there under a probing path mentioned under the probing element in app.config file
When I started developing an executable , which demands to split its logic among several dlls and which are part of same solution and are deployed using simple xcopy method I found it quite convenent to use probing
path combined with postbuild script under project properties section of the main executable file .

Here in my example project, I have a dll project and an executable , which has been refered by the executable project in the same solution
The following post-script build script save me from copying the required files into Binaries\Libs folder strcuture under the current selected
build method(Release/Debug) . This is quite convenient in case to perform an xcopy of your binaries to the deployment folder. All the unwanted .vshost , pdb,manifest etc files are discarded and the probing directory
will get created under and the dll's are copied under the mentioned private probing path(s)

xcopy /Y $(ProjectDir)$(OutDir)*.dll $(ProjectDir)$(OutDir)Binaries\Libs\
xcopy /Y $(ProjectDir)$(OutDir)$(TargetFileName) $(ProjectDir)$(OutDir)Binaries\
xcopy /Y $(ProjectDir)$(OutDir)$(TargetFileName).config $(ProjectDir)$(OutDir)Binaries\

The app config section mentioned below make sure that the dll's are under the private path mentioned under it . It is possible to use multiple probing paths by separating them with (;) eg: bin;Libs\DataLib;ConfigLib

<runtime>
<assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
<probing privatePath="Libs" />
</assemblyBinding>
</runtime>

Download the sample application source code here http://bit.ly/N4MneU

References
http://msdn.microsoft.com/en-us/library/823z9h8w.aspx (read about probing path)

WatiN+CassiniDev project Provide automated testing of your asp.net webforms

2012-07-03T21:59:00.000-07:00

WatiN (pronounced as What-in) http://watin.org/
WatiN is developed in C# and aims to bring an easy way to automate tests with Internet Explorer and FireFox using .Net
Read code project article on WatiN and nUnit http://bit.ly/Mv1RZj

CassiniDev project
http://cassinidev.codeplex.com/
CassiniDev project is to provide an open platform for developing a robust ASP.Net web server
CassiniDev is packaged as a standalone WinForms GUI application, a console application and library assembly suitable for self hosting and in automated testing scenarios including continuous integration and as a 100% compatible drop-in replacement for the Visual Studio 2008/2010 development server.

Combining CassiniDev project + WatiN + VisualStudioTestProject OR nUnit + your asp.net web application project = Automated asp.net webform testing without providing a moke object for your asp.net page

I have made one sample application which can be downloaded by accessing URL http://bit.ly/MvcvPS (Google drive)
* Extract the folder structure under D:\ or change the path in the test project
* Used Visual studio Team system 2008

SQL Statements

2012-04-08T21:07:00.003-07:00

--1) Reseed Indentity column
--drop table TABLE_NAME
if exists (select * from sys.objects where name='TABLE_NAME')
drop table TABLE_NAME
create table TABLE_NAME (ID int primary key identity (1,1),Increment int )

insert into TABLE_NAME (Increment ) values(1)
insert into TABLE_NAME (Increment ) values(1)
insert into TABLE_NAME (Increment ) values(1)
insert into TABLE_NAME (Increment ) values(1)
select 'Max of id is ' ,max(id) from TABLE_NAME
delete from TABLE_NAME

select 'Max of id after delete ', isnull(max(id),0) from TABLE_NAME
insert into TABLE_NAME (Increment ) values(1)
insert into TABLE_NAME (Increment ) values(1)
insert into TABLE_NAME (Increment ) values(1)
insert into TABLE_NAME (Increment ) values(1)
select 'Max of id after delete insert', max(id) from TABLE_NAME

--Reseed the Identity column with with one, so that the autoincremented
delete TABLE_NAME
DBCC CHECKIDENT (TABLE_NAME, RESEED, 1)

insert into TABLE_NAME (Increment ) values(1)
insert into TABLE_NAME (Increment ) values(1)
insert into TABLE_NAME (Increment ) values(1)
insert into TABLE_NAME (Increment ) values(1)
select 'Max of id after Reseed', max(id) from TABLE_NAME

--Or use Truncate table to reseed
Truncate table TABLE_NAME
go

--2) Wait after an operation
insert into TABLE_NAME (Increment) values(0)
select * from TABLE_NAME
go
update TABLE_NAME set Increment=Increment +1
print 'will update after 5 seconds'
go

--Wait delay example. The follwoing code induces a wit on the execution sequence in sql server
WAITFOR DELAY '00:00:05'
select * from TABLE_NAME

--Partition by example
--Rank() Row_number example
--Google for more explanation
UPDATE STATISTICS TABLE_NAME

select
*,
Rank() over(

partition by Rating
order by Person,App
) rank1
,
row_number() over(
partition by Rating
order by Person,App
) rank2

from
(
select 'Sam' as Person,'Angry birds'as App, 5 as Rating
union all
select 'Jane' ,'Angry birds', 2
union all
select 'Sam' ,'Ninja', 4
union all
select 'Jane' ,'Ninja', 4
union all
select 'Sam' ,'Ninja Guru', 5
union all
select 'Jane' ,'Ninja Guru', 5
union all
select 'Sam' ,'MyMaps', 1
union all
select 'Jane' ,'MyMaps', 3
union all
select 'Sam' ,'GMaps', 3
union all
select 'Jane' ,'GMaps', 4
) Ratings

GO

--Return multiple sql server rows as single comma seperated string
select
'ApprovedFruits are' Approved,
substring(
(
select
','+Fruit from
(
select 'Grapes' as Fruit
union all
select 'Mango'
union all
select 'Blue Berries'
union all
select 'Apple'
) T
for xml path('')
)
,2
,8000
) as FruitList

go

List of useful tools(Must have tools/Application)

2012-04-05T10:51:00.000-07:00

Snoop WPF (allows you to spy/browse the visual tree and change properties of a WPF UI)
http://bit.ly/HgOHYc

7zip ( Zipping utility that supports number of different compression and extraction format 7zip,.tar,.zip,.rar,.bz etc:.)
http://bit.ly/HQG6RC

Free download manager(Accelerate downloading of files by using sliced download and support built-in bit-torrent protocol which can be enabled/disabled, once it is disables we cannot download using .torrent files)
http://bit.ly/HgQ0ql

Winmerge Compare and merge plain text files or directories . read more here http://winmerge.org/

Libere office, replacement for MS Office http://www.libreoffice.org/download/

Unstopcopy (Copies files from a source , can be useful if you would like to read corrupted files from your old VCD/CD/DVD) http://bit.ly/HgRgti

Sysinternals Suit (Complete set of tools required to master windows) http://technet.microsoft.com/en-us/sysinternals/bb842062

Free English dictionary , select the word and press CTRL+ALT+W will make this application appear with the meaning and example of the word (http://wordweb.info/free/)

Fences : Arrange the desk top and make the desktop look cleaner (http://www.stardock.com/products/fences/)

Foxit reader: fast pdf reader compared to adobe reader ttp://www.foxitsoftware.com/Secure_PDF_Reader/

Free management ui for sql server database with auto-complete option http://www.snapfiles.com/get/emsmssqllite.html
http://www.sqlmanager.net/en/products/mssql/manager/download/5/769
and list of free DB tools offered @ http://bit.ly/HrjXFy

Best and free antivirus (Avira free) http://bit.ly/I2o6Sp

PDF Creator, ever want to save your documents, web page etc as PDF document ? Try PDF Creator http://sourceforge.net/projects/pdfcreator/ or cutepdf http://www.cutepdf.com/

Run multiple OS's in virtual machine, try VMWare Player/Virtual Box/MS Virtual PC

<Will continue...>
--keep posting.

.NET 4.5 Beta- WPF Changes

2012-04-05T10:04:00.000-07:00

The new Ribbon control, which enables you to implement a ribbon user interface that hosts a Quick Access Toolbar, Application Menu, and tabs.
The new INotifyDataErrorInfo interface, which supports synchronous and asynchronous data validation.
New features for the VirtualizingPanel and Dispatcher classes.
Improved performance when displaying large sets of grouped data, and by accessing collections on non-UI threads.
Data binding to static properties, data binding to custom types that implement the ICustomTypeProvider interface, and retrieval of data binding information from a binding expression.
Repositioning of data as the values change (live shaping).
Ability to check whether the data context for an item container is disconnected.
Ability to set the amount of time that should elapse between property changes and data source updates.
Improved support for implementing weak event patterns. Also, events can now accept markup extensions.

http://msdn.microsoft.com/en-us/library/bb613588(v=vs.110).aspx#ribbon_control

--Keep Posting.

How to find out to which table the column name belongs to ?

2012-04-05T08:25:00.000-07:00

How to find out to which table the column name belongs to ?

Ans:

SELECT TABLE_NAME=SYSOBJECTS.NAME,
COLUMN_NAME=SYSCOLUMNS.NAME,
DATATYPE=SYSTYPES.NAME,
LENGTH=SYSCOLUMNS.LENGTH
FROM SYSOBJECTS
JOIN SYSCOLUMNS ON SYSOBJECTS.ID = SYSCOLUMNS.ID
JOIN SYSTYPES ON SYSCOLUMNS.XTYPE=SYSTYPES.XTYPE
WHERE SYSOBJECTS.XTYPE=’U’
AND SYSCOLUMNS.NAME LIKE (‘COLUMNAME2FIND%’)
ORDER BY SYSOBJECTS.NAME,SYSCOLUMNS.COLID

--keep posting

Map more than one sitemap in asp.net webform

2012-04-05T08:21:00.000-07:00

How to map more than one sitemap in same asp.net webforms application ?

If there are multiple sitemap in an asp.net application eg: for your administrator you need to show entirely different set of menu compared to normal user .

After adding following entry in web.config will help in using multiple sitemap, you can have 2 different sitemap files named AppDefaultMap.sitemap and AdminSitemap.sitemap (remember by default we can have only one web.sitemap file in our project)

name="AppDefaultSiteMap"
type="System.Web.XmlSiteMapProvider"
siteMapFile="~/Application.sitemap" />

name="AdminSitemap"
type="System.Web.XmlSiteMapProvider"
siteMapFile="~/AdminMenu.sitemap" />

--keep posting.

Swap mouse button

2012-04-05T08:13:00.000-07:00

Code to swap the mouse button's action

using System;
using System.Runtime.InteropServices;
using System.Windows.Forms;

namespace MouseSwap

/// Summary description for Class1.
///

class Class1
{
[DllImport("user32.dll")]
static extern bool SwapMouseButton(bool fSwap);

///

/// The main entry point for the application.
///

[STAThread]
static void Main(string[] args)
{
bool b;
using(System.Threading.Mutex m=new
System.Threading.Mutex(true,
"ajai_myname_is Different _guid",out b))
{
if(!b)
{
MessageBox.Show("An Instance Already Runnig!","Error",
MessageBoxButtons.OK,MessageBoxIcon.Stop);
return;
}
Console.WriteLine("Swapping Primary Button From {0}",System.Windows.Forms.
SystemInformation.MouseButtonsSwapped?"Right to Left":"Left to Right");
SwapMouseButton(!System.Windows.Forms.SystemInformation.
MouseButtonsSwapped);
Console.WriteLine("Swapped\n\a\a \t \n Developed by Ajai NP");
}}
}
}

--keep posing