public static void RunUnenforcedWorksOrders(List <THAS_CONNECT_GetCompletedWorksorders_Result> untriedWOs, int woCounter, thas01Entities thas01) { var thousCounter = 0; var deadlockCount = 0; Logger.Log("Start Time: " + DateTime.Now); foreach (var wo in untriedWOs) { try { woCounter++; if (woCounter % 1000 == 0) { thousCounter += 1; Logger.Log("Processed : " + thousCounter + "k records. Deadlock Count: " + deadlockCount + ". Time is now: " + DateTime.Now); } } catch (Exception) { deadlockCount++; } var origWOCostStatus = wo.WorksOrderCostStatusCode; var count = 1; thas01.CostCompletedWO_CostWorksOrder(wo.WorksOrderNumber, "/A", 1); var thisWO = thas01.THAS_CONNECT_GetSingleWorksOrder(wo.WorksOrderNumber).First(); //if (thisWO.WorksOrderStatusCode == 5) //{ // //Must have costed successfully // Logger.Log(thisWO.WorksOrderNumber + " Has Been Costed Successfully. Works Order Cost Status: " + thisWO.WorksOrderCostStatusCode); // count++; //} //else if (thisWO.WorksOrderCostStatusCode == 2) //{ // Logger.Log(thisWO.WorksOrderNumber + " Has Failed To Be Costed..."); // count++; //} while (thisWO.WorksOrderCostStatusCode == origWOCostStatus && count < 10) { //Still ongoing Logger.Log(thisWO.WorksOrderNumber + " Is Still Processing... Check " + count); count++; } } }
public static void RunErrorWorksOrders(List <THAS_CONNECT_GetCompletedWorksorders_Result> errorWOs, int woCounter, int woSuccessCounter, int woFailCounter, thas01Entities thas01) { foreach (var wo in errorWOs) { Logger.Log("WO Count: " + woCounter); woCounter++; var count = 1; Logger.Log("Attempting to Cost " + wo.WorksOrderNumber + "..."); //prepare works order var woFromDb = thas01.WorksOrders.Where(x => x.WorksOrderNumber == wo.WorksOrderNumber).First(); var wotFromDb = thas01.WorksOrderTransfers.Where(x => x.WorksOrderNumber == wo.WorksOrderNumber).First(); woFromDb.WorksOrderCostStatusCode = 1; wotFromDb.WorksOrderCostStatusCode = 1; thas01.SaveChanges(); //end works order preparation thas01.CostCompletedWO_CostWorksOrder(wo.WorksOrderNumber, "/A", 1); Logger.Log("Stored Procedure Finished Running..."); var thisWO = thas01.THAS_CONNECT_GetSingleWorksOrder(wo.WorksOrderNumber).First(); if (thisWO.WorksOrderStatusCode == 5) { //Must have costed successfully Logger.Log(thisWO.WorksOrderNumber + " Has Been Costed Successfully. Works Order Cost Status: " + thisWO.WorksOrderCostStatusCode + ". WO Success Count: " + woSuccessCounter); woSuccessCounter++; } else if (thisWO.WorksOrderCostStatusCode == 2) { Logger.Log(thisWO.WorksOrderNumber + " Has Failed To Be Costed..." + " WO Fail Count: " + woFailCounter); woFailCounter++; } while (thisWO.WorksOrderCostStatusCode == 1 && count < 10) { //Still ongoing Logger.Log(thisWO.WorksOrderNumber + " Is Still Processing... Check " + count); count++; } } }
public static void RunEnforcedWorksOrders(List <THAS_CONNECT_GetCompletedWorksorders_Result> enforcedWOs, int woCounter, thas01Entities thas01) { var deadlockCount = 0; var thousCounter = 0; Logger.Log("Start Time: " + DateTime.Now); foreach (var wo in enforcedWOs) { try { woCounter++; if (woCounter % 1000 == 0) { thousCounter += 1; Logger.Log("Processed : " + thousCounter + "k records. Time is now: " + DateTime.Now); } var count = 1; ////prepare works order //var woFromDb = thas01.WorksOrders.Where(x => x.WorksOrderNumber == wo.WorksOrderNumber).First(); //var wotFromDb = thas01.WorksOrderTransfers.Where(x => x.WorksOrderNumber == wo.WorksOrderNumber).First(); //woFromDb.WorksOrderCostStatusCode = 3; //wotFromDb.WorksOrderCostStatusCode = 3; //wotFromDb.IsEnforced = true; //thas01.SaveChanges(); //end works order preparation thas01.CostCompletedWO_CostWorksOrder(wo.WorksOrderNumber, "/A", 1); //Logger.Log("Stored Procedure Finished Running..."); var thisWO = thas01.THAS_CONNECT_GetSingleWorksOrder(wo.WorksOrderNumber).First(); //if (thisWO.WorksOrderStatusCode == 5) //{ // //Must have costed successfully // Logger.Log(thisWO.WorksOrderNumber + " Has Been Costed Successfully. Works Order Cost Status: " + thisWO.WorksOrderCostStatusCode + ". WO Success Count: " + woSuccessCounter); // woSuccessCounter++; //} //else if (thisWO.WorksOrderCostStatusCode == 2) //{ // Logger.Log(thisWO.WorksOrderNumber + " Has Failed To Be Costed..." + " WO Fail Count: " + woFailCounter); // woFailCounter++; //} while (thisWO.WorksOrderCostStatusCode == 1 && count < 10) { //Still ongoing Logger.Log(thisWO.WorksOrderNumber + " Is Still Processing... Check " + count); count++; } } catch (Exception) { deadlockCount++; } } }