public IHttpActionResult InsertForm(FormBuilderAddRequest data) { try { data.CreatedById = _currentUserId; if (!ModelState.IsValid) { return(BadRequest(ModelState)); } ItemResponse <int> response = new ItemResponse <int> { Item = _formService.InsertForm(data) }; return(Ok(response)); } catch (Exception ex) { return(BadRequest(ex.Message)); } }
public int InsertForm(FormBuilderAddRequest data) { int returnValue = 0; DataProvider.ExecuteNonQuery("dbo.Form_Insert", inputParamMapper: (SqlParameterCollection inputs) => { inputs.Add(SqlDbParameter.Instance.BuildParameter("@ScholarshipId", data.ScholarshipId, SqlDbType.Int)); inputs.Add(SqlDbParameter.Instance.BuildParameter("@Form", data.Form, SqlDbType.NVarChar, -1)); inputs.Add(SqlDbParameter.Instance.BuildParameter("@CreatedById", data.CreatedById, SqlDbType.Int)); SqlParameter idOut = new SqlParameter("@Id", 0); idOut.Direction = ParameterDirection.Output; inputs.Add(idOut); }, returnParameters: (SqlParameterCollection inputs) => { int.TryParse(inputs["@Id"].Value.ToString(), out returnValue); } ); return(returnValue); }