public int Insert(ForumAddRequest model)
{
int id = 0;
//Runs the stored procedure to create a new forum
this.DataProvider.ExecuteNonQuery(
"Forum_Insert",
inputParamMapper : delegate(SqlParameterCollection forumParamCol)
{
SqlParameter param = new SqlParameter();
param.ParameterName = "@Id";
param.SqlDbType = System.Data.SqlDbType.Int;
param.Direction = System.Data.ParameterDirection.Output;
forumParamCol.Add(param);
forumParamCol.AddWithValue("@ProjectId", model.ProjectId);
forumParamCol.AddWithValue("@StatusId", model.StatusId);
forumParamCol.AddWithValue("@ModifiedBy", model.ModifiedBy);
},
returnParameters : delegate(SqlParameterCollection forumParamCol)
{
id = (int)forumParamCol["@Id"].Value;
}
);
return(id);
}
public HttpResponseMessage Post(ForumAddRequest model)
{
try
{
if (ModelState.IsValid)
{
model.ModifiedBy = _principal.Identity.GetCurrentUser().Name;
//Creates a new forum
int id = _service.Insert(model);
ItemResponse <int> resp = new ItemResponse <int>();
resp.Item = id;
return(Request.CreateResponse(HttpStatusCode.OK, resp));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState));
}
}
catch (System.Exception ex)
{
//Log any exception that occurs
log.Error("Error Creating new Forum", ex);
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex.Message));
}
}
