public static List<ErrorLog> GetLogs(string LocationName = null, string MethodName = null,
string ErroMessage = "", EventLogEntryType? type = null,
DateTime? LogDateTime = null
)
{
if (LogDateTime.HasValue)
LogDateTime = LogDateTime.Value.Date;
string cnnString = CreateEntitiesConnectionString();
using (BMIKidsEntities ctx = new BMIKidsEntities(cnnString))
{
var q = from l in ctx.ErrorLogs
where (String.IsNullOrEmpty(LocationName) || l.Location == LocationName) &&
(String.IsNullOrEmpty(ErroMessage) || l.ErrorDescription.Contains(ErroMessage)) &&
(!LogDateTime.HasValue || l.LogDateTime >= LogDateTime)
orderby l.LogDateTime descending
select l;
return q.ToList();
}
}
public static void TruncateErrorLogs()
{
string cnnString = CreateEntitiesConnectionString();
using (BMIKidsEntities e = new BMIKidsEntities(cnnString))
{
e.ExecuteStoreCommand("Truncate Table ErrorLogs");
}
}
private static void WriteErrorToDB(ErrorLog log)
{
string cnnString = CreateEntitiesConnectionString();
using (BMIKidsEntities ctx = new BMIKidsEntities(cnnString))
{
ctx.ErrorLogs.AddObject(log);
ctx.SaveChanges();
ctx.AcceptAllChanges();
}
}
