public IHttpActionResult Post(ChatMessageAddRequest model)
{
try
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState)); // validation check on model
}
ItemResponse <int> response = new ItemResponse <int>
{
Item = _chatMessageService.Insert(model) // on is valid and success, set Item to hold response id
};
return(Ok(response));
}
catch (Exception ex)
{
int currentUser = _userService.GetCurrentUserId();
_appLogService.Insert(new AppLogAddRequest
{
AppLogTypeId = 1,
Message = ex.Message,
StackTrace = ex.StackTrace,
Title = "Error in " + GetType().Name + " " + System.Reflection.MethodBase.GetCurrentMethod().Name,
UserBaseId = currentUser
});
return(BadRequest(ex.Message));
}
}
public HttpResponseMessage Post(ChatMessageAddRequest model)
{
try
{
model.UserBaseId = _userService.GetCurrentUserId();
ItemResponse <int> response = new ItemResponse <int>();
response.Item = _chatMessageService.Insert(model);
return(Request.CreateResponse(HttpStatusCode.OK, response));
}
catch (Exception ex)
{
throw ex;
}
}
public int Insert(ChatMessageAddRequest model)
{
int returnValue = 0;
DataProvider.ExecuteNonQuery("dbo.ChatMessage_Insert",
inputParamMapper: (SqlParameterCollection inputs) =>
{
inputs.Add(SqlDbParameter.Instance.BuildParameter("@SenderUserBaseId", model.SenderUserBaseId, SqlDbType.Int));
inputs.Add(SqlDbParameter.Instance.BuildParameter("@Message", model.Message, SqlDbType.NVarChar, 1000));
inputs.Add(SqlDbParameter.Instance.BuildParameter("@ChatId", model.ChatId, 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 int Insert(ChatMessageAddRequest model)
{
int id = 0;
DataProvider.ExecuteNonQuery("dbo.ChatMessage_Insert",
inputParamMapper : delegate(SqlParameterCollection parameterCollection)
{
parameterCollection.AddWithValue("@Id", id);
parameterCollection.AddWithValue("@ChatId", model.ChatId);
parameterCollection.AddWithValue("@CreatedDate", model.CreatedDate);
parameterCollection.AddWithValue("@UserBaseId", model.UserBaseId);
parameterCollection.AddWithValue("@Message", model.Message);
},
returnParameters : delegate(SqlParameterCollection parameterCollection)
{
int.TryParse(parameterCollection["@Id"].Value.ToString(), out id);
});
return(id);
}
