public ThongKeTheoThoiGianViewModel <PhuongTienTheoDoan> TkPhuongTien(DateTime from, DateTime to) { try { ThongKeTheoThoiGianViewModel <PhuongTienTheoDoan> result = new ThongKeTheoThoiGianViewModel <PhuongTienTheoDoan>(); List <DoanKhach> list = db.DoanKhaches.Where(c => c.NgayKetThuc >= from && c.NgayKetThuc <= to).ToList(); result.from = from; result.to = to; List <PhuongTienTheoDoan> resultks = new List <PhuongTienTheoDoan>(); int sum = 0; foreach (DoanKhach item in list) { List <PhuongTienTheoDoan> listks = db.PhuongTienTheoDoans.Where(c => c.DoanKhachId == item.Id).ToList(); foreach (PhuongTienTheoDoan i in listks) { resultks.Add(i); sum += i.GiaTien; } } result.danhsach = resultks; result.Tong = sum; return(result); } catch (Exception e) { return(null); } }
public ThongKeTheoThoiGianViewModel <ThongKeNhanVienViewModel> TkNhanVien(DateTime from, DateTime to) { try { ThongKeTheoThoiGianViewModel <ThongKeNhanVienViewModel> result = new ThongKeTheoThoiGianViewModel <ThongKeNhanVienViewModel>(); List <DoanKhach> list = db.DoanKhaches.Where(c => c.NgayKetThuc >= from && c.NgayKetThuc <= to).ToList(); result.from = from; result.to = to; List <NhanVienTheoDoan> listnv = new List <NhanVienTheoDoan>(); List <ThongKeNhanVienViewModel> resultnv = new List <ThongKeNhanVienViewModel>(); foreach (DoanKhach item in list) { List <NhanVienTheoDoan> listks = db.NhanVienTheoDoans.Where(c => c.idDoanKhach == item.Id).ToList(); foreach (NhanVienTheoDoan i in listks) { listnv.Add(i); } } foreach (NhanVien nv in db.NhanViens.ToList()) { ThongKeNhanVienViewModel tk = new ThongKeNhanVienViewModel(); tk.SoLan = listnv.Count(c => c.idNhanVien == nv.Id); tk.Id = nv.Id; tk.TenNV = nv.TenNhanVien; resultnv.Add(tk); } result.danhsach = resultnv; return(result); } catch (Exception e) { return(null); } }
public ActionResult TienAn([Bind(Include = "from,to")] ThongKeTheoThoiGianViewModel <KhachSanTheoDoan> thongke) { if (ModelState.IsValid) { var thongkedoan = bus.TkTienAn(thongke.from, thongke.to); if (thongkedoan == null) { ViewBag.error = "Không tìm thấy lịch sử tiền ăn!!!!"; return(View(thongke)); } return(View(thongke)); } return(View(thongke)); }
public ActionResult DoanKhach([Bind(Include = "from,to")] ThongKeTheoThoiGianViewModel <DoanKhach> thongke) { if (ModelState.IsValid) { var thongkedoan = bus.TkDoanKhach(thongke.from, thongke.to); if (thongkedoan == null) { ViewBag.error = "Không tìm thấy lịch sử đoàn khách!!!!"; return(View(thongke)); } return(View(thongke)); } return(View(thongke)); }
public ThongKeTheoThoiGianViewModel <DoanKhach> TkDoanKhach(DateTime from, DateTime to) { try { ThongKeTheoThoiGianViewModel <DoanKhach> result = new ThongKeTheoThoiGianViewModel <DoanKhach>(); List <DoanKhach> list = db.DoanKhaches.Where(c => c.NgayKetThuc >= from && c.NgayKetThuc <= to).ToList(); result.from = from; result.to = to; result.danhsach = list; int sum = 0; foreach (DoanKhach item in list) { sum += item.TongChiPhi; } result.Tong = sum; return(result); } catch (Exception e) { return(null); } }