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