public static ModelResult <DTO.Account.ErrorsLogs> ErrorLogsInsert(DTO.Account.ErrorsLogs oErrorsLogs)
{
var oResult = new ModelResult <DTO.Account.ErrorsLogs>();
var conn = new SqlConnection(DbConnection.ConnectionString);
try
{
using (conn)
{
using (var cmd = new SqlCommand())
{
cmd.Connection = conn;
cmd.CommandText = "SP_ErrorsLogsInsert";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@ErrorMessage", oErrorsLogs.ErrorMessage);
cmd.Parameters.AddWithValue("@Link", oErrorsLogs.Link);
cmd.Parameters.AddWithValue("@IP", oErrorsLogs.IP);
cmd.Parameters.AddWithValue("@Browser", oErrorsLogs.Browser);
cmd.Parameters.AddWithValue("@UserAgent", oErrorsLogs.UserAgent);
cmd.Parameters.AddWithValue("@RequestType", oErrorsLogs.RequestType);
if (!string.IsNullOrEmpty(oErrorsLogs.PostedData))
{
cmd.Parameters.AddWithValue("@PostedData", oErrorsLogs.PostedData);
}
cmd.Parameters.AddWithValue("@IsSolved", oErrorsLogs.IsSolved);
cmd.Parameters.AddWithValue("@IsAjax", oErrorsLogs.IsAjax);
conn.Open();
oErrorsLogs.Id = Convert.ToInt32(cmd.ExecuteScalar());
oResult.HasResult = true;
oResult.Results = oErrorsLogs;
}
}
}
finally
{
conn.Close();
}
return(oResult);
}
protected void Application_Error(object sender, EventArgs e)
{
Exception exception = Server.GetLastError();
var oErrorLog = new DTO.Account.ErrorsLogs();
oErrorLog.ErrorMessage = exception.Message;
oErrorLog.Browser = Request.RequestContext.HttpContext.Request.Browser.Browser;
oErrorLog.UserAgent = Request.RequestContext.HttpContext.Request.UserAgent;
oErrorLog.IP = Request.RequestContext.HttpContext.Request.UserHostAddress;
oErrorLog.RequestType = Request.RequestContext.HttpContext.Request.RequestType;
oErrorLog.IsAjax = Request.RequestContext.HttpContext.Request.IsAjaxRequest();
oErrorLog.Link = Request.RequestContext.HttpContext.Request.Url.ToString();
if (!string.IsNullOrEmpty(oErrorLog.PostedData))
{
oErrorLog.PostedData = Server.UrlDecode(Request.RequestContext.HttpContext.Request.Form.ToString());
}
if (oErrorLog.RequestType.ToLower() == "get")
{
oErrorLog.PostedData = Server.UrlDecode(Request.RequestContext.HttpContext.Request.QueryString.ToString());
}
DAL.Account.ErrorsLogs.ErrorLogsInsert(oErrorLog);
}
public static ModelResult <List <DTO.Account.ErrorsLogs> > ErrorLogsGet(DTO.Account.ErrorsLogs oErrorsLogs)
{
var oResult = new ModelResult <List <DTO.Account.ErrorsLogs> >();
var conn = new SqlConnection(DbConnection.ConnectionString);
try
{
using (conn)
{
using (var cmd = new SqlCommand())
{
cmd.Connection = conn;
#region SQLCOMMAND Builder
var command = @"SELECT * FROM ErrorsLogs WHERE 1=1 ";
if (oErrorsLogs.Id > 0)
{
command += "and Id =@Id ";
cmd.Parameters.AddWithValue("@Id", oErrorsLogs.Id);
}
if (!oErrorsLogs.IsList) // isList=false get DataTable with paging ----- isList=True get list without paging
{
command += " order by @SortCol @SortType OFFSET (@Page -1 )* @RowsPerPage ROWS FETCH NEXT @RowsPerPage ROWS ONLY";
command = command.Replace("@SortCol", oErrorsLogs.SortCol);
command = command.Replace("@SortType", oErrorsLogs.SortType);
command = command.Replace("@Page", oErrorsLogs.Page.ToString());
command = command.Replace("@RowsPerPage", oErrorsLogs.RowPerPage.ToString());
}
#endregion
if (conn.State != ConnectionState.Open)
{
conn.Open();
}
cmd.CommandText = command;
SqlDataReader reader = cmd.ExecuteReader();
var lstErrorsLogs = new List <DTO.Account.ErrorsLogs>();
if (reader.HasRows)
{
while (reader.Read())
{
var obErrorLog = new DTO.Account.ErrorsLogs();
obErrorLog.Id = Convert.ToInt32(reader["Id"]);
obErrorLog.ErrorMessage = Convert.ToString(reader["ErrorMessage"]);
obErrorLog.Link = Convert.ToString(reader["Link"]);
obErrorLog.IP = Convert.ToString(reader["IP"]);
obErrorLog.Browser = Convert.ToString(reader["Browser"]);
obErrorLog.UserAgent = Convert.ToString(reader["UserAgent"]);
obErrorLog.RequestType = Convert.ToString(reader["RequestType"]);
obErrorLog.PostedData = Convert.ToString(reader["PostedData"]);
obErrorLog.IsSolved = Convert.ToBoolean(reader["IsSolved"]);
obErrorLog.ErrorDate = Convert.ToDateTime(reader["ErrorDate"]);
obErrorLog.IsAjax = Convert.ToBoolean(reader["IsAjax"]);
lstErrorsLogs.Add(obErrorLog);
}
}
int count = 0;
if (!oErrorsLogs.IsList)
{
using (SqlConnection connCount = new SqlConnection(DbConnection.ConnectionString))
{
using (var cmdCount = new SqlCommand())
{
cmdCount.Connection = connCount;
command = @"SELECT COUNT(1) FROM ErrorsLogs WHERE 1=1 ";
if (oErrorsLogs.Id > 0)
{
command += " AND Id = @Id";
cmd.Parameters.AddWithValue("@Id", oErrorsLogs.Id);
}
cmdCount.CommandText = command;
if (connCount.State != ConnectionState.Open)
{
connCount.Open();
}
count = Convert.ToInt32(cmdCount.ExecuteScalar());
connCount.Close();
}
}
}
if (lstErrorsLogs.Count > 0)
{
oResult.HasResult = true;
oResult.Results = lstErrorsLogs;
oResult.RowCount = count;
}
}
}
}
finally
{
conn.Close();
}
return(oResult);
}
