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