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>();
}
}
