public RequestModel findRequestById(int requestId)
{
Request efRequest = context.Requests.Find(requestId);
if (efRequest == null)
{
//return null;
throw new ItemNotFoundException();
}
RequestModel request = new RequestModel(efRequest, efRequest.Department, ItemGetter._getPendingOrUpdatedItemsForRequest(efRequest));
return(request);
}
public RequestModelCollection getAllRequestsByUser(string username)
{
List <Request> all = context.Requests
.Where(x => x.deleted != "Y" &&
x.username == username
).ToList();
if (all.Count == 0)
{
throw new ItemNotFoundException();
}
else
{
List <RequestModel> records = all.Select(x =>
{
string status = x.current_status;
return(new RequestModel(x, x.Department, ItemGetter._getItemsForRequest(x, status)));
}).ToList();
return(new RequestModelCollection(records));
}
}
public RequestModelCollection getAllRequestsOfDepartment(string departmentCode)
{
List <Request> all = context.Requests
.Where(x => x.deleted != "Y" &&
x.dept_code == departmentCode
).ToList();
if (all.Count == 0)
{
throw new ItemNotFoundException();
}
else
{
List <RequestModel> records = all.Select(x => new RequestModel(x, x.Department, ItemGetter._getPendingOrUpdatedItemsForRequest(x))).ToList();
return(new RequestModelCollection(records));
}
}
public RequestModelCollection getAllPendingRequestsOfDepartment(string departmentCode)
{
List <Request> pending = context.Requests
.Where(x => x.deleted != "Y" &&
(x.current_status == RequestStatus.PENDING || x.current_status == RequestStatus.UPDATED) &&
x.dept_code == departmentCode
).ToList();
if (pending.Count == 0)
{
throw new ItemNotFoundException();
}
else
{
List <RequestModel> records = pending.Select(x => new RequestModel(x, ItemGetter._getPendingOrUpdatedItemsForRequest(x))).ToList();
return(new RequestModelCollection(records));
}
}
public RequestModelCollection getAllApprovedRequests()
{
List <Request> approved = context.Requests
.Where(x => x.deleted != "Y" &&
x.current_status == RequestStatus.APPROVED).ToList();
if (approved.Count == 0)
{
throw new ItemNotFoundException();
}
else
{
List <RequestModel> records = approved.Select(x => new RequestModel(x, x.Department, ItemGetter._getItemsForRequest(x, RequestStatus.APPROVED))).ToList();
return(new RequestModelCollection(records));
}
}
