//sửa dữ liệu
public int SuaDuLieu(EC_DichVu et)
{
return(sql.SuaDuLieu(et));
}
//xóa dữ liệu
public void XoaDuLieu(EC_DichVu et)
{
sql.XoaDuLieu(et);
}
//xóa dữ liệu
public void XoaDuLieu(EC_DichVu et)
{
cn.ThucThiCauLenhSQL(@"DELETE from DichVu where MaDV=N'" + et.MaDV + "'");
}
public int ThemDuLieu(EC_DichVu et)
{
return(sql.ThemDuLieu(et));
}
//sửa dữ liệu
public int SuaDuLieu(EC_DichVu et)
{
return(cn.ThucThiCauLenhSQL(@"UPDATE DichVu SET TenDV =N'" + et.TenDV + "', Gia =N'" + et.Gia + "', MaNQL =N'" + et.MaNQL + "' where MaDV=N'" + et.MaDV + "'"));
}
//Hàm thêm dữ liệu
public int ThemDuLieu(EC_DichVu et)
{
return(cn.ThucThiCauLenhSQL(@"INSERT INTO DichVu(TenDV, Gia, MaNQL)
VALUES (N'" + et.TenDV + "',N'" + et.Gia + "',N'" + et.MaNQL + "')"));
}
public int XoaTTDichVu(EC_DichVu EC_DV)
{
return(connect.ThucHienLenh("delete from tblDichVu where MaDV = '" + EC_DV.MaDV + "'"));
}
public void SuaThongTin(EC_DichVu EC_DV)
{
connect.ThucHienLenh("update tblDichVu set TenDV = N'" + EC_DV.TenDV + "', Gia = N'" + EC_DV.Gia + "' where MaDV = '" + EC_DV.MaDV + "'");
}
public void ThemThongTin(EC_DichVu EC_DV)
{
connect.ThucHienLenh("insert into tblDichVu(MaDV,TenDV,Gia) values(N'" + EC_DV.MaDV + "', N'" + EC_DV.TenDV + "', '" + EC_DV.Gia + "')");
}
