public void PostBill(Datphong datphong) { using (QLKhachsanEntities entity = new QLKhachsanEntities()) { entity.SP_THEMDAT(datphong.Ngaydat.ToString(), datphong.MaNV, datphong.CMT, datphong.Ghichu); } }
public IEnumerable <SP_CTDATDV_Result> GetCTHDDV(long idhd) { using (QLKhachsanEntities entity = new QLKhachsanEntities()) { return(entity.SP_CTDATDV(idhd).ToList()); } }
public IEnumerable <LOADROOMRANH_Result> GetRR(string loaip) { using (QLKhachsanEntities entity = new QLKhachsanEntities()) { return(entity.LOADROOMRANH(loaip).ToList()); } }
public void DeleteRoom2(int numberroom) { QLKhachsanEntities entity = new QLKhachsanEntities(); entity.Phongs.Remove(entity.Phongs.FirstOrDefault(e => e.Sophong == numberroom)); entity.SaveChanges(); }
public void LuuHD(Hoadon hoadon) { using (QLKhachsanEntities entity = new QLKhachsanEntities()) { entity.LuuHoaDon(hoadon.Tienphong, hoadon.Tiendichvu, hoadon.VAT, hoadon.Khuyenmai, hoadon.Ngaylap, hoadon.IDDAT); } }
public IEnumerable <SP_CTDATPHONG_Result> GetCTHDP(long iddat) { using (QLKhachsanEntities entity = new QLKhachsanEntities()) { return(entity.SP_CTDATPHONG(iddat).ToList()); } }
public IEnumerable <TIMKH_Result> GetTim(string cmt) { using (QLKhachsanEntities entity = new QLKhachsanEntities()) { return(entity.TIMKH(cmt).ToList()); } }
public void PostService(Dichvu Service) { using (QLKhachsanEntities entity = new QLKhachsanEntities()) { entity.THEMDV(Service.TenDV, Service.GiaDV, Service.DVT, Service.Hinh, Service.Mota); } }
public void PostEmployee(Nhanvien employee) { QLKhachsanEntities entity = new QLKhachsanEntities(); entity.Nhanviens.Add(employee); entity.SaveChanges(); }
public void PostRoom2(Phong room) { QLKhachsanEntities entity = new QLKhachsanEntities(); entity.Phongs.Add(room); entity.SaveChanges(); }
public IEnumerable <THONGKETHANG_Result> Get(string ngay) { using (QLKhachsanEntities entity = new QLKhachsanEntities()) { return(entity.THONGKETHANG(ngay).ToList()); } }
public IEnumerable <Phong> GetRooms() { QLKhachsanEntities entity = new QLKhachsanEntities(); entity.Configuration.ProxyCreationEnabled = false; return(entity.Phongs.ToList()); }
public IEnumerable <SP_LOGIN_Result> GetLogin(string ac, string pass) { using (QLKhachsanEntities entity = new QLKhachsanEntities()) { return(entity.SP_LOGIN(ac, pass).ToList()); } }
public IEnumerable <KTMANV_Result> KTNV(string manv) { using (QLKhachsanEntities entity = new QLKhachsanEntities()) { entity.Configuration.ProxyCreationEnabled = false; return(entity.KTMANV(manv).ToList()); } }
public IEnumerable <SEARCHUSER_Result> SearchUser(string name) { using (QLKhachsanEntities entity = new QLKhachsanEntities()) { entity.Configuration.ProxyCreationEnabled = false; return(entity.SEARCHUSER(name).ToList()); } }
public IEnumerable <Nhanvien> GetEmployees() { using (QLKhachsanEntities entity = new QLKhachsanEntities()) { entity.Configuration.ProxyCreationEnabled = false; return(entity.Nhanviens.ToList()); } }
public void DeleteCTHDDV(long iddv, long idhd) { using (QLKhachsanEntities entity = new QLKhachsanEntities()) { entity.Chitietdatdichvus.Remove(entity.Chitietdatdichvus.FirstOrDefault(e => e.IDDAT.Equals(idhd) && e.IDDV == iddv)); entity.SaveChanges(); } }
public void PostCTHDDV(Chitietdatdichvu cthddv) { using (QLKhachsanEntities entity = new QLKhachsanEntities()) { entity.Chitietdatdichvus.Add(cthddv); entity.SaveChanges(); } }
public IEnumerable <Loaiphong> GetTypeRoom() { using (QLKhachsanEntities entity = new QLKhachsanEntities()) { entity.Configuration.ProxyCreationEnabled = false; return(entity.Loaiphongs.ToList()); } }
public void DeleteTypeRoom(string loai) { using (QLKhachsanEntities entity = new QLKhachsanEntities()) { entity.Loaiphongs.Remove(entity.Loaiphongs.FirstOrDefault(e => e.Loaiphong1.Equals(loai))); entity.SaveChanges(); } }
public void PostTypeRoom(Loaiphong loai) { using (QLKhachsanEntities entity = new QLKhachsanEntities()) { entity.Loaiphongs.Add(loai); entity.SaveChanges(); } }
public void DeleteEmployees(string manv) { using (QLKhachsanEntities entity = new QLKhachsanEntities()) { entity.Nhanviens.Remove(entity.Nhanviens.FirstOrDefault(e => e.MaNV == manv)); entity.SaveChanges(); } }
public void Taotk(TaiKhoan dangnhap) { using (QLKhachsanEntities entity = new QLKhachsanEntities()) { entity.TaiKhoans.Add(dangnhap); entity.SaveChanges(); } }
public void DeleteService(long iddv) { using (QLKhachsanEntities entity = new QLKhachsanEntities()) { entity.Dichvus.Remove(entity.Dichvus.FirstOrDefault(e => e.IDDV == iddv)); entity.SaveChanges(); } }
public IEnumerable <Hoadon> Get() { using (QLKhachsanEntities entity = new QLKhachsanEntities()) { entity.Configuration.ProxyCreationEnabled = false; return(entity.Hoadons.ToList()); } }
public void PostCTHDP(Chitietdatphong ctdp) { using (QLKhachsanEntities entity = new QLKhachsanEntities()) { entity.Chitietdatphongs.Add(ctdp); entity.SaveChanges(); } }
public IEnumerable <Datphong> GetBill() { using (QLKhachsanEntities entity = new QLKhachsanEntities()) { entity.Configuration.ProxyCreationEnabled = false; return(entity.Datphongs.ToList()); } }
public void DeleteBill(long iddat) { using (QLKhachsanEntities entity = new QLKhachsanEntities()) { entity.Datphongs.Remove(entity.Datphongs.FirstOrDefault(e => e.IDDAT.Equals(iddat))); entity.SaveChanges(); } }
public void DeleteCTHDP(long sophong, long iddat) { using (QLKhachsanEntities entity = new QLKhachsanEntities()) { entity.Chitietdatphongs.Remove(entity.Chitietdatphongs.FirstOrDefault(e => e.IDDAT.Equals(iddat) && e.Sophong.Equals(sophong))); entity.SaveChanges(); } }
public IEnumerable <Chitietdatdichvu> Get() { using (QLKhachsanEntities entity = new QLKhachsanEntities()) { entity.Configuration.ProxyCreationEnabled = false; return(entity.Chitietdatdichvus.ToList()); } }