public int Insert(DigAddRequest model)
{
int id = 0;
string procName = "[dbo].[Ding_Insert]";
_dataProvider.ExecuteNonQuery(procName
, inputParamMapper : delegate(SqlParameterCollection sqlParams)
{
sqlParams.AddWithValue("@DingCategory", model.DingCategory);
sqlParams.AddWithValue("@Value", model.Value);
sqlParams.AddWithValue("@CreatedBy", model.CreatedBy);
sqlParams.AddWithValue("@RouteId", model.RouteId);
sqlParams.AddWithValue("@StopId", model.StopId);
sqlParams.AddWithValue("@StopDisplayName", model.StopDisplayName);
sqlParams.AddWithValue("@Agency", model.Agency);
sqlParams.AddWithValue("@Lat", model.Lat);
sqlParams.AddWithValue("@Long", model.Long);
SqlParameter idParameter = new SqlParameter("@DingId", System.Data.SqlDbType.Int);
idParameter.Direction = System.Data.ParameterDirection.Output;
sqlParams.Add(idParameter);
}, returnParameters : delegate(SqlParameterCollection sqlParams)
{
Int32.TryParse(sqlParams["@DingId"].Value.ToString(), out id);
}
);
return(id);
}
public HttpResponseMessage Create(DigAddRequest model)
{
if (!ModelState.IsValid)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState));
}
ItemResponse <int> response = new ItemResponse <int>();
IUserAuthData user = _auth.GetCurrentUser();
int userId = user.Id;
model.CreatedBy = userId;
response.Item = _service.Insert(model);
return(Request.CreateResponse(HttpStatusCode.OK, response));
}
