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); }