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