Asad's Technical Blog

2016-10-26T23:44:00.000-07:00

Docker Swarm in CentOS 7, learn by example

Installation

1. Download CentOS 7 Minimal install ISO Image and install it on 5 machines (Could be VMs as well)
2. Set static IP address on all nodes

$cat /etc/sysconfig/network-scripts/ifcfg-ens160

TYPE=Ethernet

BOOTPROTO=static

IPADDR=192.168.107.140

NETMASK=255.255.250.0

GATEWAY=192.168.104.1

DEFROUTE=yes

PEERDNS=yes

PEERROUTES=yes

IPV4_FAILURE_FATAL=no

IPV6INIT=yes

IPV6_AUTOCONF=yes

IPV6_DEFROUTE=yes

IPV6_PEERDNS=yes

IPV6_PEERROUTES=yes

IPV6_FAILURE_FATAL=no

NAME=ens160

UUID=012345678-2163-4bf8-850d-123456781234

DEVICE=ens160

ONBOOT=yes

3. $ service network restart
4. $ sysctl -w net.ipv4.ip_forward=1

Install Docker Service on all machines

5. $ curl -sSL https://get.docker.com/ | sh
6. sudo systemctl stop docker

Configure instance

7. Create the directories and configuration files as

$ mkdir -p /etc/systemd/system/docker.service.d/
$ vi /etc/systemd/system/docker.service.d/http-proxy.conf
[Service]
Environment="HTTP_PROXY=http://myProxy.com:80"

$ sudo systemctl daemon-reload

$ sudo systemctl show --property Environment docker

Environment="HTTP_PROXY=http://myProxy.com:80"

vi /etc/systemd/system/docker.service.d/docker.conf
[Service]
ExecStart=
ExecStart=/usr/bin/dockerd -H tcp://0.0.0.0:2375 -H unix:///var/run/docker.sock

8. Check and validate instance configurations

$ sudo systemctl restart docker
$ sudo docker login
$ sudo docker run hello-world

Machine Configurations and roles

IP Fucntion Description

192.168.107.140 Node 01 Running containers and storing images

192.168.107.141 Node 02 Running containers and storing images

192.168.104.236 Node 03 Running containers and storing images

192.168.107.142 Consul 01 & Management 01 Consul: Discovery Background, Management: manage and access the Docker Swarm

192.168.104.235 Node 04 & Management 02 Running containers and storing images, Management: manage and access the Docker Swarm

IP	Fucntion	Description
192.168.107.140	Node 01	Running containers and storing images
192.168.107.141	Node 02	Running containers and storing images
192.168.104.236	Node 03	Running containers and storing images
192.168.107.142	Consul 01 & Management 01	Consul: Discovery Background, Management: manage and access the Docker Swarm
192.168.104.235	Node 04 & Management 02	Running containers and storing images, Management: manage and access the Docker Swarm

Consul Instance Configuration

To keep things simple, we run a single consul daemon on the same host as one of the Swarm managers.

Use SSH to connect to the consul0 instance.

$ ifconfig

From the output, copy the eth0 IP address from inet addr.

Paste the launch command into the command line:

sysctl -w net.ipv4.ip_forward=1

$ sudo docker run -d -p 8500:8500 --name=consul progrium/consul -server -bootstrap

Enter docker ps.

From the output, verify that a consul container is running.

Management Instances Configuration

ssh to manager 01
$ sysctl -w net.ipv4.ip_forward=1
docker run -d -p 4000:4000 swarm manage -H :4000 --replication --advertise 192.168.107.142:4000 consul://192.168.107.142:8500
ssh to manager 02
$ ifconfig
Start the secondary Swarm manager using following command.
sysctl -w net.ipv4.ip_forward=1
$ sudo docker run -d -p 4000:4000 swarm manage -H :4000 --replication --advertise 10.160.104.235:4000 consul://192.168.107.142:8500

Nodes Instances Configuration

Connect to node 1, node 2 and node 3 in turn and join them to the cluster.
Start a Swarm container each using the following syntax:
sysctl -w net.ipv4.ip_forward=1
sudo docker run -d swarm join --advertise=192.168.107.140:2375 consul://192.168.107.142:8500

sysctl -w net.ipv4.ip_forward=1
sudo docker run -d swarm join --advertise=192.168.107.141:2375 consul://192.168.107.142:8500

sysctl -w net.ipv4.ip_forward=1
sudo docker run -d swarm join --advertise=192.168.104.236:2375 consul://192.168.107.142:8500

Test Configuration

Connect to Management 1Check Swarm information using following syntax:$ sudo docker -H :4000 info

Containers: 22
Running: 6
Paused: 0
Stopped: 16
Images: 15
Server Version: swarm/1.2.5
Role: primary
Strategy: spread
Filters: health, port, containerslots, dependency, affinity, constraint
Nodes: 4
dockerHost: 192.168.107.140:2375
└ ID: RF2E:R27P:XFWC:2B36:DOYJ:RHRU:EIEF:NCLN:3YBY:HZ7A:RYKW:KMAT
└ Status: Healthy
└ Containers: 8 (1 Running, 0 Paused, 7 Stopped)
└ Reserved CPUs: 0 / 8
└ Reserved Memory: 0 B / 516.5 GiB
└ Labels: kernelversion=3.10.0-327.el7.x86_64, operatingsystem=CentOS Linux 7 (Core), storagedriver=devicemapper
└ UpdatedAt: 2016-10-27T05:07:28Z
└ ServerVersion: 1.12.2
localhost.localdomain: 192.168.104.236:2375
└ ID: SP4D:OVOH:K5SF:BWNL:MRGD:EDZU:HJD6:Y5UX:DUR6:N7YD:LW5R:MTVN
└ Status: Healthy
└ Containers: 2 (1 Running, 0 Paused, 1 Stopped)
└ Reserved CPUs: 0 / 1
└ Reserved Memory: 0 B / 1.887 GiB
└ Labels: kernelversion=3.10.0-327.el7.x86_64, operatingsystem=CentOS Linux 7 (Core), storagedriver=devicemapper
└ UpdatedAt: 2016-10-27T05:07:16Z
└ ServerVersion: 1.12.2
localhost.localdomain: 192.168.107.141:2375
└ ID: FGHH:CCLK:BTJD:PA27:6NMX:K6RQ:3ZPC:SVV4:HWML:HJYQ:MKJY:DHF4
└ Status: Healthy
└ Containers: 8 (2 Running, 0 Paused, 6 Stopped)
└ Reserved CPUs: 0 / 8
└ Reserved Memory: 0 B / 31.83 GiB
└ Labels: kernelversion=3.10.0-327.el7.x86_64, operatingsystem=CentOS Linux 7 (Core), storagedriver=devicemapper
└ UpdatedAt: 2016-10-27T05:07:44Z
└ ServerVersion: 1.12.2
localhost.localdomain: 192.168.107.142:2375
└ ID: BM4X:XGZR:6YA5:WPVA:OKOB:ON76:3KSL:GMGI:ROPV:D2TB:VWCC:BJKB
└ Status: Healthy
└ Containers: 4 (2 Running, 0 Paused, 2 Stopped)
└ Reserved CPUs: 0 / 2
└ Reserved Memory: 0 B / 1.887 GiB
└ Labels: kernelversion=3.10.0-327.el7.x86_64, operatingsystem=CentOS Linux 7 (Core), storagedriver=devicemapper
└ UpdatedAt: 2016-10-27T05:07:30Z
└ ServerVersion: 1.12.2
Plugins:
Volume:
Network:
Swarm:
NodeID:
Is Manager: false
Node Address:
Security Options:
Kernel Version: 3.10.0-327.el7.x86_64
Operating System: linux
Architecture: amd64
CPUs: 19
Total Memory: 552.1 GiB
Name: 95d3e2eac529
Docker Root Dir:
Debug Mode (client): false
Debug Mode (server): false
WARNING: No kernel memory limit support

2016-05-21T21:32:00.000-07:00

Docker Containers in Windows Server 2016 Pre Release

SQL server Express Example:

Installation:

Download Windows server 2016 ISO image and install inside Virtual Box

2. Install-PackageProvider ContainerImage -Force

Once installed, a list of Base OS images can be returned using Find-ContainerImage.

Find-ContainerImage

Name                           Version          Source           Summary
----                           -------          ------           -------
NanoServer                     10.0.14300.1010  ContainerImag... Container OS Image of Windows Server 2016 Technical...
WindowsServerCore              10.0.14300.1000  ContainerImag... Container OS Image of Windows Server 2016 Technical...

3. Download WindowsServerCore and NanoServer Docker Images

Install-ContainerImage -Name NanoServer

Install-ContainerImage -Name WindowsServerCore

4. Download DockerFile for MS SQL Server Express

wget https://github.com/brogersyh/Dockerfiles-for-windows/archive/master.zip -outfile master.zip

5. Unzip Docker file and build docker image from docker file, this operation would take up to 1 hour.

expand-archive master.zip
cd master\dockerfiles-for-windows-master\sqlexpress
docker build -t sqlexpress .
docker images

6. This example demonstrate running 2 SQL Server Express instances together ruing on ports 1433 and 1434, following command with create firewall exception rules
if (!(Get-NetFirewallRule | where {$_.Name -eq "SQLServer 1433"})) { New-NetFirewallRule -Name "SQL Server 1433" -DisplayName "SQL Server 1433" -Protocol tcp -LocalPort 1433 -Action Allow -Enabled True}

if (!(Get-NetFirewallRule | where {$_.Name -eq "SQLServer 1434"})) { New-NetFirewallRule -Name "SQL Server 1434" -DisplayName "SQL Server 1434" -Protocol tcp -LocalPort 1434 -Action Allow -Enabled True}

7. Run sqlexpress image on host post 1434 named as sql2

mkdir c:\sql
mkdir c:\sql2

8. Connect SQL server express from network, this example using SQL Work Bench on a MAC

2015-01-20T17:39:00.004-08:00

ESX/ESXi Copy Paste not working, ESXi Isolation issue

I several posts and guides I found that there is an issue that seems to be correct configuration of vmx file do not enable copy paste functionality, I finally figured out the issue.

Requirement

Enable Copy ans Paste between Virtual Machine and remote User Machine, given that VM is hosted on VMware ESX/ESXi server.

Even setting following properties in .vmx file it wont enable copy and paste

isolation.tools.copy.disable = "FALSE"

isolation.tools.paste.disable = "FALSE"

Solution

In most of the websites they do not mentioned case sensitivity requirement, for example ESXi 5.5 must required false in lower case, therefore correct property should be

isolation.tools.copy.disable = "false"

isolation.tools.paste.disable = "false"

2015-01-19T21:43:00.000-08:00

Access Vmware ESXi guest console without runing vSphere client

There are several reasons to access remote console/desktop ESXi guest virtual machines without running vSphere client software

You do not want keep your ESXi connected to vSphere while accessing a console one, because of security reasons.
vSphere do not allow to get full screen console on secondary monitor.
Access guest console from vSphere client is not a single step operation, and opens multiple application windows

Depending on your installation of vSphere client your path may deffer, you can create a shortcut of Guest Console by using following command.

Command

C:\Program Files (x86)\Common Files\VMware\VMware VMRC Plug-in\Internet Explorer>vmware-vmrc -X -u root -p rootPassword -h 10.10.10.22:443 -d "[datastore1] Ubuntu 64-bit/ Ubuntu 64-bit.vmx"

Note:
Replace rootPassword with your Esxi root password, if you do not use -u and -p switch, vmware-vmrc pop up a dialog to input credentials.

Replace 10.10.10.22 with your ESXi server IP address

MYSQL Enable Users or Root Remote Access Suse Linux 11.3

2013-02-06T05:41:00.001-08:00

All you need to do is update the user table host field with % for which ever user you need to grant remote access permission.

Remember that when you remotely try to connect, if there is no connection, means Firewall or network issue, if there is an access dined error mean you need to follow the below demonstration:

TestManager:~ # mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 6
Server version: 5.1.46-log SUSE MySQL RPM

Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> use mysql;Database changed
mysql> select host,user from user;
+------------+-----------------+
| host | user |
+------------+-----------------+
| % | root |
| % | super_user |
| 127.0.0.1 | root |
| linux-npc5 | |
| linux-npc5 | root |
| localhost | |
| localhost | asad |
| localhost | my_new_username |
| localhost | root |
+------------+-----------------+
9 rows in set (0.00 sec)

mysql> update user set host='%' where user='root' and host='linux-npc5';
ERROR 1062 (23000): Duplicate entry '%-root' for key 'PRIMARY'
(This error came because I have two records for user root, one is correct one is bad, let delte the bad one)
mysql> delete from user where user='root' and host='linux-npc5';
Query OK, 1 row affected (0.00 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

mysql>
========================================================================

Testing from Workbench:

Configuring Juniper Secure Networks SA SSL-VPN

2011-05-24T22:32:00.000-07:00

1. Add RADIUS Authentication Server

Start the Juniper Secure Networks Secure Access SSL-VPN Central Manager.

Go to Authentication - Auth. Servers
--> New RADIUS Auth Server
Configure as below

2. Custom Radius Authentication Rules

Note that "Access Challenge” has to be added where the "Reply-Message" "matches the expression" "(.*)" and in that case shows ”show GENERIC LOGIN page”. This will present the OTP field for the user.

When you're done configuring the Authentication Rules they should look like this:

3. Sign in page

Create a Sign-in page

4. User Realm

Create a User Realm that uses the Authentication Server created in step 1 for

authentication.

5. Sign In Policy

Create a Sign In Policy that uses the Sign-in Page from step 2 and the User Realm
from step 3.

Note that from the users’ perspective you can always configure the login-pages for both
graphics and text to suit your company.

6. Start testing

Go to your Juniper url and add that realm you have created. In this example juniper.nordicedge.se/test

Enter the user-id and password for the user that you have added your mobile number to.

Enter your one time password and click on “Sign In”.

The C++ 'const' Declaration: Why & How

2011-04-15T04:33:00.000-07:00

The 'const' system is one of the really messy features of C++.
It is simple in concept, variables declared with ‘const’ added become constants and cannot be altered by the program, but, in the way is has to be used to bodge in a substitute for one of the missing features of C++, it gets horridly complicated and frustratingly restrictive. The following attempts to explain how 'const' is used and why it exists.

Simple Use of ‘const’

The simplest use is to declare a named constant. To do this, one declares a constant as if it was a variable but add ‘const’ before it. One has to initialise it immediately in the constructor because, of course, one cannot set the value later as that would be altering it. For example,

const int Constant1=96;

will create an integer constant, unimaginatively called ‘Constant1’, with the value 96.
Such constants are useful for parameters which are used in the program but are do not need to be changed after the program is compiled. It has an advantage for programmers over the C preprocessor ‘#define’ command in that it is understood & used by the compiler itself, not just substituted into the program text by the preprocessor before reaching the main compiler, so error messages are much more helpful.
It also works with pointers but one has to be careful where ‘const’ to determine whether the pointer or what it points to is constant or both. For example,

const int * Constant2

declares that Constant2 is variable pointer to a constant integer and

int const * Constant2

is an alternative syntax which does the same, whereas

int * const Constant3

declares that Constant3 is constant pointer to a variable integer and

int const * const Constant4

declares that Constant4 is constant pointer to a constant integer. Basically ‘const’ applies to whatever is on its immediate left (other than if there is nothing there in which case it applies to whatever is its immediate right).

Use of ‘const’ in Functions Return Values

Of the mixes of pointers and ‘const’, the constant pointer to a variable is useful for storage that can be changed in value but not moved in memory and the pointer (constant or otherwise) is useful for returning constant strings and arrays from functions which, because they are implemented as pointers, the program could otherwise try to alter and crash. Instead of a difficult to track down crash, the attempt to alter unalterable values will be detected during compilation.
For example, if a function which returns a fixed ‘Some text’ string is written like

char *Function1() { return “Some text”;}

then the program could crash if it accidentally tried to alter the value doing

Function1()[1]=’a’;

whereas the compiler would have spotted the error if the original function had been written

const char *Function1() { return "Some text";}

because the compiler would then know that the value was unalterable. (Of course, the compiler could theoretically have worked that out anyway but C is not that clever.)

Where it Gets Messy - in Parameter Passing

When a subroutine or function is called with parameters, variables passed as the parameters might be read from to transfer data into the subroutine/function, written to to transfer data back to the calling program or both to do both. Some languages enable one to specify this directly, such as having ‘in:’, ‘out:’ & ‘inout:’ parameter types, whereas in C one has to work at a lower level and specify the method for passing the variables choosing one that also allows the desired data transfer direction.
For example, a subroutine like

void Subroutine1(int Parameter1) { printf("%d",Parameter1);}

accepts the parameter passed to it in the default C & C++ way which is a copy. Therefore the subroutine can read the value of the variable passed to it but not alter it because any alterations it makes are only made to the copy and lost when the subroutine ends so

void Subroutine2(int Parameter1) { Parameter1=96;}

would leave the variable it was called with unchanged not set to 96.
The addition of an ‘&’ to the parameter name in C++ (which was a very confusing choice of symbol because an ‘&’ infront of variables elsewhere in C generate pointers!) like causes the actual variable itself, rather than a copy, to be used as the parameter in the subroutine and therefore can be written to thereby passing data back out the subroutine. Therefore

void Subroutine3(int &Parameter1) { Parameter1=96;}

would set the variable it was called with to 96. This method of passing a variable as itself rather than a copy is called a ‘reference’ in C.
That way of passing variables was a C++ addition to C. To pass an alterable variable in original C, a rather involved method using a pointer to the variable as the parameter then altering what it pointed to was used. For example

void Subroutine4(int *Parameter1) { *Parameter1=96;}

works but requires the every use of the variable in the called routine so altered and the calling routine altered to pass a pointer to the variable which is rather cumbersome.
But where does ‘const’ come into this? Well, there is a second common use for passing data by reference or pointer instead of copy. That is when copying a the variable would waste too much memory or take too long. This is particularly likely with large compound user-defined variable types (‘structures’ in C & ‘classes’ in C++). So a subroutine declared

void Subroutine4(big_structure_type &Parameter1);

might being using ‘&’ because it is going to alter the variable passed to it or it might just be to save copying time and there is no way to tell which it is if the function is compiled in someone else’s library. This could be a risk if one needs to trust the the subroutine not to alter the variable.
To solve this, ‘const’ can be used the in the parameter list like

void Subroutine4(big_structure_type const &Parameter1);

which will cause the variable to passed without copying but stop it from then being altered. This is messy because it is essentially making an in-only variable passing method from a both-ways variable passing method which was itself made from an in-only variable passing method just to trick the compiler into doing some optimization.
Ideally, the programmer should not need control this detail of specifying exactly how it variables are passed, just say which direction the information goes and leave the compiler to optimize it automatically, but C was designed for raw low-level programming on far less powerful computers than are standard these days so the programmer has to do it explicitly.

Messier Still - in the Object Oriented Programming

In Object Oriented Programming, calling a ‘method’ (the Object Oriented name for a function) of an object has gives an extra complication. As well as the variables in the parameter list, the method has access to the member variables of the object itself which are always passed directly not as copies. For example a trivial class, ‘Class1’, defined as

class Class1 { void Method1(); int MemberVariable1;}

has no explicit parameters at all to ‘Method1’ but calling it in an object in this class might alter ‘MemberVariable1’ of that object if ‘Method1’ happened to be, for example,

void Class1::Method1() { MemberVariable1=MemberVariable1+1;}

The solution to that is to put ‘const’ after the parameter list like

class Class2 { void Method1() const; int MemberVariable1;}

which will ban Method1 in Class2 from being anything which can attempt to alter any member variables in the object.
Of course one sometimes needs to combine some of these different uses of ‘const’ which can get confusing as in

const int*const Method3(const int*const&)const;

where the 5 uses ‘const’ respectively mean that the variable pointed to by the returned pointer & the returned pointer itself won’t be alterable and that the method does not alter the variable pointed to by the given pointer, the given pointer itself & the object of which it is a method!.

Inconveniences of ‘const’

Besides the confusingness of the ‘const’ syntax, there are some useful things which the system prevents programs doing.
One in particular annoys me because my programs often need to be optimized for speed. This is that a method which is declared ‘const’ cannot even make changes to the hidden parts of its object that would not make any changes that would be apparent from the outside. This includes storing intermediary results of long calculations which would save processing time in subsequent calls to the class’s methods. Instead it either has to pass such intermediary results back to the calling routine to store and pass back next time (messy) or recalculate from scratch next time (inefficient). In later versions of C++, the ‘mutable’ keyword was added which enables ‘const’ to be overridden for this purpose but it totally relies on trusting the programmer to only use it for that purpose so, if you have to write a program using someone else's class which uses ‘mutable’ then you cannot guarantee that ‘‘mutable’ things will really be constant which renders ‘const’ virtually useless.
One cannot simply avoid using ‘const’ on class methods because ‘const’ is infectious. An object which has been made ‘const’, for example by being passed as a parameter in the ‘const &’ way, can only have those of its methods that are explicitly declared ‘const’ called (because C++’s calling system is too simple work out which methods not explicitly declared ‘const’ don’t actually change anything). Therefore class methods that don’t change the object are best declared ‘const’ so that they are not prevented from being called when an object of the class has somehow acquired ‘const’ status.

Nokia Messaging Push Email Setup on Nokia E5

2011-04-04T04:49:00.000-07:00

There are lots of issues and problems reported about people have trouble setting up Nokia Messaging account on Nokia E5, below are the steps to follow for successful configurations: (Assuming you have Internet Setup/GPRS Configuration / WLAN done on your device)

Goto Control Panel, Setting, General, Personalization, Messaging Key, Messaging Key, Short Press.
Set short press to Email Setup.
Exit from Control Panel and short-press the messaging key
It will bring the Nokia messaging setup, enter Gamil credentials
Follow the instruction and you're done
Sing in to (https://email.nokia.com/account/login.action) with your step 4 Gmail credentials
Setup other email account (Max 10 including first Gamil one)
All of configured Email accounts are will be available on your device shortly
Perform step 1 and set short-press to default
Cheers

Getting newly generated ID auto-number values from Intersystems Cache table, by using ODBC connection provider

2010-12-02T08:05:00.000-08:00

In Cache you need to create following Stored Procedure

===========================================================
ClassMethod MaxID(TableName as %String) As %String [ SqlProc ]
{
s lastID="0"
lock +(^lastID)
//s cmd1="s ^lastID=^Sample.PersonD"
s cmd1="s ^lastID=^"_TableName_"D"
XECUTE cmd1
s lastID=^lastID
lock -(^lastID)
q lastID

}
===========================================================

In SQL you can access it by using following SQL statement

===========================================================
Select top 1 Sample.Person_MaxID('Sample.Person') AS MaxID from Sample.Person
===========================================================

FILESTREAM storage in SQL 2008 with ASP.net MVC Part 2/2

2010-11-26T23:31:00.000-08:00

Updating FILESTREAM enabled Table for easy access in C#:

1. Open FIleSTREAM enabled table in design mode in SQL Server Management Studio

2. Add following computed properties:

PathName with formula value FileContents.pathName()

3. Add FileStreamTransactionContext with formula value get_filestream_transaction_context()

4. Save changes and accept any validation warning appeared

Creating LINQ Domain Model:

Table to class mapping:

using System;

using System.Collections.Generic;

using System.Data.Linq;

using System.Data.Linq.Mapping;

using System.Linq;

using System.Text;

using System.IO;

using System.Data.SqlTypes;

namespace FileUploadSample.Models

{

[Table(Name = "Files")]

public class tbl_Files

{

[Column(IsPrimaryKey = true, IsDbGenerated = false)]

public Guid FileID { get; set; }

[Column]

public String FileName { get; set; }

[Column]

public Int64 Length { get; set; }

[Column(Name = "pathName", IsDbGenerated = true, AutoSync = AutoSync.OnInsert)]

private String _PathName { get; set; }

[Column(Name = "FileStreamTransactionContext", IsDbGenerated = true, AutoSync = AutoSync.OnInsert)]

private byte[] _FileStreamTransactionContext { get; set; }

public String PathName

{

get

{

return this._PathName;

}

public byte[] FileStreamTransactionContext

{

get

{

return this._FileStreamTransactionContext;

}

SQL Repository:

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.IO;

using FileUploadSample.Controllers;

using System.Data.Linq;

using System.Transactions;

using System.Data.SqlTypes;

using System.Data.SqlClient;

using System.Data;

namespace FileUploadSample.Models

{

public class tbl_FilesRepository

{

private String connectionString;

private Table<tbl_Files> FileTable;

private DataContext FilesContext;

public tbl_FilesRepository(string connectionString)

{

FilesContext = new DataContext(connectionString);

FileTable = FilesContext.GetTable<tbl_Files>();

//FileTable = (new DataContext(connectionString)).GetTable();

this.connectionString = connectionString;

}

public Table<tbl_Files> getTable()

{

return FileTable;

}

public void Addfile(tbl_Files ObjFile)

{

FileTable.InsertOnSubmit(ObjFile);

FileTable.Context.CommandTimeout = 3600;

FileTable.Context.SubmitChanges();

}

public void downloadFileStream(Guid id, HttpResponseBase Response)

{

using (TransactionScope ts = new TransactionScope())

{

var selectedFile = FileTable.Where(Tfile => Tfile.FileID == id).FirstOrDefault();

SqlFileStream sqlFile = new SqlFileStream(((SqlString)selectedFile.PathName).Value, ((SqlBinary)selectedFile.FileStreamTransactionContext).Value, System.IO.FileAccess.Read);

if (selectedFile != null)

{

// Buffer to read 10K bytes in chunk:

byte[] buffer = new Byte[1024 * 512]; //512 KB

// Length of the file:

int length;

// Total bytes to read:

long dataToRead;

try

{

// Total bytes to read:

dataToRead = sqlFile.Length;

Response.ContentType = "application/octet-stream";

Response.AddHeader("Content-Disposition", "attachment; filename=" + selectedFile.FileName);

// Read the bytes.

while (dataToRead > 0)

{

// Verify that the client is connected.

if (Response.IsClientConnected)

{

// Read the data in buffer.

length = sqlFile.Read(buffer, 0, 1024 * 512);

// Write the data to the current output stream.

Response.OutputStream.Write(buffer, 0, length);

// Flush the data to the HTML output.

Response.Flush();

buffer = new Byte[1024 * 512];

dataToRead = dataToRead - length;

}

else

{

//prevent infinite loop if user disconnects

dataToRead = -1;

}

ts.Complete();

}

catch (Exception ex)

{

// Trap the error, if any.

Response.Write("Error : " + ex.Message);

ts.Dispose();

}

finally

{

if (sqlFile != null)

{

//Close the file.

sqlFile.Close();

Response.Close();

}

public bool uploadStream(HttpRequestBase Request)

{

foreach (string inputTagName in Request.Files)

{

HttpPostedFileBase file = Request.Files[inputTagName];

if (file.ContentLength > 0)

{

SqlFileStream sqlFile = null;

using (TransactionScope ts = new TransactionScope())

{

try

{

FileUploadSample.Models.tbl_Files objFile = new FileUploadSample.Models.tbl_Files();

objFile.FileName = file.FileName.Split('\\')[file.FileName.Split('\\').Length - 1]; ;

objFile.Length = Convert.ToInt64(file.ContentLength / 1024);

objFile.FileID = Guid.NewGuid();

//objFile.FileContents = new byte[0];

Addfile(objFile);

//Save file on FILESTREAM

sqlFile = new SqlFileStream(((SqlString)objFile.PathName).Value, ((SqlBinary)objFile.FileStreamTransactionContext).Value, System.IO.FileAccess.Write);

byte[] buffer = new byte[1024 * 1024]; // 512Kb

int bytesRead = file.InputStream.Read(buffer, 0, buffer.Length);

while (bytesRead > 0)

{

sqlFile.Write(buffer, 0, bytesRead);

bytesRead = file.InputStream.Read(buffer, 0, buffer.Length);

}

ts.Complete();

return true;

}

catch (Exception ex)

{

ts.Dispose();

return false;

}

finally

{

if (sqlFile != null)

sqlFile.Close();

}

}// For Each Loop

return false; // If this LOC is reached that means there is no valid file to upload.

}//Method uploadStream()

}

Creating View:

<%@ Page Title="" Language="C#" MasterPageFile="~/Views/Shared/Site.Master" Inherits="System.Web.Mvc.ViewPage>" %>

<asp:Content ID="Content1" ContentPlaceHolderID="TitleContent" runat="server">

Index

asp:Content>

<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" runat="server">

$(function () {

$("#dialog").dialog({

bgiframe: true,

height: 140,

modal: true,

autoOpen: false,

resizable: false

})

});

script>

<h2>

Indexh2>

<% using (Html.BeginForm("UploadFileStream", "File", FormMethod.Post, new { enctype = "multipart/form-data" }))

{%>

<p>

<p>

<% } %>

div>

<a href="#" onclick="jQuery('#dialog').dialog('open'); return false">Upload Filea>

<br />

<tr>

<th>

Name

th>

<th>

File Url

th>

<th>

Uploaded Date

th>

<th>

Size

th>

tr>

<% foreach (var item in Model)

{

string fileType = System.IO.Path.GetExtension(item.FileName);

<tr>

<td>

<%= Html.Encode(item.FileName)%>

td>

<a href='<%= Html.Encode("/file/downloadFileStream/"+item.FileID)%>'>Download a>

td>

td>

<%= Html.Encode(item.Length) + " KB" %>

td>

tr>

<% } %>

table>

asp:Content>

Creating Controller:

Note:We must have to use Integrated Security=True in connection string

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.Mvc;

using System.Web.Mvc.Ajax;

using FileUploadSample.Models;

using System.IO;

using System.Data.Linq;

namespace FileUploadSample.Controllers

{

public class FileController : Controller

{

static String connectionString = "Data Source=ASAD-PC-DESKTOP\\SQLSERVER_R2;Initial Catalog=CSAFMS;Integrated Security=True";

FileRepository fileRepository = new FileRepository(connectionString);

tbl_FilesRepository tbl_FilesRepository = new tbl_FilesRepository(connectionString);

public ActionResult Index()

{

return View(tbl_FilesRepository.getTable().ToList());

}

public ActionResult downloadFileStream(Guid id)

{

tbl_FilesRepository.downloadFileStream(id, Response);

return View();

}

public void UploadFileStream()

{

tbl_FilesRepository.uploadStream(Request);

Response.Redirect("~/File");

}

Source download password (asadyousufi.blogspot.com)

Download Source

FILESTREAM storage in SQL 2008 with ASP.net MVC Part 1/2

2010-11-26T20:35:00.000-08:00

The FILESTREAM feature of SQL Server 2008, which allows storage of and efficient access to BLOB data using a combination of SQL Server 2008 and the NTFS file system. It covers choices for BLOB storage, configuring Windows and SQL Server for using FILESTREAM data, considerations for combining FILESTREAM with other features, and implementation details such as partitioning and performance.

1. Enable FILESTREAM support

To enable FILESTREAM support, run the following SQL:

On SQL Server 2008 Express:

USE master;

EXEC sys.sp_configure N'filestream access level', N'2'

RECONFIGURE WITH OVERRIDE

On SQL Server 2008 Enterprise :

exec [sp_filestream_configure] @enable_level = 3;

This command enables or disables the support according to the parameter. The value 3 means that FILESTREAM will be enabled for Transact-SQL, local file system access, and remote file system access.

2. Create a database with a File Group that contains FILESTREAM

To create a database instance with a file group that contains FILESTREAM, run the following sql command. This creates the database with 3 file groups, but only one of them contains FILESTREAM as you can see in the command.

CREATE DATABASE CSAFMS

PRIMARY (

NAME = CSAFMS_Primary,

FILENAME = 'D:\Databases\CSAFMS\CSAFMS.mdf'),

FILEGROUP FileStreamGroup CONTAINS FILESTREAM (

NAME = FileManagement_FileGroup,

FILENAME = 'D:\Databases\CSAFMS\CSAFMS')

LOG ON ( NAME = FileManagement_Log,

FILENAME = 'D:\Databases\CSAFMS\CSAFMSLog.ldf')

This command will create the following directories structure:

In the Data Directory, I could find the files specified above:

and in the CSAFMS directory, I could find the following content:

3. Create a Table with FILESTREAM

Note: FILESTREAM is not a type of a column, but it is a property you put on a varbinary(max) column.

So, in order to create a table with a varbinary(max) column that will be used for FILESTREAM, run the following command. Note that I don't have any additional columns to the file itself.

CREATE TABLE [dbo].[Files]

(

FileID uniqueidentifier NOT NULL ROWGUIDCOL PRIMARY KEY,

FileName Varchar(300) NOT NULL,

Length bigint NOT NULL,

FileContents varbinary(max) FILESTREAM DEFAULT NULL

)

4. Add Test Data

In order to get the feeling of the experience of working with files, let add an empty file:

insert into Files

(FileID,[FileName],Length,FileContents)

values (newid(),'Dummy File 2',0, CAST ('my test file' as varbinary(max)));

If we now query the database to see the files in it:

select * from Files

We will get the following result (the GUID will probably be different...)

FileID FileContents

------------------------------------ ------------------------------------------------

8247CE78-74DF-4BDE-A08D-9760AE0B1555 my test file

and If we look at the FileManagement directory, we can see that a new directory has been created

.Net Framework remote cleanup and installation

2010-10-20T07:15:00.000-07:00

There are several reasons that lead to the corruption of installed .Net Framework on a machine running Microsoft Windows operating system, corruption of .Net Framework could leads to initiation failure problem for .Net Framework dependent applications like KBOX Agent and KBOX Agent debugger.

However this problem could be solved by uninstalling all versions of .Net Framework from effected machine and reinstalling .Net Frame required versions.

In some corruption cases, .Net Framework got corrupted in such a way that cannot be fixed by regular reinstallation procedure, or uninstall/reinstall ends up with an exception message.

This post describes how to encounter such .Net Framework corruption issue and get KBOX Agent running on client machines. This post describes the use of tools and procedures that can fix a local machine as well as large number of machines on remote locations, by using authenticated remote cleanup of corrupt .Net Framework version and push installation of .Net Framework version 1.1 that is prerequisite for KBOX Agent.

Problem Identification

From a KBOX administrator prospective, you may experience that some of the clients are not get connected for a long period of time, or clients are connected but are not getting refreshed inventory for an abnormal period of time.

If you can get an active ICMP response (PING response) then, it could be a corrupted .Net framework issue.

Solution

There are several .Net framework version could be installed and corrupted on a client machine, to fix the issue we must have to uninstall all of them in descending order of version number then install .Net Framework 1.1, that is prerequisite for KBOX Agent.
For remote cleanup of .Net Framework you need:

A shared folder on network that is accessible for target client machine
Target client machine Administrative access
A source machine to initiate the remote cleanup and reinstall process
Attached SharedFolder.rar
Attached SourceMachine.rar
WinRAR application to extract attached files

Steps

Extract SharedFolder.rar to the network shared folder, make sure that target client machine can access the files on shared folder without any requirement to enter access credentials (you can accomplish it by granting Read Permission to Everyone Group).
Extract SourceMachine.rar to any drive of your machine.
Double click and run PSExec.exe and accept the agreement.
PING target machine to ensure connectivity.
Run following commands on windows command line after changing directory to SourceMachine.rar folder, after replacing sample values with real values (You must have run the following command in descending order of .Net Framework versions, each of the command written below may run up to several minutes, please be patient)

Sample Value	Description to change the sample value to real value
192.168.1.209	Target client machine’s IP address or DNS Name
TEST4SIGHT\administrator	Domain Name\User Name (User must have administrative access on target machine)
123456	Password of above mentioned user
dc1	Shared folder machine’s IP address or DNS Name
framework_cleanup	Folder network share name where you extracted the SharedFolder.rar

To Cleanup .Net Framework 4.0

D:\>psexec \\192.168.1.209 -u TEST4SIGHT\administrator -p 123456 \\dc1\\framework_cleanup\cleanup11.bat

To Cleanup .Net Framework 3.5

D:\>psexec \\192.168.1.209 -u TEST4SIGHT\administrator -p 123456 \\dc1\\framework_cleanup\cleanup35.bat

To Cleanup .Net Framework 3.0

D:\>psexec \\192.168.1.209 -u TEST4SIGHT\administrator -p 123456 \\dc1\\framework_cleanup\cleanup30.bat

To Cleanup .Net Framework 2.0

D:\>psexec \\192.168.1.209 -u TEST4SIGHT\administrator -p 123456 \\dc1\\framework_cleanup\cleanup20.bat

To Cleanup .Net Framework 1.1

D:\>psexec \\192.168.1.209 -u TEST4SIGHT\administrator -p 123456 \\dc1\\framework_cleanup\cleanup11.bat

To Cleanup .Net Framework 1.0

D:\>psexec \\192.168.1.209 -u TEST4SIGHT\administrator -p 123456 \\dc1\\framework_cleanup\cleanup10.bat

Result

If cleanup tool find the targeted version of .Net Framework on target machine it will normally uninstall it and give Error Code 0 on console (see below):
\\dc1\\framework_cleanup\cleanup11.bat exited on 192.168.1.209 with error code 0
If you get other error codes it means that Framework is failed to uninstall due to absence of targeted version or some program is currently using it, you may try this command on a later time when machine is idle and no application is running, you can restart that machine to close all running application forcefully.

Run following commands on windows command line after changing directory to SourceMachine.rar folder, after replacing sample values with real values

Sample Value	Description to change the sample value
192.168.1.209	Target client machine’s IP address or DNS Name
TEST4SIGHT\administrator	Domain Name\User Name (User must have administrative access on target machine)
123456	Password of above mentioned user
192.168.1.200	KBOX server’s IP address or DNS Name

Note: Following command may run up to several minutes, please be patient.

psexec \\192.168.1.209 -u TEST4SIGHT\administrator -p 123456 \\192.168.1.200\client\agent_provisioning\windows_platform\dotnetfx /q /c:"install /q"

Result

If push install command normally install .Net Framework, it will Error Code 0 on console (see below):
\\192.168.1.200\client\agent_provisioning\windows_platform\dotnetfx exited on 192.168.1.209 with error code 0.

Open KBOX web administration portal and initiate push agent process on target machine

SharedFolder.rar
SourceMachine.rar

Domain Driven Design (DDD) implementation using C# and LINQ

2010-10-14T03:44:00.000-07:00

The part of the software that specifically solves problems from the domain model usually constitutes only a small portion of the entire software system, although its importance is disproportionate to its size. To apply our best thinking, we need to be able to look at the elements of the model and see them as a system.We must not be forced to pick them out of a much larger mix of objects, like trying to identify constellations in the night sky.We need to decouple the domain objects from other functions of the system, so we can avoid confusing domain concepts with concepts related only to software technology or losing sight of the domain altogether in the mass of the system. Domain-Driven Design: Tackling Complexity in the Heart of Software, by Eric Evans

(Addison-Wesley, 2004)

Aggregates and Simplification

The DDD way to break down this complexity is to arrange domain entities into groups
called aggregates.

Each aggregate has a root entity that defines the identity of the whole aggregate, and acts
as the “boss” of the aggregate for the purposes of validation and persistence. The aggregate is
a single unit when it comes to data changes, so choose aggregates that relate logically to real
business processes—that is, the sets of objects that tend to change as a group (thereby embedding
further insight into your domain model).
Objects outside a particular aggregate may only hold persistent references to the root
entity, not to any other object inside that aggregate (in fact, ID values for non-root entities
don’t even have to be unique outside the scope of their aggregate). This rule reinforces
aggregates as atomic units, and ensures that changes inside an aggregate don’t cause data
corruption elsewhere.

In our example we have 3 aggregates (Customer,Store and Item)

Source Code

code file password (asadyousufi.blogspot.com)

Creating a Video Sharing Library

2010-04-20T02:14:00.000-07:00

First step to create a video sharing library we need to have all videos in a FLV flash format in order to play them on webpage,

Sounds familiar, yeah the famous youtube.com does that, how exactly we can do something similar to youtube?

How to convert files uploaded by people in FLV format?

There are different open source tools available for converting different formats of videos to other formats, unfortunately there are issues and bugs in these tools, and less support, we can not use one tool for convert videos in FLV format, we have to mix two different tools for this purpose, below are the steps how can we achieve that using FFMPEG and FLVTOOL.

Step # 1:

Download FFMPEG (search it on Google, download it build it)

Download FLVTOOL (search it on Google, download it build it)

Or simply download my pre build copy from

sample.3gp

http://www.filefactory.com/file/b131a99/n/sample.3gp

FFmpeg_FLVTOOL.rar

http://www.filefactory.com/file/b131aa7/n/FFmpeg_FLVTOOL.rar

beelden.zip

http://www.filefactory.com/file/b131bgf/n/beelden.zip

Extract following in a folder, (I supposed d:\ffmpeg folder)

Step # 2:

Run following command-line commands form your programming language exp C#.

1) Convert to AVI first because some formats are not directly convert able into FLV

D:\FFmpeg>ffmpeg -i sample.3gp -s 470X320 -ar 44100 s22.avi

2) Take snap from video file

D:\FFmpeg>ffmpeg -i s22.avi -ss 3 t11.jpg

3) Convert to required FLV format

D:\FFmpeg>ffmpeg -i s22.avi -s 470X320 t11.flv

4) fix errors using flvtool

D:\FFmpeg\>flvtool2 -UP t11.flv out2.flv

Step # 3

Download FW flash player (search it from Google)

Extract it into the same folder

Step # 4

Create a new HTML file and paste and save the following code:

<html>

<body>

<div id='mediaspace'>This text will be replaced<div>

<div>

var so = new SWFObject('player.swf','ply','468','348','9','#ffffff');

so.addParam('allowfullscreen','true');

so.addParam('allowscriptaccess', 'always');

so.addVariable('image', 't11.jpg');

so.addVariable('skin', 'beelden.zip');

so.addParam('wmode','opaque');

so.addVariable('file','out2.flv');

so.write('mediaspace');

<body>

<html>

Step # 5

Preview your newly saved HTML in web browser.

Implementation of SQL IN clause in LINQ

2010-04-14T04:02:00.000-07:00

To implement SQL IN clause in LINQ there are 4 steps

1. GetTable from which you need to filter rows.

2. GetTable that contains the values(only one clumn) you need to match in IN clause.

3. Type cast data of step # 2 DataTable column data identical to step # 1 DataTable filtering column/property.

4. Use step# 2 DataTable’s Contains() method of step # 1 DataTable’s where caluse

public List<CustomerCoupon> getCustomerNonSpecials(int StoreID, int customerID)

{

//Step # 1

List<CustomerCoupon> coupons = new List<CustomerCoupon>();

coupons = customerCouponsTable.Where(coupon => coupon.Customer.CustomerID == customerID).ToList();

//Step # 2

Table<CategoryItem> specialsTable = customersTable.Context.GetTable<CategoryItem>();

Table<CustomerCoupon> customerCouponsTable = customersTable.Context.GetTable<CustomerCoupon>();

List<CategoryItem> specials = new List<CategoryItem>();

specials = specialsTable.Where(cItem => cItem.StoreCategory.CategoryName == cItem.Item.Store.StoreCategorys[0].CategoryName && cItem.Item.Store.StoreID == StoreID).ToList();

var query = from c in coupons

join s in specials on c.ItemID equals s.ItemID

select new { c.Item.ItemID };

//Step # 3

List<int> SpecialsCouponsIDs = new List<int>();

SpecialsCouponsIDs = query.ToList().ConvertAll<int>(i=> Convert.ToInt16(i.ItemID));

//Step # 4

List<CustomerCoupon> nonSpecialsCoupons =new List<CustomerCoupon>();

nonSpecialsCoupons = (from c in coupons where SpecialsCouponsIDs.Contains(c.ItemID) select c).ToList();

return nonSpecialsCoupons;

}

Pessimistic and optimistic locking

2010-04-14T03:40:00.000-07:00

Transactional isolation is usually implemented by locking whatever is accessed in a transaction. There are two different approaches to transactional locking: Pessimistic locking and optimistic locking.

The disadvantage of pessimistic locking is that a resource is locked from the time it is first accessed in a transaction until the transaction is finished, making it inaccessible to other transactions during that time. If most transactions simply look at the resource and never change it, an exclusive lock may be overkill as it may cause lock contention, and optimistic locking may be a better approach. With pessimistic locking, locks are applied in a fail-safe way. In the banking application example, an account is locked as soon as it is accessed in a transaction. Attempts to use the account in other transactions while it is locked will either result in the other process being delayed until the account lock is released, or that the process transaction will be rolled back. The lock exists until the transaction has either been committed or rolled back.

Pessimistic locking in ADO.NET

One way to deal with optimistic concurrency issues in ADO.NET is to lock records as they are retrieved from the data source. It doesn't take much code, but it does involve some risks. Find out when you should use this procedure and how it works.

Six steps to implement Pessimistic Locking in ADO.NET

Create a transaction by using IsolationLevel of RepeatableRead.

Set the DataAdapter’s SelectCommand property to use the transaction we have created in step #1.

Make the changes to the data.

Set DataAdapter’s Insert, Update, and Delete command properties to use the transaction created in step #1.

Call the DataAdapter’s Update method.

Commit the transaction.

Below is an example using pessimistic locking by using ADO.NET, developer just need to create object of the class mentioned below, select data in DataSet, update it with required changes, then call submitChanges method to save it into database, by using pessimistic locking procedure.

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Data.Sql;

using System.Data.SqlClient;

using System.Data.Common;

using System.Data;

namespace Locking_example

{

public class DAL

{

private String CommandText;

private SqlConnection ObjSqlConnection;

private SqlDataAdapter ObjSqlDataAdapter;

private String connectionString;

private DataSet Ds;

private SqlTransaction ObjSqlTransaction;

//Constructor

public DAL(String ConnectionString)

{

this.connectionString = ConnectionString;

ObjSqlConnection = new SqlConnection(this.connectionString);

ObjSqlDataAdapter = new SqlDataAdapter();

}

public DataSet select(String commandText)

{

ObjSqlConnection.Open();

ObjSqlTransaction = ObjSqlConnection.BeginTransaction(IsolationLevel.RepeatableRead);

ObjSqlDataAdapter.SelectCommand.CommandText=this.CommandText;

ObjSqlDataAdapter.SelectCommand.Transaction = ObjSqlTransaction;

ObjSqlDataAdapter.Fill(Ds);

return Ds;

}

public bool SubmitChanges(DataSet Ds)

{

try

{

ObjSqlDataAdapter.InsertCommand.Transaction = ObjSqlTransaction;

ObjSqlDataAdapter.UpdateCommand.Transaction = ObjSqlTransaction;

ObjSqlDataAdapter.DeleteCommand.Transaction = ObjSqlTransaction;

ObjSqlDataAdapter.Update(Ds);

ObjSqlTransaction.Commit();

ObjSqlConnection.Close();

return true;

}

catch (Exception ex)

{

throw ex;

}

Pessimistic locking in LINQ to SQL

Pessimistic locking is pre-implemented in LINQ to SQL, however we need to user TransactionScope class in order to use pessimistic locking.

If two different instances of same program trying to update a data rows set (collection of LINQ objects) or even different programs, first program who ever update the selected data will be saved in database, reset of others will get following exception :

Unhandled Exception: System.Data.Linq.ChangeConflictException: Row not found or changed.

Because of the fact that before updating LINQ to SQL first tried to select the same row using a where clause with all old values.

Below is an example of using pessimistic locking using LINQ to SQL and TransactionScope

using (TransactionScope ts = new TransactionScope())

{

Customer newCustomer = new Customer

{

FirstName = "To be Updated",

LastName = "To be Updated",

State = "To be Updated",

ZipCode = "To be Updated",

City = "To be Updated",

Address1 = "To be Updated",

Address2 = "To be Updated",

};

customersTable.InsertOnSubmit(newCustomer);

try

{

this.SubmitChanges();

}

catch (Exception ex)

{

return null;

}

CustomerStoreConfiguration newCustomerStoreConfiguration = addSignupConfigurations(newCustomer, storeID, cellPhoneNumber, pin);

if (newCustomerStoreConfiguration == null)

{

ts.Dispose();

return null;

}

ts.Complete();

return newCustomerStoreConfiguration;

}

public void SubmitChanges()

{

customersTable.Context.SubmitChanges();

}

public CustomerStoreConfiguration addSignupConfigurations(Customer newCustomer, int storeID, string cellphoneNumber, string pin)

{

Table<CustomerStoreConfiguration> CustomerStoreConfigurationTable = customersTable.Context.GetTable<CustomerStoreConfiguration>();

CustomerStoreConfiguration newCustomerStoreConfiguration = new CustomerStoreConfiguration

{

CellPhoneNumber = cellphoneNumber,

StoreID = storeID,

PIN = pin,

CustomerID = newCustomer.CustomerID,

EmailAddress = "To_Be_Updated@updateMe.now",

EnableAllCatelogPromotions = false,

EnableAllEmailPromotions = false,

EnableAllRetailFlyerPromotions = false,

EnableCatelogPromotions = false,

EnableRetailFlyerPromotions = false,

EnableSpatialEmailPromotions = false,

MaxCatelogPromotions = 0,

MaxEmailPromotions = 0,

MaxRetailFlyerPromotions = 0,

MaxMobilePromotions=0

};

CustomerStoreConfigurationTable.InsertOnSubmit(newCustomerStoreConfiguration);

try

{

CustomerStoreConfigurationTable.Context.SubmitChanges();

return newCustomerStoreConfiguration;

}

catch (Exception ex)

{

return null;

}

Incase of voilation of pessimistic locking user may encounter follwing exception:

Unhandled Exception: System.Data.SqlClient.SqlException: Transaction (Process ID 52) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

Commonly Used Data Security Acronyms and Abbreviations

2010-04-07T01:08:00.000-07:00

RADIUS:

Remote Authentication Dial-in User Service

GINA:

Graphical Identification and Authentication

pGINA:

Plug-able Graphical Identification and Authentication

LDAP:

Light-Weight Directory Access Protocol

DMZ:

Demilitarized Zone

PAM:

Pluggable Authentication Module

FFIEC:

Federal Financial Institute Examination Council

RAS:

Remote Access Service

OOB:

Out of Bound

OTP:

One Time Password

TOTP:

Time-based One Time Password

HOTP:

HMAC-Based (RFC 4226) One-Time Password Algorithm

RoSH:

Restriction of Hazardous Substances

Phishing Scam:

Restriction of Hazardous Substances
A phishing scam is an identity theft scam that arrives via email. The email appears to come from a legitimate source such as a trusted business or financial institution, and includes an urgent request for personal information usually invoking some critical need to update an account immediately. Clicking on a link provided in the email leads to an official-looking website. Personal information provided to this site, however, goes directly to the scam artist.

HRC:

Hashed Response Code, usually sent via different network (SMS)

CRC:

Challenge Response Code,user need to solve a arithmetical question to tell the answer.

CRC:

Challenge Response Code,user need to solve a arithmetical question to tell the answer.

DSSS/DS3:

Data Security Systems Solutions.

EMV:

EuroPay, MasterCard, Visa (Smart debit cards)

CAP:

Chip Authentication Program

Join List objects LINQ C#

2010-03-27T00:12:00.000-07:00

public List getCustomerSpecials(int StoreID, int customerID)

{

Table<CategoryItem> specialsTable = customersTable.Context.GetTable<CategoryItem>();

Table<CustomerCoupon> customerCouponsTable = customersTable.Context.GetTable<CustomerCoupon>();

List<CategoryItem> specials = new List<CategoryItem>();

List<CustomerCoupon> coupons = new List<CustomerCoupon>();

coupons = customerCouponsTable.Where(coupon => coupon.Customer.CustomerID == customerID).ToList();

specials = specialsTable.Where(cItem => cItem.StoreCategory.CategoryName == cItem.Item.Store.StoreCategorys[0].CategoryName && cItem.Item.Store.StoreID == StoreID).ToList();

var query = from c in coupons

join s in specials on c.ItemID equals s.ItemID

select new { c.Item };

return query.ToList();

}

Write Files directly on Response ASP.Net C#

2010-03-24T07:21:00.001-07:00

using System;

using System.Collections;

using System.Configuration;

using System.Data;

using System.Linq;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.HtmlControls;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Xml.Linq;

using System.IO;

///

/// Summary description for Util

///

namespace Utility

{

public class FileUtil

{

public FileUtil()

{

// TODO: Add constructor logic here

}

static public void writeFileToResponse(string filePath,HttpResponse Response)

{

try

{

string FileName = Path.GetFileName(filePath);

Response.Clear();

Response.AddHeader("Content-Disposition", "attachment; filename=" + FileName);

//Response.ContentType = sContentType;

Response.WriteFile(filePath);

Response.Flush();

File.Delete(filePath);

Response.End();

}

catch (System.Exception ex)

{

}

Verify DSSS/DS3 ASM ASClinent connectivity

2010-03-22T00:16:00.000-07:00

1) Run DSSS/DS3 Virtual Machine

2) Run vmwaregateway.exe/t

3) telnet localhost 55178

4) paste following line into telnet session (keystore location must be correct)

openConnection;d:/DS3/ASClient/ASClient/Java/lib/asadclient.keystore;123456;192.168.1.85;false

LINQ to Object : Querying Non- IEnumerable collections

2010-03-16T03:33:00.000-07:00

Below is an example of accessing EventlofEntityCollection, if I need to filter EventlogEntityCollect using LINQ I just need to mention object type in my collect after from clause in LINQ statement.

Instead of:

var ev = from e in elog.Entries where e.Source == "MsiInstaller" && e.Message.Contains(megString) select e;

Use:

var ev = from EventLogEntry e in elog.Entries where e.Source == "MsiInstaller" && e.Message.Contains(megString) select e;

Example:

EventLog elog = new EventLog();

/* Tell Which type of log we need to access

1. System

2. Security

3. Application

elog.Log = "Application";

//Filter and Select Eventlog Entries Using LINQ

var ev = from EventLogEntry e in elog.Entries where e.Source == "MsiInstaller" && e.Message.Contains(megString) select e;

Read Eventlog using C# and LINQ

2010-03-16T03:20:00.000-07:00

using System;

using System.Diagnostics;

using System.Linq;

using System.Collections.Generic;

namespace EventUtils

{

class EventViewer

{

static void Main(string[] args)

{

string megString = "Product: MySQL Tools for 5.0";

/* Create an object for event log */

EventLog elog = new EventLog();

/* Tell Which type of log we need to access

1. System

2. Security

3. Application

elog.Log = "Application";

//Filter and Select Eventlog Entries Using LINQ

var ev = from EventLogEntry e in elog.Entries where e.Source == "MsiInstaller" && e.Message.Contains(megString) select e;

foreach (var eventEntity in ev)

{

Console.WriteLine("Message: " + eventEntity.Message + "\n" +

"App: " + eventEntity.Source + "\n" +

"Entry type: " + eventEntity.EntryType + "\n" +

"User Name: " + eventEntity.UserName);

Console.WriteLine();

}

Console.ReadLine();

}

Create Table Like Structure using DIV Objects

2010-02-23T21:49:00.000-08:00

Below is a table Structure created by using DIV Objects, you should keep in mind that W3C clearly stated that we should use table objects only for tabular data, my example here is not encouraging using DIV objects for tabular data, I just use tabular data example for clarification and simplicity.

Code:

DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<head>

<title>title>

body

{

margin: 0px;

font-family:Verdana;

}

div.tableStart

{

width: 100%;

display: table;

}

div.tableRow

{

display: table-row;

}

div.tableCell

{

display: table-cell;

width: 20%;

}

div.tableHeader

{

display: table-cell;

width: 100%;

}

div.tableFooter

{

display: table-cell;

width: 100%;

}

/*IE Only code */

* html div.outTable

{

width: 100%;

display: block;

height: 100%;

border: 1px #f00 dotted;

}

* html div.tableRow

{

display: inline;

height: 100%;

}

* html div.tableCell

{

display: inline;

width: 20%;

float: left;

height: auto;

}

* html div.tableHeader

{

display: inline;

width: 100%;

float: left;

height: auto;

}

* html div.tableFooter

{

display: inline;

width: 100%;

float: left;

height: auto;

}

</style>

</head>

<body>

<h2>Put Header Here</h2></div>

</div>

<b>Fisrt Name</b></div>

</div>

<b>Blog Address</b>

</div>

<div class="tableCell" style="background-color:#66CCFF;height:25px;"><b>Comments</b></div>

>div>

<h6>Asad Hafeez</h6></div>

<h6>Yousufi</h6>

</div>

<h6>http://asadyousufi.blogspot.com/</h6>

</div>

<div class="tableCell" style="background-color:#CCCCFF"><h6>This is a testing text, all div objects reflecting same hight and width,

This code is tested in IE 8.0 and FF 6.x</h6></div>

</div>

<div class="tableFooter" style="background-color:#66CCFF"><h2>Put Footer Here</h2></div>

</div>

</body>

</html>

Put Header Here

Fisrt Name

Last Name

Blog Address

Comments

1 Asad Hafeez

Yousufi

http://asadyousufi.blogspot.com/

This is a testing text, all div objects reflecting same hight and width,
This code is tested in IE 8.0 and FF 6.x

Put Footer Here

How to get list of tables using ADO.Net using ODBC data connection (C#)

2010-02-11T01:09:00.000-08:00

class Program

{

static void Main(string[] args)

{

string connectionString = GetConnectionString();

sing (SqlConnection connection = new SqlConnection(connectionString))

{

// Connect to the database then retrieve the schema information.

connection.Open();

DataTable table = connection.GetSchema("Tables");

// Display the contents of the table.

DisplayData(table);

Console.WriteLine("Press any key to continue.");

Console.ReadKey();

}

Convert HEX string into Byte Array in Java

2010-02-08T20:58:00.000-08:00

byte[] tokenSeed = new BigInteger("CA423C495478E12CCB329C5C2BA779D0", 16).toByteArray();