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