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(); } }