public HttpResponseMessage Post(TestimonialsAddRequest model) { if (!ModelState.IsValid) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState)); } ItemResponse <int> response = new ItemResponse <int>(); response.Item = _TestimonialsService.Insert(model); return(Request.CreateResponse(response)); }
public int Insert(TestimonialsAddRequest model) { var id = 0; DataProvider.ExecuteNonQuery(GetConnection, "dbo.Testimonial_Insert", inputParamMapper : delegate(SqlParameterCollection parameterCollection) { parameterCollection.AddWithValue("@Title", model.Title); parameterCollection.AddWithValue("@Body", model.Body); parameterCollection.AddWithValue("@StarRating", model.StarRating); SqlParameter s = new SqlParameter("@Id", System.Data.SqlDbType.Int) { Direction = System.Data.ParameterDirection.Output }; parameterCollection.Add(s); }, returnParameters : delegate(SqlParameterCollection para) { int.TryParse(para["@Id"].Value.ToString(), out id); } ); return(id); }