private void cbTenphong_TextChanged(object sender, EventArgs e) { if (cbTenkh1.Items != null) { cbTenkh1.Items.Clear(); } cbTenkh1.Text = ""; if (cbTenphong.Text != "") { int taikhoan = (from tk in dl.ChiTietThuePhongs where tk.TenPhong == cbTenphong.Text select tk).Count(); if (taikhoan != 0) { ChiTietThuePhong ct = dl.ChiTietThuePhongs.Single(a => a.TenPhong == cbTenphong.Text); string map = ct.MaPhong; var query = (from n in dl.ThuePhongs where n.MaPhong == map select n.MaKH); foreach (string item in query) { makh = item; int taikhoan1 = (from tk in dl.HDDichVus where tk.MaKH == makh select tk).Count(); if (taikhoan1 != 0) { KhachHang kh = dl.KhachHangs.Single(b => b.MaKH == makh); cbTenkh1.Items.Add(kh.TenKH); } } } } }
public ActionResult DeleteConfirmed(int id, int khachHang) { ChiTietThuePhong chiTietThuePhong = db.ChiTietThuePhong.Find(id, khachHang); db.ChiTietThuePhong.Remove(chiTietThuePhong); db.SaveChanges(); return(RedirectToAction("ChiTiếtDoanhThu")); }
public ActionResult Edit([Bind(Include = "MaThuePhong,MaKhachHang,SoLuongKhach")] ChiTietThuePhong chiTietThuePhong) { if (ModelState.IsValid) { db.Entry(chiTietThuePhong).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); return(RedirectToAction("ChiTiết", new { id = chiTietThuePhong.MaThuePhong, khachHang = chiTietThuePhong.MaKhachHang })); } ViewBag.MaKhachHang = new SelectList(db.KhachHang, "MaKhachHang", "TenKhachHang", chiTietThuePhong.MaKhachHang); ViewBag.MaThuePhong = new SelectList(db.ThuePhong, "MaThuePhong", "MaThuePhong", chiTietThuePhong.MaThuePhong); return(View(chiTietThuePhong)); }
public ActionResult Create([Bind(Include = "MaThuePhong,MaKhachHang,SoLuongKhach")] ChiTietThuePhong chiTietThuePhong) { if (ModelState.IsValid) { db.ChiTietThuePhong.Add(chiTietThuePhong); db.SaveChanges(); return(RedirectToAction("ChiTiết", new { id = chiTietThuePhong.MaThuePhong, khachHang = chiTietThuePhong.MaKhachHang })); } ViewBag.MaKhachHang = new SelectList(db.KhachHang, "MaKhachHang", "TenKhachHang", chiTietThuePhong.MaKhachHang); ViewBag.MaThuePhong = new SelectList(db.ThuePhong, "MaThuePhong", "MaThuePhong", chiTietThuePhong.MaThuePhong); return(View(chiTietThuePhong)); }
public ActionResult Details(int?id, int?khachHang) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } ChiTietThuePhong chiTietThuePhong = db.ChiTietThuePhong.Find(id, khachHang); if (chiTietThuePhong == null) { return(HttpNotFound()); } return(View(chiTietThuePhong)); }
public ActionResult Edit(int?id, int?khachHang) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } ChiTietThuePhong chiTietThuePhong = db.ChiTietThuePhong.Find(id, khachHang); if (chiTietThuePhong == null) { return(HttpNotFound()); } ViewBag.MaKhachHang = new SelectList(db.KhachHang, "MaKhachHang", "TenKhachHang", chiTietThuePhong.MaKhachHang); ViewBag.MaThuePhong = new SelectList(db.ThuePhong, "MaThuePhong", "MaThuePhong", chiTietThuePhong.MaThuePhong); return(View(chiTietThuePhong)); }
public string getMaThue_By_MaPhong_TrangThai(string maPhong, bool trangThai) { string maThue = ""; ChiTietThuePhong cttpnull = db.ChiTietThuePhongs.Where(x => x.maPhong.Equals(maPhong) && x.trangThai == Convert.ToByte(trangThai) && x.ghiChu == null).FirstOrDefault(); ChiTietThuePhong cttpkhacnull = db.ChiTietThuePhongs.Where(x => x.maPhong.Equals(maPhong) && x.trangThai == Convert.ToByte(trangThai) && x.ghiChu != null).FirstOrDefault(); if (cttpnull == null) { maThue = cttpkhacnull.maThue; } if (cttpkhacnull == null) { maThue = cttpnull.maThue; } return(maThue); }
public eChiTietThuePhong getCTTP_By_MaPhong_TrangThai(string maPhong, bool trangThai) { ChiTietThuePhong item = db.ChiTietThuePhongs.Where(x => x.maPhong.Equals(maPhong) && x.trangThai == Convert.ToByte(false)).FirstOrDefault(); eChiTietThuePhong cttp = new eChiTietThuePhong(); cttp.MaThue = item.maThue; cttp.MaKhach = item.maKhach; cttp.MaPhong = item.maPhong; cttp.NgayRa = item.ngayRa; cttp.NgayVao = item.ngayVao; cttp.GioRa = item.gioRa; cttp.GioVao = item.gioVao; cttp.TrangThai = Convert.ToBoolean(item.trangThai); cttp.GhiChu = item.ghiChu; cttp.TienKhac = Convert.ToDouble(item.tienKhac); return(cttp); }
public int insertCTTP(eChiTietThuePhong cttpnew) { ChiTietThuePhong temp = new ChiTietThuePhong(); temp.maThue = cttpnew.MaThue; temp.maPhong = cttpnew.MaPhong; temp.maKhach = cttpnew.MaKhach; temp.ngayRa = cttpnew.NgayRa; temp.ngayVao = cttpnew.NgayVao; temp.gioRa = cttpnew.GioRa; temp.gioVao = cttpnew.GioVao; temp.trangThai = Convert.ToByte(cttpnew.TrangThai); temp.ghiChu = cttpnew.GhiChu; temp.tienKhac = Convert.ToDecimal(cttpnew.TienKhac); db.ChiTietThuePhongs.InsertOnSubmit(temp); db.SubmitChanges(); return(1); }
public ActionResult XoaChiTietThuePhong(string id, string khachHang, ChiTietThuePhong chiTietThuePhong) { var decode = Encryption.decrypt(id); var decodeKH = Encryption.decrypt(khachHang); int x = int.Parse(decode); int y = int.Parse(decodeKH); chiTietThuePhong = db.ChiTietThuePhong.Find(x, y); try { db.ChiTietThuePhong.Remove(chiTietThuePhong); db.SaveChanges(); return(View("ThànhCông")); } catch { return(View("LỗiXoáThuêPhòng")); } }
public ActionResult XoaChiTietThuePhong(string id, string khachHang) { var decode = Encryption.decrypt(id); var decodeKH = Encryption.decrypt(khachHang); int x = int.Parse(decode); int y = int.Parse(decodeKH); if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } ChiTietThuePhong chiTietThuePhong = db.ChiTietThuePhong.Find(x, y); if (chiTietThuePhong == null) { return(HttpNotFound()); } return(View(chiTietThuePhong)); }
public ActionResult SuaChiTietThuePhong(string id, string khachHang) { var decode = Encryption.decrypt(id); var decodeKH = Encryption.decrypt(khachHang); int x = int.Parse(decode); int y = int.Parse(decodeKH); if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } ChiTietThuePhong chiTietThuePhong = db.ChiTietThuePhong.Find(x, y); if (chiTietThuePhong == null) { return(HttpNotFound()); } List <SelectListItem> tenKh = new List <SelectListItem>(); foreach (var item in db.KhachHang) { tenKh.Add(new SelectListItem { Text = item.TenKhachHang, Value = item.MaKhachHang.ToString() }); } ViewBag.MaKhachHang = /*new SelectList(db.KhachHangs, "MaKhachHang", "TenKhachHang", chiTietThuePhong.MaKhachHang)*/ tenKh; List <SelectListItem> maTP = new List <SelectListItem>(); foreach (var i in db.ThuePhong) { maTP.Add(new SelectListItem { Text = i.MaThuePhong.ToString(), Value = i.MaThuePhong.ToString() }); } ViewBag.MaThuePhong = /*new SelectList(db.ThuePhongs, "MaThuePhong", "MaThuePhong")*/ maTP; return(View(chiTietThuePhong)); }
public ActionResult SuaChiTietThuePhong([Bind(Include = "MaThuePhong,MaKhachHang,SoLuongKhach")] ChiTietThuePhong chiTietThuePhong) { List <SelectListItem> tenKh = new List <SelectListItem>(); foreach (var item in db.KhachHang) { tenKh.Add(new SelectListItem { Text = item.TenKhachHang, Value = item.MaKhachHang.ToString() }); } ViewBag.MaKhachHang = /*new SelectList(db.KhachHangs, "MaKhachHang", "TenKhachHang", chiTietThuePhong.MaKhachHang)*/ tenKh; List <SelectListItem> maTP = new List <SelectListItem>(); foreach (var i in db.ThuePhong) { maTP.Add(new SelectListItem { Text = i.MaThuePhong.ToString(), Value = i.MaThuePhong.ToString() }); } ViewBag.MaThuePhong = /*new SelectList(db.ThuePhongs, "MaThuePhong", "MaThuePhong")*/ maTP; try { if (ModelState.IsValid) { db.Entry(chiTietThuePhong).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); return(RedirectToAction("TrangThuêPhòng")); } } catch { ModelState.AddModelError("", "Không thể sửa chi tiết vì đã có chi tiết thuê phòng này rồi"); } return(View(chiTietThuePhong)); }
public string getMaKhach_By_MaPhong_TrangThai(string maPhong, bool trangThai) { ChiTietThuePhong cttp = db.ChiTietThuePhongs.Where(x => x.maPhong.Equals(maPhong) && x.trangThai == Convert.ToByte(trangThai)).FirstOrDefault(); return(cttp.maKhach); }