AG's Blog

Remove Empty rows from datatable using c#

2016-07-15T05:06:00.002-07:00

public DataTable RemoveEmptyRowsFromDataTable(DataTable dt)
        {
            for (int i = dt.Rows.Count - 1; i >= 0; i--)
            {
                if (dt.Rows[i][1] == DBNull.Value)
                    dt.Rows[i].Delete();
            }
            dt.AcceptChanges();
            return dt;
        }

Bulk Insert in MS-SQL using c#

2016-07-15T05:02:00.000-07:00

using (SqlConnection con = new SqlConnection(consString))
                    {
                        using (SqlBulkCopy sqlBulkCopy = new SqlBulkCopy(con))
                        {
                            //Set the database table name
                            sqlBulkCopy.DestinationTableName = "PLQualifications";

                            //[OPTIONAL]: Map the DataTable columns with that of the database table
                            sqlBulkCopy.ColumnMappings.Add("QualificationId", "QualificationId");
                            sqlBulkCopy.ColumnMappings.Add("PLQuestionCode", "PLQuestionCode");
                            sqlBulkCopy.ColumnMappings.Add("LanguageId", "LanguageId");
                            con.Open();
                            sqlBulkCopy.WriteToServer(distinctQualifications);
                            con.Close();
                        }
                    }

Removing unrecognized ASCII characters from string c#

2016-06-29T07:25:00.002-07:00

var stripped = Regex.Replace("străipped of baâ€d charâ€cters", "[^ -~]", "");

[ -~] matches all printable ascii characters (light blue background)

Break long URLs within the specified column

2015-11-12T00:35:00.003-08:00

First add a style / class as below

.hyphenate {
/* Careful, this breaks the word wherever it is without a hyphen */
overflow-wrap: break-word;
word-wrap: break-word;

/* Adds a hyphen where the word breaks */
-webkit-hyphens: auto;
-ms-hyphens: auto;
-moz-hyphens: auto;
hyphens: auto;
}

Now add this class / style on the div or td as below

<p class="hyphenate">http://kjfh.com/kjdfhsdkdksjfjdskfkjdshkfjsdkjflkdsjlfjdslfjldsjlfjldskjfldsjlfjldsjfljdslfjldsjfldjslfjldsjfljdsljfldsjf</p>

Calculate sub total of all rows values having textbox in each row

2015-09-15T00:49:00.002-07:00

http://stackoverflow.com/questions/20159426/showing-the-sum-of-all-price-text-boxclass-price-in-to-subtotal-textboxid

-----------HTML----------------

<tr class="row" id="item10">
<td><input type="text" name="barcode" class="barcode" style="width: 50px"/></td>
<td><input type="text" name="type" class="type" readonly="true" style="width: 50px"/></td>
<td><input type="text" name="color" class="color" readonly="true" style="width: 50px"/></td>
<td><input type="text" name="qty" class="qty" style="width: 50px"/></td>
<td><input type="text" name="unitprice" readonly="true" class="unitPrice" style="width: 50px"/></td>
<td><input type="text" name="price" class="price" style="width: 50px"/></td>
</tr>

<tr class="row" id="item10">
<td><input type="text" name="barcode" class="barcode" style="width: 50px"/></td>
<td><input type="text" name="type" class="type" readonly="true" style="width: 50px"/></td>
<td><input type="text" name="color" class="color" readonly="true" style="width: 50px"/></td>
<td><input type="text" name="qty" class="qty" style="width: 50px"/></td>
<td><input type="text" name="unitprice" readonly="true" class="unitPrice" style="width: 50px"/></td>
<td><input type="text" name="price" class="price" style="width: 50px"/></td>
</tr>

<tr id="SubTotal">
<td colspan="5">SubTotal</td>
<td><input type="text" name="subTotal" id="subTotal" style="width: 50px"/></td>
</tr>
<tr id="VAt">
<td colspan="5">Vat</td>
<td><input type="text" name="vat" id="vat" style="width: 50px"/></td>
</tr>
<tr id="Total">
<td colspan="5">Total</td>
<td><input type="text" name="Total" id="Total" style="width: 50px"/></td>
</tr>

---- jQuery

var $inputs = $('input[name=price]');
$inputs.change(function () {
var sum = 0;
$inputs.each(function () {
if($(this).val()>10)
{
$(this).css('border','solid 1px #ee0000');
}
else
{
$(this).css('border','solid 1px #000000');
}
sum += +$(this).val() || 0;
});
$('#subTotal').val(sum);
});

Bulk insert into an Oracle database through .Net C#

2014-05-13T03:27:00.003-07:00

Bulk insert into an Oracle database through .Net C#

Below is the code to import thousands of records into an Oracle database in a .NET component.

Both allow you to do bulk inserts using something called array binding. This basically means that you can insert multiple records at once in one database call, thereby avoiding unnecessary round trips.

The table that I had to fill was called IMPORTJOBS:

CREATE TABLE IMPORTJOBS
(
ID             RAW(16)                        NOT NULL,
IMPORTBATCHID RAW(16)                        NOT NULL,
DATA           VARCHAR2(4000 BYTE)            NOT NULL,
STATUSCODE     VARCHAR2(20 BYTE)              NOT NULL,
RESULTID       RAW(16)
)

public interface IOracleBulkInsertProvider
{
    void BulkInsertImportBatches(string connectionString,
          List<ImportJob> importJobs);
}

public class OracleBulkInsertProvider : IOracleBulkInsertProvider
{
    public void BulkInsertImportBatches(string connectionString,
                                            List<ImportJob> importJobs)
    {
        var ids = importJobs.Select(ib => ib.Id).ToList();
        var importBatchIds =
                  importJobs.Select(ib => ib.ImportBatchId).ToList();
        var datas = importJobs.Select(ib => ib.Data).ToList();
        var statusCodes =
                  importJobs.Select(ib => ib.ImportJobStatus.Code).ToList();

        const string sql = "insert into IMPORTJOBS (ID, IMPORTBATCHID, DATA,
            STATUSCODE) values (:id, :importBatchId, :data, :statusCode)";

        using (var oracleConnection =
                               new OracleConnection(connectionString))
        {
            oracleConnection.Open();
            using (var command = oracleConnection.CreateCommand())
            {
                command.CommandText = sql;
                command.CommandType = CommandType.Text;
                command.Parameters.Add(":id", OracleDbType.Raw,
                  ids.ToArray(), ParameterDirection.Input);
                command.Parameters.Add(":importBatchId", OracleDbType.Raw,
                  importBatchIds.ToArray(), ParameterDirection.Input);
                command.Parameters.Add(":data", OracleDbType.VarChar,
                  datas.ToArray(), ParameterDirection.Input);
                command.Parameters.Add(":statusCode", OracleDbType.VarChar,
                  statusCodes.ToArray(), ParameterDirection.Input);
                command.ExecuteArray(importJobs.Count);
            }
        }
    }
}

I think the code is straightforward. The goal is to create a command, add input parameters and at the same time provide a list of actual values to insert for that parameter. At the end we simply call the ExecuteArray operation.

This way, the time needed to insert 25.000 records takes about 2 seconds.

Recommendations for Abstract Classes vs. Interfaces

2014-03-13T04:21:00.003-07:00

The general guideline: Use abstract clas for "is A" relationship, while use interfaces for "Can do" relationship.
For example:
An Aircraft "is a" Vehicle and it "can" fly.
So it makes sense to make Vehicle an abstract class and make an interface IFlyable that class Aircraft implements and Aircraft derives from Vehicle class.

The choice of whether to design your functionality as an interface or an abstract class (a MustInherit class in Visual Basic) can sometimes be a difficult one. An abstract class is a class that cannot be instantiated, but must be inherited from. An abstract class may be fully implemented, but is more usually partially implemented or not implemented at all, thereby encapsulating common functionality for inherited classes. For details, see Abstract Classes.

An interface, by contrast, is a totally abstract set of members that can be thought of as defining a contract for conduct. The implementation of an interface is left completely to the developer.

Both interfaces and abstract classes are useful for component interaction. If a method requires an interface as an argument, then any object that implements that interface can be used in the argument. For example:

// C#
public void Spin (IWidget widget)
{}

This method could accept any object that implemented IWidget as the widget argument, even though the implementations of IWidget might be quite different. Abstract classes also allow for this kind of polymorphism, but with a few caveats:

    Classes may inherit from only one base class, so if you want to use abstract classes to provide polymorphism to a group of classes, they must all inherit from that class.
    Abstract classes may also provide members that have already been implemented. Therefore, you can ensure a certain amount of identical functionality with an abstract class, but cannot with an interface.

Here are some recommendations to help you to decide whether to use an interface or an abstract class to provide polymorphism for your components.

    If you anticipate creating multiple versions of your component, create an abstract class. Abstract classes provide a simple and easy way to version your components. By updating the base class, all inheriting classes are automatically updated with the change. Interfaces, on the other hand, cannot be changed once created. If a new version of an interface is required, you must create a whole new interface.
    If the functionality you are creating will be useful across a wide range of disparate objects, use an interface. Abstract classes should be used primarily for objects that are closely related, whereas interfaces are best suited for providing common functionality to unrelated classes.
    If you are designing small, concise bits of functionality, use interfaces. If you are designing large functional units, use an abstract class.
    If you want to provide common, implemented functionality among all implementations of your component, use an abstract class. Abstract classes allow you to partially implement your class, whereas interfaces contain no implementation for any members.

If you need shared behavior to derived classes then use abstract class or if you need plug gable element structure use interfaces because interface is only alternative of multiple inheritance in term of reusable component design not for shared functionality, it’s just define a contract to derived classes .
Differences:

    Abstract class may or may not have abstract method other than interfaces only declarative.
    Abstract class can contain variable other than interface can’t.
    Interfaces members are implicitly public; so you can’t use access modifiers to restrict access other than abstract class follows the general class rules.
    We can’t use static and constant members in interface other than abstract class we can use.
    A Class or Struct can be inherited from multiple interfaces but only from single abstract class.
Interface provides loose coupling other than concrete class provide strong coupling.
Interfaces support events, indexers, methods, and properties.

Coupling: In Brief when one class has direct knowledge of other class refer as coupling. If dependent class has direct reference to concrete class then it‘s called strong coupling else when dependent class contains pointer to interface it’s called loose coupling.
Partial Interfaces: Interfaces can be used with partial keyword like partial classes as we know compiler combine the partial elements to create unified interface definition.
partial interface IProcess
      {   void DataProcess();   }
partial interface IProcess
      {   string ProcessType { get; } }

class Process : IProcess
{
      public void DataProcess()
       {     //Logic    }
      public string ProcessType { get { return "Data"; } }

}
Explicit Interface Implementation: Multiple inheritances by using interfaces are quite easy until members are identical .Suppose two interfaces have same member like below:

interface IExportProcess { void Save();   }
interface IImportProcess { void Save();   }

Problem occur when XMLDocument object up cast to IExportProcess ,calls to the Save Method expecting different result then if the same method was called when the object up cast to IImportProcess .
To sort out this problem you can use explicit interface implementation as below;
class XMLDocument :IExportProcess,IImportProcess
{
   public void IExportProcess.Save()
      {   //Logic    }

   public void IImportProcess.Save()
       { //Logic    }

}

MySQL: Split comma separated list into multiple rows

2014-03-13T03:18:00.004-07:00

    In MySQL this can be achieved as below

    SELECT id, length FROM vehicles WHERE id IN ( 117, 148, 126)

    +---------------+
    | id | length |
    +---------------+
    | 117 | 25        |
    | 126 | 8        |
    | 148 | 10        |
    +---------------+

    SELECT id,vehicle_ids FROM load_plan_configs WHERE load_plan_configs.id =42

    +---------------------+
    | id | vehicle_ids   |
    +---------------------+
    | 42 | 117, 148, 126 |
    +---------------------+

    Now to get the length of comma separated vehicle_ids use below query

    Output

    SELECT length FROM vehicles, load_plan_configs   WHERE load_plan_configs.id = 42 AND FIND_IN_SET(vehicles.id, load_plan_configs.vehicle_ids)

    +---------+
    | length |
    +---------+
    | 25        |
    | 8          |
    | 10       |
    +---------+

Macro to unprotect excel sheet

2014-02-24T22:46:00.001-08:00

sub MyMacro()
                        Dim i As Integer, j As Integer, k As Integer
                Dim l As Integer, m As Integer, n As Integer
                Dim i1 As Integer, i2 As Integer, i3 As Integer
               Dim i4 As Integer, i5 As Integer, i6 As Integer
               On Error Resume Next
                For i = 65 To 66 : For j = 65 To 66 : For k = 65 To 66
             For l = 65 To 66 : For m = 65 To 66 : For i1 = 65 To 66
             For i2 = 65 To 66 : For i3 = 65 To 66 : For i4 = 65 To 66
             For i5 = 65 To 66 : For i6 = 65 To 66 : For n = 32 To 126
             ActiveSheet.Unprotect(Chr(i) & Chr(j) & Chr(k) & _
                Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & _
                 Chr(i4) & Chr(i5) & Chr(i6) & Chr(n))
             If ActiveSheet.ProtectContents = False Then
                Exit Sub
             End If
                                Next : Next : Next : Next : Next : Next
                                 Next : Next : Next : Next : Next : Next
                end sub

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

Private Sub UnprotectSheet()
        'Breaks worksheet password protection.
        Dim strPassword As String = Configuration.ConfigurationManager.AppSettings("ProtectPassword").ToString()
        Dim intCtr As Integer = 0
        Dim ObjExcel As New Excel.Application
        Dim objWbook As Excel.Workbook
        For intCtr = 0 To lstFiles.Items.Count - 1
            ObjExcel.Workbooks.Add(txtInputFolder.Text & "\" & lstFiles.Items(intCtr))
        Next
        Dim wsHeet As Excel.Worksheet
        ObjExcel.DisplayAlerts = False
        intCtr = 0
        For Each objWbook In ObjExcel.Workbooks
            Dim xlmodule As Object 'VBComponent
            xlmodule = objWbook.VBProject.VBComponents.Add(1) 'vbext_ct_StdModule
            Dim strCode As String
            strCode = _
               "sub MyMacro()" & vbCr & _
               "         Dim i As Integer, j As Integer, k As Integer " & vbNewLine & _
               " Dim l As Integer, m As Integer, n As Integer " & vbNewLine & _
                "Dim i1 As Integer, i2 As Integer, i3 As Integer " & vbNewLine & _
              " Dim i4 As Integer, i5 As Integer, i6 As Integer " & vbNewLine & _
              " On Error Resume Next " & vbNewLine & _
                "For i = 65 To 66 : For j = 65 To 66 : For k = 65 To 66 " & vbNewLine & _
            " For l = 65 To 66 : For m = 65 To 66 : For i1 = 65 To 66 " & vbNewLine & _
            " For i2 = 65 To 66 : For i3 = 65 To 66 : For i4 = 65 To 66 " & vbNewLine & _
            " For i5 = 65 To 66 : For i6 = 65 To 66 : For n = 32 To 126 " & vbNewLine & _
            " ActiveSheet.Unprotect(Chr(i) & Chr(j) & Chr(k) & _" & vbNewLine & _
            "    Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & _ " & vbNewLine & _
                " Chr(i4) & Chr(i5) & Chr(i6) & Chr(n))" & vbNewLine & _
            " If ActiveSheet.ProtectContents = False Then " & vbNewLine & _
            "    Exit Sub " & vbNewLine & _
            " End If " & vbNewLine & _
                          "      Next : Next : Next : Next : Next : Next " & vbNewLine & _
                                " Next : Next : Next : Next : Next : Next " & vbNewLine & _
                "end sub"

            strCode = _
               "sub MyMacro()" & vbCr & _
               " If ActiveSheet.ProtectContents = true Then" & vbNewLine & _
             "   ActiveSheet.Unprotect """ & strPassword & """ " & vbNewLine & _
            " End If " & vbNewLine & _
             "end sub"

            xlmodule.CodeModule.AddFromString(strCode)

            For Each wsHeet In objWbook.Worksheets
                wsHeet.Activate()
                If objWbook.ActiveSheet.ProtectContents = True Then
                    ObjExcel.Run("MyMacro")
                End If
            Next
            objWbook.Close(True, txtInputFolder.Text & "\" & lstFiles.Items(intCtr))
            intCtr = intCtr + 1


        Next
        ObjExcel.Quit()

    End Sub

Convert XmlNodeList to DataTable

2013-12-31T00:25:00.003-08:00

XmlDocument xmlDoc = new XmlDocument();
XmlNodeList nodes;
string xmlResp;
// convert string to stream
byte[] byteArray = Encoding.ASCII.GetBytes(xmlResp);
MemoryStream stream = new MemoryStream(byteArray);
xmlDoc = ConvertStreamToXMLDocument(stream);
nodes = xmlDoc.GetElementsByTagName("Items");
DataTable dt = Utility.ConvertXmlNodeListToDataTable(nodes);

public static DataTable ConvertXmlNodeListToDataTable(XmlNodeList xnl)
{
    DataTable dt = new DataTable();
    int TempColumn = 0;

    foreach (XmlNode node in xnl.Item(0).ChildNodes)
    {
        TempColumn++;
        DataColumn dc = new DataColumn(node.Name, System.Type.GetType("System.String"));
        if (dt.Columns.Contains(node.Name))
        {
            dt.Columns.Add(dc.ColumnName = dc.ColumnName + TempColumn.ToString());
        }
        else
        {
            dt.Columns.Add(dc);
        }
    }

    int ColumnsCount = dt.Columns.Count;
    for (int i = 0; i < xnl.Count; i++)
    {
        DataRow dr = dt.NewRow();
        for (int j = 0; j < ColumnsCount; j++)
        {
            //dr[j] = xnl.Item(i).ChildNodes[j].InnerText;
            if (xnl.Item(i).ChildNodes[j] != null)
                dr[j] = xnl.Item(i).ChildNodes[j].InnerText;
            else
                dr[j] = null;
        }
        dt.Rows.Add(dr);
    }
    return dt;
}

Read values from cookies

2013-12-31T00:24:00.000-08:00

const string COOKIE_NAME = "xyz";
string subject = "";
if (HttpContext.Current.Request.Cookies[COOKIE_NAME] != null)
{
    allClaims = new Dictionary<String, String>();

    HttpCookie authCookie = HttpContext.Current.Request.Cookies[COOKIE_NAME];

    NameValueCollection col = new NameValueCollection(authCookie.Values);
    String[] keyNames = col.AllKeys;
    foreach (string key in keyNames)
    {
        allClaims.Add(key, col.GetValues(key)[0]);
    }

    subject = authCookie["subject"].ToString();
}

Write DataTable to Excel

2013-12-31T00:23:00.006-08:00

public void WriteToExcel(Excel.Worksheet worksheet, DataTable dataTable)
{
    var columns = dataTable.Columns.Count;
    var rows = dataTable.Rows.Count;
    var startCell = (Excel.Range)worksheet.Cells[1, 1];
    var endCell = (Excel.Range)worksheet.Cells[rows + 1, columns];
    var writeRange = (Excel.Range)worksheet.get_Range(startCell, endCell);
    var data = new object[rows + 1, columns];
    //Header
    for (var column = 0; column < columns; column++)
    {
        data[0, column] = dataTable.Columns[column].ColumnName;
    }
    for (var row = 1; row <= rows; row++)
    {
        for (var column = 0; column < columns; column++)
        {
            data[row, column] = dataTable.Rows[row - 1][column].ToString();
        }
    }
    worksheet.Rows.Clear();
    writeRange.Value = data;
    worksheet.Name = "test";
}

Convert JSON to XML

2013-12-31T00:23:00.002-08:00

Run below command in Visual Studio for the project
PM> Install-Package Newtonsoft.Json

XmlDocument xmlDoc = new XmlDocument();
xmlDoc = JsonConvert.DeserializeXmlNode("{records:{items:" + xmlResp + "}}");

Convert string to stream to XML document

2013-12-31T00:22:00.004-08:00

// convert string to stream
XmlDocument xmlDoc = new XmlDocument();
byte[] byteArray = Encoding.ASCII.GetBytes(xmlResp);
MemoryStream stream = new MemoryStream(byteArray);
xmlDoc = ConvertStreamToXMLDocument(stream);
private XmlDocument ConvertStreamToXMLDocument(Stream stream)
{
    XmlDocument xmlDocument = new XmlDocument();
    xmlDocument = new XmlDocument();
    //load into XDocument
    XDocument xDocument = XDocument.Load(stream);

    //scrub the namespaces out!
    xDocument.Descendants().Attributes().Where(x => x.IsNamespaceDeclaration).Remove();
    // convert to xml document
    using (var xmlReader = xDocument.CreateReader())
    {
        xmlDocument.Load(xmlReader);
    }

    // remove default namespace
    xmlDocument.LoadXml(xmlDocument.OuterXml.Replace(xmlDocument.DocumentElement.NamespaceURI, ""));
    xmlDocument.DocumentElement.RemoveAllAttributes();

    return xmlDocument;
}

Calling & receiving response of any webpage C# - ASP.Net

2013-12-31T00:21:00.003-08:00

public void CallWebPage(string url)
{
    WebRequest request = WebRequest.Create(url);
    //WebProxy proxy = new WebProxy("fresproxy1:8080");
    //proxy.UseDefaultCredentials = true;
    //request.Proxy = proxy;
    request.Headers.Add("Key", Value);
    request.Headers.Add("Key", Value);
    WebResponse objWebResponse = request.GetResponse();
    Stream objWebStream = objWebResponse.GetResponseStream();
    string response = "";
    string OAuthToken="";
    using (StreamReader objStreamReader = new StreamReader(objWebStream))
    {
        response = objStreamReader.ReadToEnd();
    }
    //if response is json - deserialize that into dictionaries for easier operation - System.Web.Extensions.dll
   JavaScriptSerializer desSSO = new JavaScriptSerializer();
   IDictionary userInfo = desSSO.Deserialize<Dictionary<string, string>>(response);
   foreach (DictionaryEntry entry in userInfo)
   {
       if (entry.Key.ToString() == "abc")
       {
           OAuthToken = entry.Value.ToString();
       }
   }
}

Export To Excel with Cell Formating

2013-11-28T00:04:00.002-08:00

using System.Text;
          using System.IO;
          using System.Drawing;
           Response.Clear();
            Response.Buffer = true;

            Response.AddHeader("content-disposition",
            "attachment;filename=GridViewExport.xls");
            Response.Charset = "";
            Response.ContentType = "application/vnd.ms-excel";
            StringWriter sw = new StringWriter();
            HtmlTextWriter hw = new HtmlTextWriter(sw);
            GridView GridView1 = new GridView();
            GridView1.DataSource = ds;
            GridView1.DataBind();
            GridView1.AllowPaging = false;
            GridView1.DataBind();
            //Change the Header Row back to white color
            GridView1.HeaderRow.Style.Add("background-color", "#FFFFFF");
            //Apply style to Individual Cells
            GridView1.HeaderRow.Style.Add("background-color", "green");
            //GridView1.HeaderRow.Cells[1].Style.Add("background-color", "green");
            //GridView1.HeaderRow.Cells[2].Style.Add("background-color", "green");
            //GridView1.HeaderRow.Cells[3].Style.Add("background-color", "green");

            for (int i = 0; i < GridView1.Rows.Count; i++)
            {
                GridViewRow row = GridView1.Rows[i];
                //Change Color back to white
                row.BackColor = System.Drawing.Color.White;
                //Apply text style to each Row
               // row.Attributes.Add("class", "textmode");

                //Apply style to Individual Cells of Alternating Row
                if (i % 2 != 0)
                {
                    row.Style.Add("background-color", "#C2D69B");
                    //row.Cells[1].Style.Add("background-color", "#C2D69B");
                }
            }
            GridView1.RenderControl(hw);
            //style to format numbers to string
            string style = @"<style> .textmode { mso-number-format:\@; } </style>";
            Response.Write(style);
            Response.Output.Write(sw.ToString());
            Response.Flush();
            Response.End();

Format Class object into JSON or XML

2013-11-28T00:03:00.003-08:00

protected void FormatOutgoingMessage<T>(T graph, string format)
{
    if (format == null)
    {
        format = "json";
    }
    bool flag = format.ToUpper() == "XML";
    WebHeaderCollection headers = WebOperationContext.Current.IncomingRequest.Headers;
    string s = string.Empty;
    string str2 = headers.Get("Accept");
    if (str2 != null)
    {
        bool flag2 = str2.ToLower().Contains("application/json");
        if ((format.ToUpper() == "JSON") || (flag2 && !flag))
        {
            s = Utility.ToJson<T>(graph);
            HttpContext.Current.Response.ContentType = "application/json; charset=utf-8";
            HttpContext.Current.Response.Write(s);
        }
        else
        {
            s = Utility.SerializeDataContract<T>(graph);
            HttpContext.Current.Response.ContentType = "application/xml";
            HttpContext.Current.Response.Write(s);
        }
    }
    else
    {
        s = Utility.SerializeDataContract<T>(graph);
        HttpContext.Current.Response.ContentType = "application/xml";
        HttpContext.Current.Response.Write(s);
    }
}
public static string ToJson<T>(T obj)
{
    DataContractJsonSerializer serializer = new DataContractJsonSerializer(obj.GetType());
    MemoryStream stream = new MemoryStream();
    serializer.WriteObject(stream, obj);
    return Encoding.Default.GetString(stream.ToArray());
}
public static string SerializeDataContract<T>(T graph)
{
    return Serialize<T>(graph, Encoding.UTF8);
}

Export To XLS

2013-11-28T00:02:00.000-08:00

protected void Page_Load(object sender, EventArgs e)
    {

               try
               {
                   SqlDataAdapter da = new SqlDataAdapter("Select * from Features", "Data Source=;Initial Catalog=;Persist Security Info=True;User ID=;Password=;");
                   DataSet ds = new DataSet();
                   da.Fill(ds);

                   string date = string.Format("{0:dd-MM-yyyy}", DateTime.Now);
                   string strFileName = "Test";
                   string path = strFileName + "_" + date + ".xls";

                   Directory.SetCurrentDirectory(Server.MapPath("~/"));// Changed the default location of the storage of the file.
                   StreamWriter sw = File.AppendText(Path.Combine(strFileName + "_" + date + ".xls")); //Append the file name with the file path.
                   for (int i = 0; i < ds.Tables[0].Columns.Count; i++)
                   {
                       sw.AutoFlush = true;
                       sw.Write(ds.Tables[0].Columns[i].ToString() + "\t");
                   }
                   sw.Write("\n");
                   for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
                   {
                       for (int x = 0; x < ds.Tables[0].Columns.Count; x++)
                       {
                           sw.Write(ds.Tables[0].Rows[i][ds.Tables[0].Columns[x].ToString()].ToString() + "\t");
                       }
                       sw.Write("\n");
                   }
                   sw.Write("\n");
               }

               catch (Exception)
               {
                   throw;
               }
               finally
               {

               }
    }

Encrypt Decrypt string in C# - ASP.Net

2013-11-28T00:01:00.001-08:00

public class EncryptDecryptUtil
{
public static string Decrypt(string strData)
{
  if (strData.Length > 0)
   return DecodeFrom64(strData);
  else
   return strData;
}
public static string Encrypt(string strData)
{
  if (strData.Length > 0)
   return EncodeBase64(strData);
  else
   return strData;
}
internal static string DecodeFrom64(string encodedData)
{
  try
  {
   byte[] encodedDataAsBytes = System.Convert.FromBase64String(encodedData);
   string returnValue = System.Text.ASCIIEncoding.ASCII.GetString(encodedDataAsBytes);
   return returnValue;
  }
  catch (Exception e)
  {
   throw new Exception("Error in EncodeBase64" + e.Message);
  }
}
internal static string EncodeBase64(string data)
{
  try
  {
   byte[] toencode_byte = System.Text.ASCIIEncoding.ASCII.GetBytes(data);
   string result = Convert.ToBase64String(toencode_byte);
   return result;
  }
  catch (Exception e)
  {
   throw new Exception("Error in EncodeBase64" + e.Message);
  }
}
}

Validate user to on windows user account - Windows Identity Impersonation

2013-11-28T00:00:00.000-08:00

IntPtr accessToken = IntPtr.Zero;
WindowsImpersonationContext impersonationContext = null;
try
{
if (iFormsServiceUtil.ImpersonateValidUser(userName, domain, password, out impersonationContext))
{
}
}
catch (Exception ex)
{

}
finally
{
if(impersonationContext != null)
  iFormsServiceUtil.UndoImpersonation(ref impersonationContext);
}

#region Windows Identity Impersonation

private const int LOGON32_LOGON_INTERACTIVE = 2;
private const int LOGON32_PROVIDER_DEFAULT = 0;
//private WindowsImpersonationContext impersonationContext;
[DllImport("advapi32.dll")]
private static extern int LogonUserA(String lpszUserName, String lpszDomain, String lpszPassword, int dwLogonType, int dwLogonProvider, ref IntPtr phToken);
[DllImport("advapi32.dll", CharSet = CharSet.Auto, SetLastError = true)]
private static extern int DuplicateToken(IntPtr hToken, int impersonationLevel, ref IntPtr hNewToken);
[DllImport("advapi32.dll", CharSet = CharSet.Auto, SetLastError = true)]
private static extern bool RevertToSelf();
[DllImport("kernel32.dll", CharSet = CharSet.Auto)]
private static extern bool CloseHandle(IntPtr handle);
internal static bool ImpersonateValidUser(String userName, String domain, String password, out WindowsImpersonationContext impersonationContext)
{
  WindowsIdentity tempWindowsIdentity;
  IntPtr token = IntPtr.Zero;
  IntPtr tokenDuplicate = IntPtr.Zero;
  impersonationContext = null;
  if (RevertToSelf())
  {
   if (LogonUserA(userName, domain, password, LOGON32_LOGON_INTERACTIVE, LOGON32_PROVIDER_DEFAULT, ref token) != 0)
   {
    if (DuplicateToken(token, 2, ref tokenDuplicate) != 0)
    {
     tempWindowsIdentity = new WindowsIdentity(tokenDuplicate);
     impersonationContext = tempWindowsIdentity.Impersonate();
     if (impersonationContext != null)
     {
      CloseHandle(token);
      CloseHandle(tokenDuplicate);
      return true;
     }
    }
   }
  }
  if (token != IntPtr.Zero)
   CloseHandle(token);
  if (tokenDuplicate != IntPtr.Zero)
   CloseHandle(tokenDuplicate);
  return false;
}
internal static void UndoImpersonation(ref WindowsImpersonationContext impersonationContext)
{
  impersonationContext.Undo();
}
#endregion

Display local date and time on the site using javascript

2013-10-13T23:08:00.001-07:00

<div id="clock"> </div>
<script type="text/javascript">
function init ( )
{
timeDisplay = document.createTextNode ( "" );
document.getElementById("clock").appendChild ( timeDisplay );
}
function updateClock ( )
{
var currentTime = new Date ( );
var currentHours = currentTime.getHours ( );
var currentMinutes = currentTime.getMinutes ( );
var currentSeconds = currentTime.getSeconds ( );
var currentDay = currentTime.getDate ( );

currentMinutes = ( currentMinutes < 10 ? "0" : "" ) + currentMinutes;
currentSeconds = ( currentSeconds < 10 ? "0" : "" ) + currentSeconds;

var timeOfDay = ( currentHours < 12 ) ? "AM" : "PM";
currentHours = ( currentHours > 12 ) ? currentHours - 12 : currentHours;
currentHours = ( currentHours == 0 ) ? 12 : currentHours;
var month_name=new Array(12);
month_name[0]="January"
month_name[1]="February"
month_name[2]="March"
month_name[3]="April"
month_name[4]="May"
month_name[5]="June"
month_name[6]="July"
month_name[7]="August"
month_name[8]="September"
month_name[9]="October"
month_name[10]="November"
month_name[11]="December"
var currentTimeString = currentHours + ":" + currentMinutes + ":" + currentSeconds + " " + timeOfDay+" "+ month_name[currentTime.getMonth()]+" "+currentDay+","+" " +currentTime.getFullYear();
document.getElementById("clock").firstChild.nodeValue = currentTimeString;
// document.getElementById("clock").style.fontWeight = 'bold';
}
</script>
<script>
updateClock( );
setInterval('updateClock()', 1000 );
</script>

Steps to configure MongoDB

2013-10-10T02:32:00.001-07:00

Steps to configure MongoDB

Download Mongo
UnZip mongodb-win32-x86_64-2.4.6.zip file in any folder (E:\MongoDB)
Create E:\MongoDB\data\db folder to store database
Open command prompt and run

E:\MongoDB\mongodb\bin\mongod.exe --dbpath E:\MongoDB\data\db\localDB   ==== to set database path

The above command prompt window should remain open so that you can work on database.
Now open another command prompt and run E:\MongoDB\mongodb\bin\mongo   ---- if successfull the below text will appear with a command prompt as ">" here you can execute commands
MongoDB shell version: 2.4.6
connecting to: test
Welcome to the MongoDB shell.
For interactive help, type "help".
For more comprehensive documentation, see
        http://docs.mongodb.org/
Questions? Try the support group
        http://groups.google.com/group/mongodb-user
>Execute your commands here

Download Mongo Interface (Robomongo) http://robomongo.org/ This is a UI tool to execute queries

Folder Structure
All local database localtion E:\MongoDB\data\db\localDB
Backup Folder
E:\MongoDB\dump\localDB\mydb
E:\MongoDB\dump\staging\mongodump-2013-10-10\dbName

BACKUP
mongodump -d <our database name> -o <directory_backup>

Take backup of local database without running the mongod instance
Run on command prompt
E:\MongoDB\mongodb\bin\mongodump --dbpath E:\MongoDB\data\db\localDB -o E:\MongoDB\dump\localDB

Take backup of remote database without running the mongod instance
E:\MongoDB\mongodb\bin\mongodump --host <servername> --port 27017 --username <username> --password <password> -db <dbname> --out E:\MongoDB\dump\staging\mongodump-2013-10-10

RESTORE - From local existing DB
mongorestore <directory_backup>
The mongorestore utility restores a binary backup created by mongodump. By default, mongorestore looks for a database backup in the dump/ directory

Connect to the the mongod instance for local restore
Local
E:\MongoDB\mongodb\bin\mongod.exe --dbpath E:\MongoDB\data\db\localDB   === Instance connection to the database
E:\MongoDB\mongodb\bin\mongorestore E:\MongoDB\dump\localDB  === Run this to restore from backup directory
--Staging
E:\MongoDB\mongodb\bin\mongod.exe --dbpath E:\MongoDB\data\db\localDB   === Instance connection to the database
E:\MongoDB\mongodb\bin\mongorestore E:\MongoDB\dump\staging\mongodump-2013-10-10\dbName === === Run this to restore from backup directory

Proper Case or Title case in c#

2013-10-07T01:12:00.002-07:00

string[] values = { "a tale of two cities", "gROWL to the rescue",
                          "inside the US government", "sports and MLB baseball",
                          "The Return of Sherlock Holmes", "UNICEF and children"};
      TextInfo ti = CultureInfo.CurrentCulture.TextInfo;
      foreach (var value in values)
         Console.WriteLine("{0} --> {1}", value, ti.ToTitleCase(value));

// The example displays the following output:
// a tale of two cities --> A Tale Of Two Cities
// gROWL to the rescue --> Growl To The Rescue
// inside the US government --> Inside The US Government
// sports and MLB baseball --> Sports And MLB Baseball
// The Return of Sherlock Holmes --> The Return Of Sherlock Holmes
// UNICEF and children --> UNICEF And Children

Async function Call on button click or page load

2013-09-11T04:45:00.002-07:00

public delegate string LoadDelegateR(string userName, string reportingDate, Dictionary<string, string> functions, string jobNumber, out string message);

protected void Page_Load(object sender, EventArgs e)
{
// call asynchronously
LoadDelegateR d = new LoadDelegateR(ImportData);
d.BeginInvoke(user, txtPeriod.Text.Trim(), functions, txtJobNumber.Text.Trim(), out message, new System.AsyncCallback(SendNotification), null);
}

public override string ImportData(string username, string reportingDate, Dictionary<string, string> functions, string jobNumber, out string message)
{
}

public void SendNotification(IAsyncResult iRes)
{
try
{
  AsyncResult ar = (AsyncResult)iRes;
  LoadDelegateR bp = (LoadDelegateR)ar.AsyncDelegate;
  string result = bp.EndInvoke(out message, iRes);
}
catch (Exception ex)
{
  message = "Error in loading the data.Please contact admin.";
}
}

Sort the IEnumerable list using Linq

2013-09-11T02:47:00.002-07:00

var sortedEngData = engData.OrderByDescending(c => c.CausalCountPeriod).ThenByDescending(c => c.CausalCountToDate);