public SaveMap BeforeSaveEntities(SaveMap saveMap) { var unAuthorizedMaps = saveMap.Where(map => map.Key != _tWg && map.Key != _tFacComment && map.Key != _tFacStratResp && map.Key != _tFacSpResp && map.Key != _tStudCommentFlag && map.Key != _tFacCommentFlag) .ToList(); //.Select(map => map.Key); saveMap.RemoveMaps(unAuthorizedMaps); var courseMonitorEntities = saveMap.MonitorCourseMaps()?.ToList(); //if (courseMonitorEntities != null) ProcessCourseMonitoredMaps(courseMonitorEntities); var workGroupMonitorEntities = saveMap.MonitorWgMaps()?.ToList(); //if (workGroupMonitorEntities != null) ProcessWorkGroupMonitoredMaps(workGroupMonitorEntities); //moved processing for monitored entities to monitoredguard if (courseMonitorEntities != null || workGroupMonitorEntities != null) { var monitoredGuard = new MonitoredGuard(ctxManager); if (courseMonitorEntities != null) { monitoredGuard.ProcessCourseMonitoredMaps(courseMonitorEntities); } if (workGroupMonitorEntities != null) { monitoredGuard.ProcessFacultyWorkGroupMonitoredMaps(workGroupMonitorEntities); } } if (saveMap.ContainsKey(_tWg)) { var workGroupMap = ProcessWorkGroup(saveMap[_tWg]); saveMap.MergeMap(workGroupMap); } if (saveMap.ContainsKey(_tFacComment)) { ProcessComments(saveMap[_tFacComment]); } saveMap.AuditMap(loggedInUser.PersonId); saveMap.SoftDeleteMap(loggedInUser.PersonId); return(saveMap); }
public SaveMap BeforeSaveEntities(SaveMap saveMap) { List <StudentOnTheMove> studentsPendingRemoval = new List <StudentOnTheMove>(); if (saveMap.ContainsKey(tWg)) { var grps = ProcessWorkGroup(saveMap[tWg]); if (grps != null) { saveMap.MergeMap(grps); } var groups = (from info in saveMap[tWg] select info.Entity as WorkGroup).ToList(); groups.ForEach(group => { group.ModifiedById = loggedInUser.PersonId; group.ModifiedDate = DateTime.Now; }); } if (saveMap.ContainsKey(tStudInGroup)) { var groupMembers = saveMap[tStudInGroup]; //Need to account for adds when a new group is created. var studentsOnTheMove = (from info in saveMap[tStudInGroup] let sig = info.Entity as CrseStudentInGroup where info.EntityState == EntityState.Modified where info.OriginalValuesMap.ContainsKey("WorkGroupId") select info).ToList(); var unAssignedStudents = (from info in saveMap[tStudInGroup] let sig = info.Entity as CrseStudentInGroup where info.EntityState == EntityState.Deleted select info).ToList(); if (unAssignedStudents.Any()) { unAssignedStudents.ForEach(uas => { var studentEntity = uas.Entity as CrseStudentInGroup; var fromWorkGroupId = Int32.Parse(studentEntity.WorkGroupId.ToString()); //uas.EntityState = Breeze.Persistence.EntityState.Deleted; var member = ctxManager.Context.StudentInGroups .Where(sig => sig.StudentId == studentEntity.StudentId) .Where(sig => sig.WorkGroupId == fromWorkGroupId) .Select(sig => new StudentOnTheMove { //Student = sig, StudentId = sig.StudentId, //IsDeleted = sig.IsDeleted, IsMoving = false, FromWorkGroupId = fromWorkGroupId, //CourseId = studentEntity.CourseId, HasChildren = sig.AuthorOfComments.Any() || sig.AssesseeSpResponses.Any() || sig.AssessorSpResponses.Any() || sig.AssesseeStratResponse.Any() || sig.AssessorStratResponse.Any() || sig.RecipientOfComments.Any() }).ToList(); studentsPendingRemoval.AddRange(member); }); } if (studentsOnTheMove.Any()) { studentsOnTheMove.ForEach(sm => { var studentEntity = sm.Entity as CrseStudentInGroup; var fromWorkGroupId = Int32.Parse(sm.OriginalValuesMap["WorkGroupId"].ToString()); var member = ctxManager.Context.StudentInGroups .Where(sig => sig.StudentId == studentEntity.StudentId) .Where(sig => sig.WorkGroupId == fromWorkGroupId) .Select(sig => new StudentOnTheMove { Student = sig, StudentId = sig.StudentId, IsDeleted = sig.IsDeleted, IsMoving = true, ToWorkGroupId = studentEntity.WorkGroupId, FromWorkGroupId = fromWorkGroupId, CourseId = studentEntity.CourseId, HasChildren = sig.AuthorOfComments.Any() || sig.AssesseeSpResponses.Any() || sig.AssessorSpResponses.Any() || sig.AssesseeStratResponse.Any() || sig.AssessorStratResponse.Any() || sig.RecipientOfComments.Any() || sig.FacultySpResponses.Any() || sig.FacultyStrat != null || sig.FacultyComment != null }).ToList(); studentsPendingRemoval.AddRange(member); }); } var studentsPendingRemovalWithChildren = studentsPendingRemoval .Where(spr => spr.HasChildren).ToList(); var studentsPendingRemovalWithoutChildren = studentsPendingRemoval .Where(spr => !spr.HasChildren).ToList(); if (studentsPendingRemovalWithChildren.Any()) { studentsPendingRemovalWithChildren.ForEach(sprwc => { //if (sprwc.IsMoving) //{ var authorCommentFlags = ctxManager.Context.StudSpCommentFlags .Where(sscf => sscf.AuthorPersonId == sprwc.StudentId) .Where(sscf => sscf.WorkGroupId == sprwc.FromWorkGroupId); var recipientCommentFlags = ctxManager.Context.StudSpCommentFlags .Where(sscf => sscf.RecipientPersonId == sprwc.StudentId) .Where(sscf => sscf.WorkGroupId == sprwc.FromWorkGroupId); var authorOfComments = ctxManager.Context.StudSpComments .Where(ssc => ssc.AuthorPersonId == sprwc.StudentId) .Where(ssc => ssc.WorkGroupId == sprwc.FromWorkGroupId); var recipientOfComments = ctxManager.Context.StudSpComments .Where(ssc => ssc.RecipientPersonId == sprwc.StudentId) .Where(ssc => ssc.WorkGroupId == sprwc.FromWorkGroupId); var assesseeSpResponses = ctxManager.Context.SpResponses .Where(sr => sr.AssesseePersonId == sprwc.StudentId) .Where(sr => sr.WorkGroupId == sprwc.FromWorkGroupId); var assessorSpResponses = ctxManager.Context.SpResponses .Where(sr => sr.AssessorPersonId == sprwc.StudentId) .Where(sr => sr.WorkGroupId == sprwc.FromWorkGroupId); var assesseeStratResponses = ctxManager.Context.SpStratResponses .Where(ssr => ssr.AssesseePersonId == sprwc.StudentId) .Where(ssr => ssr.WorkGroupId == sprwc.FromWorkGroupId); var assessorStratResponses = ctxManager.Context.SpStratResponses .Where(ssr => ssr.AssessorPersonId == sprwc.StudentId) .Where(ssr => ssr.WorkGroupId == sprwc.FromWorkGroupId); var facSpResponses = ctxManager.Context.FacSpResponses .Where(fsr => fsr.AssesseePersonId == sprwc.StudentId) .Where(fsr => fsr.WorkGroupId == sprwc.FromWorkGroupId); var facStratResponse = ctxManager.Context.FacStratResponses .Where(fsr => fsr.AssesseePersonId == sprwc.StudentId) .Where(fsr => fsr.WorkGroupId == sprwc.FromWorkGroupId); var facComments = ctxManager.Context.FacSpComments .Where(fsc => fsc.RecipientPersonId == sprwc.StudentId) .Where(fsc => fsc.WorkGroupId == sprwc.FromWorkGroupId); var facCommentsFlag = ctxManager.Context.FacSpCommentFlags .Where(fscf => fscf.RecipientPersonId == sprwc.StudentId) .Where(fscf => fscf.WorkGroupId == sprwc.FromWorkGroupId); if (authorOfComments.Any()) { if (authorCommentFlags.Any()) { ctxManager.Context.StudSpCommentFlags.RemoveRange(authorCommentFlags); } ctxManager.Context.StudSpComments.RemoveRange(authorOfComments); } if (recipientOfComments.Any()) { if (recipientCommentFlags.Any()) { ctxManager.Context.StudSpCommentFlags.RemoveRange(recipientCommentFlags); } ctxManager.Context.StudSpComments.RemoveRange(recipientOfComments); } if (assesseeSpResponses.Any()) { ctxManager.Context.SpResponses.RemoveRange(assesseeSpResponses); } if (assessorSpResponses.Any()) { ctxManager.Context.SpResponses.RemoveRange(assessorSpResponses); } if (assesseeStratResponses.Any()) { ctxManager.Context.SpStratResponses.RemoveRange(assesseeStratResponses); } if (assessorStratResponses.Any()) { ctxManager.Context.SpStratResponses.RemoveRange(assessorStratResponses); } if (facSpResponses.Any()) { ctxManager.Context.FacSpResponses.RemoveRange(facSpResponses); } if (facStratResponse.Any()) { ctxManager.Context.FacStratResponses.RemoveRange(facStratResponse); } if (facComments.Any()) { ctxManager.Context.FacSpComments.RemoveRange(facComments); } if (facCommentsFlag.Any()) { ctxManager.Context.FacSpCommentFlags.RemoveRange(facCommentsFlag); } //} if (sprwc.IsMoving) { ctxManager.Context.StudentInGroups.Remove(sprwc.Student); } }); ctxManager.Context.SaveChanges(); } if (studentsPendingRemovalWithoutChildren.Any()) { studentsPendingRemovalWithoutChildren.ForEach(sprwoc => { if (sprwoc.IsMoving) { ctxManager.Context.StudentInGroups.Remove(sprwoc.Student); ctxManager.Context.SaveChanges(); } //ctxManager.Context.Entry(sprwoc.Student).State = System.Data.Entity.EntityState.Deleted; }); //ctxManager.Context.SaveChanges(); } var studentsToBeAddedBack = studentsPendingRemoval .Where(spr => spr.IsMoving).ToList(); ////Students that were previously deleted with children. studentsOnTheMove.ForEach(info => saveMap.Remove(tStudInGroup)); if (studentsToBeAddedBack.Any()) { List <EntityInfo> toAddInfos; toAddInfos = new List <EntityInfo>(); studentsToBeAddedBack.ForEach(stab => { var toAdd = new CrseStudentInGroup { StudentId = stab.StudentId, CourseId = stab.CourseId, WorkGroupId = stab.ToWorkGroupId, HasAcknowledged = false, IsDeleted = false, ModifiedById = loggedInUser.PersonId, ModifiedDate = DateTime.Now }; var toAddEi = ctxManager.CreateEntityInfo(toAdd); toAddInfos.Add(toAddEi); }); saveMap.Add(tStudInGroup, toAddInfos); } } return(saveMap); }