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); }