public static void Log()
{
using (var db = new TimeRecordContext())
{
var query = db.TimeRecords.OrderByDescending((t) => t.Time);
Console.WriteLine("All TimeRecords from data base:\n");
foreach (var item in query)
{
ConsoleColor color;// = ConsoleColor.Red;
if (item.Type == TimeRecordType.Entry)
{
color = ConsoleColor.Green;
}
else
{
color = ConsoleColor.Red;
}
Console.ForegroundColor = color;
Console.WriteLine($"{item.Id} {item.Type.ToString()} - {item.Time}");
Console.ResetColor();
}
}
}
public static void Clear()
{
using (var db = new TimeRecordContext())
{
db.Database.ExecuteSqlCommand("DELETE FROM [TimeRecords]");
}
Console.WriteLine("All records was cleaned up");
}
public static void RegisterTimeRecord(TimeRecordType type, DateTime?date = null)
{
using (var db = new TimeRecordContext())
{
var dateRecord = DateTime.Now;
if (date.HasValue)
{
dateRecord = date.Value;
}
else
{
dateRecord = DateTime.Now;
}
var timeRecord = new TimeRecord(dateRecord, type);
db.TimeRecords.Add(timeRecord);
db.SaveChanges();
Console.Write($"{type.ToString()} Registered");
}
}
