public void CreateCourse(Course course) { var courseExists = (from c in _dataContext.Course.Where(c => c.Subject == course.Subject) select c).ToList(); //is new course if (courseExists.Count == 0) { AddCourse(course); AddCourseGrade(new CourseGrade { CourseId = course.Id, Grade = course.Grade }); return; } var existingCourseId = courseExists[0].Id; try { var courseGradeExists = (from cg in _dataContext.CourseGrade.Where(cg => cg.CourseId == existingCourseId && cg.Grade == course.Grade) select cg).ToList(); //is new grade for existing course if (courseGradeExists.Count == 0) { var courseGrade = new CourseGrade { CourseId = existingCourseId, Grade = course.Grade }; AddCourseGrade(courseGrade); } } catch (Exception ex) { throw ex; } }
private int FindCourseId(string course, string grade) { int courseGradeId = 0; int courseId = int.Parse(course); var courseGrade = (from cg in _dataContext.CourseGrade where (cg.CourseId == courseId && cg.Grade == grade) select cg).ToList(); if (courseGrade.Count > 0) { courseGradeId = courseGrade[0].Id; } else { var cg = new CourseGrade() { CourseId = int.Parse(course), Grade = grade }; _dataContext.CourseGrade.Add(cg); _dataContext.SaveChanges(); courseGradeId = cg.Id; } return courseGradeId; }
private void AddCourseGrade(CourseGrade courseGrade) { _dataContext.CourseGrade.Add(courseGrade); _dataContext.SaveChanges(); }