/// <summary>
/// Initialise local database.
/// </summary>
private void InitializeDatabase()
{
using (var db = new UwianTimerContext())
{
db.Database.Migrate();
}
}
public bool CurrentDayStartLogsExists()
{
using (var db = new UwianTimerContext())
{
return(db.START_LOGS.Any(x => x.StartTime.ToLocalTime().Date == DateTime.Now.Date));
}
}
public DateTime GetActiveStartLogToday()
{
using (var db = new UwianTimerContext())
{
return(db.START_LOGS.Where(x => x.StartTime.ToLocalTime().Date == DateTime.Now.Date && x.IsActive).OrderByDescending(x => x.StartTime).First().StartTime);
}
}
public void AddStartLog(DateTime startTime)
{
using (var db = new UwianTimerContext())
{
db.START_LOGS.Add(new START_LOGS {
StartTime = startTime
});
db.SaveChanges();
}
}
