public DoanKhachViewModel getDetail(int?id) { try { DoanKhachViewModel result = new DoanKhachViewModel(); DoanKhach doan = db.DoanKhaches.Find(id); result.maDoan = doan.Id; result.soluong = doan.SLCho - getSoLuong(doan.Id); result.tenDoan = doan.TenGoi; result.tenTour = doan.Tour.TenGoi; result.thongtin = doan.Tour.DacDiem; result.ngayKhoiHanh = doan.NgayKhoiHanh; result.ngayKetThuc = doan.NgayKetThuc; result.danhsachkhach = getListKhachHang(id); result.nhanvien = getListNhanVien(id); result.dstienan = db.TienAnTheoDoans.Where(c => c.DoanKhachId == id).ToList(); result.dstienKs = db.KhachSanTheoDoans.Where(c => c.DoanKhachId == id).ToList(); result.dstienpt = db.PhuongTienTheoDoans.Where(c => c.DoanKhachId == id).ToList(); result.dstienkhac = db.ChiPhiKhacTheoDoans.Where(c => c.DoanKhachId == id).ToList(); return(result); } catch (Exception e) { return(null); } }
public List <DoanKhachViewModel> getList() { try { List <DoanKhachViewModel> list = new List <DoanKhachViewModel>(); var doanKhaches = db.DoanKhaches.ToList(); foreach (var khach in doanKhaches) { DoanKhachViewModel item = new DoanKhachViewModel(); item.maDoan = khach.Id; item.soluong = khach.SLCho - getSoLuong(khach.Id); item.tenDoan = khach.TenGoi; item.tenTour = khach.Tour.TenGoi; item.thongtin = khach.Tour.DacDiem; item.ngayKhoiHanh = khach.NgayKhoiHanh; item.ngayKetThuc = khach.NgayKetThuc; item.isEdit = khach.isEdit; list.Add(item); } return(list); } catch (Exception ex) { return(null); } }