public IQueryable <WorkRequestDetailDTO> GetWorkRequestDetailDTOs()
{
return(from request in DbContext.WorkRequests
join capacity in DbContext.vWorkRequestCapacities on request.WorkRequestId equals capacity.WorkRequestId
select new WorkRequestDetailDTO
{
Section = SectionMetadataDTO.MapToDTOFunc(request.Section),
ApprovalStatus = new ApprovalStatusMetadataDTO
{
ApprovalStatusId = request.ApprovalStatus.ApprovalStatusId,
IsFinal = request.ApprovalStatus.IsFinal,
StatusName = request.ApprovalStatus.StatusName
},
Approver = EmployeeMetadataDTO.MapToDTOFunc(request.Approver),
Person = EmployeeMetadataDTO.MapToDTOFunc(request.Person),
Requestor = EmployeeMetadataDTO.MapToDTOFunc(request.Requestor),
ApproverNotes = request.ApproverNotes,
EndTime = request.EndTime,
Office = OfficeMetadataDTO.MapToDTOFunc(request.Office),
OfficeUsedCapacity = capacity.OfficeUsedCapacity,
RequestorNotes = request.RequestorNotes,
SectionUsedCapacity = capacity.SectionUsedCapacity,
StartTime = request.StartTime,
WorkRequestId = request.WorkRequestId
});
}
public OfficeMetadataDTO UpdateOrCreateOffice(OfficeMetadataDTO officeDTO)
{
Office newOffice = null;
if (officeDTO.OfficeId != Guid.Empty)
{
newOffice = DbContext.Offices.Find(officeDTO.OfficeId);
}
if (newOffice != null) // Edit existing
{
newOffice.OfficeName = officeDTO.OfficeName;
newOffice.OfficeStreet = officeDTO.OfficeStreet;
newOffice.OfficeCity = officeDTO.OfficeCity;
newOffice.OfficeState = officeDTO.OfficeState;
newOffice.OfficeZip = officeDTO.OfficeZip;
newOffice.OfficeMaxCapacity = officeDTO.OfficeMaxCapacity;
newOffice.OfficeSafeCapacity = officeDTO.OfficeSafeCapacity;
}
else // Create new office
{
newOffice = OfficeMetadataDTO.MapToBaseFunc(officeDTO);
newOffice.OfficeId = Guid.NewGuid();
DbContext.Offices.Add(newOffice);
}
DbContext.SaveChanges();
return(OfficeMetadataDTO.MapToDTOFunc(newOffice));
}
public OfficeMetadataDTO UpdateOrCreateOffice([FromBody] OfficeMetadataDTO officeDetailDTO)
{
return(Repository.UpdateOrCreateOffice(officeDetailDTO));
}
public async ValueTask <OfficeMetadataDTO> GetOfficeById(Guid officeId)
{
var office = await DbContext.Offices.FindAsync(officeId);
return(OfficeMetadataDTO.MapToDTOFunc(office));
}