Пример #1
0
 private static void MapCommonParameter(BlogCommentAddRequest model, SqlParameterCollection paramCollection)
 {
     paramCollection.AddWithValue("@Comment", model.Comment);
     paramCollection.AddWithValue("@BlogId", model.BlogId);
     paramCollection.AddWithValue("@ParentId", model.ParentId);
     paramCollection.AddWithValue("@UserIdCreated", UserService.GetCurrentUserId());
 }
        public HttpResponseMessage Create(BlogCommentAddRequest model)
        {
            if (!ModelState.IsValid)
            {
                return(Request.CreateResponse(HttpStatusCode.BadRequest, ModelState));
            }
            ItemResponse <int> response = new ItemResponse <int>();

            response.Item = BlogCommentService.Post(model);
            return(Request.CreateResponse(HttpStatusCode.OK, response));
        }
Пример #3
0
        public static int Post(BlogCommentAddRequest model)
        {
            int id = 0;

            DataProvider.ExecuteNonQuery(GetConnection, "dbo.BlogComment_Insert",
                                         inputParamMapper : delegate(SqlParameterCollection paramCollection)
            {
                MapCommonParameter(model, paramCollection);

                SqlParameter p = new SqlParameter("@Id", System.Data.SqlDbType.Int);

                p.Direction = ParameterDirection.Output;

                paramCollection.Add(p);
            },
                                         returnParameters : delegate(SqlParameterCollection param)
            {
                int.TryParse(param["@Id"].Value.ToString(), out id);
                //id = (int)param["@Id"].Value;
            }
                                         );
            return(id);
        }