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 String PhanCong(NhanVienTheoDoan nv) { List <NhanVienTheoDoan> list = db.NhanVienTheoDoans.Where(c => c.idNhanVien == nv.idNhanVien).ToList(); DateTime starttime = db.DoanKhaches.Find(nv.idDoanKhach).NgayKhoiHanh; DateTime endtime = db.DoanKhaches.Find(nv.idDoanKhach).NgayKetThuc; foreach (NhanVienTheoDoan item in list) { DoanKhach doan = db.DoanKhaches.Find(item.idDoanKhach); if (doan.NgayKhoiHanh.Date > starttime && endtime > doan.NgayKhoiHanh) { return("Trùng Lịch!! chọn lại"); } if (doan.NgayKhoiHanh < starttime && doan.NgayKetThuc > starttime) { return("Trùng Lịch!!! chọn lại"); } if (doan.NgayKhoiHanh == starttime) { return("Trùng Lịch!!! chọn lại"); } } db.NhanVienTheoDoans.Add(nv); db.SaveChanges(); return(null); }
public bool TinhTongTien(int id) { DoanKhach doan = db.DoanKhaches.Find(id); int tong = 0; foreach (KhachSanTheoDoan item in db.KhachSanTheoDoans.Where(c => c.DoanKhachId == id)) { tong += item.GiaTien; } foreach (TienAnTheoDoan item in db.TienAnTheoDoans.Where(c => c.DoanKhachId == id)) { tong += item.GiaTien; } foreach (PhuongTienTheoDoan item in db.PhuongTienTheoDoans.Where(c => c.DoanKhachId == id)) { tong += item.GiaTien; } foreach (ChiPhiKhacTheoDoan item in db.ChiPhiKhacTheoDoans.Where(c => c.DoanKhachId == id)) { tong += item.GiaTien; } doan.TongChiPhi = tong; doan.isEdit = true; db.Entry(doan).State = EntityState.Modified; db.SaveChanges(); return(true); }
public String getTenTour(int?id) { var doankhaches = db.DoanKhaches.Include(c => c.Tour).ToList(); DoanKhach doan = doankhaches.Find(c => c.Id == id); return(doan.Tour.TenGoi); }
public NhanVienViewModel ThongTinNV(int?id) { try { NhanVienViewModel result = new NhanVienViewModel(); NhanVien nv = db.NhanViens.Find(id); result.tenNV = nv.TenNhanVien; List <PhanCongViewModel> phancong = new List <PhanCongViewModel>(); List <NhanVienTheoDoan> list = db.NhanVienTheoDoans.Where(c => c.idNhanVien == id).ToList(); result.TinhTrang = "Rãnh Rỗi"; foreach (NhanVienTheoDoan item in list) { PhanCongViewModel pc = new PhanCongViewModel(); DoanKhach doan = db.DoanKhaches.Find(item.idDoanKhach); pc.TenDoan = doan.TenGoi; pc.TuNgay = doan.NgayKhoiHanh; pc.DenNgay = doan.NgayKetThuc; pc.ChucVu = db.NhiemVus.Find(item.idNhiemVu).TenNhiemVu; pc.TenTour = db.Tours.Find(doan.TourId).TenGoi; if (doan.NgayKhoiHanh.Date <= DateTime.Now.Date && doan.NgayKetThuc.Date >= DateTime.Now.Date) { result.TinhTrang = "Đang Hoạt Động Trong Đoàn"; } phancong.Add(pc); } result.PhanCong = phancong; return(result); } catch (Exception e) { return(null); } }
public ActionResult DeleteConfirmed(int id) { DoanKhach doanKhach = db.DoanKhaches.Find(id); db.DoanKhaches.Remove(doanKhach); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult PhanCong(int?id) { DoanKhach dk = db.DoanKhaches.Find(id); List <DoanKhach> list = new List <DoanKhach>(); list.Add(dk); ViewBag.idNhiemVu = new SelectList(db.NhiemVus, "Id", "TenNhiemVu"); ViewBag.idNhanVien = new SelectList(db.NhanViens, "Id", "TenNhanVien"); ViewBag.idDoanKhach = new SelectList(list, "Id", "TenGoi"); return(View()); }
public ActionResult DangKy(int?id) { List <DoanKhach> list = new List <DoanKhach>(); DoanKhach doan = db.DoanKhaches.Find(id); list.Add(doan); ViewBag.DoanKhachId = new SelectList(list, "Id", "TenGoi"); ViewBag.KhachHangId = new SelectList(db.KhachHangs, "Id", "HoTen"); ViewBag.tenTour = bus.getTenTour(id); ViewBag.ngayKhoiHanh = doan.NgayKhoiHanh.Date.ToString(); ViewBag.ngayKetThuc = doan.NgayKetThuc.Date.ToString(); return(View()); }
private int timgiacuatour(DoanKhach k, Tour t) { int gia = 0; for (int i = t.GiaTours.Count - 1; i >= 0; i--) { if (k.NgayKhoiHanh >= t.GiaTours.ElementAt(i).NgayCapNhat) { gia = t.GiaTours.ElementAt(i).Gia; } } return(gia); }
// GET: DoanKhaches/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } DoanKhach doanKhach = db.DoanKhaches.Find(id); if (doanKhach == null) { return(HttpNotFound()); } return(View(doanKhach)); }
public ActionResult Create([Bind(Include = "Id,TenGoi,NgayKhoiHanh,NgayKetThuc,TongKS,TongAn,TongPT,TongKhac,TourId,SLCho")] DoanKhach doanKhach) { if (ModelState.IsValid) { String error = bus.CreateDoan(doanKhach); if (error != null) { ViewBag.error = error; ViewBag.TourId = new SelectList(db.Tours, "Id", "TenGoi"); return(View()); } return(RedirectToAction("Index")); } ViewBag.TourId = new SelectList(db.Tours, "Id", "TenGoi", doanKhach.TourId); return(View(doanKhach)); }
public String CreateDoan(DoanKhach doan) { try { if (doan.NgayKhoiHanh.Date < DateTime.Now.Date) { return("Ngày khởi hành phải lớn hơn ngày hiện hành!!!"); } if (doan.NgayKhoiHanh.Date > doan.NgayKetThuc.Date) { return("Ngày khởi hành phải bé hơn ngày kết thúc !!!!"); } db.DoanKhaches.Add(doan); db.SaveChanges(); return(null); } catch (Exception e) { return("Có Lỗi xảy ra: " + e); } }
public ActionResult DangKy([Bind(Include = "Id,DoanKhachId,KhachHangId")] DSKhachTheoDoan dSKhachTheoDoan) { if (ModelState.IsValid) { if (bus.Dangky(dSKhachTheoDoan)) { return(RedirectToAction("Index")); } else { ViewBag.error = "Lỗi xảy ra!, Kiểm tra lại số lượng hoặc đã đăng ký vui lòng thử lại sau!"; DoanKhach doan = db.DoanKhaches.Find(dSKhachTheoDoan.Id); ViewBag.DoanKhachId = new SelectList(db.DoanKhaches, "Id", "TenGoi"); ViewBag.KhachHangId = new SelectList(db.KhachHangs, "Id", "HoTen"); ViewBag.tenTour = bus.getTenTour(dSKhachTheoDoan.Id); ViewBag.ngayKhoiHanh = doan.NgayKhoiHanh.Date.ToString(); ViewBag.ngayKetThuc = doan.NgayKetThuc.Date.ToString(); return(View()); } } ViewBag.DoanKhachId = new SelectList(db.DoanKhaches, "Id", "TenGoi", dSKhachTheoDoan.DoanKhachId); ViewBag.KhachHangId = new SelectList(db.KhachHangs, "Id", "HoTen", dSKhachTheoDoan.KhachHangId); return(View(dSKhachTheoDoan)); }
public bool Dangky(DSKhachTheoDoan ds) { try { DoanKhach doan = db.DoanKhaches.Find(ds.DoanKhachId); int count = db.DSKhachTheoDoans.Count(c => c.DoanKhachId == ds.DoanKhachId); if (doan.SLCho > count) { DSKhachTheoDoan result = db.DSKhachTheoDoans.Where(c => c.DoanKhachId == ds.DoanKhachId).ToList().Find(c => c.KhachHangId == ds.KhachHangId); if (result == null) { db.DSKhachTheoDoans.Add(ds); db.SaveChanges(); return(true); } return(false); } return(false); } catch (Exception e) { return(false); } }
public void Update(DoanKhach entity) { _context.DoanKhachs.Update(entity); _context.SaveChanges(); }
public void Delete(DoanKhach entity) { entity.isDeleted = Status.Deleted; _context.DoanKhachs.Update(entity); _context.SaveChanges(); }
public void Add(DoanKhach entity) { _context.DoanKhachs.Add(entity); _context.SaveChanges(); }
private void init() { if (formType != EditState.View) { IEnumerable <Tour> Tours = _tourRepository.getAll(); foreach (Tour tourm in Tours) { tourd.Items.Add(tourm.Ten); } } datestart.Value = DateTime.Now.Date; dateend.Value = DateTime.Now.Date; switch (formType) { case EditState.Create: tourd.SelectedIndex = 0; break; case EditState.Edit: //Init Data to DoanForm DoanKhach dk_init = _doanRepo.getById(id); mad.Text = dk_init.MaDoan; tend.Text = dk_init.TenDoan; tourd.SelectedItem = dk_init.Tour.Ten; statusd.Text = dk_init.Chitiet; datestart.Value = dk_init.DateStart; dateend.Value = dk_init.DateEnd; if (dk_init.DateStart <= DateTime.Now.Date) { mad.ReadOnly = true; tend.ReadOnly = true; statusd.ReadOnly = true; datestart.Enabled = false; dateend.Enabled = false; Save.Enabled = false; cp_btn.Enabled = false; nv_btn.Enabled = false; hk_btn.Enabled = false; tourd.Enabled = false; } //HanhKhach foreach (var hk in dk_init.CTDoans) { data_hk.Rows.Add(hk.HanhKhach.MaKhach, hk.HanhKhach.Ten, hk.HanhKhach.SDT); } //NhanVien foreach (var nv in dk_init.NV_VTs) { data_nv.Rows.Add(nv.NhanVien.MaNV, nv.NhanVien.Ten, nv.ViTri); } //ChiTieu foreach (var ct in dk_init.CTChitieus) { data_cp.Rows.Add(ct.ChiTieu.Ten, ct.TienCT); } break; case EditState.View: DoanKhach dk_init1 = _doanRepo.getById(id); mad.Text = dk_init1.MaDoan; tend.Text = dk_init1.TenDoan; tourd.Items.Add(dk_init1.Tour.Ten); tourd.SelectedIndex = 0; statusd.Text = dk_init1.Chitiet; datestart.Value = dk_init1.DateStart; dateend.Value = dk_init1.DateEnd; //HanhKhach foreach (var hk in dk_init1.CTDoans) { data_hk.Rows.Add(hk.HanhKhach.MaKhach, hk.HanhKhach.Ten, hk.HanhKhach.SDT); } //NhanVien foreach (var nv in dk_init1.NV_VTs) { data_nv.Rows.Add(nv.NhanVien.MaNV, nv.NhanVien.Ten, nv.ViTri); } //ChiTieu foreach (var ct in dk_init1.CTChitieus) { data_cp.Rows.Add(ct.ChiTieu.Ten, ct.TienCT); } mad.ReadOnly = true; tend.ReadOnly = true; statusd.ReadOnly = true; datestart.Enabled = false; dateend.Enabled = false; Save.Enabled = false; break; } }
private void save() { //init Create Type DoanKhach doan = new DoanKhach(); Tour tour1 = _tourRepository.getByName(tourd.SelectedItem.ToString()); //init Edit Type if (formType == EditState.Edit) { doan = _doanRepo.getById(id); if (tour1.TourId != doan.TourId) { doan.Gia = tour1.Gias.LastOrDefault(); } } //Add value to each of column doan doan.MaDoan = mad.Text; doan.TenDoan = tend.Text; doan.Tour = tour1; doan.Chitiet = statusd.Text; doan.DateStart = datestart.Value.Date; doan.DateEnd = dateend.Value.Date; //NhanVien List <NV_VT> doan_nvs = new List <NV_VT>(); foreach (DataGridViewRow row in data_nv.Rows) { NV_VT doan_nv = new NV_VT(); NhanVien nhanvien = _nvRepo.getById(0, row.Cells[0].Value.ToString()); doan_nv.NhanVien = nhanvien; doan_nv.DoanKhach = doan; doan_nv.ViTri = row.Cells[2].Value.ToString(); doan_nvs.Add(doan_nv); } doan.NV_VTs = doan_nvs; //HanhKhach List <CTDoan> cTDoans = new List <CTDoan>(); foreach (DataGridViewRow row in data_hk.Rows) { CTDoan cTDoan = new CTDoan(); HanhKhach hk = _hkRepo.getById(0, row.Cells[0].Value.ToString()); cTDoan.HanhKhach = hk; cTDoan.DoanKhach = doan; cTDoans.Add(cTDoan); } doan.CTDoans = cTDoans; //ChiTieu List <CTChitieu> cTChiTieus = new List <CTChitieu>(); foreach (DataGridViewRow row in data_cp.Rows) { CTChitieu cTChiTieu = new CTChitieu(); ChiTieu ct = _ctRepo.getByName(row.Cells[0].Value.ToString()); cTChiTieu.ChiTieu = ct; cTChiTieu.TienCT = row.Cells[1].Value.ToString(); cTChiTieu.DoanKhach = doan; cTChiTieus.Add(cTChiTieu); } doan.CTChitieus = cTChiTieus; if (formType == EditState.Edit) { _doanRepo.Update(doan); } else { doan.Gia = doan.Tour.Gias.LastOrDefault(); doan.DateCreated = DateTime.Now; _doanRepo.Add(doan); } }