Happy Coding ...

Get C# class declaration from Oracle Table

2018-01-11T20:03:00.002-08:00

Select distinct
'public ' ||
case Lower(DATA_TYPE)
when 'raw' then 'Guid?'
when 'number' then 'Decimal?'
when 'char' then 'string'
when 'date' then 'DateTime?'
when 'decimal' then 'decimal?'
when 'nvarchar' then 'string?'
when 'uniqueidentifier' then 'Guid?'
when 'varchar2' then 'string'
else 'UNKNOWN_' || DATA_TYPE
end|| ' '
|| replace(initcap(replace(Column_name,'_',' ')),' ','') || ' { get; set; }' ,
all_tab_columns.column_id
from all_tab_columns where table_name= upper('SPA_DISCOUNT_GROUP')
order by all_tab_columns.column_id

select * from all_tab_columns where table_name= upper('SPA_DISCOUNT_GROUP')

--------------- Result --------------

'PUBLIC'||CASELOWER(DATA_TYPE) COLUMN_ID
1 public Decimal? RefUniqueNo { get; set; } 1
2 public string Reference { get; set; } 2
3 public string DiscType { get; set; } 3
4 public Decimal? DiscPct { get; set; } 4
5 public Guid? DiscountGroupKey { get; set; } 5
6 public Guid? ReferenceRef { get; set; } 6

Get C# class Declaration from SQL Table structure

2018-01-11T03:37:00.002-08:00

Get C# class Declaration from SQL Table structure

------------ CODE ---------- to be executed in SQL ---------

declare @TableName sysname = 'Transaction_document'

declare @Result varchar(max) = 'public class ' + @TableName + '

select @Result = @Result + '

public ' + ColumnType + NullableSign + ' ' + ColumnName + ' { get; set; }

from

(

select

replace(col.name, ' ', '_') ColumnName,

column_id ColumnId,

case typ.name

when 'bigint' then 'long'

when 'binary' then 'byte[]'

when 'bit' then 'bool'

when 'char' then 'string'

when 'date' then 'DateTime'

when 'datetime' then 'DateTime'

when 'datetime2' then 'DateTime'

when 'datetimeoffset' then 'DateTimeOffset'

when 'decimal' then 'decimal'

when 'float' then 'float'

when 'image' then 'byte[]'

when 'int' then 'int'

when 'money' then 'decimal'

when 'nchar' then 'string'

when 'ntext' then 'string'

when 'numeric' then 'decimal'

when 'nvarchar' then 'string'

when 'real' then 'double'

when 'smalldatetime' then 'DateTime'

when 'smallint' then 'short'

when 'smallmoney' then 'decimal'

when 'text' then 'string'

when 'time' then 'TimeSpan'

when 'timestamp' then 'DateTime'

when 'tinyint' then 'byte'

when 'uniqueidentifier' then 'Guid'

when 'varbinary' then 'byte[]'

when 'varchar' then 'string'

else 'UNKNOWN_' + typ.name

end ColumnType,

case

when col.is_nullable = 1 and typ.name in ('bigint', 'bit', 'date', 'datetime', 'datetime2', 'datetimeoffset', 'decimal', 'float', 'int', 'money', 'numeric', 'real', 'smalldatetime', 'smallint', 'smallmoney', 'time', 'tinyint', 'uniqueidentifier')

then '?'

else ''

end NullableSign

from sys.columns col

join sys.types typ on

col.system_type_id = typ.system_type_id AND col.user_type_id = typ.user_type_id

where object_id = object_id(@TableName)

) t

order by ColumnId

set @Result = @Result + '

print @Result

-------------------- RESULT --------------

public class proration_log

{

public Guid Proration_Log_Key { get; set; }

public string Text { get; set; }

public DateTime? Create_Date { get; set; }

}

Load XML data in DataTable and use LINQ on it

2018-01-11T01:53:00.002-08:00

XML Document Structure -

xml version="1.0" encoding="utf-8" standalone="yes"?>

<Root>

</Type>

</Type>

</Root>

Load XML Document in DataTable -

XmlDocument xmlDoc = new XmlDocument();

xmlDoc.Load(Environment.CurrentDirectory + "\\ClientWiseFunctionality.xml");

XmlNodeList elemList = xmlDoc.GetElementsByTagName("Type");

oXmlDataTable.Columns.AddRange(new DataColumn[2] {new DataColumn("FunctionName", typeof(string)),new DataColumn("ClientList",typeof(string)) });

foreach (XmlNode node in elemList)

{

if (node.Attributes["TypeName"].Value == "Functions")

{

foreach (XmlNode childnode in node)

{

oXmlDataTable.Rows.Add(childnode.Attributes["FunctionName"].Value, childnode.Attributes["ClientList"].Value);

}

Load XML data in DataTable and use LINQ on it

var dttt = (from n in oXmlDataTable.AsEnumerable()

where n.Field<string>("FunctionName") == "UnAssignedUasdsers_Mail"

&& n.Field<string>("ClientList").Split(',').Any(i => i.Equals("Malasia"))

select n).ToList();

Visual Studio 2017 keyboard shortcuts

2018-01-11T01:10:00.001-08:00

http://visualstudioshortcuts.com/2017/

2018-01-11T01:02:00.001-08:00

When your keyboard does not display single quotes (') on single click but when it is clicked again displays 2 single quotes ('') , do the following settings

Control Panel > Clock, Language and Region > Region and Language > Keyboards and Language. Click the “Change keyboards” button under “Keyboards and other input languages”. Now the chances are you have chosen “US international”. This behaviour is default on this keyboard setup. Click the “Add” button and add “US”. Change to this and remove US international and your keyboard should start working as expected.

Converts a byte array to a string

2014-03-05T06:16:00.002-08:00

///

/// Converts a byte array to a string

///

/// Byte array to be converted

/// string representation of the byte array

private static string byteArrayToString(byte[] arrInput)
{

StringBuilder sb = new StringBuilder(arrInput.Length * 2);

for (int i = 0; i < arrInput.Length; i++)
sb.Append(arrInput[i].ToString(
"X2"));

return sb.ToString().ToUpper();
}

private static byte[] StringToByteArray(string textString)
{

UTF8Encoding encoding = new UTF8Encoding();

return encoding.GetBytes(textString);
}

Serialization

2014-03-05T06:15:00.002-08:00

Serialization is a process where an object is converted to a form , able to store and transport to different places.

Used for:
to store object to hard drive
send object over the network [Without serialization the remoting will be impossible]

To serialize a class add [Serializable] attribute in front of the class definition

if you dont want to serialize something in this 'serialized' class use [NonSerialized] before it

Note: properties are not serialized

To store the data of a class into a file in binary format
Store myStore = new Store(); // create object of a class to be serialized
myStore.stockCount = 50; // pass value to the variable

    FileStream flStream = new FileStream("MyStore.dat", FileMode.OpenOrCreate, FileAccess.Write);
    try
    {
        BinaryFormatter binFormatter = new BinaryFormatter(); //to store the data to a file in binary format.
        binFormatter.Serialize(flStream, myStore);        //Seralize method stores the data in streams
    }
    finally
    {
        flStream.Close();
     }

DeSeralize
Store readStore = new Store();

    FileStream flStream = new FileStream("MyStore.dat",
        FileMode.Open, FileAccess.Read);
    try
    {
        BinaryFormatter binFormatter = new BinaryFormatter();
        readStore = (Store)binFormatter.Deserialize(flStream);   //'Deserialize' method returns the deserialized object which we cast to our own class 'Store'
    }
    finally
    {
        flStream.Close();
     }

SOAP formatter
seralizes object to XML file. It is a standardized format which all web services use
- add using and reference to System.Runtime.Serialization.Formatters.Soap

The SOAP format being an XML is readable by humans unlike the binary one. So I wrote a function to show the actual code which the object is converted to.

Here is the code: Store myStore = new Store();
Store myStore = new Store();

MemoryStream memStream = new MemoryStream();
    try
    {
        myStore.stockCount = 50;
        SoapFormatter soapFormatter = new SoapFormatter();
        soapFormatter.Serialize(memStream, myStore);

byte[] buff = memStream.GetBuffer();

string soapOutput = "";

foreach(byte b in buff)
soapOutput += (char)b;

        tbOutput.Text += Environment.NewLine +                  "Object 'myStore' serialized to SOAP!";
        tbOutput.Text += soapOutput;
    }
    finally
    {
        memStream.Close();
    }

Here I use a MemoryStream instead of the FileStream I used previously. This way we save ourselves the use of file.

After we store the data to the stream we get its contents with GetBuffer(). I didn't close the memStream right after the write as I did with the FileStream. This is because we loose the stored data once we close it.

The output we get by the SOAP formatter is this:

http://www.w3.org/2001/XMLSchema-instance

"
xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:SOAP-ENC="http://schemas.xmlsoap.org/soap/encoding/"
xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/"
xmlns:clr="http://schemas.microsoft.com/soap/encoding/clr/1.0"
SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/">

http://schemas.microsoft.com/clr/nsassem/

SerializeTest/SerializeTest%2C%20Version%3D1.0.938.186%2C
%20Culture%3Dneutral%2C%20PublicKeyToken%3Dnull">
            50
            My local store

serialization - to save information to disk or the registry
Mark your classes with the [Serializable] attribute and there you go. It�s a simple matter of creating a Formatter and a Stream and a couple of lines later it�s done. Alternatively, you could mark up your class with the necessary attributes and use XML Serialization.

ISSUES with Serialization:
- It forces you to design your classes a certain way
XML serialization only works on public methods and fields, and on classes with public constructors. That means your classes need to be accessible to the outside world. You cannot have private or internal classes, or serialize private data. In addition, it forces restrictions on how you implement collections.

- It is not future-proof for small changes
If you mark your classes as [Serializable], then all the private data not marked as [NonSerialized] will get dumped. You have no control over the format of this data. If you change the name of a private variable, then your code will break.

You can get around this by implementing the ISerializable interface. This gives you much better control of how data is serialized and deserialized.

-It is not future-proof for large changes
Type information is stored as part of the serialization information. If you change your class names or strong-name your assemblies, you�re going to hit all sorts of problems.

5. It is not secure
Using XML serialization is inherently insecure. Your classes need to be public, and they need to have public properties or fields. In addition, XML serialization works by creating temporary files. If you think you�re creating temporary representations of your data (for example, to create a string that you�re going to post to a web service), then files on disk will pose a potential security risk. If, instead, you implement the ISerializable interface and are persisting sensitive internal data, then, even if you�re not exposing private data through your classes, anyone can serialize your data to any file and read it that way, since GetObjectData is a public method.

6. It is inefficient
XML is verbose. And, if you are using the ISerializable interface, type information gets stored along with data. This makes serialization very expensive in terms of disk space.

Random Notes

2014-03-05T06:13:00.001-08:00

Infragistic controls / 3rd party controls are slow. bcos they have additional properties .. they need time to load which can slow a website. By replacing these conrols by user deigned .net controls we made the websit faster frm 3.3 seconds to 2 sec.

also redesign the pages to have better look and feel

SQL profiler is used to see the performance of a sql script. By % how much time taken by what

To return 2 values from a method... 1 can be returned by normal process, other by reference

SQL also has an Execution palnner -> (Query->include execution planner ) Ctrl + M

to get the current user of the system - @System.Security.Principal.WindowsIdentity.GetCurrent().Name;

Create a Maintainance Plan on SQL

2014-03-05T06:12:00.001-08:00

- There are two ways to create a maintenance plan: you can create a plan using the Maintenance Plan Wizard, or you can create a plan using the design surface. The Wizard is best for creating basic maintenance plans, while creating a plan using the design surface allows you to utilize enhanced workflow.

To create or manage Maintenance Plans, you must be a member of the sysadmin fixed server role. Note that Object Explorer only displays maintenance plans if the user is a member of the sysadmin fixed server role.

The Maintenance Plan Wizard helps you set up the core maintenance tasks to make sure that your database performs well, is regularly backed up, and is free of inconsistencies. The Maintenance Plan Wizard creates one or more SQL Server Agent jobs that perform these tasks on local servers or on target servers in a multiserver environment. Execution can be at scheduled intervals or on demand.

Maintenance plans can be created to perform the following tasks:
- Reorganize the data on the data and index pages by rebuilding indexes
- Compress data files by removing empty database pages.

To create a maintenance plan using the Maintenance Plan Wizard
1.In Object Explorer, expand a server, and then expand Management.

2.Right-click Maintenance Plans and select Maintenance Plan Wizard.

3.Follow the steps of the wizard to create a maintenance plan.

WebService - all about it

2014-03-05T06:11:00.003-08:00

This is from 4guysfromrolla.com

A Web Service is an external interface provided by a Web site that can be called from other Web sites. For example, a financial company may make up to the minute stock quotes available via a Web Service for those who do their trading with that company. This information could be read from a Web page and displayed, or read from a stand-alone application on a customer's desktop computer.

my Web Service should provide other Web sites the ability to:

1. View a listing of all of the FAQ categories

2. View a listing of all of the FAQs for a particular category

3. View the "Question" (but not the Answer) for a particular FAQ

Creating Web Services is quite simple. Start by creating a .asmx file. The Web Service is created as an ordinary class; the methods that have the macro before them indicate the method is accessible via the Web Service.

For the ASPFAQs.com Web Service, we will create three Web Service-accessible methods: GetCategories, GetFAQsInCategory, and GetFAQ, which perform the tasks (1), (2), and (3) outlined above, respectively. A private helper function, GetDataSet, is also included, which essentially populates a DataSet based on a passed in SQL query. The code for our Web Service class can be seen below:

<%@ WebService Language="VB" Class="ASPFAQs" %>

Imports System.Web.Services

Imports System.Data

Imports System.Data.SqlClient

Imports System.Configuration

Public Class ASPFAQs

  Private Function GetDataSet(strSQL as String) as DataSet

    '1. Create a connection

    Dim myConnection as New SqlConnection(ConnectionString)

    '2. Create the command object, passing in the SQL string

    Dim myCommand as New SqlCommand(strSQL, myConnection)

    myConnection.Open()

    '3. Create the DataAdapter

    Dim myDataAdapter as New SqlDataAdapter()

    myDataAdapter.SelectCommand = myCommand

    '4. Populate the DataSet and close the connection

    Dim myDataSet as New DataSet()

    myDataAdapter.Fill(myDataSet)

    myConnection.Close()

    'Return the DataSet

    Return myDataSet

  End Function

   Public Function GetCategories() as DataSet

    Return GetDataSet(SQL Query for Retrieving the FAQ Categories)

  End Function

   Public Function GetFAQsInCategory(catID as Integer) as DataSet

    Return GetDataSet(SQL Query for Retrieving the FAQs for Category catID)

  End Function

   Public Function GetFAQ(FAQID as Integer) as DataSet

    Return GetDataSet(SQL Query for Retrieving the FAQ FAQID)

  End Function

End Class

Some things to note: the three Web Service-accessible methods are predicated with ; at the top of the .asmx file is a @WebService directive that specifies the language and class in the file; the Web Service is named ASPFAQs, as shown by the class name. Once you have created this .asmx file and stored it on a Web-accessible directory, you can view the methods by visiting the page directly through your Web browser. For example, I named my Web Service file ASPFAQs.asmx and saved it in the /ws directory; so, by visiting http://aspnet.4guysfromrolla.com/ws/ASPFAQs.asmx, you can see a listing of the Web Method's public methods. Furthermore, you can "try out" the Web Methods by providing input parameters and viewing the returned results.

If you read last week's Protecting Yourself from SQL Injection Attacks article you may be concerned that in using Web Services that accept parameters that are used directly in a SQL statement you are opening yourself up to a SQL Injection attack. (The GetFAQsInCategory and GetFAQ are two such methods that may concern the alert reader.) However, SQL Injection attack is not a problem here because the Web Service code automatically ensures that the input parameter is of the correct type, which is Integer here. Hence, if a malicious user attempts to pass to the Web Service an input parameter of, say, 0 'malicious SQL statement, an error message like Cannot convert 0 'malicious SQL to System.Int32. Parameter name: type --> Input string was not in a correct format will be returned. If, however, the input string is of type String, you should be sure to sanitize the input string by replacing all single apostrophes with two successive single apostrophes.

As the creator of the Web Service, our job is done - we've created the Web Service and other Web sites can now use it through their Web site. You may be wondering, though, how a Web Service can be "consumed" by another Web site.

Consuming a Web Service

For a Web site to consume a Web Service, a rather complicated and terse communication must occur between the client Web site (henceforth referred to as the "consumer") and the Web site that is providing the Web service (henceforth the "producer"). Essentially, the consumer must decide what producer's method it wishes to call. If there are input parameters, these parameters must be converted into XML to be passed along. An HTTP request is then made from the consumer to the producer, specifying the method it wishes to call and passing along the parameters in either a SOAP request, through the QueryString, or in the POST headers.

The producer receives the incoming request, unpackages the input parameters, and calls the appropriate method of the specified class. This method, when complete, returns some value, which is packaged up and sent back to the consumer in an HTTP response. The consumer receives this response, unpackages the return value, completing the Web Service call.

Clearly we'd like to not have to worry about the HTTP message passing semantics at all when using Web Services. In order to remove this as a concern, we use what is called a Proxy class. Proxy classes serve as an intermediate step between the program (or Web page) on the consumer and the actual Web service on the producer. For each method in the producer's Web Service, there is a method in the Proxy class. It is the responsibility of the Proxy class to do all of the complicated message-passing tasks; essentially this complexity is hidden in the class, our Web page can simply call the methods of this class and not concern itself with the underlying semantics involved in calling a Web Service.

What in the World did he just Say?

The fundamental thing to understand is that the HTTP communications that must occur between a consumer and producer when calling a Web Service can be complicated and require much code. We'd prefer to have our Web pages that utilize Web Services be able to invoke the Web Service just as if it were a local component. In order to accomplish this, a Proxy class is used, whose public interface mirrors that of the Web Service.

Creating the Proxy Class in Visual Studio .NET

Creating a Proxy class for a Web Service is a breeze in Visual Studio .NET. In your ASP.NET Web Project, simply right click on the References icon and choose to "Add a Web Reference." A dialog box will appear asking you for a URL - simply enter the URL of the Web Service, such as: http://aspnet.4guysfromrolla.com/ws/ASPFAQs.asmx. You will then see the description of the Web Service (just as if you had visited the URL directly through your Web browser). To complete this task, click the "Add Reference" button, which will automatically create the Proxy class for you and compile it.

When added to your project the Proxy class's namespace will likely be the URL of your site, for example: com.4guysfromrolla.aspnet. (You can rename this if you so choose.) To call the Web Service from a Web page you use the Proxy class like you would any other local component. Imagine that we wanted to display a list of the FAQs from the ASP.NET category (which has category ID 22). We could do this by making a call to the GetFAQsInCategory method of the Web Service, passing in the parameter 22, and binding the resulting DataSet to a DataGrid, like so:

'HTML content in .aspx page...

'*** ------------------------------------------------ ***'

'code content in the code-behind page

Private Sub Page_Load(sender as Object, e as EventArgs)

  'Create an instance of the Proxy class

  Dim consumeWebService as com._4guysfromrolla.aspnet.ASPFAQs

  Set consumeWebService = New com._4guysfromrolla.aspnet.ASPFAQs

  'Bind the results of GetFAQsInCategory to dgCategoryFAQs

  dgCategoryFAQs.DataSource = consumeWebService.GetFAQsInCategory(22)

  dgCategoryFAQs.DataBind()

End Sub

From simply examining the code you could not determine that the call to the com._4guysfromrolla.aspnet.ASPFAQs Proxy class is, in actuality, a remote Web service call. When the Proxy class's GetFAQsInCategory method is called, the complex communications discussed previously occur (the remote HTTP request/response dialogue).

Creating a Proxy Class without Visual Studio .NET

Creating a Proxy class through Visual Studio .NET is very easy; however, if you don't have Visual Studio .NET, you can still create Proxy classes, but you must do so through the command-line. For more information on this technique be sure to read the PowerPoint presentation: Calling a Web Service from an ASP.NET Web Page.

Conclusion

In this article we examined how to create a Web Service and then how to consume it from an ASP.NET Web page using Visual Studio .NET. Microsoft has really simplified the process of producing and consuming Web Services with .NET. Creating a Web Service is as simple as creating a .asmx file and writing the code for the Web Service methods - save for the macros, the code appears nearly identical to the code one would write for a local component. Consuming a Web Service is painfully simple too, thanks to the use of Proxy classes. On top of that, the creation of Proxy classes is utterly simple through tools such as Visual Studio .NET.

Threading in C#

2014-03-05T06:10:00.002-08:00

C# supports parallel execution of code through multithreading

A thread is an independent execution path, able to run simultaneously with other thread

http://www.albahari.com/threading/

WCF Basic

2014-03-05T06:09:00.002-08:00

WCF
- windows communication foundation (.net 3.0)
- communication framework
- enables us to expose CLR type services and consume exisitng services as CLR types
- Different communication technologies in the world - webservices (asmx), web services enhancements(wse), messaging (msmq), .net enterprise services (ES), .net remoting
- used for building service oriented applications
- eg: websevice for weather - consumes zip code and outputs forecast
- wcf service is based on contract ( implemented as an interface decorated with the attribute [ServiceContractAttribute] )
[ServiceContract]
public interface IWeatherForecastService
{
    [OperationContract]
    public WeatherForecast GetForeCast(int zipCode);
}
- Address : where the service will be found [ServiceContract]
public interface IWeatherForecastService
{
    [OperationContract]
    public WeatherForecast GetForeCast(int zipCode);
}
ABC od WCF
- Address: where the service will be found scheme://domaon[:port]/path (e.g.: http://localhost:8080/MyWCFService ).
- Binding :Protocols used by specific endpoint(http, tcp, msmq)
- Contract : Expresses what the service does (can have an app with multiple channels)
- Endpoint : combination of ABC
- Consumer of sevice creates a proxy. This Proxy is what the consumer uses to communicate with the host and basically is an empty type that exposes all operations in a service contract, and hides serialization/sending over wire details. A single proxy, uses a single endpoint.
- WeatherForecast type is a class we wrote and it represents a business object that conveniently holds all data related to the forecast. When sending this object to a consumer it will be serialized.
Conclusion: We have a host and client who agree upon a contract. Our host exposes one or more EndPoints which are a combination of Address, Binding and Contract. On the other side our client uses a Proxy (this proxy is tied to a specified EndPoint thus also tied to a particular Contract). The actual communication related details are abstracted in Channels and Behaviors.
Ask these to yourself
   - First, think of the contract (What am I trying to do?!)
   - Secondly, think of where you will host it, and what technology you will use to host it.
   - Finally think of the other parts like authentication.
1. Create a 'WCF Service Application'
2. Add a new WCF Service file (.svc). [name.svc and Iname.cs will be created]
3. Add this in .cs file
namespace HelloWorldService
{
    [ServiceContract]
    public interface IHelloWorld
    {
        [OperationContract]
        string sayHello(string name);
    }
}
4. Add this in .svc file
namespace HelloWorldService
{
   public class HelloWorld : IHelloWorld
    {
        public string sayHello(string name)
        {
            return "Hello " + name;
        }
    }
}
5. We just can run the application and use the default bindings
6. To test the method we can also run WCF Test Client (in C:\Program Files\Microsoft Visual Studio 10.0\Common7\IDE) and pass value to the method. We can see the output in 2 formats - XML, formated

The request:
http://schemas.xmlsoap.org/soap/envelope/

">

            xmlns="http://schemas.microsoft.com/ws/2005/05/addressing/none">                 http://tempuri.org/IHelloWorld/sayHello>

    http://tempuri.org/">
      Jeroen


The response:http://schemas.xmlsoap.org/soap/envelope/
">

    http://tempuri.org/">
      Hello Jeroen


WCF CLIENT - will consume this service
client can be created
- by using metadata exposed by the EndPoint to generate proxies on the fly
- by pre-distribute the metadata as a definition of the interface, or a dll that contains the IHelloWorld interface.
1. Create a console app and add a refernce to our WCF service (add service refernce : address : http://localhost:5558/HelloWorld.svc
2. write
static void Main(string[] args)
{
    // Create a new HelloWorldClient object
    HelloWorldReference.HelloWorldClient client = new HelloWorldReference.HelloWorldClient();
    // Write the response from the sayHello method
    Console.WriteLine(client.sayHello("Jeroen"));
    // Close the WCF connection
    client.Close();
    Console.Read();
}

Types of Contracts / Services:
1. Service Contract : all operations that client can perform
2. Data Contract : defines data types that are passed in and out of service. [DataContract] and [DataMember] attributes are used
3. Fault Contract : describes the error raised by the service . [FaultContract(<>)] attribute is used
4. Message Contracts: direct control over SOAP message structure. This is useful in inter-operability cases and when there is an existing message format you have to comply with. [MessageContract], [MessageHeader], [MessageBodyMember] attributes are used

Example of Data Service:
- Microsoft implementation of OData, which is an open-format specification for accessing data
- Microsoft Visual Studio .NET facilitates creating a WCF data service by using an ADO.NET Entity Framework data model.
- WCF Data Services is designed to provide access to your data (xml, database,

A solution has a web application and a 'WCF Data Service' file (exposed URI you can call from the internet)

GetNoOfPagesPDF & Merge

2014-03-05T05:29:00.002-08:00

 //public static int GetNoOfPagesPDF(string FileName)
        //{
        //    int result = 0;
        //    FileStream fs = new FileStream(FileName, FileMode.Open, FileAccess.Read);
        //    StreamReader r = new StreamReader(fs);
        //    string pdfText = r.ReadToEnd();
 
        //    System.Text.RegularExpressions.Regex regx = new Regex(@"/Type\s*/Page[^s]");
        //    System.Text.RegularExpressions.MatchCollection matches = regx.Matches(pdfText);
        //    result = matches.Count;
        //    return result;
 
        //}

 public void merge(string sFile1, string sFile2)
        {
            FileStream fs1 = null;
            FileStream fs2 = null;
            try
            {
                fs1 = File.Open(sFile1, FileMode.Append);
                fs2 = File.Open(sFile2, FileMode.Open);
                byte[] fs2Content = new byte[fs2.Length];
                fs2.Read(fs2Content, 0, (int)fs2.Length);
                fs1.Write(fs2Content, 0, (int)fs2.Length);
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message + " : " + ex.StackTrace);
            }
            finally
            {
                fs1.Close();
                fs2.Close();
            }
        }

Connecting to multiple databases in MVC web application

2014-03-05T05:28:00.003-08:00

In your web.config file, you could define your two connection strings:


    <add name="DevelopmentDB" providerName="System.Data.SqlClient"
        connectionString="Data Source=sql-dev.example.com;Initial Catalog=MyDB;User Id=MyUser;Password=MyPassword" />
    <add name="ProductionDB" providerName="System.Data.SqlClient"
        connectionString="Data Source=sql-prod.example.com;Initial Catalog=MyDB;User Id=MyUser;Password=MyPassword" />
</connectionStrings>

Then, in your (base) controller, you could create a method that returns the appropriate connection string based upon the request, such as:

internal string ConnectionString
{
    get
    {
        return getConnectionStringByServerName(this.HttpContext.Request.ServerVariables["SERVER_NAME"]);
    }
}

internal string getConnectionStringByServerName(string serverName)
{
    if (serverName.Equals("localhost"))
    {
        return WebConfigurationManager.ConnectionStrings["DevelopmentDB"].ConnectionString;
    }
    else
    {
        return WebConfigurationManager.ConnectionStrings["ProductionDB"].ConnectionString;
    }
}

IEnumerator and IEnumerable interfaces in the .NET framework

2014-03-05T05:27:00.003-08:00

Enumerators can be an incredibly powerful way of iterating through data.

Iterators are also very useful in situations where the amount of data is not easily known at the start of the process.

- and for deserialisation of a file

The iterator reads the file, calls the necessary factory methods and passes back objects that it have been constructed based on data in the file.

using a while loop accessing the IEnumerator based object directly, and second, using a foreach loop accessing the enumerator through the IEnumerable interface.

As enumerators are always initially pointed to just before the first element, this index is set to -1. The Reset() method also sets the current index back to -1.

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

IEnumerator interface

The IEnumerator interface provides iterative capability for a collection that is internal to a class. IEnumerator requires that you implement three methods:

    * The MoveNext method, which increments the collection index by 1 and returns a bool that indicates whether the end of the collection has been reached.
    * The Reset method, which resets the collection index to its initial value of -1. This invalidates the enumerator.
    * The Current method, which returns the current object at [position].

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

IEnumerable interface
The IEnumerable interface provides support for the foreach iteration. IEnumerable requires that you implement the GetEnumerator method.

Classes and Property Grid

2014-03-05T05:26:00.001-08:00

The property grid is fairly easy to use.The hard part is making the class that you want to display in the grid "Property Grid Friendly".

1. Create public properties for fields you want to expose. All properties should have get and set methods.(If you don't have a get method, the property won't show up in the PropertyGrid).
2. System.ComponentModel namespace have the following attribute
a. CategoryAttribute: This attribute places your property in the appropriate category in a node on the property grid.
b. DescriptionAttribute: This attribute places a description of your property at the bottom of the property grid
c. BrowsableAttribut: This is used to determine whether or not the property is shown or hidden in the property grid
d. ReadOnlyAttribute: Use this attribute to make your property read only inside the property grid
e.DefaultValueAttribute: Specifies the default value of the property shown in the property grid
f: DefaultPropertyAttribute:If placed above a property, this property gets the focus when the property grid is first launched. Unlike the other attributes, this attribute goes above the class.

eg: Customer Class: we simply create the customer class with private fields and public properties that access these fields. Attributes are placed above the properties to ready each property for the property grid.
using System.ComponentModel;
[DefaultPropertyAttribute("Name")]public class Customer
{private string _name;private int _age;private DateTime _dateOfBirth;private string _SSN;private string _address;private string _email;private bool _frequentBuyer; // Name property with category attribute and // description attribute added [CategoryAttribute("ID Settings"), DescriptionAttribute("Name of the customer")]
public string Name
{get{return _name;
} set
{
_name = value;
}
}
[CategoryAttribute("ID Settings"),
DescriptionAttribute("Social Security Number of the customer")]public string SSN
{get{return _SSN;
} set{
_SSN = value;
}
}
[CategoryAttribute("ID Settings"),
DescriptionAttribute("Address of the customer")]public string Address
{get{return _address;
}set{
_address = value;
}
}
[CategoryAttribute("ID Settings"),
DescriptionAttribute("Date of Birth of the Customer (optional)")]public DateTime DateOfBirth
{get{return _dateOfBirth;
} set{
_dateOfBirth = value;
}
}
[CategoryAttribute("ID Settings"), DescriptionAttribute("Age of the customer")]
public int Age
{get{return _age;
} set{
_age = value;
}
}
[CategoryAttribute("Marketting Settings"), DescriptionAttribute("If the customer as bought more than 10 times, this is set to true")]public bool FrequentBuyer
{get{return _frequentBuyer;
} set{
_frequentBuyer = value;
}
}
[CategoryAttribute("Marketting Settings"), DescriptionAttribute("Most current e-mail of the customer")] public string Email
{get{return _email;
} set{
_email = value;
}
}public Customer()
{
}
}

Assigning the PropertyGrid an Object

All that is left to do to get the grid running is assign an instance of our customer class to the property grid.The property grid will automatically figure out all the fields of the customer through reflection and display the property name along with the property value on each line of the grid. Another nice feature of the property grid is it will create special editing controls on each line that correspond to the value type on that line.For example, a Date of Birth property (of type DateTime) of the customer will allow you to edit the value of the the date with the calendar control. Booleans can be edited with a combo box showing True or False (saves you from excess typing).

created a new customer and populated it with values through its properties.We then use the SelectObject property of the PropertyGrid and assign our customer object to this property.Upon assigning the customer to the grid, the grid will display all of the public properties we defined in our Customer class.

private void Form1_Load(object sender, System.EventArgs e)
{// Create the customer object we want to displayCustomer bill = new Customer();// Assign values to the propertiesbill.Age = 50;
bill.Address = " 114 Maple Drive ";
bill.DateOfBirth = Convert.ToDateTime(" 9/14/78");
bill.SSN = "123-345-3566";
bill.Email = bill@aol.com;
bill.Name = "Bill Smith"; // Sets the the grid with the customer instance to be// browsedpropertyGrid1.SelectedObject = bill;
}

Sp_updatestats

2014-03-05T04:25:00.000-08:00

select

B.name as TableName

,c.name IndexName

,A.OBJECT_ID,avg_fragmentation_in_percent

,' ALTER INDEX [' + c.name + '] ON ' + B.name +

CASE WHEN avg_fragmentation_in_percent>= 40.0

THEN ' REBUILD'

WHEN avg_fragmentation_in_percent >= 10.0 AND avg_fragmentation_in_percent < 40.0

THEN ' REORGANIZE'

ELSE

END AS FixIndexCommand

--,A.*

from SYS.objects B

JOIN SYS.indexes C ON B.object_id=C.object_id

JOIN SYS.dm_db_index_physical_stats(DB_ID(),NULL,NULL,NULL,NULL) A

ON A.object_id=B.object_id AND A.database_ID = DB_ID()

AND a.index_id = C.index_id

where c.name is not null

--and B.name like 'TableName'

and A.avg_fragmentation_in_percent >= 10.0

ORDER BY B.Name

Time out issue

2014-03-05T04:10:00.003-08:00

When your app runs into a timeout on a database operation the error message may lead you in a wrong direction to fix things. Which happened to me so this is my little index to the docs.

A sqlConnection has a ConnectionTimeout property. It is a property which determines the maximum number of seconds your code will wait for a connection to the database to open. It is set in the connectionstring to the database

data source=BROCHIS;initial catalog=Indato;integrated security=SSPI;Connect Timeout=60;

Opening the connection does not do anything in the database yet. That is handled by a SqlCommand, which could be part of a SqlDataAdapter. The SqlCommand has aCommandTimeOut. This is a settable property which determines the maximum number of seconds the command is given to execute the sql. By default this is 30 seconds. When you perform something costly in the database this is the one whose value you’ll have to change.

SqlCommand cmd;

if (bigJob)

cmd.CommandTimeout = 60;

For both properties a value of 0 indicates to wait forever. Both properties also apply to non sqlserver database operations. They are defined in IdbConnection and IdbCommand.

TFS

2014-03-05T04:10:00.000-08:00

Work items will NOT be duplicated during branching or merging process
The work item links will NOT be updated or extend with links referencing the new branch/merged items
Work items exist at a logical level that is distinct from that of the source control repository. That means the branching of the source code or merging between two branches has no impact on work items.

Relativity

2014-03-05T03:50:00.002-08:00

Relativity – Imaging Documents

In relativity, you can convert group of doc to images using imaging porofile and sets

· Image output DPI

· Color Image – yes/No

· Image Size : Converts a document to an image that fits with the selected page dimension.This feature will resize images when they are larger tgan the selected page size , using the aspect ratio to maintain image proportion. When an image is of the same size or smaller no change will be made to it.

o Use page setting : uses current document size for image conversion

o Letter (8.5 in X 11 in)

o A4 (8.27 in X 11.69 in)

o Legal (8.5 X 14 in)

o Custom Size

· Maximum Image Height (inches) / Maximum Image Width (inches) - largest allowed size for geneartion of custom image

Relativity is using web services (web service URL for the native imaging server in the configuration table)

Word Processor is the category for common word processing formats such as Word, WordStar, Word-Perfect, and others. (Additional super types are Database, Spreadsheet, Graphic, Multimedia,and Other.)

Maximum pages imaged per file is a native global setting for all document types that sets the

maximum number of document pages that are imaged. For example, if you set this value to 50

and have a 100-page document, only the first 50 pages of the document will be imaged. Use this

option to image only the number of pages entered in this box.

Time Zone Field on Document determines what time zone will be used to display dates/times

in a document image. If no selection is made here, the time zone will default to Greenwich Mean Time

(GMT).

Node.js – javascript api to run programs on server

single-threaded approach to event-driven programming is different from what I know today

When a client browser initiates an HTTP request for a resource on the Web server, HTTP.sys intercepts the request.
HTTP.sys contacts WAS to obtain information from the configuration store.
WAS requests configuration information from the configuration store, applicationHost.config.
The WWW Service receives configuration information, such as application pool and site configuration.
The WWW Service uses the configuration information to configure HTTP.sys.
WAS starts a worker process for the application pool to which the request was made.
The worker process processes the request and returns a response to HTTP.sys.
The client receives a response.

When WAS starts a worker process (w3wp.exe) the worker process allocates a thread for loading and executing your application. This is analogous to starting a program and inspecting the process in Windows Task Manager. If you open 3 instances of the program, you will see 3 processes in task manager and each process will have a minimum of one thread. If an unhandled exception occurs in the program, the entire process is torn down, but it doesn’t affect other processes because they are isolated for each other.

Processes, however, are not free. Starting and maintaining a process requires CPU time and memory, both of which are finite, and more processes and threads require more resources.

.NET improves resource consumption and adds an additional degree of isolation through Application Domains or AppDomains. AppDomains live within a process and your application runs inside an AppDomain.

You’ve created two ASP.NET applications on the same server, and have not done any special configuration. What is happening?

A single ASP.NET worker process will host both of the ASP.NET applications. On Windows XP and Windows 2000 this process is named aspnet_wp.exe, and the process runs under the security context of the local ASPNET account. On Windows 2003 the worker process has the name w3wp.exe and runs under the NETWORK SERVICE account by default.

An object lives in one AppDomain. Each ASP.NET application will have it’s own set of global variables: Cache, Application, and Session objects are not shared. Even though the code for both of the applications resides inside the same process, the unit of isolation is the .NET AppDomain. If there are classes with shared or static members, and those classes exist in both applications, each AppDomain will have it’s own copy of the static fields – the data is not shared. The code and data for each application is safely isolated and inside of a boundary provided by the AppDomain

In order to communicate or pass objects between AppDomains, you’ll need to look at techniques in .NET for communication across boundaries, such as .NET remoting or web services.

As outlined in steps 1 – 7 above, when a request comes in, IIS uses an I/O thread to dispatch the request off to ASP.NET. ASP.NET immediately sends the request to the CLR thread pool which returns immediately with a pending status. This frees the IIS I/O thread to handle the next request and so on. Now, if there is a thread available in the thread pool, life is good, and the work item is executed, returning back to the I/O thread in step 7. However, if all of the threads in the thread pool are busy, the request will queue until a CLR thread pool thread is available to process the work item, and if the queue length is too high, users will receive a somewhat terse request to go away and come back later.

This is a bit of an extreme trivialization of what happens. There are a number of knobs that can be set in IIS and ASP.NET that allow you to tune the number of concurrent requests, threads and connections that affect both IIS and the CLR thread pool. For example, the IIS thread pool has a maximum thread count of 256. ASP.NET initializes its thread pool to 100 threads per processor/core. You can adjust things like the maximum number of concurrent requests per CPU (which defaults to 5000) and maximum number of connections of 12 per CPU but this can be increased. This stuff is not easy to grasp, and system administrators dedicate entire careers to getting this right. In fact, it is so hard, that we are slowly moving away from having to manage this ourselves and just paying some really smart engineers to do it for us, at massive scale.

Diff Input Types

2014-03-05T03:48:00.004-08:00

*InputType*	*Description*	*Functionality*
Text	Any text string up to 450 characters	Multiple times
Date	Eight character date in YYYYMMDD format	Multiple times
Partial Date	Eight character date in YYYYMMDD format which allows zeroes	Multiple times
Numeric	Any number value (2, 27, 999)	Multiple times
List - Single Select	Drop down list, only allowing the list to appear once	Single
List - Multi Select	Drop down list, allowing the list to appear multiple times	Multiple times
List - Optional Select	Drop Down List with option to type in the value	Single
Memo	Any length text string	Multiple times
Decimal	Any number value requiring up to 5 decimal places	Multiple times
Text (Single)	Any text string up to 450 characters	Single
Date (Single)	Eight character date in YYYYMMDD format	Single
Partial Date (Single)	Eight character date in YYYYMMDD format which allows zeroes	Single
Numeric (Single)	Any number value (2, 27, 999)	Single
Memo (Single)	Any length text string	Single
Decimal (Single)	Any number value requiring up to 5 decimal places	Single

Adding FileName in footer to PDF file

2014-03-05T03:46:00.003-08:00

Open Adobe Acrobat Pro

Advanced – Document processing – Batch processing - New Sequence

Name the sequence *** and click OK

Select the sequence - In Edit Sequence –Select command - select ->JavaSript – Execute JavaScript – Add – JavaScript – click edit and paste the javascript there

var re = /.*\/|\.pdf$/ig;

var FileNM = this.path.replace(re,"")+".pdf";

var Path = this.path;

var Box2Width = 50

for (var p = 0; p < this.numPages; p++)

{

var aRect = this.getPageBox("Crop",p);

var TotWidth = aRect[2] - aRect[0]

var fd = this.addField("xftDate", "text", p, [30,15, TotWidth-30-30,30]);

fd.value = FileNM ;

fd.textSize=6;

fd.readonly = true;

fd.alignment="left" ;

var bStart=(TotWidth/2)-(Box2Width/2)

var bEnd=((TotWidth/2)+(Box2Width/2))

var bStart=(TotWidth-Box2Width-30); var bEnd=(TotWidth-30);

var fp = this.addField(String("xftPage"+p+1), "text", p, [bStart,30,bEnd,15]);

fp.value = "Page: " + String(p+1)+ "/" + this.numPages;

fp.textSize=6;

fp.readonly = true;

fp.alignment="center";

}

flattenPages();

Logic:

Get all files that are PDF

Assign the name of the file and append .pdf to it to get the full filename

Get the path

Assign width of 50 to the box

Loop through all the pages

Get the rectangle and width

Add field field-name, field-type, page-number, location

Set field value

Set field text size

Is it read-only

Alignment in the rectangle

Add another field and follow the same process

SQL Server 2008 Microsoft Certified Master (MCM) Readiness Videos

2014-02-28T04:37:00.002-08:00

http://technet.microsoft.com/en-us/sqlserver/ff977043.aspx

Display Chinese Characters in SQL

2012-12-07T13:12:00.001-08:00

-- TO REMOVE ALL UNWANTED TERMS FROM THE STRING AND DISPLAY CHINESE , RUSSIAN AND ENGLISH, DUTCH, GERMAN.... CHARACTERS

CREATE PROCEDURE [dbo].[XXX]

@UserName nvarchar(32)

BEGIN

-- SET NOCOUNT ON added to prevent extra result sets from

-- interfering with SELECT statements.

SET NOCOUNT ON;

Declare @strText as nvarchar(500)

select @strText = Replace(SearchText,N'^',N'')

from TABLENAME

where UserName = @UserName

While PatIndex(N'%[^a-z^A-Z^0-9^А-Я^а-я^诶-贼德^一-龥 ]%', @strText) > 0

BEGIN

Set @strText = Stuff(@strText, PatIndex(N'%[^a-z^A-Z^0-9^А-Я^а-я^诶-贼德^一-龥 ]%', @strText), 1, ' ')

END

select @strText as UserKeyword

END

Reasons Not to Mess with Children

2012-05-14T19:02:00.000-07:00

A little girl was talking to her teacher about whales.
The teacher said it was physically impossible for a whale to swallow
a human because even though it was a very large mammal its
throat was very small.

The little girl stated that Jonah was swallowed by a whale.

Irritated, the teacher reiterated that a whale could not swallow
a human; it was physically impossible.

The little girl said, 'When I get to heaven I will ask Jonah.'

The teacher asked, 'What if Jonah went to hell?'

The little girl replied, 'Then you ask him.'

A Kindergarten teacher was observing her classroom of children
while they were drawing. She would occasionally walk around
to see each child's work.

As she got to one little girl who was working diligently,
she asked what the drawing was.

The girl replied, 'I'm drawing God.'

The teacher paused and said,
'But no one knows what God looks like.'

Without missing a beat, or looking up from her drawing,
the girl replied, 'They will in a minute.'

A Sunday school teacher was discussing the
Ten Commandments with her five and six year olds.

After explaining the commandment to 'honour' thy Father and
thy Mother, she asked, 'Is there a commandment that
teaches us how to treat our brothers and sisters?'

Without missing a beat one little boy,
the oldest of a family, answered,
'Thou shall not kill.'

One day a little girl was sitting and watching her mother do
the dishes at the kitchen sink. She suddenly noticed that
her mother had several strands of white hair sticking out
in contrast on her brunette head.

She looked at her mother and inquisitively asked,
'Why are some of your hairs white, Mum?'

Her mother replied, 'Well, every time that you do something wrong
and make me cry or unhappy, one of my hairs turns white.'

The little girl thought about this revelation for a while and then said, 'Mummy, how come ALL of grandma's hairs are white?'

The children had all been photographed, and the teacher was
trying to persuade them each to buy a copy of the group picture.

'Just think how nice it will be to look at it when you are all
grown up and say, 'There's Jennifer, she's a lawyer,' or
'That's Michael, he's a doctor.'

A small voice at the back of the room rang out, 'And there's the teacher, she's dead.'

A teacher was giving a lesson on the circulation of the blood.
Trying to make the matter clearer, she said, 'Now, class, if I
stood on my head, the blood, as you know, would run into it,
and I would turn red in the face.'
'Yes,' the class said.

'Then why is it that while I am standing upright in the ordinary position the blood doesn't run into my feet?'

A little fellow shouted,
'Cause your feet ain't empty.'

The children were lined up in the cafeteria of a Catholic
elementary school for lunch. At the head of the table was a
large pile of apples. The nun made a note,
and posted on the apple tray:

'Take only ONE. God is watching.'

Moving further along the lunch line, at the other end of
the table was a large pile of chocolate chip cookies.

A child had written a note,
'Take all you want. God is watching the apples.'