public void ApproveGradeChange(int gradeChangeId, ref List<string> errors)
{
grade_change db_gradeChange = new grade_change();
try
{
db_gradeChange.gradeChange_id = gradeChangeId;
db_gradeChange = this.context.grade_change.Find(db_gradeChange);
db_gradeChange.approved = true;
this.context.SaveChanges();
}
catch (Exception e)
{
errors.Add("Error occured in GradeChangeRepository.ApproveGradeChange: " + e);
}
}
public void AddGradeChange(GradeChange gradeChange, ref List<string> errors)
{
grade_change db_gradeChange = new grade_change();
try
{
db_gradeChange.student_id = gradeChange.Student_id;
db_gradeChange.schedule_id = gradeChange.Schedule_id;
db_gradeChange.course_id = gradeChange.Course_id;
db_gradeChange.approved = gradeChange.Approved;
db_gradeChange.desired = gradeChange.Desired;
db_gradeChange.description = gradeChange.Description;
this.context.grade_change.Add(db_gradeChange);
this.context.SaveChanges();
}
catch (Exception e)
{
errors.Add("Error occured in GradeChangeRepository.RequestGradeChange: " + e);
}
}
public int GetGradeChangeScheduleId(string student_id, int course_id, ref List<string> errors)
{
grade_change db_gradeChange = new grade_change();
IEnumerable<int> scheduleIDs = this.context.enrollments.Where(x => x.student_id == student_id).Select(y => y.schedule_id);
bool temp;
foreach (int s in scheduleIDs)
{
temp = this.context.course_schedule.Where(x => x.schedule_id == s && x.course_id == course_id).Count() > 0;
if (temp)
{
return s;
}
}
return -1;
}
