public static void UpdateL(tblKetQuaLHP gv)
{
SqlConnection Conn = dbConnectionData.ketnoi();
SqlCommand command = new SqlCommand("pr_KetQuaLHP_Update", Conn);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add("@MaLopHP", SqlDbType.NVarChar, 10);
command.Parameters.Add("@MaSV", SqlDbType.NVarChar, 100);
command.Parameters.Add("@DiemCC", SqlDbType.Float, 10);
command.Parameters.Add("@DiemTX", SqlDbType.Float, 10);
command.Parameters.Add("@DiemThi", SqlDbType.Float, 100);
command.Parameters["@MaLopHP"].Value = gv.MaLopHP1;
command.Parameters["@MaSV"].Value = gv.MaSV1;
command.Parameters["@DiemCC"].Value = gv.DiemCC1;
command.Parameters["@DiemTX"].Value = gv.DiemTX1;
command.Parameters["@DiemThi"].Value = gv.DiemThi1;
Conn.Open();
command.ExecuteNonQuery();
Conn.Close();
}
public static void UpdateLop(tblKetQuaLHP gv)
{
dalChamDiem.UpdateL(gv);
}
public static void InsertDiem(tblKetQuaLHP gv)
{
dalChamDiem.InsertL(gv);
}
