public int Insert(NewsFeedPostAddRequest model)
{
int returnValue = 0;
DataProvider.ExecuteNonQuery("dbo.NewsFeedPost_Insert",
inputParamMapper: (SqlParameterCollection inputs) =>
{
inputs.Add(SqlDbParameter.Instance.BuildParameter("@FeedText", model.FeedText, SqlDbType.NVarChar, -1)); // max
inputs.Add(SqlDbParameter.Instance.BuildParameter("@FeedImgUrl", model.FeedImgUrl, SqlDbType.NVarChar, 256));
inputs.Add(SqlDbParameter.Instance.BuildParameter("@FeedRepostId", model.FeedRepostId, SqlDbType.Int));
inputs.Add(SqlDbParameter.Instance.BuildParameter("@CreatedById", model.CreatedById, SqlDbType.Int));
inputs.Add(SqlDbParameter.Instance.BuildParameter("@Id", 0, SqlDbType.Int, paramDirection: ParameterDirection.Output));
},
returnParameters: (SqlParameterCollection inputs) =>
{
int.TryParse(inputs["@Id"].Value.ToString(), out returnValue);
});
return(returnValue);
}
public IHttpActionResult Post(NewsFeedPostAddRequest model)
{
try
{
model.CreatedById = currentUserId;
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
ItemResponse <int> response = new ItemResponse <int>
{
Item = _newsFeedPostService.Insert(model)
};
return(Ok(response));
}
catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}
