public void UpdateGradeDistribution(GradeDistribution gradeDistribution, ref List <string> errors) { if (gradeDistribution == null) { errors.Add("Grade Distribution cannot be null"); throw new ArgumentException(); } if (gradeDistribution.Schedule_id < 0) { errors.Add("Invalid Schedule ID"); } if (string.IsNullOrEmpty(gradeDistribution.Grade_Distribution)) { errors.Add("Invalid Grade Distribution"); throw new ArgumentException(); } if (string.IsNullOrEmpty(gradeDistribution.Title)) { errors.Add("Invalid Grade Distribution"); throw new ArgumentException(); } this.repository.UpdateGradeDistribution(gradeDistribution, ref errors); }
public void InsertGradeDistribution(GradeDistribution gradeDistribution, ref List <string> errors) { var conn = new SqlConnection(ConnectionString); try { var adapter = new SqlDataAdapter(InsertGradeDistributionInfo, conn) { SelectCommand = { CommandType = CommandType.StoredProcedure } }; adapter.SelectCommand.Parameters.Add(new SqlParameter("@schedule_id", SqlDbType.Int)); adapter.SelectCommand.Parameters.Add(new SqlParameter("@grade_distribution", SqlDbType.VarChar, 50)); adapter.SelectCommand.Parameters.Add(new SqlParameter("@title", SqlDbType.VarChar, 50)); adapter.SelectCommand.Parameters["@schedule_id"].Value = gradeDistribution.Schedule_id; adapter.SelectCommand.Parameters["@grade_distribution"].Value = gradeDistribution.Grade_Distribution; adapter.SelectCommand.Parameters["@title"].Value = gradeDistribution.Title; var dataSet = new DataSet(); adapter.Fill(dataSet); } catch (Exception e) { errors.Add("Error: " + e); } finally { conn.Dispose(); } }
public ActionResult DeleteConfirmed(int id) { GradeDistribution gradeDistribution = db.GradeDistributions.Find(id); db.GradeDistributions.Remove(gradeDistribution); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "GradeDistributionID,Name,EffectiveDate")] GradeDistribution gradeDistribution) { if (ModelState.IsValid) { db.Entry(gradeDistribution).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(gradeDistribution)); }
public ActionResult Create([Bind(Include = "GradeDistributionID,Name,EffectiveDate")] GradeDistribution gradeDistribution) { if (ModelState.IsValid) { db.GradeDistributions.Add(gradeDistribution); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(gradeDistribution)); }
// GET: GradeDistributions/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } GradeDistribution gradeDistribution = db.GradeDistributions.Find(id); if (gradeDistribution == null) { return(HttpNotFound()); } return(View(gradeDistribution)); }
public string InsertGradeDistribution(GradeDistribution gradeDistribution) { var errors = new List <string>(); var repository = new GradeDistributionRepository(); var service = new GradeDistributionService(repository); service.InsertGradeDistribution(gradeDistribution, ref errors); if (errors.Count == 0) { return("ok"); } return("error"); }
protected void gridSample_RowDeleting(object sender, GridViewDeleteEventArgs e) { int gradeID = Convert.ToInt32(teacherCourseGradeGrid.DataKeys[e.RowIndex].Value); using (var context = new GradebookDataEntities()) { GradeDistribution obj = context.GradeDistributions.First(x => x.GradeID == gradeID); //context.Assignments.Where(x => x.GradeID == gradeID).Delete(); context.GradeDistributions.Remove(obj); context.SaveChanges(); //BindGrid(); loadTeacherCourseGradeGrid(); loadTeacherStudentGradesGrid(); } }
public List <GradeDistribution> GetGradeDistribution(ref List <string> errors) { var conn = new SqlConnection(ConnectionString); var gradeDistributionList = new List <GradeDistribution>(); try { var adapter = new SqlDataAdapter(GetGradeDistributionInfo, conn) { SelectCommand = { CommandType = CommandType.StoredProcedure } }; var dataSet = new DataSet(); adapter.Fill(dataSet); if (dataSet.Tables[0].Rows.Count == 0) { return(null); } for (var i = 0; i < dataSet.Tables[0].Rows.Count; i++) { var gradeDistributionContainer = new GradeDistribution { Schedule_id = Convert.ToInt32(dataSet.Tables[0].Rows[i]["schedule_id"].ToString()), Grade_Distribution = dataSet.Tables[0].Rows[i]["grade_distribution"].ToString(), Title = dataSet.Tables[0].Rows[i]["title"].ToString() }; gradeDistributionList.Add(gradeDistributionContainer); } } catch (Exception e) { errors.Add("Error: " + e); } finally { conn.Dispose(); } return(gradeDistributionList); }
public void InsertGradeDistributionTest2() { //// Arrange var errors = new List <string>(); var mockRepository = new Mock <IGradeDistributionRepository>(); var gradeDistributionService = new GradeDistributionService(mockRepository.Object); var gradeDistribution = new GradeDistribution { Schedule_id = -1, Grade_Distribution = string.Empty, Title = string.Empty }; //// Act gradeDistributionService.InsertGradeDistribution(gradeDistribution, ref errors); //// Assert Assert.AreEqual(1, errors.Count); }
public GradeDistribution GetCourseGradeDistribution(int scheduleId, ref List <string> errors) { var conn = new SqlConnection(ConnectionString); GradeDistribution gradeDistribution = null; try { var adapter = new SqlDataAdapter(GetCourseGradeDistributionInfo, conn) { SelectCommand = { CommandType = CommandType.StoredProcedure } }; adapter.SelectCommand.Parameters.Add(new SqlParameter("@schedule_id", SqlDbType.Int)); adapter.SelectCommand.Parameters["@schedule_id"].Value = scheduleId; var dataSet = new DataSet(); adapter.Fill(dataSet); if (dataSet.Tables[0].Rows.Count == 0) { return(null); } gradeDistribution = new GradeDistribution { Schedule_id = Convert.ToInt32(dataSet.Tables[0].Rows[0]["schedule_id"].ToString()), Grade_Distribution = dataSet.Tables[0].Rows[0]["grade_distribution"].ToString(), Title = dataSet.Tables[0].Rows[0]["title"].ToString() }; } catch (Exception e) { errors.Add("Error: " + e); } finally { conn.Dispose(); } return(gradeDistribution); }
protected void gridSample_RowUpdating(object sender, GridViewUpdateEventArgs e) { GridViewRow row = teacherCourseGradeGrid.Rows[e.RowIndex]; TextBox txtCategory = row.FindControl("txtCategory") as TextBox; TextBox txtWeight = row.FindControl("txtWeight") as TextBox; if (txtCategory != null && txtWeight != null) { using (var context = new GradebookDataEntities()) { int gradeID = Convert.ToInt32(teacherCourseGradeGrid.DataKeys[e.RowIndex].Value); GradeDistribution obj = context.GradeDistributions.First(x => x.GradeID == gradeID); obj.Category = txtCategory.Text; obj.Weight = Convert.ToDecimal(txtWeight.Text); context.SaveChanges(); teacherCourseGradeGrid.EditIndex = -1; //BindGrid(); loadTeacherCourseGradeGrid(); } } }