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); }
}
