public bool ThemKhuVucPhong(string tenkv, string tang, string tenday, int soluongphong, string tinhtrang, string diachikhuvuc) { try { KhuVucPhong kvp = new KhuVucPhong(); kvp.TenKV = tenkv; kvp.Tang = tang; kvp.TenDayPhong = tenday; kvp.SoLuongPhong = soluongphong; kvp.TinhTrang = tinhtrang; kvp.DiaChiKhuVuc = diachikhuvuc; QUANLYNHATRO1DataContext context = new QUANLYNHATRO1DataContext(); context.KhuVucPhongs.InsertOnSubmit(kvp); context.SubmitChanges(); return(true); } catch { } return(false); }
public bool XoaKhuVucPhong(int makv) { try { QUANLYNHATRO1DataContext context = new QUANLYNHATRO1DataContext(); KhuVucPhong kvp = context.KhuVucPhongs.FirstOrDefault(x => x.MaKV == makv); if (kvp.PhongTros.Count > 0) { return(false); } else { context.KhuVucPhongs.DeleteOnSubmit(kvp); context.SubmitChanges(); return(true); } } catch { } return(true); }
public bool SuaKhuVucPhong(int makvp, string tenkv, string tang, string tenday, int soluongphong, string tinhtrang, string diachikhuvuc) { try { QUANLYNHATRO1DataContext context = new QUANLYNHATRO1DataContext(); KhuVucPhong kvp = context.KhuVucPhongs.FirstOrDefault(x => x.MaKV == makvp); if (kvp != null) { kvp.TenKV = tenkv; kvp.Tang = tang; kvp.TenDayPhong = tenday; kvp.SoLuongPhong = soluongphong; kvp.TinhTrang = tinhtrang; kvp.DiaChiKhuVuc = diachikhuvuc; context.SubmitChanges(); return(true); } return(false); } catch { } return(false); }