private static void AddParamMapper(BusinessProfilesAddRequest model, SqlParameterCollection parms)
{
var nullValue = (object)(DBNull.Value);
parms.AddWithValue("@Name", model.Name);
parms.AddWithValue("@BusinessStageId", model.BusinessStageId);
parms.AddWithValue("@BusinessTypeId", model.BusinessTypeId);
parms.AddWithValue("@IndustryTypeId", model.IndustryTypeId);
parms.AddWithValue("@ProjectedAnnualBusinessIncome", model.ProjectedAnnualBusinessIncome ?? nullValue);
parms.AddWithValue("@AnnualBusinessIncome", model.AnnualBusinessIncome ?? nullValue);
parms.AddWithValue("@YearsInBusiness", model.YearsInBusiness ?? nullValue);
parms.AddWithValue("@ImageUrl", model.ImageUrl);
parms.AddWithValue("@AddressId", model.AddressId ?? nullValue);
}
public ActionResult <ItemResponse <int> > Create(BusinessProfilesAddRequest model)
{
ObjectResult result = null;
try
{
int userId = _authService.GetCurrentUserId();
int id = _service.Create(model, userId);
ItemResponse <int> response = new ItemResponse <int>();
result = Created201(response);
}
catch (Exception ex)
{
Logger.LogError(ex.ToString());
ErrorResponse response = new ErrorResponse(ex.Message);
result = StatusCode(500, response);
}
return(result);
}
public int Create(BusinessProfilesAddRequest model, int userId)
{
int retVal = 0;
_dataProvider.ExecuteNonQuery("dbo.BusinessProfiles_Insert", inputParamMapper : delegate(SqlParameterCollection parms)
{
SqlParameter parm = new SqlParameter();
parm.ParameterName = "@Id";
parm.SqlDbType = SqlDbType.Int;
parm.Direction = ParameterDirection.Output;
parms.Add(parm);
parms.AddWithValue("@UserId", userId);
AddParamMapper(model, parms);
parms.AddWithValue("@CreatedBy", userId);
parms.AddWithValue("@ModifiedBy", userId);
}, returnParameters : delegate(SqlParameterCollection parms)
{
Int32.TryParse(parms["@Id"].Value.ToString(), out retVal);
});
return(retVal);
}
