private void buttonThem_Click(object sender, EventArgs e)
{
using (QUANLYKHACHSANEntities db = new QUANLYKHACHSANEntities())
{
PHONG phong = new PHONG()
{
MaPhong = textBoxMaPhong.Text,
SoPhong = textBoxTenPhong.Text,
TrangThai = comboBoxTrangThai.Text,
MaLoaiPhong = textBoxMaLoaiPhong.Text,
};
if (db.PHONGs.Select(p => p.MaPhong).Contains(textBoxMaPhong.Text))
{
MessageBox.Show("Mã phòng đã tồn tại!!!");
return;
}
if (db.PHONGs.Select(p => p.SoPhong).Contains(textBoxTenPhong.Text))
{
MessageBox.Show(" Phòng đã tồn tại!!!");
return;
}
db.PHONGs.Add(phong);
db.SaveChanges();
MessageBox.Show("Thêm phòng thành công");
LoadPhong(dataGridViewPhong);
}
}
void LoadNV(DataGridView dtgv)
{
using (QUANLYKHACHSANEntities db = new QUANLYKHACHSANEntities())
{
var query =
from nv in db.NHANVIENs
join q in db.QUYENs on nv.MaQuyen equals q.MaQuyen
join bp in db.BOPHANs
on nv.IDBoPhan equals bp.IDBoPhan
select new
{
MANV = nv.MaNV,
TenNV = nv.HoTenNV,
NGAYSINH = nv.NgaySinh,
GT = nv.GioiTinh,
CM = nv.CMND,
DC = nv.DiaChi,
SoDienThoai = nv.SDT,
TenQuyen = q.MaQuyen,
BoPhan = bp.IDBoPhan,
Quyen = q.TenQuyen,
ChucVu = bp.TenBoPhan,
};
var results = query.ToList();
dtgv.DataSource = results;
}
BindingNV(dataGridView1);
}
void LoadTK(DataGridView dtgv)
{
using (QUANLYKHACHSANEntities db = new QUANLYKHACHSANEntities())
{
var query =
from nv in db.NHANVIENs
join q in db.QUYENs on nv.MaQuyen equals q.MaQuyen
join tk in db.TAIKHOANs on nv.MaNV equals tk.MaNV
join bp in db.BOPHANs
on nv.IDBoPhan equals bp.IDBoPhan
select new
{
ID = tk.ID,
MANV = nv.MaNV,
TenNV = nv.HoTenNV,
Mật_Khẩu = tk.MatKhau,
Quyen = q.TenQuyen,
ChucVu = bp.TenBoPhan,
};
var results = query.ToList();
dtgv.DataSource = results;
}
}
void loadDataToGridView(DataGridView dtgv)
{
using (QUANLYKHACHSANEntities db = new QUANLYKHACHSANEntities())
{
var query =
from p in db.PHONGs
join sd in db.PHIEUTHUEPHONGs on p.MaPhong equals sd.MaPhong
join kh in db.KHACHHANGs on sd.MaKH equals kh.MaKH
where p.TrangThai.Contains("Đã ở")
select new
{
maPhong = p.MaPhong,
maKH = sd.MaKH,
diaChi = kh.DiaChi,
tenPhong = p.SoPhong,
ngayThue = sd.NgayNhan,
tenKH = kh.TenKH,
trangThai = p.TrangThai,
};
var results = query.ToList();
dtgv.DataSource = results;
}
}
private void buttonThem_Click(object sender, EventArgs e)
{
using (QUANLYKHACHSANEntities db = new QUANLYKHACHSANEntities())
{
NHANVIEN nv = new NHANVIEN()
{
MaNV = textBoxMaNV.Text,
HoTenNV = textBoxHoTen.Text,
GioiTinh = comboBoxGT.Text,
SDT = textBoxSDT.Text,
DiaChi = textBoxDiaChi.Text,
CMND = textBoxCMND.Text,
NgaySinh = System.DateTime.Parse(dateTimeNS.Text),
MaQuyen = Int32.Parse(textBoxTenQuyen.Text),
IDBoPhan = Int32.Parse(textBoxTenBoPhan.Text),
};
if (db.NHANVIENs.Select(p => p.MaNV).Contains(textBoxMaNV.Text))
{
MessageBox.Show("Mã nhân viên đã tồn tại");
return;
}
db.NHANVIENs.Add(nv);
db.SaveChanges();
MessageBox.Show("Thêm nhân viên thành công !!!");
LoadNV(dataGridView1);
}
}
private void button1_Click(object sender, EventArgs e)
{
using (QUANLYKHACHSANEntities db = new QUANLYKHACHSANEntities())
{
THIETBI tb = new THIETBI
{
MaTB = textBoxMaTB.Text,
TenTB = textBoxTenTB.Text,
GhiChu = textBoxGhiChu.Text,
};
if (db.THIETBIs.Select(p => p.MaTB).Contains(textBoxMaTB.Text))
{
MessageBox.Show("Mã thiết bị đã tồn tại");
return;
}
if (db.THIETBIs.Select(p => p.TenTB).Contains(textBoxTenTB.Text))
{
MessageBox.Show("Tên thiết bị đã tồn tại");
return;
}
db.THIETBIs.Add(tb);
MessageBox.Show("Thêm thiết bị thành công");
db.SaveChanges();
LoadTB(dataGridViewTBP);
}
}
private void buttonXoa_Click(object sender, EventArgs e)
{
using (QUANLYKHACHSANEntities db = new QUANLYKHACHSANEntities())
{
db.KHACHHANGs.Remove(db.KHACHHANGs.Find(Int32.Parse(textBoxMaKH.Text)));
db.SaveChanges();
MessageBox.Show("Xóa thành công");
LoadKH(dataGridViewKH);
}
}
private void buttonSua_Click(object sender, EventArgs e)
{
using (QUANLYKHACHSANEntities db = new QUANLYKHACHSANEntities())
{
THIETBI tb = db.THIETBIs.Find(Int32.Parse(textBoxMaTB.Text));
tb.TenTB = textBoxTenTB.Text;
tb.GhiChu = textBoxGhiChu.Text;
db.SaveChanges();
MessageBox.Show("Sửa thành công");
LoadTB(dataGridViewTBP);
}
}
//sửa
private void button2_Click(object sender, EventArgs e)
{
using (QUANLYKHACHSANEntities db = new QUANLYKHACHSANEntities())
{
var dv = db.THIETBI_SD.Where(x => x.MaTB == textBoxMa.Text).FirstOrDefault();
dv.MaPhong = comboBoxTB.Text;
dv.SoLuong = Int32.Parse(textBoxSL.Text);
db.THIETBI_SD.AddOrUpdate(dv);
db.SaveChanges();
MessageBox.Show("Sửa thành công");
LoadTBSD(dataGridViewTB);
}
}
private void button1_Click(object sender, EventArgs e)
{
using (QUANLYKHACHSANEntities db = new QUANLYKHACHSANEntities())
{
string id = textBoxMaNV.Text;
TAIKHOAN nv = db.TAIKHOANs.Find(id);
nv.ID = textBoxID.Text;
nv.MatKhau = textBoxMK.Text;
db.SaveChanges();
MessageBox.Show("Sửa thành công ");
LoadTK(dataGridViewDK);
}
}
private void buttonSua_Click_1(object sender, EventArgs e)
{
using (QUANLYKHACHSANEntities db = new QUANLYKHACHSANEntities())
{
PHONG p = db.PHONGs.Find(Int32.Parse(textBoxMaPhong.Text));
p.SoPhong = textBoxTenPhong.Text;
p.TrangThai = comboBoxTrangThai.Text;
p.MaLoaiPhong = textBoxMaLoaiPhong.Text;
db.SaveChanges();
MessageBox.Show("Sửa thành công ");
LoadPhong(dataGridViewPhong);
}
}
private void buttonXoa_Click(object sender, EventArgs e)
{
using (QUANLYKHACHSANEntities db = new QUANLYKHACHSANEntities())
{
string id = textBoxMaNV.Text;
db.NHANVIENs.Remove(db.NHANVIENs.Find(id));
var TK = (from tk in db.TAIKHOANs where tk.MaNV.Equals(id) select tk).FirstOrDefault();
db.TAIKHOANs.Remove(TK);
db.SaveChanges();
MessageBox.Show("Xóa thành công");
LoadNV(dataGridView1);
}
}
private void buttonSua_Click(object sender, EventArgs e)
{
using (QUANLYKHACHSANEntities db = new QUANLYKHACHSANEntities())
{
KHACHHANG kh = db.KHACHHANGs.Find(Int32.Parse(textBoxMaKH.Text));
kh.TenKH = textBoxTenKH.Text;
kh.SDT = textBoxSDT.Text;
kh.CMND = textBoxCMND.Text;
kh.GioiTinh = comboBoxGT.Text;
kh.DiaChi = textBoxDC.Text;
db.SaveChanges();
MessageBox.Show("Sửa thành công");
LoadKH(dataGridViewKH);
}
}
private void buttonXoa_Click(object sender, EventArgs e)
{
using (QUANLYKHACHSANEntities db = new QUANLYKHACHSANEntities())
{
//var maKH = dataGridViewKH.Rows[index].Cells[0].Value.ToString();
string maKH = textBoxMaKH.Text;
var dv = db.KHACHHANGs.Where(x => x.MaKH == maKH).FirstOrDefault();
var tk = (from a in db.KHACHHANGs
join b in db.HOADONs
on a.MaKH equals b.MaKH
select new
{
mnv = a.MaKH
}).FirstOrDefault();
if (tk.mnv == maKH)
{
var phong = (from p in db.HOADONs where p.MaKH.Equals(maKH) select p).FirstOrDefault();
phong.MaKH = "KH00";
db.HOADONs.AddOrUpdate(phong);
}
var tk1 = (from a in db.KHACHHANGs
join b in db.PHIEUTHUEPHONGs
on a.MaKH equals b.MaKH
select new
{
mnv = a.MaKH
}).FirstOrDefault();
if (tk1.mnv == maKH)
{
var phong1 = (from p in db.PHIEUTHUEPHONGs where p.MaKH.Equals(maKH) select p).FirstOrDefault();
phong1.MaKH = "KH00";
db.PHIEUTHUEPHONGs.AddOrUpdate(phong1);
}
db.KHACHHANGs.Remove(dv);
db.SaveChanges();
MessageBox.Show("Xóa thành công");
LoadKH(dataGridViewKH);
}
}
private void buttonThem_Click(object sender, EventArgs e)
{
using (QUANLYKHACHSANEntities db = new QUANLYKHACHSANEntities())
{
TAIKHOAN nv = new TAIKHOAN()
{
ID = textBoxID.Text,
MatKhau = textBoxMK.Text,
MaNV = textBoxMaNV.Text,
};
db.TAIKHOANs.Add(nv);
db.SaveChanges();
MessageBox.Show("Thêm thành công !!!");
LoadTK(dataGridViewDK);
}
}
//xóa
private void button3_Click(object sender, EventArgs e)
{
using (QUANLYKHACHSANEntities db = new QUANLYKHACHSANEntities())
{
var maTB = dataGridViewTB.Rows[Index].Cells[0].Value.ToString();;
var dv = db.THIETBI_SD.Where(x => x.MaTB == maTB).FirstOrDefault();
db.THIETBI_SD.Remove(dv);
var lstSddv = db.THIETBIs.Where(x => x.MaTB == maTB).ToList();
foreach (var sddv in lstSddv)
{
db.THIETBIs.Remove(sddv);
}
// db.THIETBI_SD.Remove(dv);
db.SaveChanges();
MessageBox.Show("Xóa thành công");
LoadTBSD(dataGridViewTB);
}
}
void LoadTB(DataGridView dtgv)
{
using (QUANLYKHACHSANEntities db = new QUANLYKHACHSANEntities())
{
var query = from p in db.THIETBIs
select new
{
Mã_TB = p.MaTB,
Tên_TB = p.TenTB,
Ghi_Chú = p.GhiChu,
};
var result = query.ToList();
dtgv.DataSource = result;
}
BindingTB(dataGridViewTBP);
}
private void buttonXoa_Click(object sender, EventArgs e)
{
using (QUANLYKHACHSANEntities db = new QUANLYKHACHSANEntities())
{
string id = textBoxMaTB.Text;
db.THIETBIs.Remove(db.THIETBIs.Find(id));
var matb = dataGridViewTBP.Rows[index].Cells[0].Value.ToString();
var lstSdtb = db.THIETBI_SD.Where(x => x.MaTB == matb).ToList();
foreach (var sddv in lstSdtb)
{
db.THIETBI_SD.Remove(sddv);
}
db.SaveChanges();
MessageBox.Show("Xóa thành công");
LoadTB(dataGridViewTBP);
}
}
private void buttonThem_Click(object sender, EventArgs e)
{
using (QUANLYKHACHSANEntities db = new QUANLYKHACHSANEntities())
{
KHACHHANG kh = new KHACHHANG()
{
MaKH = textBoxMaKH.Text,
TenKH = textBoxTenKH.Text,
SDT = textBoxSDT.Text,
CMND = textBoxCMND.Text,
GioiTinh = comboBoxGT.Text,
DiaChi = textBoxDC.Text,
};
db.KHACHHANGs.Add(kh);
MessageBox.Show("Thêm thành công");
db.SaveChanges();
LoadKH(dataGridViewKH);
}
}
void LoadKH(DataGridView dtgv)
{
using (QUANLYKHACHSANEntities db = new QUANLYKHACHSANEntities())
{
var query = from kh in db.KHACHHANGs
select new
{
Mã_KH = kh.MaKH,
Tên_KH = kh.TenKH,
SĐT = kh.SDT,
CMND = kh.CMND,
Địa_Chỉ = kh.DiaChi,
Giới_Tính = kh.GioiTinh,
};
var result = query.ToList();
dtgv.DataSource = result;
}
BindingKH(dataGridViewKH);
}
void LoadPhong(DataGridView dtgv)
{
using (QUANLYKHACHSANEntities db = new QUANLYKHACHSANEntities())
{
var query = from p in db.PHONGs
join lp in db.LOAIPHONGs on p.MaLoaiPhong equals lp.MaLoaiPhong
select new
{
Mã_Phòng = p.MaPhong,
Tên_Phòng = p.SoPhong,
Trạng_Thái = p.TrangThai,
Mã_Loại_Phòng = lp.MaLoaiPhong,
Tên_Loai_Phòng = lp.TenLoaiPhong,
Giá = lp.GiaPhong,
};
var result = query.ToList();
dtgv.DataSource = result;
}
BindingPhong(dataGridViewPhong);
}
private void buttonXoa_Click(object sender, EventArgs e)
{
using (QUANLYKHACHSANEntities db = new QUANLYKHACHSANEntities())
{
string id = textBoxMaNV.Text;
db.NHANVIENs.Remove(db.NHANVIENs.Find(id));
var tk = (from a in db.NHANVIENs
join b in db.TAIKHOANs
on a.MaNV equals b.MaNV
select new
{
mnv = a.MaNV
}).FirstOrDefault();
if (tk.mnv == id)
{
var TK1 = (from tk1 in db.TAIKHOANs where tk1.MaNV.Equals(id) select tk1).FirstOrDefault();
db.TAIKHOANs.Remove(TK1);
}
var hd = (from a in db.NHANVIENs
join b in db.HOADONs
on a.MaNV equals b.MaNV
select new
{
mnv = a.MaNV
}).FirstOrDefault();
if (hd.mnv == id)
{
var phong = (from p in db.HOADONs where p.MaNV.Equals(id) select p).FirstOrDefault();
phong.MaKH = "NULL";
db.HOADONs.AddOrUpdate(phong);
}
db.SaveChanges();
MessageBox.Show("Xóa thành công");
LoadNV(dataGridView1);
}
}
void LoadNV(DataGridView dtgv)
{
using (QUANLYKHACHSANEntities db = new QUANLYKHACHSANEntities())
{
var query =
from p in db.DICHVU_SD
join dv in db.DICHVUs on p.MaDV equals dv.MaDV
join lp in db.PHONGs on p.MaPhong equals lp.MaPhong
select new
{
SoPhong = lp.SoPhong,
TenDV = dv.TenDV,
SoLuong = p.SoLuong,
giaDV = dv.GiaDV,
};
var results = query.ToList();
dtgv.DataSource = results;
}
}
private void buttonSua_Click(object sender, EventArgs e)
{
using (QUANLYKHACHSANEntities db = new QUANLYKHACHSANEntities())
{
string id = textBoxMaNV.Text;
NHANVIEN nv = db.NHANVIENs.Find(id);
nv.HoTenNV = textBoxHoTen.Text;
nv.GioiTinh = comboBoxGT.Text;
nv.SDT = textBoxSDT.Text;
nv.DiaChi = textBoxDiaChi.Text;
nv.CMND = textBoxCMND.Text;
nv.NgaySinh = System.DateTime.Parse(dateTimeNS.Text);
nv.MaQuyen = Int32.Parse(textBoxTenQuyen.Text);
nv.IDBoPhan = Int32.Parse(textBoxTenBoPhan.Text);
db.SaveChanges();
MessageBox.Show("Sửa thành công ");
LoadNV(dataGridView1);
}
}
void LoadTBSD(DataGridView dtgv)
{
using (QUANLYKHACHSANEntities db = new QUANLYKHACHSANEntities())
{
var query = from p in db.THIETBIs
join tbsd in db.THIETBI_SD on p.MaTB equals tbsd.MaTB
join ph in db.PHONGs on tbsd.MaPhong equals ph.MaPhong
select new
{
Mã_TB = p.MaTB,
Tên_TB = p.TenTB,
Ghi_Chú = p.GhiChu,
Mã_Phòng = tbsd.MaPhong,
Tên_Phòng = ph.SoPhong,
Số_Lượng = tbsd.SoLuong,
};
var result = query.ToList();
dtgv.DataSource = result;
}
BindingTBSD(dataGridViewTB);
}
private DataProvider()
{
DB = new QUANLYKHACHSANEntities();
}