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