private List<flexnotchks> FnFetchData()
{
try
{
var myList = new List<flexnotchks>();
var con = new SqlConnection(constring);
const string query = "SELECT CONTRACT_REF_NO, BOOK_DATE, CUSTOM_REF_NO, DR_CCY, DR_AMOUNT, DR_ACCOUNT, BEN_AC_NO, PAYMENT_DETAILS," +
" BY_ORDER_OF, ULT_BENEFICIARY, ACC_WITH_INSTN FROM VW_IN_FLEX_NOT_CHKPT_UPDATED";
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 flexnotchks
{
CONTRACT_REF_NO = n[0].ToString(),
BOOK_DATE = n[1].ToString(),
CUSTOM_REF_NO = n[2].ToString(),
DR_CCY = n[3].ToString(),
DR_AMOUNT = n[4].ToString(),
DR_ACCOUNT = n[5].ToString(),
BEN_AC_NO = n[6].ToString(),
PAYMENT_DETAILS = n[7].ToString(),
BY_ORDER_OF = n[8].ToString(),
ULT_BENEFICIARY = n[9].ToString(),
ACC_WITH_INSTN = n[10].ToString()};
myList.Add(singleItem);
}
}
return myList;
}
catch (Exception ex)
{
_logs.LogError(User.Identity.GetUserName(), "flexnotchksFnFetchData", "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<flexnotchks>();
}
}
private List<flexnotchks> FnFetchData()
{
try
{
var myList = new List<flexnotchks>();
var con = new SqlConnection(constring);
const string query = "SELECT COUNT(CONTRACT_REF_NO) AS NoOfItems, DR_CCY, SUM(CONVERT (MONEY, DR_AMOUNT)) AS AMOUNT FROM VW_IN_FLEX_NOT_CHKPT_UPDATED GROUP BY DR_CCY";
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 flexnotchks
{
DR_CCY = n[0].ToString(),
DR_AMOUNT = n[2].ToString()
};
myList.Add(singleItem);
}
}
return myList;
}
catch (Exception ex)
{
_logs.LogError(User.Identity.GetUserName(), "TotalFlexNotChqFnFetchData", "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<flexnotchks>();
}
}