public ActionResult <ItemResponse <int> > CreateByContact(LocationByContactAddRequest model)
{
ObjectResult result = null;
try
{
int userId = _authService.GetCurrentUserId();
int id = _service.AddByContact(model, userId);
ItemResponse <int> response = new ItemResponse <int>()
{
Item = id
};
result = Created201(response);
}
catch (Exception ex)
{
Logger.LogError(ex.ToString());
ErrorResponse response = new ErrorResponse(ex.Message);
result = StatusCode(500, response);
}
return(result);
}
public int AddByContact(LocationByContactAddRequest model, int userId)
{
int id = 0;
string procName = "[dbo].[Locations_Insert_ByContactId]";
_data.ExecuteNonQuery(procName, inputParamMapper : delegate(SqlParameterCollection collection)
{
CommonParams(model, collection);
collection.AddWithValue("@CreatedBy", userId);
collection.AddWithValue("@ContactId", model.ContactId);
SqlParameter idOut = new SqlParameter("@Id", SqlDbType.Int);
idOut.Direction = ParameterDirection.Output;
collection.Add(idOut);
}, returnParameters : delegate(SqlParameterCollection returnCollection)
{
object objId = returnCollection["@Id"].Value;
int.TryParse(objId.ToString(), out id);
});
return(id);
}
