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(); } }