//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);
