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