public bool ThemDichVu(DichVu dichVu) { SimpleQuanLyKhachSanEntities QLKSEntities = new SimpleQuanLyKhachSanEntities(); QLKSEntities.DichVus.Add(dichVu); QLKSEntities.SaveChanges(); return(true); }
public bool ThemNhanVien(NhanVien nhanVien) { SimpleQuanLyKhachSanEntities QLKSEntities = new SimpleQuanLyKhachSanEntities(); QLKSEntities.NhanViens.Add(nhanVien); QLKSEntities.SaveChanges(); return(true); }
public bool ThemChucDanh(ChucDanh chucDanh) { SimpleQuanLyKhachSanEntities QLKSEntities = new SimpleQuanLyKhachSanEntities(); QLKSEntities.ChucDanhs.Add(chucDanh); QLKSEntities.SaveChanges(); return(true); }
public bool ThemKhachHang(KhachHang khachHang) { SimpleQuanLyKhachSanEntities QLKSEntities = new SimpleQuanLyKhachSanEntities(); QLKSEntities.KhachHangs.Add(khachHang); QLKSEntities.SaveChanges(); return(true); }
public bool XoaDichVu(DichVu dichVu) { SimpleQuanLyKhachSanEntities QLKSEntities = new SimpleQuanLyKhachSanEntities(); QLKSEntities.DichVus.Attach(dichVu); QLKSEntities.DichVus.Remove(dichVu); QLKSEntities.SaveChanges(); return(true); }
public bool XoaChucDanh(ChucDanh chucDanh) { SimpleQuanLyKhachSanEntities QLKSEntities = new SimpleQuanLyKhachSanEntities(); QLKSEntities.ChucDanhs.Attach(chucDanh); QLKSEntities.ChucDanhs.Remove(chucDanh); QLKSEntities.SaveChanges(); return(true); }
public int IdChucDanh(string chucDanh) { SimpleQuanLyKhachSanEntities QLKSEntities = new SimpleQuanLyKhachSanEntities(); var query = (from p in QLKSEntities.ChucDanhs where p.Ten == chucDanh select p).SingleOrDefault(); return(query.ID); }
public bool XoaNhanVien(NhanVien nhanVien) { SimpleQuanLyKhachSanEntities QLKSEntities = new SimpleQuanLyKhachSanEntities(); QLKSEntities.NhanViens.Attach(nhanVien); QLKSEntities.NhanViens.Remove(nhanVien); QLKSEntities.SaveChanges(); return(true); }
public bool XoaKhachHang(KhachHang khachHang) { SimpleQuanLyKhachSanEntities QLKSEntities = new SimpleQuanLyKhachSanEntities(); QLKSEntities.KhachHangs.Attach(khachHang); QLKSEntities.KhachHangs.Remove(khachHang); QLKSEntities.SaveChanges(); return(true); }
public bool SuaChucDanh(ChucDanh chucDanh) { SimpleQuanLyKhachSanEntities QLKSEntities = new SimpleQuanLyKhachSanEntities(); var Query = (from p in QLKSEntities.ChucDanhs where p.ID == chucDanh.ID select p).SingleOrDefault(); if (Query != null) { Query.Ten = chucDanh.Ten; QLKSEntities.SaveChanges(); } return(true); }
public bool SuaDichVu(DichVu dichVu) { SimpleQuanLyKhachSanEntities QLKSEntities = new SimpleQuanLyKhachSanEntities(); var Query = (from p in QLKSEntities.DichVus where p.ID == dichVu.ID select p).SingleOrDefault(); if (Query != null) { Query.Ten = dichVu.Ten; Query.Gia = dichVu.Gia; QLKSEntities.SaveChanges(); } return(true); }
public DataTable DSChucDanh() { SimpleQuanLyKhachSanEntities QLKSEntities = new SimpleQuanLyKhachSanEntities(); var dstp = from p in QLKSEntities.ChucDanhs select p; DataTable dtb = new DataTable(); dtb.Columns.Add("ID"); dtb.Columns.Add("Ten"); foreach (var p in dstp) { dtb.Rows.Add(p.ID, p.Ten); } return(dtb); }
public bool SuaKhachHang(KhachHang khachHang) { SimpleQuanLyKhachSanEntities QLKSEntities = new SimpleQuanLyKhachSanEntities(); var Query = (from p in QLKSEntities.KhachHangs where p.ID == khachHang.ID select p).SingleOrDefault(); if (Query != null) { Query.Ten = khachHang.Ten; Query.NgaySinh = khachHang.NgaySinh; Query.GioiTinh = khachHang.GioiTinh; Query.QuocTich = khachHang.QuocTich; Query.SDT = khachHang.SDT; Query.CMND = khachHang.CMND; Query.Email = khachHang.Email; QLKSEntities.SaveChanges(); } return(true); }
public bool SuaNhanVien(NhanVien nhanVien) { SimpleQuanLyKhachSanEntities QLKSEntities = new SimpleQuanLyKhachSanEntities(); var Query = (from p in QLKSEntities.NhanViens where p.ID == nhanVien.ID select p).SingleOrDefault(); if (Query != null) { Query.Ten = nhanVien.Ten; Query.IDChucDanh = nhanVien.IDChucDanh; Query.NgaySinh = nhanVien.NgaySinh; Query.GioiTinh = nhanVien.GioiTinh; Query.DiaChi = nhanVien.DiaChi; Query.SDT = nhanVien.SDT; Query.CMND = nhanVien.CMND; Query.Email = nhanVien.Email; QLKSEntities.SaveChanges(); } return(true); }
public DataTable DSKhachHang() { SimpleQuanLyKhachSanEntities QLKSEntities = new SimpleQuanLyKhachSanEntities(); var dstp = from p in QLKSEntities.KhachHangs select p; DataTable dtb = new DataTable(); dtb.Columns.Add("ID"); dtb.Columns.Add("Ten"); dtb.Columns.Add("NgaySinh"); dtb.Columns.Add("GioiTinh"); dtb.Columns.Add("QuocTich"); dtb.Columns.Add("SDT"); dtb.Columns.Add("CMND"); dtb.Columns.Add("Email"); foreach (var p in dstp) { dtb.Rows.Add(p.ID, p.Ten, p.NgaySinh, p.GioiTinh, p.QuocTich, p.SDT, p.CMND, p.Email); } return(dtb); }
public DataTable DSNhanVien() { SimpleQuanLyKhachSanEntities QLKSEntities = new SimpleQuanLyKhachSanEntities(); var dstp = from p in QLKSEntities.NhanViens select p; DataTable dtb = new DataTable(); dtb.Columns.Add("ID"); dtb.Columns.Add("Ten"); dtb.Columns.Add("ChucDanh"); dtb.Columns.Add("NgaySinh"); dtb.Columns.Add("GioiTinh"); dtb.Columns.Add("DiaChi"); dtb.Columns.Add("SDT"); dtb.Columns.Add("CMND"); dtb.Columns.Add("Email"); foreach (var p in dstp) { dtb.Rows.Add(p.ID, p.Ten, p.ChucDanh.Ten, p.NgaySinh, p.GioiTinh, p.DiaChi, p.SDT, p.CMND, p.Email); } return(dtb); }