public ErrorExceptionLogs Add(ErrorExceptionLogs ErrorExceptionLogs)
{
using (IDbConnection _db = OpenConnection())
{
try
{
var parameters = new DynamicParameters();
parameters.Add("Source", ErrorExceptionLogs.Source);
parameters.Add("LogDateTime", DateTime.Now.ToString("g"));
parameters.Add("Message", ErrorExceptionLogs.Message);
parameters.Add("QueryString", ErrorExceptionLogs.QueryString);
parameters.Add("TargetSite", ErrorExceptionLogs.TargetSite);
parameters.Add("StackTrace", ErrorExceptionLogs.StackTrace);
parameters.Add("ServerName", ErrorExceptionLogs.ServerName);
parameters.Add("RequestURL", ErrorExceptionLogs.RequestURL);
parameters.Add("UserAgent", ErrorExceptionLogs.UserAgent);
parameters.Add("UserIP", ErrorExceptionLogs.UserIP);
parameters.Add("UserAuthentication", ErrorExceptionLogs.UserAuthentication);
parameters.Add("UserName", ErrorExceptionLogs.UserName);
parameters.Add("EventId", dbType: DbType.Int32, direction: ParameterDirection.Output);
var EventId = _db.Query <int>("SaveErrorExceptionLogs", parameters, commandType: CommandType.StoredProcedure).SingleOrDefault();
ErrorExceptionLogs.EventId = EventId;
return(ErrorExceptionLogs);
}
catch (Exception ex)
{
string ErrorMsg = ex.Message.ToString();
errLog.LogError(ex);
return(null);
}
}
}
public void Delete(ErrorExceptionLogs model)
{
if (model == null)
{
throw new ArgumentNullException("ErrorExceptionLogs");
}
List <ErrorExceptionLogs> ErrorExceptionLogs = GetAll();
ErrorExceptionLogs.Remove(ErrorExceptionLogs.Find(l => l.EventId == model.EventId));
UnitOfWork.ErrorExceptionLogsRepository.Delete(model);
}
public void Insert(ErrorExceptionLogs model)
{
if (model == null)
{
throw new ArgumentNullException("ErrorExceptionLog");
}
List <ErrorExceptionLogs> ErrorExceptionLogs = GetAll();
ErrorExceptionLogs.Add(model);
UnitOfWork.ErrorExceptionLogsRepository.Insert(model);
}
public void LogError(Exception ex)
{
string strMessage = string.Empty, strSource = string.Empty, strTargetSite = string.Empty, strStackTrace = string.Empty;
while (ex != null)
{
strMessage = ex.Message;
strSource = ex.Source;
strTargetSite = ex.TargetSite.ToString();
strStackTrace = ex.StackTrace;
ex = ex.InnerException;
}
if (strMessage.Length > 0)
{
try
{
ErrorExceptionLogs errorExceptionLog = new ErrorExceptionLogs();
errorExceptionLog.RequestURL = GetExecutingMethodName(ex);
var parameters = new DynamicParameters();
parameters.Add("Source", strSource);
parameters.Add("LogDateTime", DateTime.Now.ToString("g"));
parameters.Add("Message", strMessage);
parameters.Add("QueryString", errorExceptionLog.QueryString);
parameters.Add("TargetSite", strTargetSite);
parameters.Add("StackTrace", strStackTrace);
parameters.Add("ServerName", errorExceptionLog.ServerName);
parameters.Add("RequestURL", errorExceptionLog.RequestURL);
parameters.Add("UserAgent", errorExceptionLog.UserAgent);
parameters.Add("UserIP", errorExceptionLog.UserIP);
parameters.Add("UserAuthentication", errorExceptionLog.UserAuthentication);
parameters.Add("UserName", errorExceptionLog.UserName);
parameters.Add("EventId", dbType: DbType.Int32, direction: ParameterDirection.Output);
using (IDbConnection _db = OpenConnection())
{
string query = "SaveErrorExceptionLogs";
_db.Execute(query, parameters, commandType: CommandType.StoredProcedure);
}
}
catch (Exception exc)
{
//StringBuilder sb = new StringBuilder();
//sb.Append("Database Error From Exception Log!");
//sb.Append("Source : " + exc.Source);
//sb.Append("Message : " + exc.Message);
//WriteLog(sb.ToString());
EventLog.WriteEntry(exc.Source, "Database Error From Exception Log!", EventLogEntryType.Error, 65535);
}
}
}
public void Update(ErrorExceptionLogs model)
{
if (model == null)
{
throw new ArgumentNullException("ErrorExceptionLog");
}
ErrorExceptionLogs ErrorExceptionLog = GetById(model.EventId.ToString());
if (ErrorExceptionLog != null)
{
UnitOfWork.ErrorExceptionLogsRepository.Update(model);
}
}
