public void GradeListView_InsertItem(Grade grade) { if (ModelState.IsValid) { try { Service.UpdateGrade(grade); //Session["Success"] = true; Response.RedirectToRoute("Settings"); } catch (Exception) { ModelState.AddModelError(String.Empty, "Ett oväntat fel inträffade då Betyguppgiften skulle läggas till."); } } }
/// <summary> /// Updates grades /// </summary> /// <param name="grade"></param> public void UpdateGrade(Grade grade) { using (SqlConnection conn = CreateConnection()) { try { SqlCommand cmd = new SqlCommand("appSchema.uspUpdateGrade", conn); cmd.CommandType = CommandType.StoredProcedure; conn.Open(); cmd.Parameters.Add("@GradeID", SqlDbType.Int, 4).Value = grade.GradeID; cmd.Parameters.Add("@GradeValue", SqlDbType.Int, 4).Value = grade.GradeValue; cmd.ExecuteNonQuery(); } catch { throw new ApplicationException("An error occured in the data access layer."); } } }
public void UpdateGrade(Grade grade) { ICollection<ValidationResult> validationResults; if (!grade.Validate(out validationResults)) { var ex = new ValidationException("Objektet klarade inte valideringen."); ex.Data.Add("ValidationResults", validationResults); throw ex; } if (grade.GradeID == 0) // New post if ID is 0! { GradeDAL.InsertGrade(grade); } else { GradeDAL.UpdateGrade(grade); } }