public int Update(HocDTO Hoc)
{
string sql = "update HOC set MaHS=@MaHS,MaLop=@MaLop,MaHK=@MaHK,DiemCuoiKy=@DiemCuoiKy,HKCuoiKy=@HKCuoiKy,MaCV=@ChucVu where MaHoc=@MaHoc";
SqlParameter[] sp = new SqlParameter[7];
sp[0] = new SqlParameter("@MaHoc", Hoc.MaHoc);
sp[1] = new SqlParameter("@MaHS", Hoc.MaHS);
sp[2] = new SqlParameter("@MaLop", Hoc.MaLop);
sp[3] = new SqlParameter("@MaHK", Hoc.MaHK);
sp[4] = new SqlParameter("@DiemCuoiKy", Hoc.DiemCuoiKy);
sp[5] = new SqlParameter("@HKCuoiKy", Hoc.HKCuoiKy);
sp[6] = new SqlParameter("@ChucVu", Hoc.MaCV);
return conectData.Insert_Update_Delete(sql, sp);
}
public int Insert(HocDTO Hoc)
{
string sql = "insert into HOC values (@MaHS,@MaLop,@MaHK,@DiemCuoiKy,@HKCuoiKy,@ChucVu)";
SqlParameter[] sp = new SqlParameter[6];
sp[0] = new SqlParameter("@MaHS", Hoc.MaHS);
sp[1] = new SqlParameter("@MaLop", Hoc.MaLop);
sp[2] = new SqlParameter("@MaHK", Hoc.MaHK);
sp[3] = new SqlParameter("@DiemCuoiKy", Hoc.DiemCuoiKy);
sp[4] = new SqlParameter("@HKCuoiKy", Hoc.HKCuoiKy);
sp[5] = new SqlParameter("@ChucVu", Hoc.MaCV);
return conectData.Insert_Update_Delete(sql, sp);
}
