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