public List <SUPPLY> AllSupplies() { try { return(supplyS.All()); } catch (Exception e) { throw e; } }
public decimal GetTotalSumMonthSupply(int month, int year) { try { using (StudioDB db = new StudioDB()) { var supplies = supplyS.All(); int idSupply = -1; foreach (var item in supplies) { if (Parser.ParseStringToIntArray(item.delivery_date, '.')[1] == month && Parser.ParseStringToIntArray(item.delivery_date, '.')[2] == year) { idSupply = item.id_supply; } } decimal res = 0; if (idSupply != -1) { var products = db.PRODUCTs.Where(x => x.id_supply == idSupply); foreach (var item in products) { res += DecrementPercentages(item.price, 10) * item.count; } var salesProducts = from b in db.BASKETs join p in db.PRODUCTs on b.id_product equals p.id_product where p.id_supply == idSupply select new { b.count, p.price }; foreach (var item in salesProducts) { res += DecrementPercentages(item.price, 10) * item.count; } } return(res); } } catch (Exception e) { throw e; } }