internal void changeReceivedStatus_CM(int month, int year, string userName, bool newReceivedStatus)
{
if (month > 0 && month < 13)
{
CoffeeRepository repository = new CoffeeRepository();
if (newReceivedStatus)
repository.changeReceivedToTrue_RP(month, year, userName);
else
repository.changeReceivedToFalse_RP(month, year, userName);
}
else
throw new Exception("Invalid Month supplied. Month must be 1-12");
}
internal List<string> getOrderNamesNotReceived_CM(int month, int year)
{
List<string> listToReturn = new List<string>();
CoffeeRepository repository = new CoffeeRepository();
List<string> names = repository.getOrderNamesNotReceived_RP(month, year);
IEnumerable data = (from ls in names select ls).Distinct();
foreach (var d in data)
listToReturn.Add(d.ToString());
return listToReturn;
}
internal List<coffee> getCoffees_CM()
{
CoffeeRepository repository = new CoffeeRepository();
return repository.getCoffees_Rp();
}
internal List<coffeeIDandQuantity> getOrdersByMonth_CM(int month, int year)
{
List<coffeeIDandQuantity> listToReturn = new List<coffeeIDandQuantity>();
if (month > 0 && month < 13)
{
CoffeeRepository repository = new CoffeeRepository();
List<order> orderList = repository.getOrdersByMonth_RP(month, year);
IEnumerable distinctCoffeeIDs = (from ls in orderList select ls.coffeeID).Distinct().AsEnumerable();
foreach (int ID in distinctCoffeeIDs)
{
coffeeIDandQuantity temp = new coffeeIDandQuantity();
int quantity = (from ls in orderList where ls.coffeeID == ID select ls.quantity).Sum();
temp.quantity = quantity;
temp.coffeeID = ID;
listToReturn.Add(temp);
}
return listToReturn;
}
else
throw new Exception("Invalid Month supplied. Month must be 1-12");
}
internal List<orderSummary> getOrdersByMonthForUser_CM(int month, int year, string userName)
{
List<orderSummary> listToReturn = new List<orderSummary>();
if (month > 0 && month < 13)
{
CoffeeRepository repository = new CoffeeRepository();
List<order> orderList = repository.getOrdersByMonthForUser_RP(month, year, userName);
//IEnumerable distinctCoffeeIDs = (from ls in orderList select ls.coffeeID).Distinct();
List<orderSummary> summaryList = (from ls in orderList
group ls by ls.coffeeID
into grp
select new orderSummary
{
coffeeID = grp.Key,
quantity = grp.Sum(q => q.quantity),
total = grp.Sum(t => t.total),
orderPaid = grp.All(p => p.orderPaid),
orderReceived = grp.All(r => r.orderReceived)
}).ToList();
/*
foreach (int ID in distinctCoffeeIDs)
{
orderSummary temp = new orderSummary();
int quantity = (from ls in orderList where ls.coffeeID == ID select ls.quantity).Sum();
decimal total = (from ls in orderList where ls.coffeeID == ID select ls.total).Sum();
temp.quantity = quantity;
temp.coffeeID = ID;
temp.total = total;
listToReturn.Add(temp);
}
*/
return summaryList;
}
else
throw new Exception("Invalid Month supplied. Month must be 1-12");
}