public async Task <JsonResult> LinkEpmToSystem(ProjectServerSystemLinkDTO syncObjectLinkViewModel) { { try { await ProjectServerSystemLinkBusinessService.LinkEpmToSystem(syncObjectLinkViewModel); } catch (Exception exception) { JsonResult result = HandleException(exception); return(result); } } return(Json(new ProxyResponse { Result = "ok", }, JsonRequestBehavior.AllowGet)); }
public async Task <JsonResult> GetProjectServerSystemLinks(Guid?projectUid) { List <ProjectServerSystemLinkDTO> projectLinks = await ProjectServerSystemLinkBusinessService .GetLinksAndBlocksWithEpmProjectsAsync(projectUid); if (projectUid != null) { var linked = new LinkEpmToSystemViewModel { ProjectUid = projectUid.Value, ProjectServerSystemLinks = projectLinks.Where(x => x.ProjectUid == projectUid.Value).ToList() }; var toBlock = new LinkEpmToSystemViewModel { ProjectUid = projectUid.Value, ProjectServerSystemLinks = projectLinks.Where(x => x.ProjectUid != projectUid.Value).ToList() }; return(Json(new ProxyResponse { Result = "ok", Data = JsonConvert.SerializeObject(new { Linked = linked, ToBlock = toBlock }) }, JsonRequestBehavior.AllowGet)); } return(Json(new ProxyResponse { Result = "ok", Data = JsonConvert.SerializeObject(new { Linked = new LinkEpmToSystemViewModel { ProjectServerSystemLinks = projectLinks } }) }, JsonRequestBehavior.AllowGet)); }
public static DataFromDbViewModel GetDataFromDbViewModel(ProjectOnlineODataService projectOnlineODataService, UnitOfWork unitOfWork, bool isWorklogs) { StagingBusinessService stagingBusinessService = new StagingBusinessService(unitOfWork); SyncSystemBusinessService syncSystemBusinessService = new SyncSystemBusinessService(unitOfWork); ProjectServerSystemLinkBusinessService projectServerSystemLinkBusinessService = new ProjectServerSystemLinkBusinessService(projectOnlineODataService, unitOfWork); MasterWorklogBusinessService masterWorklogBusinessService = new MasterWorklogBusinessService(unitOfWork); MasterBusinessService masterBusinessService = new MasterBusinessService(unitOfWork); DateTime startDateTimesheetPeriods = projectOnlineODataService.GetODataTimesheetPeriods().Select(x => x.StartDate).Min(); DateTime endDateTimesheetPeriods = projectOnlineODataService.GetODataTimesheetPeriods().Select(x => x.EndDate).Max(); DataFromDbViewModel dataFromDbViewModel = new DataFromDbViewModel { SyncSystems = syncSystemBusinessService.GetSyncSystemList(), ProjectServerSystemLinks = projectServerSystemLinkBusinessService.GetList() }; stagingBusinessService.RemoveDoneStagings(); dataFromDbViewModel.StagingsAll = stagingBusinessService.GetAllStagings(isWorklogs); dataFromDbViewModel.MasterWorklogs = masterWorklogBusinessService.GetActualMasterWorklogs(dataFromDbViewModel.StagingsAll, dataFromDbViewModel.SyncSystems, startDateTimesheetPeriods, endDateTimesheetPeriods); List <int> stagingIds = dataFromDbViewModel.StagingsAll.Select(x => x.StagingId).ToList(); //stagingBusinessService.SetStagingsRecordState(stagingIds, // isWorklogs ? ProjectServerConstants.RecordStateActual : ProjectServerConstants.RecordStateGeneral, // RecordStateConst.Pending); dataFromDbViewModel.CustomValuesAll = stagingBusinessService .GetCustomValues(stagingIds); List <VStagingFieldMappingValue> lastUpdateUsersCustomValues = dataFromDbViewModel.CustomValuesAll .Where(x => x.StagingId.HasValue && stagingIds.Contains(x.StagingId.Value) && x.EpmFieldName == ProjectServerConstants.LastUpdateUser) .ToList(); List <AssignmentInfo> assignees = dataFromDbViewModel.StagingsAll .Where(x => !String.IsNullOrEmpty(x.Assignee)) .Select(x => new AssignmentInfo { IssueKey = x.IssueKey, IssueId = x.IssueId, SystemId = x.SystemId, AuthorKey = x.Assignee }).ToList(); List <AssignmentInfo> lastUpdateUsers = (from staging in dataFromDbViewModel.StagingsAll join lu in lastUpdateUsersCustomValues on staging.StagingId equals lu.StagingId select new AssignmentInfo { IssueKey = staging.IssueKey, IssueId = staging.IssueId, SystemId = staging.SystemId, AuthorKey = lu.Value }).ToList(); List <AssignmentInfo> worklogUsers = (from staging in dataFromDbViewModel.StagingsAll join worklog in dataFromDbViewModel.MasterWorklogs on new { staging.SystemId, staging.IssueId } equals new { worklog.SystemId, worklog.IssueId } select new AssignmentInfo { IssueKey = staging.IssueKey, IssueId = staging.IssueId, SystemId = staging.SystemId, AuthorKey = worklog.AuthorKey }).ToList(); dataFromDbViewModel.Assignments = lastUpdateUsers.Union(assignees).Union(worklogUsers).Distinct(new AssignmentInfoComparer()).ToList(); foreach (AssignmentInfo assignmentInfo in dataFromDbViewModel.Assignments) { ODataResource resource = projectOnlineODataService.GetODataResource(assignmentInfo.AuthorKey); if (resource != null) { assignmentInfo.ResourceUid = resource.ResourceId; } } dataFromDbViewModel.Assignments = dataFromDbViewModel.Assignments.Where(x => x.ResourceUid != Guid.Empty).ToList(); //List<string> issueKeysCurrentLevel = dataFromDbViewModel.StagingsAll // .Where(x => x.IsSubTask && !String.IsNullOrEmpty(x.ParentIssueKey)) // .Select(x => x.ParentIssueKey).Distinct().ToList(); dataFromDbViewModel.ParentIssues = new List <Master>(); List <string> issueKeysCurrentLevel = dataFromDbViewModel.StagingsAll .Where(x => !String.IsNullOrEmpty(x.ParentIssueKey)) .Select(x => x.ParentIssueKey).Distinct().ToList(); List <Master> parentIssuesCurrentLevel = masterBusinessService.GetMasters(issueKeysCurrentLevel); dataFromDbViewModel.ParentIssues.AddRange(parentIssuesCurrentLevel); while (parentIssuesCurrentLevel.Count != 0) { issueKeysCurrentLevel = parentIssuesCurrentLevel .Where(x => !String.IsNullOrEmpty(x.ParentIssueKey)) .Select(x => x.ParentIssueKey).Distinct().ToList(); parentIssuesCurrentLevel = masterBusinessService.GetMasters(issueKeysCurrentLevel); dataFromDbViewModel.ParentIssues.AddRange(parentIssuesCurrentLevel); } return(dataFromDbViewModel); }