public List <ActionItem> SearchItems(ActionItemSearchRequest model)
{
List <ActionItem> list = null;
_prov.ExecuteCmd("dbo.ActionItem_Search",
inputParamMapper : delegate(SqlParameterCollection paramCollection)
{
paramCollection.AddWithValue("@ActionItemStatus", model.ActionItemStatus);
paramCollection.AddWithValue("@ActionItemTypeId", model.ActionItemTypeId);
paramCollection.AddWithValue("@AssignedDateBegin", model.AssignedDateBegin);
paramCollection.AddWithValue("@AssignedDateEnd", model.AssignedDateEnd);
paramCollection.AddWithValue("@DueDateBegin", model.DueDateBegin);
paramCollection.AddWithValue("@DueDateEnd", model.DueDateEnd);
paramCollection.AddWithValue("@Assignees", model.Assignees.ToDataTable());
paramCollection.AddWithValue("@SearchString", model.SearchString);
},
singleRecordMapper : delegate(IDataReader rdr, short set)
{
ActionItem item = MapActionItem(rdr);
if (list == null)
{
list = new List <ActionItem>();
}
list.Add(item);
});
return(list);
}
public HttpResponseMessage SearchItems([FromUri] ActionItemSearchRequest model)
{
if (!ModelState.IsValid)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState));
}
ItemsResponse <ActionItem> response = new ItemsResponse <ActionItem>();
response.Items = _svc.SearchItems(model);
return(Request.CreateResponse(HttpStatusCode.OK, response));
}
