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());
}
}