private void themDV()
{
tenphong = cbbPhong.SelectedItem.ToString();
var result = (from sdp in db.PHIEUTHUEPHONGs
join p in db.PHONGs on sdp.MaPhong equals p.MaPhong
where p.SoPhong == tenphong
select new
{
mkh = sdp.MaPhong
}
).FirstOrDefault();
tendv = cbbDichVu.SelectedItem.ToString();
var ABC = (from dv in db.DICHVUs
where dv.TenDV == tendv
select new
{
mdv = dv.MaDV
}
).FirstOrDefault();
if (string.IsNullOrWhiteSpace(cbbPhong.ValueMember))
{
var newSDDV = new DICHVU_SD()
{
MaDV = ABC.mdv,
MaPhong = result.mkh,
SoLuong = Convert.ToInt16(cbbSoLuong.SelectedItem),
};
db.DICHVU_SD.AddOrUpdate(newSDDV);
db.SaveChanges();
}
}
private void buttonThemTBP_Click(object sender, EventArgs e)
{
tenphong = comboBoxTB.SelectedItem.ToString();
var ABC = (from p in db.PHONGs
where p.SoPhong == tenphong
select new
{
mdv = p.MaPhong
}
).FirstOrDefault();
THIETBI_SD tb = new THIETBI_SD
{
MaTB = textBoxMa.Text,
MaPhong = ABC.mdv,
SoLuong = Int32.Parse(textBoxSL.Text),
};
db.THIETBI_SD.Add(tb);
db.SaveChanges();
MessageBox.Show("Thêm thiết bị thành công");
LoadTBSD(dataGridViewTB);
}
private void themHD()
{
tenphong = comboBoxPhong.SelectedItem.ToString();
var result = (from sdp in db.PHIEUTHUEPHONGs
join p in db.PHONGs on sdp.MaPhong equals p.MaPhong
where p.SoPhong == tenphong
select new
{
mp = sdp.MaPhong,
}
).FirstOrDefault();
tenKH = comboBoxKH.SelectedItem.ToString();
var ABC = (from kh in db.KHACHHANGs
join sdp in db.PHIEUTHUEPHONGs on kh.MaKH equals sdp.MaKH
where kh.TenKH == tenKH
select new
{
mkh = sdp.MaKH,
ptp = sdp.NgayNhan,
}
).FirstOrDefault();
tenNV = comboBoxNV.SelectedItem.ToString();
var result1 = (from nv in db.NHANVIENs
where nv.HoTenNV == tenNV
select new
{
mnv = nv.MaNV,
}
).FirstOrDefault();
if (string.IsNullOrWhiteSpace(comboBoxPhong.ValueMember))
{
var newHD = new HOADON()
{
MaHD = textBoxMaHD.Text,
MaKH = ABC.mkh,
MaNV = result1.mnv,
NgayLap = DateTime.Now,
// TongTien = Convert.ToDecimal(_DoiSoSangDonViTienTe(sum)),
};
db.HOADONs.AddOrUpdate(newHD);
var newCTHD = new CHITIETHD()
{
MaHD = textBoxMaHD.Text,
MaPhong = result.mp,
GiamGia = Int32.Parse(textBoxGG.Text),
NgayNhan = ABC.ptp,
NgayTra = DateTime.Now,
SoNgay = Int32.Parse(textBoxSoNgay.Text),
// ThanhTien= Convert.ToDecimal(_DoiSoSangDonViTienTe(sum)),
};
db.CHITIETHDs.AddOrUpdate(newCTHD);
db.SaveChanges();
}
}
private void buttonThem_Click(object sender, EventArgs e)
{
var newTK = new TAIKHOAN()
{
ID = textBoxID.Text,
MatKhau = textBoxMK.Text,
MaNV = textBoxMaNV.Text,
};
db.TAIKHOANs.Add(newTK);
db.SaveChanges();
HienThiDS();
MessageBox.Show("Thêm thành công");
}
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 btnThuePhong_Click_1(object sender, EventArgs e)
{
PHIEUTHUEPHONG sd = new PHIEUTHUEPHONG()
{
MaPhieu = textBoxMaPhieu.Text,
MaPhong = txtMaPhong.Text,
MaKH = txtMaKhachHang.Text,
NgayNhan = DateTime.Now
};
db.PHIEUTHUEPHONGs.Add(sd);
string MaPhong = txtMaPhong.Text;
var phong = (from p in db.PHONGs where p.MaPhong.Equals(MaPhong) select p).FirstOrDefault();
phong.TrangThai = "Đã ở";
db.PHONGs.AddOrUpdate(phong);
db.SaveChanges();
MessageBox.Show("Thêm thành công !");
loadDataToGridView(dgvThuePhong);
}
private void btnTraPhong_Click(object sender, EventArgs e)
{
if (listViewP.SelectedIndices.Count > 0)
{
string tenPhong = listViewP.SelectedItems[0].SubItems[1].Text;
string soDienThoai = listViewP.SelectedItems[0].SubItems[4].Text;
var khachHang = (from kh in db.KHACHHANGs where kh.SDT.Equals(soDienThoai) select kh).FirstOrDefault();
var phong = (from p in db.PHONGs where p.SoPhong.Equals(tenPhong) select p).FirstOrDefault();
//var hoaDon = (from hd in db.HOADONs
// where hd.MaKH.Equals(khachHang.MaKH) select hd).FirstOrDefault();
var cthd = (from ct in db.CHITIETHDs
where ct.MaPhong.Equals(phong.MaPhong)
// && ct.MaHD.Equals(hoaDon.MaHD)
select ct).FirstOrDefault();
phong.TrangThai = "Trống";
db.PHONGs.AddOrUpdate(phong);
cthd.NgayTra = DateTime.Now;
db.CHITIETHDs.AddOrUpdate(cthd);
db.SaveChanges();
HienThiDanhSach();
}
else
{
MessageBox.Show("Bạn chưa chọn phòng để trả !");
}
}
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);
}
}
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 btnThuePhong_Click_1(object sender, EventArgs e)
{
tenKH = comboBoxKH.SelectedItem.ToString();
var result = (from kh in db.KHACHHANGs
where kh.TenKH == tenKH
select new
{
mkh = kh.MaKH,
}
).FirstOrDefault();
PHIEUTHUEPHONG sd = new PHIEUTHUEPHONG()
{
MaPhieu = textBoxMaPhieu.Text,
MaPhong = txtMaPhong.Text,
MaKH = result.mkh,
NgayNhan = DateTime.Now
};
db.PHIEUTHUEPHONGs.Add(sd);
if (db.PHIEUTHUEPHONGs.Select(p => p.MaPhieu).Contains(textBoxMaPhieu.Text))
{
MessageBox.Show("Mã phiếu đã tồn tại");
return;
}
string MaPhong = txtMaPhong.Text;
var phong = (from p in db.PHONGs where p.MaPhong.Equals(MaPhong) select p).FirstOrDefault();
phong.TrangThai = "Đã ở";
db.PHONGs.AddOrUpdate(phong);
db.SaveChanges();
MessageBox.Show("Thêm thành công !");
loadDataToGridView(dgvThuePhong);
}
//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 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);
}
}
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(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())
{
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_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())
{
//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);
}
}
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);
}
}
//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);
}
}
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);
}
}
private void btnInHoaDon_Click_1(object sender, EventArgs e)
{
try
{
try
{
var isExist = db.KHACHHANGs.Where(x => x.SDT.Equals(txtSDT.Text.Trim())).FirstOrDefault();
var sdp = db.PHIEUTHUEPHONGs.Where(x => x.MaKH.Equals(isExist.MaKH)).FirstOrDefault();
if (sdp != null)
{
var phong = db.PHONGs.Where(x => x.MaPhong.Equals(sdp.MaPhong)).FirstOrDefault();
phong.TrangThai = "Trống";
}
//var sdv = db.PHIEUTHUEPHONGs.Where(x => x.MaKH.Equals(isExist.MaKH)).FirstOrDefault();
//if (sdv != null)
// sdv.TRANGTHAI = 1;
db.SaveChanges();
}
catch (Exception)
{
}
PrintDialog _PrintDialog = new PrintDialog();
PrintDocument _PrintDocument = new PrintDocument();
_PrintDialog.Document = _PrintDocument; //add the document to the dialog box
_PrintDocument.PrintPage += new System.Drawing.Printing.PrintPageEventHandler(_CreateReceipt); //add an event handler that will do the printing
//on a till you will not want to ask the user where to print but this is fine for the test envoironment.
DialogResult result = _PrintDialog.ShowDialog();
if (result == DialogResult.OK)
{
_PrintDocument.Print();
}
}
catch (Exception)
{
}
}
private void buttonThem_Click_1(object sender, EventArgs e)
{
dataGridViewQLND.Rows.Clear();
var newTK = new TAIKHOAN()
{
ID = textBoxID.Text,
MatKhau = textBoxMK.Text,
MaNV = textBoxMaNV.Text,
TenDangNhap = textBoxTenDN.Text,
};
if (db.TAIKHOANs.Select(p => p.ID).Contains(textBoxID.Text))
{
MessageBox.Show("Mã đã tồn tại");
return;
}
db.TAIKHOANs.Add(newTK);
db.SaveChanges();
HienThiDS();
MessageBox.Show("Thêm thành công");
}
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);
}
}
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);
}
}