public void ShowAllRecords() { var dbContext = new OrderCheckerDBModel(); var queryDB = from db in dbContext.Orders orderby db.Id select db; foreach (var item in queryDB) { Console.WriteLine("ID: {0} | Creator: {1} | TaskName: {2} | TaskDescription: {3} |" + "CreatedOn: {4:yyyy-MM-dd} | Assignee: {5} | Status: {6} | Notes: {7}", item.Id, item.Creator, item.TaskName, item.TaskDescription, item.CreatedOn, item.Assignee, item.Status, item.Note); } }
static void Main(string[] args) { var dbContext = new OrderCheckerDBModel(); int items = 0; int maxID = -1; int index = 0; var orderCheck = new OrdersChecker(); orderCheck.ShowAllRecords(); //orderCheck.WaitForKeyPress(); do { try { var queryDB1 = from db in dbContext.Orders select db.Id; maxID = queryDB1.Max(); items = queryDB1.Count(); } catch (Exception ex) { Console.WriteLine("Get max ID failed with error: {0}", ex.Message); } if (maxID >= 0) { var queryDB = (from db in dbContext.Orders where db.Id == maxID select db).SingleOrDefault(); if (orderCheck.OrdersStatusChanged(queryDB, items)) { Console.WriteLine("Status changed !!!"); } else { Console.WriteLine("Status not changed"); } } Console.WriteLine("Itteration: {0}", ++index); Thread.Sleep(5000); } while (index < 20); }