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