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 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 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 int AddTimeline(Timeline timeline) { timeline.IsDeleted = false; using (var db = new CurriculumManagementDBContext()) { db.Timelines.Add(timeline); db.SaveChanges(); } return(timeline.Id); }
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 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 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 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 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(); } }
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 DeleteTheme(int id) { var theme = GetTheme(id); using (var db = new CurriculumManagementDBContext()) { db.Themes.Attach(theme); //if it is "Test" then delete corresponding ThemeAssignments. if (theme.ThemeType.Id == (int)IUDICO.CurriculumManagement.Models.Enums.ThemeType.Test) { DeleteThemeAssignments(theme); } theme.IsDeleted = true; db.SaveChanges(); } }
public void DeleteCurriculum(int id) { var curriculum = GetCurriculum(id); using (var db = new CurriculumManagementDBContext()) { db.Curriculums.Attach(curriculum); //delete stages var stageIds = GetStages(id).Select(item => item.Id); DeleteStages(stageIds); //delete corresponding CurriculumAssignments var curriculumAssignmentIds = GetCurriculumAssignmnetsByCurriculumId(id).Select(item => item.Id); DeleteCurriculumAssignments(curriculumAssignmentIds); curriculum.IsDeleted = true; db.SaveChanges(); } }
public void UpdateTheme(Theme theme) { var oldTheme = GetTheme(theme.Id); using (var db = new CurriculumManagementDBContext()) { /*try * {*/ db.Themes.Attach(oldTheme); oldTheme.Name = theme.Name; oldTheme.SortOrder = theme.SortOrder; oldTheme.CourseRef = theme.CourseRef; oldTheme.Updated = DateTime.Now; //if ThemeType has changed then add or remove corresponding ThemeAssignments. if (oldTheme.ThemeTypeRef != theme.ThemeTypeRef) { oldTheme.ThemeTypeRef = theme.ThemeTypeRef; if (theme.ThemeType.Id == (int)IUDICO.CurriculumManagement.Models.Enums.ThemeType.Test) { AddThemeAssignments(theme); } else { DeleteThemeAssignments(theme); } } db.SaveChanges(); /*} * catch (ChangeConflictException) * { * foreach (ObjectChangeConflict conflict in db.ChangeConflicts) * { * conflict.Resolve(RefreshMode.KeepChanges); * } * }*/ } }
public Theme ThemeDown(int themeId) { var theme = GetTheme(themeId); IList <Theme> themes = GetThemesByStageId(theme.StageRef).ToList(); using (var db = new CurriculumManagementDBContext()) { int index = themes.IndexOf(theme); if (index != -1 && index != themes.Count - 1) { db.Themes.Attach(themes[index - 1]); int temp = themes[index + 1].SortOrder; themes[index + 1].SortOrder = theme.SortOrder; theme.SortOrder = temp; } db.SaveChanges(); } return(theme); }
public void DeleteStage(int id) { var stage = GetStage(id); using (var db = new CurriculumManagementDBContext()) { db.Stages.Attach(stage); //delete themes var themeIds = GetThemesByStageId(id).Select(item => item.Id); DeleteThemes(themeIds); //delete corresponding StageTimelines var stageTimelines = GetStageTimelinesByStageId(id); foreach (Timeline timeline in stageTimelines) { DeleteTimeline(timeline.Id); } stage.IsDeleted = true; db.SaveChanges(); } }
public int AddTheme(Theme theme) { using (var db = new CurriculumManagementDBContext()) { theme.Created = DateTime.Now; theme.Updated = DateTime.Now; theme.IsDeleted = false; db.Themes.Add(theme); db.SaveChanges(); theme.SortOrder = theme.Id; UpdateTheme(theme); } //if it is "Test" then add corresponding ThemeAssignments. if (theme.ThemeType.Id == (int)IUDICO.CurriculumManagement.Models.Enums.ThemeType.Test) { AddThemeAssignments(theme); } return(theme.Id); }