public static double GetByMonth(ExpenditureBuilding eb)
        {
            List <tenant_tbl> tenants = TenantBL.GetAllTenantByBuilding(eb.buildingId);
            double            sum     = (ExpenditureDAL.GetByMonth(eb));

            return(sum / tenants.Count);
        }
示例#2
0
        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));
        }