public void TraPhong(EC_Phong EC_Ph)
{
connect.ThucHienLenh("update tblPhong set TrangThai = N'" + EC_Ph.TrangThai + "' where MaPh = '" + EC_Ph.MaPh + "'");
}
public int SuaThongTin(EC_Phong EC_Ph)
{
return(connect.ThucHienLenh("update tblPhong set SoPhong = N'" + EC_Ph.SoPhong + "', TrangThai = N'" + EC_Ph.TrangThai + "' where MaPh = '" + EC_Ph.MaPh + "'"));
}
public int XoaTTPhong(EC_Phong EC_Ph)
{
return(connect.ThucHienLenh("delete from tblPhong where MaPh = '" + EC_Ph.MaPh + "'"));
}
public int ThemThongTin(EC_Phong EC_Ph)
{
return(connect.ThucHienLenh("insert into tblPhong(MaPh,SoPhong,TrangThai) values(N'" + EC_Ph.MaPh + "', N'" + EC_Ph.SoPhong + "', N'" + EC_Ph.TrangThai + "') "));
}