Exemplo n.º 1
0
        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);
            }
        }
Exemplo n.º 2
0
        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);
            }
        }
Exemplo n.º 3
0
        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;
        }