public IEnumerable <Stage> GetStages(int curriculumId)
{
using (var db = new CurriculumManagementDBContext())
{
return(db.Stages.Where(item => item.CurriculumRef == curriculumId && !item.IsDeleted));
}
}
public void DeleteCurriculumAssignment(int curriculumAssignmentId)
{
var curriculumAssignment = GetCurriculumAssignment(curriculumAssignmentId);
//delete corresponding CurriculumAssignmentTimelines
var curriculumAssignmentTimelineIds = GetCurriculumAssignmentTimelines(curriculumAssignmentId).Select(item => item.Id);
DeleteTimelines(curriculumAssignmentTimelineIds);
//delete corresponding StageTimelines
var stageTimelineIds = GetStageTimelinesByCurriculumAssignmentId(curriculumAssignmentId).Select(item => item.Id);
DeleteTimelines(stageTimelineIds);
//delete corresponding ThemeAssignments
var themeAssignmentIds = GetThemeAssignmentsByCurriculumAssignmentId(curriculumAssignmentId).Select(item => item.Id);
DeleteThemeAssignments(themeAssignmentIds);
using (var db = new CurriculumManagementDBContext())
{
db.CurriculumAssignments.Attach(curriculumAssignment);
curriculumAssignment.IsDeleted = true;
db.SaveChanges();
}
}
public IEnumerable <Curriculum> GetCurriculumsByGroupId(int groupId)
{
using (var db = new CurriculumManagementDBContext())
{
return(GetCurriculumAssignmentsByGroupId(groupId).Select(item => item.Curriculum));
}
}
public IEnumerable <Curriculum> GetCurriculums(IEnumerable <int> ids)
{
using (var db = new CurriculumManagementDBContext())
{
return(db.Curriculums.Where(item => ids.Contains(item.Id) && !item.IsDeleted));
}
}
private IEnumerable <Timeline> GetTimelines()
{
using (var db = new CurriculumManagementDBContext())
{
return(db.Timelines.Where(item => !item.IsDeleted));
}
}
public IEnumerable <CurriculumAssignment> GetCurriculumAssignmentsByGroupId(int groupId)
{
using (var db = new CurriculumManagementDBContext())
{
return(db.CurriculumAssignments.Where(item => item.UserGroupRef == groupId && !item.IsDeleted));
}
}
public int AddCurriculumAssignment(CurriculumAssignment curriculumAssignment)
{
using (var db = new CurriculumManagementDBContext())
{
curriculumAssignment.IsDeleted = false;
db.CurriculumAssignments.Add(curriculumAssignment);
db.SaveChanges();
}
//add corresponding ThemeAssignments
var themesInCurrentCurriculum = GetThemesByCurriculumId(curriculumAssignment.CurriculumRef)
.Where(item => item.ThemeTypeRef == (int)IUDICO.CurriculumManagement.Models.Enums.ThemeType.Test);
foreach (var theme in themesInCurrentCurriculum)
{
ThemeAssignment newThemeAssingment = new ThemeAssignment()
{
CurriculumAssignmentRef = curriculumAssignment.Id,
ThemeRef = theme.Id,
MaxScore = Constants.DefaultThemeMaxScore
};
AddThemeAssignment(newThemeAssingment);
}
return(curriculumAssignment.Id);
}
public IEnumerable <CurriculumAssignment> GetCurriculumAssignments()
{
using (var db = new CurriculumManagementDBContext())
{
return(db.CurriculumAssignments.Where(item => !item.IsDeleted));
}
}
public IEnumerable <ThemeAssignment> GetThemeAssignmentsByThemeId(int themeId)
{
using (var db = new CurriculumManagementDBContext())
{
return(db.ThemeAssignments.Where(item => item.ThemeRef == themeId && !item.IsDeleted));
}
}
public IEnumerable <Theme> GetThemesByCourseId(int courseId)
{
using (var db = new CurriculumManagementDBContext())
{
return(db.Themes.Where(item => item.CourseRef == courseId && !item.IsDeleted));
}
}
public IEnumerable <ThemeType> GetThemeTypes()
{
using (var db = new CurriculumManagementDBContext())
{
return(db.ThemeTypes);
}
}
public IEnumerable <Theme> GetThemesByStageId(int stageId)
{
using (var db = new CurriculumManagementDBContext())
{
return(db.Themes.Where(item => item.StageRef == stageId && !item.IsDeleted).OrderBy(item => item.SortOrder));
}
}
public IEnumerable <Theme> GetThemes(IEnumerable <int> ids)
{
using (var db = new CurriculumManagementDBContext())
{
return(db.Themes.Where(item => ids.Contains(item.Id) && !item.IsDeleted).OrderBy(item => item.SortOrder));
}
}
public Theme GetTheme(int id)
{
using (var db = new CurriculumManagementDBContext())
{
return(db.Themes.SingleOrDefault(item => item.Id == id && !item.IsDeleted));
}
}
public ThemeAssignment GetThemeAssignment(int themeAssignmentId)
{
using (var db = new CurriculumManagementDBContext())
{
return(db.ThemeAssignments.SingleOrDefault(item => item.Id == themeAssignmentId && !item.IsDeleted));
}
}
public IEnumerable <CurriculumAssignment> GetCurriculumAssignmnetsByCurriculumId(int curriculumId)
{
using (var db = new CurriculumManagementDBContext())
{
return(db.CurriculumAssignments.Where(item => item.CurriculumRef == curriculumId && !item.IsDeleted));
}
}
public IEnumerable <Curriculum> GetCurriculums()
{
using (var db = new CurriculumManagementDBContext())
{
return(db.Curriculums.Where(item => !item.IsDeleted));
}
//return GetDbDataContext().Curriculums.Where(item => !item.IsDeleted);
}
public Curriculum GetCurriculum(int id)
{
using (var db = new CurriculumManagementDBContext())
{
return(db.Curriculums.SingleOrDefault(item => item.Id == id && !item.IsDeleted));
}
//return GetDbDataContext().Curriculums.Single(item => item.Id == id && !item.IsDeleted);
}
public int AddThemeAssignment(ThemeAssignment themeAssignment)
{
using (var db = new CurriculumManagementDBContext())
{
db.ThemeAssignments.Add(themeAssignment);
db.SaveChanges();
}
return(themeAssignment.Id);
}
public void UpdateThemeAssignment(ThemeAssignment themeAssignment)
{
using (var db = new CurriculumManagementDBContext())
{
db.ThemeAssignments.Attach(themeAssignment);
themeAssignment.MaxScore = themeAssignment.MaxScore;
db.SaveChanges();
}
}
public void UpdateTimeline(Timeline timeline)
{
using (var db = new CurriculumManagementDBContext())
{
db.Timelines.Attach(timeline);
timeline.StartDate = timeline.StartDate;
timeline.EndDate = timeline.EndDate;
db.SaveChanges();
}
}
public void UpdateCurriculumAssignment(CurriculumAssignment curriculumAssignment)
{
//var oldCurriculumAssignment = GetCurriculumAssignment(curriculumAssignment.Id);
using (var db = new CurriculumManagementDBContext())
{
db.CurriculumAssignments.Attach(curriculumAssignment);
curriculumAssignment.UserGroupRef = curriculumAssignment.UserGroupRef;
db.SaveChanges();
}
}
public int AddTimeline(Timeline timeline)
{
timeline.IsDeleted = false;
using (var db = new CurriculumManagementDBContext())
{
db.Timelines.Add(timeline);
db.SaveChanges();
}
return(timeline.Id);
}
public void DeleteTimeline(int timelineId)
{
var timeline = GetTimeline(timelineId);
using (var db = new CurriculumManagementDBContext())
{
db.Timelines.Attach(timeline);
timeline.IsDeleted = true;
db.SaveChanges();
}
}
public void UpdateCurriculum(Curriculum curriculum)
{
var oldCurriculum = GetCurriculum(curriculum.Id);
using (var db = new CurriculumManagementDBContext())
{
db.Curriculums.Attach(oldCurriculum);
oldCurriculum.Name = curriculum.Name;
oldCurriculum.Updated = DateTime.Now;
db.SaveChanges();
}
}
public void UpdateStage(Stage stage)
{
Stage oldStage = GetStage(stage.Id);
using (var db = new CurriculumManagementDBContext())
{
db.Stages.Attach(oldStage);
oldStage.Name = stage.Name;
oldStage.Updated = DateTime.Now;
db.SaveChanges();
}
}
public int AddCurriculum(Curriculum curriculum)
{
using (var db = new CurriculumManagementDBContext())
{
curriculum.Created = DateTime.Now;
curriculum.Updated = DateTime.Now;
curriculum.IsDeleted = false;
db.Curriculums.Add(curriculum);
db.SaveChanges();
return(curriculum.Id);
}
}
public int AddStage(Stage stage)
{
using (var db = new CurriculumManagementDBContext())
{
stage.Created = DateTime.Now;
stage.Updated = DateTime.Now;
stage.IsDeleted = false;
db.Stages.Add(stage);
db.SaveChanges();
return(stage.Id);
}
}
public void DeleteThemeAssignments(IEnumerable <int> ids)
{
var themeAssignments = GetThemeAssignments(ids);
using (var db = new CurriculumManagementDBContext())
{
foreach (ThemeAssignment item in themeAssignments)
{
db.ThemeAssignments.Attach(item);
item.IsDeleted = true;
}
db.SaveChanges();
}
}
public void DeleteTimelines(IEnumerable <int> timelineIds)
{
var timelines = GetTimelines(timelineIds);
using (var db = new CurriculumManagementDBContext())
{
foreach (Timeline timeline in timelines)
{
db.Timelines.Attach(timeline);
timeline.IsDeleted = true;
}
db.SaveChanges();
}
}
