//Thêm public bool them_DichVu(DICHVU dv) { try { data.DICHVUs.InsertOnSubmit(dv); data.SubmitChanges(); return(true); } catch { return(false); } }
public void ThemSP(string MSP, string TSP, string DVT, string DGN, string MLSP, string HA) { QLKhachSanEntities chung = new QLKhachSanEntities(); DICHVU td = new DICHVU(); td.MADV = MSP; td.TENDV = TSP; td.DVT = DVT; td.DONGIA = int.Parse(DGN); td.MALOAIDV = MLSP; td.HINHANH = HA; chung.DICHVU.Add(td); chung.SaveChanges(); }
//Xóa public bool xoa_DichVu(string pMaDV) { try { DICHVU dv = data.DICHVUs.Where(t => t.MADV == pMaDV).FirstOrDefault(); data.DICHVUs.DeleteOnSubmit(dv); data.SubmitChanges(); return(true); } catch { return(false); } }
public bool themDichVu(DICHVU dichVu) { try { ketNoi.DICHVUs.InsertOnSubmit(dichVu); ketNoi.SubmitChanges(); return(true); } catch (Exception) { return(false); throw; } }
//Sửa public bool sua_DichVu(DICHVU pDichVu) { try { DICHVU nv = data.DICHVUs.Where(t => t.MADV == pDichVu.MADV).FirstOrDefault(); if (nv != null) { nv.TENDV = pDichVu.TENDV; nv.GIADV = pDichVu.GIADV; nv.DONVI = pDichVu.DONVI; data.SubmitChanges(); } return(true); } catch { return(false); } }
public bool capNhatDichVu(DICHVU dichVu) { try { var ketQua = from dichVuTam in ketNoi.DICHVUs where dichVuTam.TENDICHVU == dichVu.TENDICHVU select dichVuTam; foreach (var tam in ketQua) { tam.DONGIA = dichVu.DONGIA; tam.DONVITINH = dichVu.DONVITINH; } ketNoi.SubmitChanges(); return(true); } catch (Exception) { return(false); } }
partial void DeleteDICHVU(DICHVU instance);
partial void UpdateDICHVU(DICHVU instance);
partial void InsertDICHVU(DICHVU instance);