How to apply Loader Image in C#

Add this div in your page:

<div id="loading" style="display:none;">

 <img id="loading-image" src="images/ajax-loader.gif" alt="Loading..." />

</div>

Add this Style in your page:

<style>

#loading {

 width: 100%;

 height: 100%;

 top: 0px;

 left: 0px;

 position: fixed;

 display: block;

 opacity: 0.7;

 background-color: #fff;

 z-index: 99;

 text-align: center;

}

#loading-image {

 position: absolute;

 top: 100px;

 left: 240px;

 z-index: 100;

}

</style>

Add this line where you want to show loading image div & hide:

$('#loading').show();

$('#loading').hide();

C# Datetime Format Examples

DateTime _datetime = DateTime.Now;
String dateFormat="";

// 07/21/2007
dateFormat = _datetime.ToString("MM/dd/yyyy");
// Saturday, 21 July 2007
dateFormat = _datetime.ToString("dddd, dd MMMM yyyy");
// Saturday, 21 July 2007 14:58
dateFormat = _datetime.ToString("dddd, dd MMMM yyyy HH:mm");
// Saturday, 21 July 2007 03:00 PM
dateFormat = _datetime.ToString("dddd, dd MMMM yyyy hh:mm tt");
// Saturday, 21 July 2007 5:01 
dateFormat = _datetime.ToString("dddd, dd MMMM yyyy H:mm");
// Saturday, 21 July 2007 3:03 PM
dateFormat = _datetime.ToString("dddd, dd MMMM yyyy h:mm tt");
// Saturday, 21 July 2007 15:04:10
dateFormat = _datetime.ToString("dddd, dd MMMM yyyy HH:mm:ss");
// 07/21/2007 15:05
dateFormat = _datetime.ToString("MM/dd/yyyy HH:mm");
// 07/21/2007 03:06 PM
dateFormat = _datetime.ToString("MM/dd/yyyy hh:mm tt");
// 07/21/2007 15:07
dateFormat = _datetime.ToString("MM/dd/yyyy H:mm");
// 07/21/2007 3:07 PM
dateFormat = _datetime.ToString("MM/dd/yyyy h:mm tt");
// 07/21/2007 15:09:29
dateFormat = _datetime.ToString("MM/dd/yyyy HH:mm:ss");
// July 21
dateFormat = _datetime.ToString("MMMM dd");
// 2007-07-21T15:11:19.1250000+05:30
dateFormat = _datetime.ToString("yyyy'-'MM'-'dd'T'HH':'mm':'ss.fffffffK");
// Sat, 21 Jul 2007 15:12:16 GMT
dateFormat = _datetime.ToString("ddd, dd MMM yyyy HH':'mm':'ss 'GMT'");
// 2007-07-21T15:12:57
dateFormat = _datetime.ToString("yyyy'-'MM'-'dd'T'HH':'mm':'ss");
// 15:14
dateFormat = _datetime.ToString("HH:mm");
// 03:14 PM
dateFormat = _datetime.ToString("hh:mm tt");
// 5:15
dateFormat = _datetime.ToString("H:mm");
// 3:16 PM
dateFormat = _datetime.ToString("h:mm tt");
// 15:16:29
dateFormat = _datetime.ToString("HH:mm:ss");
// 2007-07-21 15:17:20Z
dateFormat = _datetime.ToString("yyyy'-'MM'-'dd HH':'mm':'ss'Z'");
// Saturday, 21 July 2007 15:17:58
dateFormat = _datetime.ToString("dddd, dd MMMM yyyy HH:mm:ss");
// 2007 July
dateFormat = _datetime.ToString("yyyy MMMM");

How to Sort and Filter in Datatable in C#

// How to Sort and Filter in Datatable          

// Connection Declaration and Fill the Values to Datatable

SqlConnection sqlConnection = new SqlConnection("Data Source=DataSource; Initial Catalog=DBName; User ID=sa; Password=Password;");

sqlConnection.Open();

SqlDataAdapter dataAdapter = new SqlDataAdapter("Select * from Employee", sqlConnection);

DataTable dataTableFill = new DataTable();

dataAdapter.Fill(dataTableFill);

// Sorting

const string sortColumn = "EmpName ASC";

dataTableFill.DefaultView.Sort = sortColumn;

DataTable dtSorting = dataTableFill.DefaultView.ToTable(); 

// Filter

const string filterCondition = "1001";

DataRow[] drRows = dataTableFill.Select("EmpCode = '" + filterCondition + "'");

DataTable dtFilter = drRows.CopyToDataTable();

How to use Ternary Operator in MVC2/MVC3 Style & Class

MVC 3

<div id="divExchangeRateShow" style="display: @(Model.TransactionProcess.BeneficiaryCurrencyCode.ToUpper() != "USD" ? "block" : "none")">

MVC 2

<div class="ft-dvm-form-block" style="display: <%=Model.TransactionProcess.BeneficiaryCurrencyCode.ToUpper() != "USD" ? "block" : "none"%>">

MVC Dropdown Binding in the View

DropDownListFor:

@Html.DropDownListFor(model => model.RoleID, new SelectList(ViewBag.Role as System.Collections.IEnumerable, "id", "roleName"), "Select", new { id = "ddlRoles", @class = "ft-sb validate[required]" })

DropDownList:

var listBranch = new List<SelectListItem>();

listBranch.Add(new SelectListItem { Text = "--Select--", Value = string.Empty });

     foreach (var agents in ViewBag.BranchList)

            {

                listBranch.Add(new SelectListItem { Text = agents, Value = agents });

            }

@Html.DropDownList("ddlBranchTypeValues", listBranch, new { @class = "ft-tb", @id = "ddlBranchTypeValues" })

Jquery Ajax Call With & Without Json

Jquery Ajax Call

var str = $('#loginform').serialize();

$.ajax({

type: 'POST',

url: "../Sessions/AttemptSenderLogin?txtEmail=" + $("#txtEmail").val() + "&txtPassword=" + $("#txtPassword").val(),

data: str,

success: function(data) {

},

error: function(res) {

}

});

Jquery Ajax Call  With JsonType

$.ajax({

type: "GET",

url: "/AdminTransactions/GetThreatMetrixDeviceIdDetails",

data: "deviceId=" + $('#HdnDeviceId').val() + "&transId=" + $('#HdnTransaciontId').val(),

dataType: 'json',

error: function () {

},

success: function (data) {

if (data != '') {

$.each(data, function (index, item) {

//item.ProcessingFee // Get Json Values

});

}

}

});

Skip Non Business Days when Adding Days in Datetime in C#

public static DateTime AddWorkdays(DateTime originalDate, int workDays, bool transtype, bool daysSkip)

        {

            DateTime tmpDate = originalDate;

            if (transtype && !daysSkip) // Check Days Condition Checking for Saturdays and Sundays

            {

                while (workDays > 0)

                {

                    tmpDate = tmpDate.AddDays(1);

                    if (tmpDate.DayOfWeek < DayOfWeek.Saturday &&

                        tmpDate.DayOfWeek > DayOfWeek.Sunday)

                        workDays--;

                }

            }

            if (!transtype && daysSkip) // Card Days Condition Checking for only Sundays

            {

                while (workDays > 0)

                {

                    tmpDate = tmpDate.AddDays(1);

                    if (tmpDate.DayOfWeek > DayOfWeek.Sunday)

                        workDays--;

                }

            }

            if (!transtype && !daysSkip) // Card

            {

                tmpDate = AddWorkdays(tmpDate, workDays, false, true);

            }

            return tmpDate;

        }