Shawon Amos

var activeSchedulers = (from scheduler in DbContext.Scheduler                                                     where scheduler.isActive == "A"                                                     && DbFunctions.TruncateTime(scheduler.Date) == DbFunctions.TruncateTime(DateTime.Now)                                                     select scheduler).ToList();

Web Config: <appSettings>     < add key= "DBSource" value = "Test" /> </appSettings> c #: string db= WebConfigurationManager.AppSettings[ "DBSource" ]; Libery: using System.Web.Configuration;

public static string EncodeTo64 ( string toEncode ) { byte [] toEncodeAsBytes = System.Text.Encoding.Unicode.GetBytes(toEncode); string returnValue = System.Convert.ToBase64String(toEncodeAsBytes); //returnValue = "." + returnValue + "."; return returnValue; } public static string DecodeFrom64 ( string encodedData ) { //encodedData = encodedData.Substring(1, encodedData.Length - 1); byte [] encodedDataAsBytes = System.Convert.FromBase64String(encodedData); string returnValue = System.Text.Encoding.Unicode.GetString(encodedDataAsBytes); return returnValue; }

<configuration>   <appSettings>     <add key="ConnectionString" value="Provider=Microsoft.ACE.OLEDB.12.0;Data Source=BCI.accdb;" />     <add key="ClientSettingsProvider.ServiceUri" value="" />   </appSettings> </configuration> http://aksadur.blogspot.com/2013/01/microsoft-access-connectivity-from-c.html

using System.Data.OleDb; using System.IO;   private DataTable ReadExcelToTable(string path) {             //Connection String             string extenstion = Path.GetExtension(path);             string connstring = "";             if (extenstion == "xls" || extenstion == "XLS")             {                 connstring = "Provider=Microsoft.JET.OLEDB.4.0;Data Source=" + path + ";Extended Properties='Excel 8.0;HDR=NO;IMEX=1';";             }             else             {                 connstring = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + path + ";Extended Properties='Excel 8.0;HDR=NO;IMEX=1';";             } ...

string num="1045987609.5678"; txtSample.Text = BengaliCommaFormat(num); //output 1,04,59,87,609.57 private string BengaliCommaFormat(string amount) {             amount = Convert.ToDecimal(amount).ToString("0.00");             string minus = "";             if (amount.Substring(0, 1) == "-")             {                 minus = amount.Substring(0, 1);                 amount = amount.Substring(1, amount.Length - 1);             }             string[] amt = amount.Split('.');             string result = "";             result = "." + amt[1];             int len = amt[0].Length;           ...

 public class SQLDAL     {         private SqlConnection connection;         public SQLDAL()         {             connection = new SqlConnection(GlobalConnection());         }         public string GlobalConnection()         {             string entityConnectionString = ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString;             //string providerConnectionString = new EntityConnectionStringBuilder(entityConnectionString).ProviderConnectionString;             return entityConnectionString;         }         #region Query Execute         public Result ExecuteQuery(string SQL)         {       ...

     // collumn name,  0000000, 0000001, table name         public string GetMaxId(string coloumName, string zeroPrefix, string initialValue, string tableName)         {             string maxId = "";             string rightStringLength = (zeroPrefix.Length + 1).ToString();             _selectQuery = "SELECT ISNULL(MAX(RIGHT(" + coloumName + ", " + rightStringLength + ")) + 1, " + initialValue + ") AS " + coloumName + " " + " FROM  " + tableName + " ";             SQLDAL dal = new SQLDAL();             DataTable dt = dal.Select(_selectQuery).Data;             if (dt != null && dt.Rows.Count > 0)             {                 maxId = decimal.Parse(d...

   public static string ConvertSystemDate(string date)         {             try             {                 string month = date.Split('/')[1];                 string day = date.Split('/')[0];                 string year = date.Split('/')[2];                 return month + "/" + day + "/" + year;             }             catch (Exception ex)             {                 return "1/1/1900";             }         }

   public static string RemoveSingleQuote(string data)         {             return string.IsNullOrEmpty(data) ? string.Empty : data.Replace("'", "''");         }  public static T RemoveSingleQuote<T>(object ob)         {             PropertyDescriptorCollection props =                 TypeDescriptor.GetProperties(typeof(T));             T Tob = (T)ob;             if (Tob != null)             {                 for (int i = 0; i < props.Count; i++)                 {                     PropertyDescriptor prop = props[i];               ...

public static string NumberToWords(long number)         {             if (number == 0)                 return "zero";             if (number < 0)                 return "minus " + NumberToWords(Math.Abs(number));             string words = "";             if ((number / 1000000) > 0)             {                 words += NumberToWords(number / 1000000) + " million ";                 number %= 1000000;             }             if ((number / 1000) > 0)             {                 words += NumberToWords(numb...