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); }