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