public void EnsureCreated() { try { using (var db = new DbContextLogs()) { db.Database.EnsureCreated(); } } catch (Exception ex) { Log.Error(Defines.TAG, "EnsureCreated exception, " + ex.Message); } }
// log message to database public async void LogToDbAsync(string text) { try { using (var db = new DbContextLogs()) { var log = new DebugLog(); log.Log = text; await db.Logs.AddAsync(log); await db.SaveChangesAsync(); } } catch (Exception ex) { Log.Error(Defines.TAG, "LogToDbAsync exception, " + ex.Message); } }
internal bool LoadAllRecords(out List <DebugLog> results) { bool bOK = true; results = new List <DebugLog>(); try { using (var db = new DbContextLogs()) { results = db.Logs.OrderByDescending(item => item.CreatedDate).ToList(); } } catch (Exception ex) { Logger.Instance.Error($"LoadAllRecords exception, {ex.Message}"); bOK = false; } return(bOK); }
internal async Task <bool> DeleteAllRecords() { bool bOK = true; try { using (var db = new DbContextLogs()) { foreach (var data in db.Logs) { db.Logs.Remove(data); } await db.SaveChangesAsync(); } } catch (Exception ex) { Logger.Instance.Error($"DeleteAllRecords exception, {ex.Message}"); bOK = false; } return(bOK); }