public HttpResponseMessage Post(DingSelectRoute model) { ItemsResponse <Ding> response = new ItemsResponse <Ding>(); { response.Items = _service.Post(model); } return(Request.CreateResponse(HttpStatusCode.OK, response)); }
public List <Ding> Post(DingSelectRoute model) { string storedProc = "[dbo].[Dings_SelectList]"; List <Ding> dingList = new List <Ding>(); _dataProvider.ExecuteCmd(storedProc , inputParamMapper : delegate(SqlParameterCollection sqlParams) { DingSelectRoute dingSelect = new DingSelectRoute(); SqlParameter p = new SqlParameter("@RouteId", System.Data.SqlDbType.Structured); if (model.RouteId != null && model.RouteId.Any()) { p.Value = new Trolli.Data.IntIdTable(model.RouteId); } sqlParams.Add(p); sqlParams.AddWithValue("@DateAdded", model.Date); } , singleRecordMapper : delegate(IDataReader reader, short set) { Ding ding = new Ding(); int startingIndex = 0; ding.DingId = reader.GetSafeInt32(startingIndex++); ding.DingCategory = reader.GetSafeString(startingIndex++); ding.Value = reader.GetSafeString(startingIndex++); ding.DateAdded = reader.GetSafeDateTime(startingIndex++); ding.CreatedBy = reader.GetSafeInt32(startingIndex++); ding.RouteId = reader.GetSafeInt32(startingIndex++); ding.StopId = reader.GetSafeInt32(startingIndex++); ding.StopDisplayName = reader.GetSafeString(startingIndex++); ding.Agency = reader.GetSafeString(startingIndex++); ding.Lat = reader.GetSafeDouble(startingIndex++); ding.Long = reader.GetSafeDouble(startingIndex++); dingList.Add(ding); }); return(dingList); }