public HttpResponseMessage Get([FromUri] WMQueryParameter parameter)
{
try {
return(Request.CreateResponse(HttpStatusCode.OK, service.GetWorklists(parameter)));
} catch (Exception ex) {
return(CreateErrorMessageResponse(ex));
}
}
public ResourceWrapper GetWorklists(WMQueryParameter parameter)
{
object empNo = DBNull.Value;
object folio = DBNull.Value;
object procName = DBNull.Value;
object activityName = DBNull.Value;
object destination = DBNull.Value;
object worklistDate = DBNull.Value;
if (!string.IsNullOrEmpty(parameter.EmpNo))
{
empNo = parameter.EmpNo;
}
if (!string.IsNullOrEmpty(parameter.Folio))
{
folio = parameter.Folio;
}
if (!string.IsNullOrEmpty(parameter.ProcName))
{
procName = parameter.ProcName;
}
if (!string.IsNullOrEmpty(parameter.ActivityName))
{
activityName = parameter.ActivityName;
}
if (!string.IsNullOrEmpty(parameter.Destination))
{
destination = parameter.Destination;
}
if (parameter.WorklistDate != null)
{
worklistDate = parameter.WorklistDate;
}
SqlParameter totalRecords = new SqlParameter("@TotalCount", System.Data.SqlDbType.Int);
totalRecords.Direction = ParameterDirection.Output;
var worklists = this.DbContext.Database.SqlQuery <WLItemDto>(@"EXEC [K2]..[mGetAllWorklists]
@Start = @Start,
@Limit = @Limit,
@EmpNo = @EmpNo,
@Folio = @Folio,
@ProcName = @ProcName,
@ActivityName = @ActivityName,
@Destination = @Destination,
@WorklistDate = @WorklistDate,
@TotalCount = @TotalCount OUTPUT",
new object[] {
new SqlParameter("@Start", parameter.start),
new SqlParameter("@Limit", parameter.limit),
new SqlParameter("@EmpNo", empNo),
new SqlParameter("@Folio", folio),
new SqlParameter("@ProcName", procName),
new SqlParameter("@ActivityName", activityName),
new SqlParameter("@Destination", destination),
new SqlParameter("@WorklistDate", worklistDate),
totalRecords
}).ToList();
ResourceWrapper resource = new ResourceWrapper();
resource.Page = 0;
resource.Size = parameter.limit;
resource.Records = worklists;
resource.TotalRecords = (int)totalRecords.Value;
return(resource);
}
public ResourceWrapper GetWorklists(WMQueryParameter parameter)
{
return(_repo.GetWorklists(parameter));
}
