// Insert new Comment public int Insert(CommentsAddRequest model, string userId) { int Id = 0; DataProvider.ExecuteNonQuery(GetConnection, "dbo.Comments_Insert", inputParamMapper : delegate(SqlParameterCollection paramCollection) { paramCollection.AddWithValue("@EntityId", model.EntityId); paramCollection.AddWithValue("@ParentId", model.ParentId); paramCollection.AddWithValue("@TypeId", model.TypeId); paramCollection.AddWithValue("@Title", model.Title); paramCollection.AddWithValue("@Description", model.Description); paramCollection.AddWithValue("@CreatedBy", userId); paramCollection.AddWithValue("@CreatedDate", model.CreatedDate); paramCollection.AddWithValue("@ModifiedDate", model.ModifiedDate); SqlParameter com = new SqlParameter("@Id", SqlDbType.Int); com.Direction = ParameterDirection.Output; paramCollection.Add(com); }, returnParameters : delegate(SqlParameterCollection param) { int.TryParse(param["@Id"].Value.ToString(), out Id); } ) return(Id); }
public HttpResponseMessage Insert(CommentsAddRequest model) { string userId = _userService.GetCurrentUserId(); if (string.IsNullOrEmpty(userId)) { userId = "18c5d19c - 998a - 4c5f - be05 - 1a3fa116d278"; } if (!ModelState.IsValid || model == null) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState)); } ItemResponse <int> response = new ItemResponse <int>(); response.Item = _commentService.Insert(model, userId); return(Request.CreateResponse(HttpStatusCode.OK, response)); }