public void UpdateCTBaoCaoDoanhThu(DTO_CTBaoCaoDoanhThu cTBaoCaoDoanhThu) { using (var context = new SQLServerDBContext()) { context.Entry(cTBaoCaoDoanhThu).State = EntityState.Modified; context.SaveChanges(); } }
public void AddCTBaoCaoDoanhThu(DTO_CTBaoCaoDoanhThu cTBaoCaoDoanhThu) { using (var context = new SQLServerDBContext()) { context.CT_BaoCaoDoanhThu.Add(cTBaoCaoDoanhThu); context.SaveChanges(); } }
public DTO_BCDoanhThu GetBCDoanhThu(int month, int year) { var isExisted = DALManager.BCDoanhThuDAL.IsExisted(month, year); //if not exists -> calculate if (!isExisted) { List <DTO_CTBaoCaoDoanhThu> listCT = new List <DTO_CTBaoCaoDoanhThu>(); var listHD = BUSManager.HoaDonBUS.GetListByMonth(month, year); var hdGroup = listHD.GroupBy(hd => hd.NgayLap.Day).OrderBy(g => g.Key); foreach (var gr in hdGroup) { int soBN = gr.Count(); double doanhThu = 0; foreach (var hd in gr) { doanhThu += hd.ThanhTien; } DTO_CTBaoCaoDoanhThu temp = new DTO_CTBaoCaoDoanhThu() { Ngay = gr.Key, Thang = month, Nam = year, SoBenhNhan = soBN, DoanhThu = doanhThu }; listCT.Add(temp); } DTO_BCDoanhThu newBC = new DTO_BCDoanhThu() { Nam = year, Thang = month, DS_CTBaoCaoDoanhThu = listCT, TongBenhNhan = 0, TongDoanhThu = 0 }; DALManager.BCDoanhThuDAL.AddBCDoanhThu(newBC); } else { if (month == DateTime.Now.Month && year == DateTime.Now.Year) { var listCTBCDT = BUSManager.CTBaoCaoDoanhThuBUS.GetListByMonth(month, year); var lastCT = listCTBCDT.OrderBy(ct => ct.Ngay).LastOrDefault(); var listHD = BUSManager.HoaDonBUS.GetListByMonth(month, year); int lastDay; if (lastCT == null) { lastDay = 0; } else { lastDay = lastCT.Ngay; } var grHD = listHD.Where(hd => hd.NgayLap.Day >= lastDay) .GroupBy(hd => hd.NgayLap.Day); foreach (var gr in grHD) { int soBN = gr.Count(); double doanhThu = 0; foreach (var hd in gr) { doanhThu += hd.ThanhTien; } if (gr.Key != lastDay) { DTO_CTBaoCaoDoanhThu temp = new DTO_CTBaoCaoDoanhThu() { Ngay = gr.Key, Thang = month, Nam = year, SoBenhNhan = soBN, DoanhThu = doanhThu }; DALManager.CTBaoCaoDoanhThuDAL.AddCTBaoCaoDoanhThu(temp); } else { lastCT.SoBenhNhan = soBN; lastCT.DoanhThu = doanhThu; DALManager.CTBaoCaoDoanhThuDAL.UpdateCTBaoCaoDoanhThu(lastCT); } } } } var result = DALManager.BCDoanhThuDAL.GetBCDoanhThu(month, year); DALManager.BCDoanhThuDAL.LoadNPCTBaoCaoDoanhThu(result); return(result); }
public void UpdateCTBCDoanhThu(DTO_CTBaoCaoDoanhThu cTBaoCaoDoanhThu) { DALManager.CTBaoCaoDoanhThuDAL.UpdateCTBaoCaoDoanhThu(cTBaoCaoDoanhThu); }
public void AddCTBaoCaoDoanhThu(DTO_CTBaoCaoDoanhThu cTBaoCaoDoanhThu) { DALManager.CTBaoCaoDoanhThuDAL.AddCTBaoCaoDoanhThu(cTBaoCaoDoanhThu); }