private Project GetProject(Project request) { var id = request?.Id; Project ret = null; var query = DocQuery.ActiveQuery ?? Execute; DocPermissionFactory.SetSelect <Project>(currentUser, "Project", request.Select); DocEntityProject entity = null; if (id.HasValue) { entity = DocEntityProject.Get(id.Value); } if (null == entity) { throw new HttpError(HttpStatusCode.NotFound, $"No Project found for Id {id.Value}"); } if (!DocPermissionFactory.HasPermission(entity, currentUser, DocConstantPermission.VIEW)) { throw new HttpError(HttpStatusCode.Forbidden, "You do not have VIEW permission for this route."); } ret = entity?.ToDto(); return(ret); }
public void Delete(Project request) { using (Execute) { Execute.Run(ssn => { if (!(request?.Id > 0)) { throw new HttpError(HttpStatusCode.NotFound, $"No Id provided for delete."); } var en = DocEntityProject.Get(request?.Id); if (null == en) { throw new HttpError(HttpStatusCode.NotFound, $"No Project could be found for Id {request?.Id}."); } if (en.IsRemoved) { return; } if (!DocPermissionFactory.HasPermission(en, currentUser, DocConstantPermission.DELETE)) { throw new HttpError(HttpStatusCode.Forbidden, "You do not have DELETE permission for this route."); } en.Remove(); DocCacheClient.RemoveSearch(DocConstantModelName.PROJECT); DocCacheClient.RemoveById(request.Id); }); } }
private TimeCard _AssignValues(TimeCard request, DocConstantPermission permission, Session session) { if (permission != DocConstantPermission.ADD && (request == null || request.Id <= 0)) { throw new HttpError(HttpStatusCode.NotFound, $"No record"); } if (permission == DocConstantPermission.ADD && !DocPermissionFactory.HasPermissionTryAdd(currentUser, "TimeCard")) { throw new HttpError(HttpStatusCode.Forbidden, "You do not have ADD permission for this route."); } request.Select = request.Select ?? new List <string>(); TimeCard ret = null; request = _InitAssignValues <TimeCard>(request, permission, session); //In case init assign handles create for us, return it if (permission == DocConstantPermission.ADD && request.Id > 0) { return(request); } var cacheKey = GetApiCacheKey <TimeCard>(DocConstantModelName.TIMECARD, nameof(TimeCard), request); //First, assign all the variables, do database lookups and conversions var pDescription = request.Description; var pDocument = DocEntityDocument.Get(request.Document?.Id, true, Execute) ?? DocEntityDocument.Get(request.DocumentId, true, Execute); var pEnd = request.End; var pProject = DocEntityProject.Get(request.Project?.Id, true, Execute) ?? DocEntityProject.Get(request.ProjectId, true, Execute); var pReferenceId = request.ReferenceId; var pStart = request.Start; DocEntityLookupTable pStatus = GetLookup(DocConstantLookupTable.TIMECARDSTATUS, request.Status?.Name, request.Status?.Id); var pUser = DocEntityUser.Get(request.User?.Id, true, Execute) ?? DocEntityUser.Get(request.UserId, true, Execute); DocEntityLookupTable pWorkType = GetLookup(DocConstantLookupTable.WORKTYPE, request.WorkType?.Name, request.WorkType?.Id); var pArchived = true == request.Archived; var pLocked = request.Locked; var entity = InitEntity <DocEntityTimeCard, TimeCard>(request, permission, session); if (AllowPatchValue <TimeCard, bool>(request, DocConstantModelName.TIMECARD, pArchived, permission, nameof(request.Archived), pArchived != entity.Archived)) { entity.Archived = pArchived; } if (AllowPatchValue <TimeCard, string>(request, DocConstantModelName.TIMECARD, pDescription, permission, nameof(request.Description), pDescription != entity.Description)) { entity.Description = pDescription; } if (AllowPatchValue <TimeCard, DocEntityDocument>(request, DocConstantModelName.TIMECARD, pDocument, permission, nameof(request.Document), pDocument != entity.Document)) { entity.Document = pDocument; } if (AllowPatchValue <TimeCard, DateTime?>(request, DocConstantModelName.TIMECARD, pEnd, permission, nameof(request.End), pEnd != entity.End)) { if (null != pEnd) { entity.End = (DateTime)pEnd; } } if (AllowPatchValue <TimeCard, DocEntityProject>(request, DocConstantModelName.TIMECARD, pProject, permission, nameof(request.Project), pProject != entity.Project)) { entity.Project = pProject; } if (AllowPatchValue <TimeCard, int?>(request, DocConstantModelName.TIMECARD, pReferenceId, permission, nameof(request.ReferenceId), pReferenceId != entity.ReferenceId)) { entity.ReferenceId = pReferenceId; } if (AllowPatchValue <TimeCard, DateTime?>(request, DocConstantModelName.TIMECARD, pStart, permission, nameof(request.Start), pStart != entity.Start)) { if (null != pStart) { entity.Start = (DateTime)pStart; } } if (AllowPatchValue <TimeCard, DocEntityLookupTable>(request, DocConstantModelName.TIMECARD, pStatus, permission, nameof(request.Status), pStatus != entity.Status)) { entity.Status = pStatus; } if (AllowPatchValue <TimeCard, DocEntityUser>(request, DocConstantModelName.TIMECARD, pUser, permission, nameof(request.User), pUser != entity.User)) { entity.User = pUser; } if (AllowPatchValue <TimeCard, DocEntityLookupTable>(request, DocConstantModelName.TIMECARD, pWorkType, permission, nameof(request.WorkType), pWorkType != entity.WorkType)) { entity.WorkType = pWorkType; } if (request.Locked && AllowPatchValue <TimeCard, bool>(request, DocConstantModelName.TIMECARD, pArchived, permission, nameof(request.Locked), pLocked != entity.Locked)) { entity.Archived = pArchived; } entity.SaveChanges(permission); var idsToInvalidate = new List <int>(); if (idsToInvalidate.Any()) { idsToInvalidate.Add(entity.Id); DocCacheClient.RemoveByEntityIds(idsToInvalidate); DocCacheClient.RemoveSearch(DocConstantModelName.TIMECARD); } entity.SaveChanges(permission); DocPermissionFactory.SetSelect <TimeCard>(currentUser, nameof(TimeCard), request.Select); ret = entity.ToDto(); var cacheExpires = DocResources.Metadata.GetCacheExpiration(DocConstantModelName.TIMECARD); DocCacheClient.Set(key: cacheKey, value: ret, entityId: request.Id, entityType: DocConstantModelName.TIMECARD, cacheExpires); return(ret); }
public Project Post(ProjectCopy request) { Project ret = null; using (Execute) { Execute.Run(ssn => { var entity = DocEntityProject.Get(request?.Id); if (null == entity) { throw new HttpError(HttpStatusCode.NoContent, "The COPY request did not succeed."); } if (!DocPermissionFactory.HasPermission(entity, currentUser, DocConstantPermission.ADD)) { throw new HttpError(HttpStatusCode.Forbidden, "You do not have ADD permission for this route."); } var pChildren = entity.Children.ToList(); var pClient = entity.Client; var pDatabaseDeadline = entity.DatabaseDeadline; var pDatabaseName = entity.DatabaseName; if (!DocTools.IsNullOrEmpty(pDatabaseName)) { pDatabaseName += " (Copy)"; } var pDataset = entity.Dataset; var pDeliverableDeadline = entity.DeliverableDeadline; var pFqId = entity.FqId; var pFqWorkflow = entity.FqWorkflow; var pLegacyPackageId = entity.LegacyPackageId; var pLibrary = entity.Library; var pLibraryPackageId = entity.LibraryPackageId; var pLibraryPackageName = entity.LibraryPackageName; if (!DocTools.IsNullOrEmpty(pLibraryPackageName)) { pLibraryPackageName += " (Copy)"; } var pNumber = entity.Number; if (!DocTools.IsNullOrEmpty(pNumber)) { pNumber += " (Copy)"; } var pOperationsDeliverable = entity.OperationsDeliverable; if (!DocTools.IsNullOrEmpty(pOperationsDeliverable)) { pOperationsDeliverable += " (Copy)"; } var pOpportunityId = entity.OpportunityId; if (!DocTools.IsNullOrEmpty(pOpportunityId)) { pOpportunityId += " (Copy)"; } var pOpportunityName = entity.OpportunityName; if (!DocTools.IsNullOrEmpty(pOpportunityName)) { pOpportunityName += " (Copy)"; } var pParent = entity.Parent; var pPICO = entity.PICO; if (!DocTools.IsNullOrEmpty(pPICO)) { pPICO += " (Copy)"; } var pProjectId = entity.ProjectId; if (!DocTools.IsNullOrEmpty(pProjectId)) { pProjectId += " (Copy)"; } var pProjectName = entity.ProjectName; if (!DocTools.IsNullOrEmpty(pProjectName)) { pProjectName += " (Copy)"; } var pStatus = entity.Status; var pTimeCards = entity.TimeCards.ToList(); var copy = new DocEntityProject(ssn) { Hash = Guid.NewGuid() , Client = pClient , DatabaseDeadline = pDatabaseDeadline , DatabaseName = pDatabaseName , Dataset = pDataset , DeliverableDeadline = pDeliverableDeadline , FqId = pFqId , FqWorkflow = pFqWorkflow , LegacyPackageId = pLegacyPackageId , Library = pLibrary , LibraryPackageId = pLibraryPackageId , LibraryPackageName = pLibraryPackageName , Number = pNumber , OperationsDeliverable = pOperationsDeliverable , OpportunityId = pOpportunityId , OpportunityName = pOpportunityName , Parent = pParent , PICO = pPICO , ProjectId = pProjectId , ProjectName = pProjectName , Status = pStatus }; foreach (var item in pChildren) { entity.Children.Add(item); } foreach (var item in pTimeCards) { entity.TimeCards.Add(item); } copy.SaveChanges(DocConstantPermission.ADD); ret = copy.ToDto(); }); } return(ret); }
private Project _AssignValues(Project request, DocConstantPermission permission, Session session) { if (permission != DocConstantPermission.ADD && (request == null || request.Id <= 0)) { throw new HttpError(HttpStatusCode.NotFound, $"No record"); } if (permission == DocConstantPermission.ADD && !DocPermissionFactory.HasPermissionTryAdd(currentUser, "Project")) { throw new HttpError(HttpStatusCode.Forbidden, "You do not have ADD permission for this route."); } request.Select = request.Select ?? new List <string>(); Project ret = null; request = _InitAssignValues <Project>(request, permission, session); //In case init assign handles create for us, return it if (permission == DocConstantPermission.ADD && request.Id > 0) { return(request); } var cacheKey = GetApiCacheKey <Project>(DocConstantModelName.PROJECT, nameof(Project), request); //First, assign all the variables, do database lookups and conversions var pChildren = GetVariable <Reference>(request, nameof(request.Children), request.Children?.ToList(), request.ChildrenIds?.ToList()); var pClient = DocEntityClient.Get(request.Client?.Id, true, Execute) ?? DocEntityClient.Get(request.ClientId, true, Execute); var pDatabaseDeadline = request.DatabaseDeadline; var pDatabaseName = request.DatabaseName; var pDataset = DocEntityDataSet.Get(request.Dataset?.Id, true, Execute) ?? DocEntityDataSet.Get(request.DatasetId, true, Execute); var pDeliverableDeadline = request.DeliverableDeadline; var pFqId = request.FqId; var pFqWorkflow = DocEntityWorkflow.Get(request.FqWorkflow?.Id, true, Execute) ?? DocEntityWorkflow.Get(request.FqWorkflowId, true, Execute); var pLegacyPackageId = request.LegacyPackageId; var pLibrary = DocEntityLibrarySet.Get(request.Library?.Id, true, Execute) ?? DocEntityLibrarySet.Get(request.LibraryId, true, Execute); var pLibraryPackageId = request.LibraryPackageId; var pLibraryPackageName = request.LibraryPackageName; var pNumber = request.Number; var pOperationsDeliverable = request.OperationsDeliverable; var pOpportunityId = request.OpportunityId; var pOpportunityName = request.OpportunityName; var pParent = DocEntityProject.Get(request.Parent?.Id, true, Execute) ?? DocEntityProject.Get(request.ParentId, true, Execute); var pPICO = request.PICO; var pProjectId = request.ProjectId; var pProjectName = request.ProjectName; var pStatus = request.Status; var pTimeCards = GetVariable <Reference>(request, nameof(request.TimeCards), request.TimeCards?.ToList(), request.TimeCardsIds?.ToList()); var pArchived = true == request.Archived; var pLocked = request.Locked; var entity = InitEntity <DocEntityProject, Project>(request, permission, session); if (AllowPatchValue <Project, bool>(request, DocConstantModelName.PROJECT, pArchived, permission, nameof(request.Archived), pArchived != entity.Archived)) { entity.Archived = pArchived; } if (AllowPatchValue <Project, DocEntityClient>(request, DocConstantModelName.PROJECT, pClient, permission, nameof(request.Client), pClient != entity.Client)) { entity.Client = pClient; } if (AllowPatchValue <Project, DateTime?>(request, DocConstantModelName.PROJECT, pDatabaseDeadline, permission, nameof(request.DatabaseDeadline), pDatabaseDeadline != entity.DatabaseDeadline)) { entity.DatabaseDeadline = pDatabaseDeadline; } if (AllowPatchValue <Project, string>(request, DocConstantModelName.PROJECT, pDatabaseName, permission, nameof(request.DatabaseName), pDatabaseName != entity.DatabaseName)) { entity.DatabaseName = pDatabaseName; } if (AllowPatchValue <Project, DocEntityDataSet>(request, DocConstantModelName.PROJECT, pDataset, permission, nameof(request.Dataset), pDataset != entity.Dataset)) { entity.Dataset = pDataset; } if (AllowPatchValue <Project, DateTime?>(request, DocConstantModelName.PROJECT, pDeliverableDeadline, permission, nameof(request.DeliverableDeadline), pDeliverableDeadline != entity.DeliverableDeadline)) { entity.DeliverableDeadline = pDeliverableDeadline; } if (AllowPatchValue <Project, int?>(request, DocConstantModelName.PROJECT, pFqId, permission, nameof(request.FqId), pFqId != entity.FqId)) { entity.FqId = pFqId; } if (AllowPatchValue <Project, DocEntityWorkflow>(request, DocConstantModelName.PROJECT, pFqWorkflow, permission, nameof(request.FqWorkflow), pFqWorkflow != entity.FqWorkflow)) { entity.FqWorkflow = pFqWorkflow; } if (AllowPatchValue <Project, int?>(request, DocConstantModelName.PROJECT, pLegacyPackageId, permission, nameof(request.LegacyPackageId), pLegacyPackageId != entity.LegacyPackageId)) { entity.LegacyPackageId = pLegacyPackageId; } if (AllowPatchValue <Project, DocEntityLibrarySet>(request, DocConstantModelName.PROJECT, pLibrary, permission, nameof(request.Library), pLibrary != entity.Library)) { entity.Library = pLibrary; } if (AllowPatchValue <Project, int?>(request, DocConstantModelName.PROJECT, pLibraryPackageId, permission, nameof(request.LibraryPackageId), pLibraryPackageId != entity.LibraryPackageId)) { entity.LibraryPackageId = pLibraryPackageId; } if (AllowPatchValue <Project, string>(request, DocConstantModelName.PROJECT, pLibraryPackageName, permission, nameof(request.LibraryPackageName), pLibraryPackageName != entity.LibraryPackageName)) { entity.LibraryPackageName = pLibraryPackageName; } if (AllowPatchValue <Project, string>(request, DocConstantModelName.PROJECT, pNumber, permission, nameof(request.Number), pNumber != entity.Number)) { entity.Number = pNumber; } if (AllowPatchValue <Project, string>(request, DocConstantModelName.PROJECT, pOperationsDeliverable, permission, nameof(request.OperationsDeliverable), pOperationsDeliverable != entity.OperationsDeliverable)) { entity.OperationsDeliverable = pOperationsDeliverable; } if (AllowPatchValue <Project, string>(request, DocConstantModelName.PROJECT, pOpportunityId, permission, nameof(request.OpportunityId), pOpportunityId != entity.OpportunityId)) { entity.OpportunityId = pOpportunityId; } if (AllowPatchValue <Project, string>(request, DocConstantModelName.PROJECT, pOpportunityName, permission, nameof(request.OpportunityName), pOpportunityName != entity.OpportunityName)) { entity.OpportunityName = pOpportunityName; } if (AllowPatchValue <Project, DocEntityProject>(request, DocConstantModelName.PROJECT, pParent, permission, nameof(request.Parent), pParent != entity.Parent)) { entity.Parent = pParent; } if (AllowPatchValue <Project, string>(request, DocConstantModelName.PROJECT, pPICO, permission, nameof(request.PICO), pPICO != entity.PICO)) { entity.PICO = pPICO; } if (AllowPatchValue <Project, string>(request, DocConstantModelName.PROJECT, pProjectId, permission, nameof(request.ProjectId), pProjectId != entity.ProjectId)) { entity.ProjectId = pProjectId; } if (AllowPatchValue <Project, string>(request, DocConstantModelName.PROJECT, pProjectName, permission, nameof(request.ProjectName), pProjectName != entity.ProjectName)) { entity.ProjectName = pProjectName; } if (AllowPatchValue <Project, ForeignKeyStatusEnm?>(request, DocConstantModelName.PROJECT, pStatus, permission, nameof(request.Status), pStatus != entity.Status)) { entity.Status = pStatus; } if (request.Locked && AllowPatchValue <Project, bool>(request, DocConstantModelName.PROJECT, pArchived, permission, nameof(request.Locked), pLocked != entity.Locked)) { entity.Archived = pArchived; } entity.SaveChanges(permission); var idsToInvalidate = new List <int>(); idsToInvalidate.AddRange(PatchCollection <Project, DocEntityProject, Reference, DocEntityProject>(request, entity, pChildren, permission, nameof(request.Children))); idsToInvalidate.AddRange(PatchCollection <Project, DocEntityProject, Reference, DocEntityTimeCard>(request, entity, pTimeCards, permission, nameof(request.TimeCards))); if (idsToInvalidate.Any()) { idsToInvalidate.Add(entity.Id); DocCacheClient.RemoveByEntityIds(idsToInvalidate); DocCacheClient.RemoveSearch(DocConstantModelName.PROJECT); } entity.SaveChanges(permission); DocPermissionFactory.SetSelect <Project>(currentUser, nameof(Project), request.Select); ret = entity.ToDto(); var cacheExpires = DocResources.Metadata.GetCacheExpiration(DocConstantModelName.PROJECT); DocCacheClient.Set(key: cacheKey, value: ret, entityId: request.Id, entityType: DocConstantModelName.PROJECT, cacheExpires); return(ret); }