public int Add(ListingAddRequest model, int userId)
{
int id = 0;
string procName = "dbo.Listings_Insert_V3";
DataTable paramValue = null;
if (model.Amenities != null)
{
paramValue = MapAmenitiesToTable(model.Amenities);
}
_data.ExecuteNonQuery(procName,
inputParamMapper : delegate(SqlParameterCollection col)
{
//Proprietary code removed
SqlParameter idOut = new SqlParameter("@Id", SqlDbType.Int);
idOut.Direction = ParameterDirection.Output;
col.Add(idOut);
},
returnParameters : delegate(SqlParameterCollection returnCol)
{
object oId = returnCol["@Id"].Value;
Int32.TryParse(oId.ToString(), out id);
});
return(id);
}
public ActionResult <ItemResponse <int> > Create(ListingAddRequest model)
{
ObjectResult result = null;
try
{
int userId = _authService.GetCurrentUserId();
int id = _service.Add(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);
}