public HttpResponseMessage Search([FromUri] ProposalSearchRequest model)
{
ItemsResponse <Proposal> response = new ItemsResponse <Proposal>();
response.Items = ProposalService.Search(model);
return(Request.CreateResponse(HttpStatusCode.OK, response));
}
public static List <Proposal> Search(ProposalSearchRequest model)
{
List <Proposal> list = null;
DataProvider.ExecuteCmd(GetConnection, "dbo.Proposal_Search"
, inputParamMapper : delegate(SqlParameterCollection paramCollection)
{
paramCollection.AddWithValue("@Name", model.Name);
}
, map : delegate(IDataReader reader, short set)
{
{
Proposal p = new Proposal();
int startingIndex = 0; //startingOrdinal
p.Id = reader.GetSafeInt32(startingIndex++);
p.Description = reader.GetSafeString(startingIndex++);
p.Budget = reader.GetSafeInt32(startingIndex++);
p.Deadline = reader.GetSafeString(startingIndex++);
p.ProjectType = reader.GetSafeString(startingIndex++);
p.FirstName = reader.GetSafeString(startingIndex++);
p.LastName = reader.GetSafeString(startingIndex++);
p.Company = reader.GetSafeString(startingIndex++);
p.PhoneNumber = reader.GetSafeString(startingIndex++);
p.Email = reader.GetSafeString(startingIndex++);
p.Notes = reader.GetSafeString(startingIndex++);
ProposalStatusCategory ps = new ProposalStatusCategory();
ps.Id = reader.GetSafeInt32(startingIndex++);
ps.Name = reader.GetSafeString(startingIndex++);
p.Status = ps;
if (list == null)
{
list = new List <Proposal>();
}
list.Add(p);
}
}
);
return(list);
}
