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