public void AddLog(SeverityLevel level, string ExceptionMessage, string ExceptionStacktrace, string customMessage)
{
try
{
var sqlCom = _db.GetWriteCommand(@"INSERT INTO logs
(
LogLevel,
ExceptionMessage,
ExceptionStacktrace,
CustomMessage,
Date
)
Values
(
@LogLevel,
@ExceptionMessage,
@ExceptionStacktrace,
@CustomMessage,
@Date
);");
sqlCom.Parameters.AddWithValue("@LogLevel", level.ToString());
sqlCom.Parameters.AddWithValue("@ExceptionMessage", ExceptionMessage);
sqlCom.Parameters.AddWithValue("@ExceptionStacktrace", ExceptionStacktrace);
sqlCom.Parameters.AddWithValue("@CustomMessage", customMessage);
sqlCom.Parameters.AddWithValue("@Date", DateTime.Now);
sqlCom.ExecuteNonQuery();
}
finally
{
_db.CloseConnections();
}
}
public void AddReminder(ReminderModel reminder, int emailID, DateTime nextRemindingDate)
{
try
{
var sqlCom = _db.GetWriteCommand(@"INSERT INTO reminder
(Day, Month, Name, EmailID, TimeZoneOffset,
CreationDate, NextRemindingDate, ReminderID)
VALUES (?Day, ?Month, ?Name, ?EmailID,?TimeZoneOffset,
?CreationDate, ?NextRemindingDate,?ID);");
sqlCom.Parameters.AddWithValue("?Day", reminder.Day);
sqlCom.Parameters.AddWithValue("?Month", reminder.Month);
sqlCom.Parameters.AddWithValue("?Name", reminder.Name);
sqlCom.Parameters.AddWithValue("?EmailID", emailID);
sqlCom.Parameters.AddWithValue("?TimeZoneOffset", reminder.TimeZoneOffset);
sqlCom.Parameters.AddWithValue("?CreationDate", DateTime.Now);
sqlCom.Parameters.AddWithValue("?NextRemindingDate", nextRemindingDate);
sqlCom.Parameters.AddWithValue("?ID", Guid.NewGuid());
sqlCom.ExecuteNonQuery();
}
finally
{
_db.CloseConnections();
}
}
