public SchoolTeacherCourse CreateSchoolTeacherCourse(SchoolTeacherCourse schoolTeacherCourse)
{
return(_DbContext.SchoolTeacherCourses.Add(schoolTeacherCourse));
}
public void SchoolRegister(SchoolDTO schoolDto, IEnumerable <DepartmentDTO> departmentDTOs, IEnumerable <CourseDTO> courseDTOs, IEnumerable <TeacherDTO> teacherDTOs)
{
using (DatabaseContext context = new DatabaseContext())
{
using (DbContextTransaction transaction = context.Database.BeginTransaction())
{
try
{
schoolRegServ = new SchoolRegistrationService(context);
var foundSchool = schoolRegServ.FindSchool(schoolDto.SchoolName);
if (foundSchool != null)
{
throw new SchoolRegistrationException();
}
if (foundSchool == null)
{
var newSchool = new School
{
Name = schoolDto.SchoolName,
ContactEmail = schoolDto.SchoolContactEmail,
EmailDomain = schoolDto.SchoolEmailDomain
};
foundSchool = schoolRegServ.CreateSchool(newSchool);
context.SaveChanges();
}
foreach (DepartmentDTO d in departmentDTOs)
{
var foundDepartment = schoolRegServ.FindDepartment(d.DepartmentName);
if (foundDepartment == null)
{
var newDepartment = new Department
{
Name = d.DepartmentName
};
foundDepartment = schoolRegServ.CreateDepartment(newDepartment);
context.SaveChanges();
}
var foundSchoolDepartment = schoolRegServ.FindSchoolDepartment(foundSchool.Name, foundDepartment.Name);
if (foundSchoolDepartment == null)
{
var newSchoolDepartment = new SchoolDepartment
{
School = foundSchool,
Department = foundDepartment,
};
foundSchoolDepartment = schoolRegServ.CreateSchoolDepartment(newSchoolDepartment);
context.SaveChanges();
}
foreach (TeacherDTO t in teacherDTOs)
{
var foundTeacher = schoolRegServ.FindTeacher(t.FirstName, t.LastName);
if (t.DepartmentName.Equals(foundDepartment.Name))
{
if (foundTeacher == null)
{
var newTeacher = new Teacher(t.FirstName, t.LastName);
foundTeacher = schoolRegServ.CreateTeacher(newTeacher);
context.SaveChanges();
}
SchoolTeacher foundSchoolTeacher = schoolRegServ.FindSchoolTeacher(foundSchool.Name, foundDepartment.Name, foundTeacher.FirstName, foundTeacher.LastName);
if (foundSchoolTeacher == null)
{
var newSchoolTeacher = new SchoolTeacher
{
Teacher = foundTeacher,
SchoolDepartment = foundSchoolDepartment
};
foundSchoolTeacher = schoolRegServ.CreateSchoolTeacher(newSchoolTeacher);
context.SaveChanges();
}
foreach (CourseDTO c in courseDTOs)
{
if (c.DepartmentName.Equals(foundDepartment.Name) &&
c.TeacherFirstName.Equals(foundTeacher.FirstName) &&
c.TeacherLastName.Equals(foundTeacher.LastName))
{
var foundCourse = schoolRegServ.FindCourse(c.CourseName);
if (foundCourse == null)
{
var newCourse = new Course
{
Name = c.CourseName,
SchoolDepartment = foundSchoolDepartment
};
foundCourse = schoolRegServ.CreateCourse(newCourse);
context.SaveChanges();
}
SchoolTeacherCourse foundSchoolTeacherCourse = schoolRegServ.FindSchoolTeacherCourse(foundSchool.Name, foundDepartment.Name, foundTeacher.FirstName, foundTeacher.LastName, foundCourse.Name);
if (foundSchoolTeacherCourse == null)
{
var newSchoolTeacherCourse = new SchoolTeacherCourse
{
SchoolTeacher = foundSchoolTeacher,
Course = foundCourse
};
schoolRegServ.CreateSchoolTeacherCourse(newSchoolTeacherCourse);
context.SaveChanges();
}
}
}
}
}
}
transaction.Commit();
}
catch (SchoolRegistrationException schoolEX)
{
throw schoolEX;
}
catch (Exception ex)
{
transaction.Rollback();
}
}
}
}
