private List<checksnotflex> FnFetchData() { try { var myList = new List<checksnotflex>(); var con = new SqlConnection(constring); const string query = "SELECT COUNT(REF_NO) AS NoOfItems,CURRENCYID, SUM(CONVERT (MONEY, AMOUNT)) AS AMOUNT FROM VW_IN_CHKPT_NOT_FLEX GROUP BY CURRENCYID"; DataTable dt = new DataTable(); con.Open(); var da = new SqlDataAdapter(query, con); da.Fill(dt); con.Close(); if (dt.Rows.Count > 0) { foreach (DataRow n in dt.Rows) { var singleItem = new checksnotflex { CURRENCYID = n[0].ToString(), AMOUNT = n[2].ToString() }; myList.Add(singleItem); } } return myList; } catch (Exception ex) { _logs.LogError(User.Identity.GetUserName(), "totalchqptnotflexFnFetchData", "Error: " + ex.Message, Request.ServerVariables["REMOTE_ADDR"], HttpContext.Server.MapPath("."), "EFTRecon"); System.IO.FileStream fs = new System.IO.FileStream(Server.MapPath("~/errorLOG.txt"), System.IO.FileMode.OpenOrCreate, System.IO.FileAccess.ReadWrite); System.IO.StreamWriter s = new System.IO.StreamWriter(fs); s.BaseStream.Seek(0, System.IO.SeekOrigin.End); s.WriteLine("ERROR DATE: " + System.DateTime.Now.ToString(System.Globalization.CultureInfo.InvariantCulture) + " \nERROR MESSAGE: " + ex.Message + "\nSOURCE: " + ex.Source + "\nFORM NAME: " + System.Web.HttpContext.Current.Request.Url.ToString() + "\nQUERYSTRING: " + Request.QueryString.ToString() + "\nTARGETSITE: " + ex.TargetSite.ToString() + "\nSTACKTRACE: " + ex.StackTrace + System.Diagnostics.EventLogEntryType.Error); s.WriteLine("-------------------------------------------------------------------------------------------------------------"); s.Close(); return new List<checksnotflex>(); } }
private List<checksnotflex> FnFetchData() { try { var myList = new List<checksnotflex>(); var con = new SqlConnection(constring); const string query = "SELECT [REF_NO],[CURRENCYID],[AMOUNT],[ACC_CR],[BFNAME],[BACKUPDATE],[ACC_DR],[ORGREF]," + "[TOBANK],[REMITTERNAME],[BATCHNO] FROM [dbo].[VW_IN_CHKPT_NOT_FLEX]"; DataTable dt = new DataTable(); con.Open(); var da = new SqlDataAdapter(query, con); da.Fill(dt); con.Close(); if (dt.Rows.Count > 0) { foreach (DataRow n in dt.Rows) { var singleItem = new checksnotflex { REF_NO = n[0].ToString(), CURRENCYID = n[1].ToString(), AMOUNT = n[2].ToString(), ACC_CR = n[3].ToString(), BFNAME = n[4].ToString(), BACKUPDATE = n[5].ToString(), ACC_DR = n[6].ToString(), ORGREF = n[7].ToString(), TOBANK = n[8].ToString(), REMITTERNAME = n[9].ToString(), BATCHNO = n[10].ToString() }; myList.Add(singleItem); } } return myList; } catch (Exception ex) { _logs.LogError(User.Identity.GetUserName(), "checksnotflexFnFetchData", "Error: " + ex.Message, Request.ServerVariables["REMOTE_ADDR"], HttpContext.Server.MapPath("."), "EFTRecon"); System.IO.FileStream fs = new System.IO.FileStream(Server.MapPath("~/errorLOG.txt"), System.IO.FileMode.OpenOrCreate, System.IO.FileAccess.ReadWrite); System.IO.StreamWriter s = new System.IO.StreamWriter(fs); s.BaseStream.Seek(0, System.IO.SeekOrigin.End); s.WriteLine("ERROR DATE: " + System.DateTime.Now.ToString(System.Globalization.CultureInfo.InvariantCulture) + " \nERROR MESSAGE: " + ex.Message + "\nSOURCE: " + ex.Source + "\nFORM NAME: " + System.Web.HttpContext.Current.Request.Url.ToString() + "\nQUERYSTRING: " + Request.QueryString.ToString() + "\nTARGETSITE: " + ex.TargetSite.ToString() + "\nSTACKTRACE: " + ex.StackTrace + System.Diagnostics.EventLogEntryType.Error); s.WriteLine("-------------------------------------------------------------------------------------------------------------"); s.Close(); return new List<checksnotflex>(); } }