public void ThemLSP(string MLSP, string TLSP)
{
QLKhachSanEntities chung = new QLKhachSanEntities();
LOAIDICHVU nv = new LOAIDICHVU();
nv.MALOAIDV = MLSP;
nv.TENLOAIDV = TLSP;
chung.LOAIDICHVU.Add(nv);
chung.SaveChanges();
}
public void ThemCTPhieu(string MAHD, string MADV, int SL)
{
QLKhachSanEntities env = new QLKhachSanEntities();
CHITIETHOADON nv = new CHITIETHOADON();
nv.MAHD = MAHD;
nv.MADV = MADV;
nv.SOLUONG = SL;
env.CHITIETHOADON.Add(nv);
env.SaveChanges();
}
//========================================== CT__QUYEN ===================================================
public void ThemQTK(string TDN, string MQ, string CT)
{
QLKhachSanEntities chung = new QLKhachSanEntities();
CTQUYEN td = new CTQUYEN();
td.TENDN = TDN;
td.MAQUYEN = MQ;
td.CHUTHICH = CT;
chung.CTQUYEN.Add(td);
chung.SaveChanges();
}
public void ThemChamCong(string MaNV, string NgayLam, string Ca)
{
QLKhachSanEntities chung = new QLKhachSanEntities();
CHAMCONG cc = new CHAMCONG();
cc.MANV = MaNV;
cc.NGAYLAM = DateTime.Parse(NgayLam);
cc.CA = Ca;
chung.CHAMCONG.Add(cc);
chung.SaveChanges();
}
public void ThemTK(string MNV, string TDN, string MK, string TT)
{
QLKhachSanEntities chung = new QLKhachSanEntities();
TAIKHOAN td = new TAIKHOAN();
td.MANV = MNV;
td.TENDN = TDN;
td.MATKHAU = MK;
td.TRANGTHAI = TT;
chung.TAIKHOAN.Add(td);
chung.SaveChanges();
}
public void ThemKH(string MKH, string HT, string GT, string DC, string SDT)
{
QLKhachSanEntities chung = new QLKhachSanEntities();
KHACHHANG nv = new KHACHHANG();
nv.MAKH = MKH;
nv.TENKH = HT;
nv.GIOITINH = GT;
nv.DIACHI = DC;
nv.SDT = SDT;
chung.KHACHHANG.Add(nv);
chung.SaveChanges();
}
public void ThemPhieu(string MaHD, string NgayTao, string MaNV, string MaP)
{
QLKhachSanEntities nh = new QLKhachSanEntities();
HOADON p = new HOADON();
p.MAHD = MaHD;
p.NGAYTAO = DateTime.Parse(NgayTao);
p.MANV = MaNV;
p.MAPHONG = MaP;
p.THANHTIEN = 0;
nh.HOADON.Add(p);
nh.SaveChanges();
}
public void ThemPD(string MPD, string MKH, string MNV, string MP, string NgayLap, string NgayBD)
{
QLKhachSanEntities chung = new QLKhachSanEntities();
PHIEUDATPHONG td = new PHIEUDATPHONG();
td.MAPHIEUDAT = MPD;
td.MAKH = MKH;
td.MANV = MNV;
td.MAPHONG = MP;
td.NGAYLAP = DateTime.Parse(NgayLap);
td.NGAYBD = DateTime.Parse(NgayBD);
chung.PHIEUDATPHONG.Add(td);
chung.SaveChanges();
}
public void ThemSP(string MSP, string TSP, string DVT, string DGN, string MLSP, string HA)
{
QLKhachSanEntities chung = new QLKhachSanEntities();
DICHVU td = new DICHVU();
td.MADV = MSP;
td.TENDV = TSP;
td.DVT = DVT;
td.DONGIA = int.Parse(DGN);
td.MALOAIDV = MLSP;
td.HINHANH = HA;
chung.DICHVU.Add(td);
chung.SaveChanges();
}
public void ThemNV(string MNV, string HT, string GT, string NS, string DC, string SDT, string LCB)
{
QLKhachSanEntities chung = new QLKhachSanEntities();
NHANVIEN nv = new NHANVIEN();
nv.MANV = MNV;
nv.HOTEN = HT;
nv.GIOITINH = GT;
nv.NGAYSINH = DateTime.Parse(NS);
nv.DIACHI = DC;
nv.SDT = SDT;
nv.LUONGCB = int.Parse(LCB);
chung.NHANVIEN.Add(nv);
chung.SaveChanges();
}
public void ThemP(string MP, string TP, string DT, string DG, string MT, string TT, string HA)
{
QLKhachSanEntities chung = new QLKhachSanEntities();
PHONG td = new PHONG();
td.MAPHONG = MP;
td.TENPHONG = TP;
td.DIENTICH = DT;
td.DONGIA = int.Parse(DG);
td.MAKV = MT;
td.TRANGTHAI = TT;
td.HINHANH = HA;
chung.PHONG.Add(td);
chung.SaveChanges();
}