public void DeleteCurriculum(Data.Curriculum curriculum)
{
var cuurGroups = curriculum.CurriculumGroups.ToList();
foreach (var curriculumGroup in cuurGroups)
{
var capGroups = curriculumGroup.CapacityGroups.ToList();
foreach (var capacityGroup in capGroups)
{
var ext = capacityGroup.Aliases.ToList();
foreach (var groupAliase in ext)
{
_db.GroupAliases.Remove(groupAliase);
}
_db.CapacityGroups.Remove(capacityGroup);
}
/*
* var semGroups = curriculumGroup.SemesterGroups.ToList();
* foreach (var semesterGroup in semGroups)
* {
* _db.SemesterGroups.Remove(semesterGroup);
* }
*/
_db.CurriculumGroups.Remove(curriculumGroup);
}
/*
* var modules = curriculum.Modules.ToList();
* foreach (var module in modules)
* {
* var courses = module.ModuleCourses.ToList();
* foreach (var moduleCourse in courses)
* {
* var c2 = moduleCourse.Courses.ToList();
* foreach (var course in c2)
* {
* _db.Activities.Remove(course);
* }
*
* _db.ModuleCourses.Remove(moduleCourse);
* }
*
* _db.CurriculumModules.Remove(module);
*
* }
*/
_db.Curricula.Remove(curriculum);
_db.SaveChanges();
}
public Data.Curriculum AddCurriculum(string shortName, string name, string orgName)
{
var cur = GetCurriculum(shortName);
var org = GetOrganiser(orgName);
if (cur == null && org != null)
{
cur = new Data.Curriculum
{
ShortName = shortName,
Name = name,
Organiser = org,
};
_db.Curricula.Add(cur);
_db.SaveChanges();
}
return(cur);
}
public ICollection <Course> GetCourses(Semester semester, Data.Curriculum curr)
{
return
(_db.Activities.OfType <Course>().Where(x => x.SemesterGroups.Any(g =>
g.Semester.Id == semester.Id && g.CapacityGroup.CurriculumGroup.Curriculum.Id == curr.Id)).ToList());
}
