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 EmployeeMetadataDTO UpdateOrCreateEmployee(EmployeeMetadataDTO employeeDTO)
{
Employee newEmployee = null;
if (employeeDTO.EmployeeId != Guid.Empty)
{
newEmployee = DbContext.Employees.Find(employeeDTO.EmployeeId);
}
if (newEmployee != null) // Edit existing
{
newEmployee.Avatar = employeeDTO.Avatar;
newEmployee.Email = employeeDTO.Email;
newEmployee.FirstName = employeeDTO.FirstName;
newEmployee.isApprover = employeeDTO.isApprover;
newEmployee.LastName = employeeDTO.LastName;
newEmployee.Title = employeeDTO.Title;
}
else // Create new Employee
{
newEmployee = EmployeeMetadataDTO.MapToBaseFunc(employeeDTO);
newEmployee.EmployeeId = Guid.NewGuid();
DbContext.Employees.Add(newEmployee);
}
DbContext.SaveChanges();
return(EmployeeMetadataDTO.MapToDTOFunc(newEmployee));
}
public EmployeeMetadataDTO UpdateOrCreateEmployee([FromBody] EmployeeMetadataDTO employeeDTO)
{
return(Repository.UpdateOrCreateEmployee(employeeDTO));
}
public async ValueTask <EmployeeMetadataDTO> GetEmployeeById(Guid employeeId)
{
var employee = await DbContext.Employees.FindAsync(employeeId);
return(EmployeeMetadataDTO.MapToDTOFunc(employee));
}
public EmployeeMetadataDTO GetEmployeeByAuthId(string auth0Id)
{
var employee = DbContext.Employees.FirstOrDefault(x => x.Auth0Id == auth0Id);
return(EmployeeMetadataDTO.MapToDTOFunc(employee));
}
