public static LOAIPHONG truyVanLoaiPhong(string maPhong) { LOAIPHONG res = new LOAIPHONG(); res = DataProvider.ISCreated.DB.Database.SqlQuery <LOAIPHONG>("SELECT LP.* FROM PHONG P JOIN LOAIPHONG LP ON P.LoaiPhongID=LP.LoaiPhongID WHERE P.PhongID = @id and P.TinhTrangTonTai=0", new SqlParameter("@id", maPhong)).FirstOrDefault(); return(res); }
public static LOAIPHONG themMoiLoaiPhong(LOAIPHONG nv) { nv.NgayTao = DateTime.Now; LOAIPHONG res = new LOAIPHONG(); res = DataProvider.ISCreated.DB.LOAIPHONGs.Add(nv); DataProvider.ISCreated.DB.SaveChanges(); return(res); }
// CAPNHAT public static void capNhatLoaiPhong(LOAIPHONG nv) { LOAIPHONG old = DataProvider.ISCreated.DB.LOAIPHONGs.Where(x => x.LoaiPhongID == nv.LoaiPhongID).SingleOrDefault(); old.TenLoai = nv.TenLoai; old.TinhTrang = nv.TinhTrang; old.LoaiPhongID = nv.LoaiPhongID; capNhatCSDL(); }
public static void updateInsertLoaiPhong(LOAIPHONG lp) { List <PHONG> listPhong = DataProvider.ISCreated.DB.PHONGs.Where(x => (x.LoaiPhongID == lp.LoaiPhongID && x.TinhTrangTonTai == false)).ToList(); foreach (PHONG item in listPhong) { item.TinhTrangTonTai = true; } capNhatCSDL(); }
public static void xoaLoaiPhong(LOAIPHONG nv) { LOAIPHONG old = DataProvider.ISCreated.DB.LOAIPHONGs.Where(x => x.LoaiPhongID == nv.LoaiPhongID).SingleOrDefault(); old.TinhTrang = true; capNhatCSDL(); List <PHONG> listPhong = DataProvider.ISCreated.DB.PHONGs.Where(x => (x.LoaiPhongID == old.LoaiPhongID && x.TinhTrangTonTai == false && x.TinhTrangThue == false)).ToList(); foreach (PHONG item in listPhong) { item.TinhTrangTonTai = true; } capNhatCSDL(); }