public static bool ThemPhong(Phong phong)
{
string query = "EXEC uspTaoPhong @maloaiphong";
string ma = TaoMa.TaoMaPhong();
List <SqlParameter> parameters = new List <SqlParameter>()
{
new SqlParameter("@maloaiphong", SqlDbType.NVarChar)
{
Value = phong.TenLoai
}
};
return(Dataprovider.ExcuteNonQuery(query, parameters.ToArray()) > 0);
}
public static bool CapNhatPhong(Phong phong)
{
string query = "EXEC uspCapNhatPhong @maphong,@maloaiphong";
List <SqlParameter> parameters = new List <SqlParameter>()
{
new SqlParameter("@maphong", SqlDbType.NVarChar)
{
Value = phong.Ten
},
new SqlParameter("@maloaiphong", SqlDbType.NVarChar)
{
Value = phong.TenLoai
}
};
return(Dataprovider.ExcuteNonQuery(query, parameters.ToArray()) > 0);
}
public bool SuaPhong(Phong P)
{
string query = "UPDATE Phong SET SUCCHUA = " + P.SucChua + ",SOSVHT = " + P.SoSVHT + ", MADAY = '" + P.MaDay + "',TRANGTHAI = N'" + P.TrangThai + "' WHERE SOPHONG = " + P.SoPhong;
return(Connec.ThucThi(query));
}
public bool ThemPhong(Phong P)
{
string query = "INSERT INTO Phong VALUES(" + P.SoPhong + "," + P.SucChua + "," + P.SoSVHT + ",'" + P.MaDay + "',N'" + P.TrangThai + "')";
return(Connec.ThucThi(query));
}
