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