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