// find orders lost on the conveyor due to a missing rack location. public List <OrdersLostOnRacktoMissingRackLocationData> OrdersLostOnRacktoMissingRackLocation() { StoreContext CurrentContext = null; List <OrdersLostOnRacktoMissingRackLocationData> ListData = new List <OrdersLostOnRacktoMissingRackLocationData>(); for (int i = 1; i <= 4; i++) { CurrentContext = GetDBStore(i); DateTime prev = DateTime.Today.AddDays(-7).Date; var invs = from inv in CurrentContext.Invoices where DbFunctions.TruncateTime(inv.DueDate) >= prev.Date && inv.Rack == null && inv.DepartmentID != 5 && inv.PaidAmount == 0 select inv; foreach (Invoice inv in invs) { OrdersLostOnRacktoMissingRackLocationData data = new OrdersLostOnRacktoMissingRackLocationData() { dueDate = inv.DueDate, invoiceID = inv.InvoiceID, storeID = i }; ListData.Add(data); } } return(ListData.OrderBy(o => o.storeID).ToList()); }
// find orders lost on the conveyor due to a missing rack location. public List <OrdersLostOnRacktoMissingRackLocationData> OrdersLostOnRacktoMissingRackLocation() { StoreContext[] connectStrings = new StoreContext[4]; ConnectionStringSettingsCollection connections = ConfigurationManager.ConnectionStrings; string StoreConnectionString = connections["StoreContext"].ConnectionString; StoreContext CurrentContext = null; connectStrings[0] = new StoreContext(StoreConnectionString); // List<Invoice> invs = assembly.Invoices.Take(10).ToList(); StoreConnectionString = connections["Store2Context"].ConnectionString; connectStrings[1] = new StoreContext(StoreConnectionString); StoreConnectionString = connections["Store3Context"].ConnectionString; connectStrings[2] = new StoreContext(StoreConnectionString); StoreConnectionString = connections["Store4Context"].ConnectionString; connectStrings[3] = new StoreContext(StoreConnectionString); List <OrdersLostOnRacktoMissingRackLocationData> ListData = new List <OrdersLostOnRacktoMissingRackLocationData>(); for (int i = 0; i < 4; i++) { CurrentContext = connectStrings[i]; DateTime prev = DateTime.Today.AddDays(-7).Date; var invs = from inv in CurrentContext.Invoices where DbFunctions.TruncateTime(inv.DueDate) >= prev.Date && inv.Rack == null && inv.DepartmentID != 5 && inv.PaidAmount == 0 select inv; foreach (Invoice inv in invs) { OrdersLostOnRacktoMissingRackLocationData data = new OrdersLostOnRacktoMissingRackLocationData() { dueDate = inv.DueDate, invoiceID = inv.InvoiceID, storeID = i }; ListData.Add(data); } } return(ListData.OrderBy(o => o.storeID).ToList()); }
// find orders lost on the conveyor due to a missing rack location. public List <OrdersLostOnRacktoMissingRackLocationData> OrdersLostOnRacktoMissingRackLocation() { StoreContext CurrentContext = null; List <OrdersLostOnRacktoMissingRackLocationData> ListData = new List <OrdersLostOnRacktoMissingRackLocationData>(); for (int i = 1; i <= 4; i++) { CurrentContext = GetDBStore(i); DateTime prev = DateTime.Today.AddDays(-7).Date; var invs = from inv in CurrentContext.Invoices where DbFunctions.TruncateTime(inv.DueDate) >= prev.Date && inv.Rack == null && inv.DepartmentID != 5 && inv.PaidAmount == 0 select inv; foreach (Invoice inv in invs) { //might have been voided so check in InvoiceDetail InvoiceDetail detail = (from id in CurrentContext.InvoiceDetails where id.InvoiceID == inv.InvoiceID && id.Voided == true select id).FirstOrDefault(); if (detail == null) //nope then we want it { OrdersLostOnRacktoMissingRackLocationData data = new OrdersLostOnRacktoMissingRackLocationData() { dueDate = inv.DueDate, invoiceID = inv.InvoiceID, storeID = i }; ListData.Add(data); } } } return(ListData.OrderBy(o => o.storeID).ToList()); }