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);
        }
Пример #2
0
 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)));
     }
 }