public static void xoaPhong(PHONG nv) { PHONG old = DataProvider.ISCreated.DB.PHONGs.Where(x => x.PhongID == nv.PhongID).SingleOrDefault(); old.TinhTrangTonTai = true; capNhatCSDL(); }
public static PHONG truyVanPhong(string phongID) { PHONG res = new PHONG(); res = DataProvider.ISCreated.DB.Database.SqlQuery <PHONG>("SELECT * FROM PHONG WHERE PhongID=@id and TinhTrangTonTai=0", new SqlParameter("@id", phongID)).FirstOrDefault(); return(res); }
// THEMMOI public static PHONG themMoiPhong(PHONG nv) { nv.NgayTao = DateTime.Now; PHONG res = new PHONG(); res = DataProvider.ISCreated.DB.PHONGs.Add(nv); DataProvider.ISCreated.DB.SaveChanges(); return(res); }
public static void capNhatPhong(PHONG nv) { PHONG old = DataProvider.ISCreated.DB.PHONGs.Where(x => x.PhongID == nv.PhongID).SingleOrDefault(); old.TenPhong = nv.TenPhong; old.DonGia = nv.DonGia; old.LoaiPhongID = nv.LoaiPhongID; old.TinhTrangTonTai = false; old.TinhTrangThue = true; // false --> chua thue try { old.TinhTrangTonTai = nv.TinhTrangTonTai; old.TinhTrangThue = nv.TinhTrangThue; } catch (Exception) { } capNhatCSDL(); }
public static PHONG truyVanTenPhongMaHoaDon(int MaHoaDon) { PHONG res = DataProvider.ISCreated.DB.Database.SqlQuery <PHONG>("SELECT P.* FROM PHONG P JOIN HOADONTHUEPHONG LP ON P.PhongID=LP.Phong WHERE LP.MaHoaDon=@id and P.TinhTrangTonTai=0", new SqlParameter("@id", MaHoaDon)).FirstOrDefault(); return(res); }