public int Add(BusinessVenturesAddRequest model) { int id = 0; _dataProvider.ExecuteNonQuery("dbo.BusinessVentures_Insert", inputParamMapper : delegate(SqlParameterCollection parm) { SqlParameter retreiveSqlVal = new SqlParameter(); retreiveSqlVal.DbType = DbType.Int32; retreiveSqlVal.Direction = ParameterDirection.Output; retreiveSqlVal.ParameterName = "@Id"; parm.Add(retreiveSqlVal); parm.AddWithValue("@UserId", model.UserId); parm.AddWithValue("@Name", model.Name); parm.AddWithValue("@StatusId", model.StatusId); parm.AddWithValue("@BusinessTypeId", model.BusinessTypeId); parm.AddWithValue("@IndustryTypeId", model.IndustryTypeId); parm.AddWithValue("@ProjectedAnnualBusinessIncome", model.ProjectedAnnualBusinessIncome); parm.AddWithValue("@AnnualBusinessIncome", model.AnnualBusinessIncome); parm.AddWithValue("@YearsInBusiness", model.YearsInBusiness); parm.AddWithValue("@ImageUrl", model.ImageUrl); parm.AddWithValue("@AddressId", model.AddressId); }, returnParameters : delegate(SqlParameterCollection param) { Int32.TryParse(param["@Id"].Value.ToString(), out id); } ); return(id); }
public ActionResult <ItemResponse <int> > Add(BusinessVenturesAddRequest model) { try { int id = _businessVenturesService.Add(model); ItemResponse <int> resp = new ItemResponse <int>(); resp.Item = id; return(Created201(resp)); } catch (Exception ex) { Logger.LogError(ex.ToString()); return(StatusCode(500, new ErrorResponse(ex.Message))); } }