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