public HttpResponseMessage Post(TestimonialAddRequest model)
        {
            if (!ModelState.IsValid)
            {
                return(Request.CreateResponse(HttpStatusCode.BadRequest, ModelState));
            }
            ItemResponse <int> response = new ItemResponse <int>();

            response.Item = _testimonial.Post(model);
            return(Request.CreateResponse(HttpStatusCode.OK, response));
        }
        public int Post(TestimonialAddRequest model)
        {
            int id = 0;

            DataProvider.ExecuteNonQuery(GetConnection, "dbo.Testimonial_Insert",
                                         inputParamMapper : delegate(SqlParameterCollection paramCollection)
            {
                MapCommonParameters(model, paramCollection);
                //paramCollection.AddWithValue("@UserIdCreated", UserService.GetCurrentUserId());
                paramCollection.AddWithValue("@PersonId", model.PersonId);
                SqlParameter p = new SqlParameter("@Id", System.Data.SqlDbType.Int);
                p.Direction    = ParameterDirection.Output;
                paramCollection.Add(p);
            }, returnParameters : delegate(SqlParameterCollection param)
            {
                Int32.TryParse(param["@Id"].Value.ToString(), out id);
            }
                                         );
            return(id);
        }
 private static void MapCommonParameters(TestimonialAddRequest model, SqlParameterCollection paramCollection)
 {
     paramCollection.AddWithValue("@Testimonial", model.Content);
 }