public DataSet dal_ErrorLogDetail(bel_ErrorLog obj_bel_Error)
{
DataSet ds = new DataSet();
try
{
SqlCommand sqlcmd = new SqlCommand("spu_ErrorLog");
sqlcmd.CommandTimeout = 0;
sqlcmd.CommandType = CommandType.StoredProcedure;
sqlcmd.Parameters.Clear();
sqlcmd.Parameters.AddWithValue("@ErrorlogDate", obj_bel_Error._ErrorlogDate);
sqlcmd.Parameters.AddWithValue("@ErrorMessage", obj_bel_Error._ErrorMessage);
sqlcmd.Parameters.AddWithValue("@FunctionName", obj_bel_Error._FunctionName);
sqlcmd.Parameters.AddWithValue("@ErrorLIne", obj_bel_Error._ErrorLIne);
sqlcmd.Parameters.AddWithValue("@PageName", obj_bel_Error._PageName);
sqlcmd.Parameters.AddWithValue("@CreatedBy", Convert.ToInt32(HttpContext.Current.Session["UserID"]));
sqlcmd.Parameters.AddWithValue("@FromDate", obj_bel_Error._FromDate);
sqlcmd.Parameters.AddWithValue("@ToDate", obj_bel_Error._ToDate);
sqlcmd.Parameters.AddWithValue("@iMode", obj_bel_Error._iMode);
sqlcmd.Parameters.AddWithValue("@BranchID", Convert.ToInt32(HttpContext.Current.Session["BranchID"]));
sqlcmd.Parameters.AddWithValue("@CompanyID", Convert.ToInt32(HttpContext.Current.Session["CompanyID"]));
ds = DataFunctions.GetDataSet(sqlcmd);
}
catch (Exception ex)
{
}
return ds;
}
public void LogFile(string sExceptionName, string sEventName, int nErrorLineNo, string sFormName)
{
bel_ErrorLog obj_Error = new bel_ErrorLog();
dal_Errorlog obj_dal_error = new dal_Errorlog();
try
{
obj_Error._ErrorlogDate = System.DateTime.Now;
obj_Error._ErrorMessage = sExceptionName;
obj_Error._FunctionName = sEventName;
obj_Error._ErrorLIne = nErrorLineNo;
obj_Error._PageName = sFormName;
obj_Error._iMode = "Insert";
using (DataSet ds = obj_dal_error.dal_ErrorLogDetail(obj_Error))
{
}
}
catch (Exception exe)
{
// LogFile(exe.Message, "Common:LogFile", Convert.ToInt32(exe.StackTrace.Substring(exe.StackTrace.LastIndexOf(":line") + 5)), this.Page.ToString());
}
//// HttpContext CurrentHTTPcontext = HttpContext.Current;
//StreamWriter log;
//string path = string.Empty;
//path = HttpContext.Current.Server.MapPath("~/Barcode INI/logfile.txt");
//if (!File.Exists(path))
//{
// log = new StreamWriter(path);
//}
// // Common.CommonVariablesandmsg.UserName
//else
//{
// log = File.AppendText(path);
//}
//// Write to the file:
//log.WriteLine("Data Time:" + DateTime.Now);
//log.WriteLine("Exception Name:" + sExceptionName);
//log.WriteLine("Event Name:" + sEventName);
//log.WriteLine("Error Line No.:" + nErrorLineNo);
//log.WriteLine("Form Name:" + sFormName);
//// Close the stream:
//log.Close();
}
