public static double GetByMonth(ExpenditureBuilding eb) { List <tenant_tbl> tenants = TenantBL.GetAllTenantByBuilding(eb.buildingId); double sum = (ExpenditureDAL.GetByMonth(eb)); return(sum / tenants.Count); }
public static double GetByMonth(ExpenditureBuilding eb) { using (HomeCommitteeDBEntities db = new HomeCommitteeDBEntities()) { List <expenditure_tbl> ex = db.expenditure_tbl.Where(m => m.date.Month == eb.month && m.building_id == eb.buildingId).ToList(); double sumPay = 0; foreach (var e in ex) { if (e.type == (int)ExpenditureType.Regular) { sumPay += e.sum; } } return(sumPay); } }
public HttpResponseMessage CalcPayForMonth(ExpenditureBuilding eb) { double sum = ExpenditureBL.GetByMonth(eb); return(Request.CreateResponse(HttpStatusCode.OK, sum)); }