public HttpResponseMessage SquadEventSearch([FromUri] SquadEventSearchRequest model)
{
int rows = 0;
List <SquadEvent> squadEvents = _squadEventService.SquadEventSearch(model, out rows);
SearchResponse <SquadEvent>
response = new SearchResponse <SquadEvent>();
response.Items = squadEvents;
response.ResultCount = rows;
return(Request.CreateResponse(HttpStatusCode.OK, response));
}
public List <SquadEvent> SquadEventSearch(SquadEventSearchRequest model, out int totalRows)
{
List <SquadEvent> list = null;
int r = 0;
DataProvider.ExecuteCmd(GetConnection, "dbo.SquadEvent_Search",
inputParamMapper : delegate(SqlParameterCollection paramCollection)
{
paramCollection.AddWithValue("@SearchStr", model.SearchString);
paramCollection.AddWithValue("@CurrentPage", model.CurrentPage);
paramCollection.AddWithValue("@ItemsPerPage", model.ItemsPerPage);
paramCollection.AddWithValue("@SquadId", model.SquadId);
}
, map : delegate(IDataReader reader, short set)
{
switch (set)
{
case 0:
SquadEvent sqe = new SquadEvent();
int ord = 0;
sqe.Id = reader.GetSafeInt32(ord++);
sqe.Name = reader.GetSafeString(ord++);
sqe.DateCreated = reader.GetSafeDateTime(ord++);
sqe.DateModified = reader.GetSafeDateTime(ord++);
sqe.UserIdCreated = reader.GetSafeString(ord++);
sqe.EventStart = reader.GetSafeDateTime(ord++);
sqe.EventEnd = reader.GetSafeDateTime(ord++);
sqe.Description = reader.GetSafeString(ord++);
sqe.Location = reader.GetSafeString(ord++);
sqe.SquadId = reader.GetSafeInt32(ord++);
sqe.Color = reader.GetSafeString(ord++);
sqe.Timezone = reader.GetSafeString(ord++);
r = reader.GetSafeInt32(ord++);
if (list == null)
{
list = new List <SquadEvent>();
}
list.Add(sqe);
break;
}
});
totalRows = r;
return(list);
}
