public void UpdateAllSaleRate()
{
var allItems = Context.Items;
foreach (Item item in allItems)
{
item.QuantityWeaklySaleRate = 0;
}
TimeSpan weekAgo = new TimeSpan(7, 0, 0);
List <ItemTransaction> validI_Ts = new List <ItemTransaction>();
using (var itsRepo = new ItemTransactionsRepo(new InventoryContext()))
{
validI_Ts = itsRepo.AllItemTransactionFrom(weekAgo)
.ToList();
itsRepo.Complete();
}
//each time an item is sold, increment its sale rate
//by quantity sold
foreach (ItemTransaction i_t in validI_Ts)
{
var currItem = i_t.Item;
currItem.QuantityWeaklySaleRate += i_t.Quantity;
}
}
//constructor
public UnitOfWork()
{
Context = new InventoryContext();
Items = new ItemRepository(Context);
ItemTransactions = new ItemTransactionsRepo(Context);
AdminAccounts = new AdminAccountsRepo(Context);
CurrentDeliveries = new CurrentDeliveriesRepo(Context);
CurrentReservations = new CurrentReservationsRepo(Context);
ItemDeliveries = new ItemDeliveriesRepo(Context);
ItemReservations = new ItemReservationsRepo(Context);
PastDeliveries = new PastDeliveriesRepo(Context);
PastReservations = new PastReservationsRepo(Context);
StaffAccounts = new StaffAccountsRepo(Context);
}