public int Insert(CT_BDM_HKDTO Ct_bdm_hk)
{
string sql = "insert into CT_BDM_HK values (@MaBDM_HK,@Diem15Phut,@DiemMieng,@Diem1Tiet,@DiemHK)";
SqlParameter[] sp = new SqlParameter[5];
sp[0] = new SqlParameter("@MaBDM_HK", Ct_bdm_hk.MaBD_HK);
sp[1] = new SqlParameter("@Diem15Phut", Ct_bdm_hk.Diem15Phut);
sp[2] = new SqlParameter("@DiemMieng", Ct_bdm_hk.DiemMieng);
sp[3] = new SqlParameter("@Diem1Tiet", Ct_bdm_hk.Diem1Tiet);
sp[4] = new SqlParameter("@DiemHK", Ct_bdm_hk.DiemHK);
return conectData.Insert_Update_Delete(sql, sp);
}
// update diem 15phut, mieng, 1 tiet dua vao ma BDM_HK, co ham lay MaBDM_HK trong gile BDM_HKdao
public int Update(CT_BDM_HKDTO Ct_bdm_hk)
{
string sql = "update CT_BDM_HK set Diem15Phut=@Diem15Phut,DiemMieng=@DiemMieng,Diem1Tiet=@Diem1Tiet, DiemHK=@DiemHK where MaBDM_HK=@MaBDM_HK";
SqlParameter[] sp = new SqlParameter[5];
sp[0] = new SqlParameter("@MaBDM_HK", Ct_bdm_hk.MaBD_HK);
sp[1] = new SqlParameter("@Diem15Phut", Ct_bdm_hk.Diem15Phut);
sp[2] = new SqlParameter("@DiemMieng", Ct_bdm_hk.DiemMieng);
sp[3] = new SqlParameter("@Diem1Tiet", Ct_bdm_hk.Diem1Tiet);
sp[4] = new SqlParameter("@DiemHK", Ct_bdm_hk.DiemHK);
return conectData.Insert_Update_Delete(sql, sp);
}
