public IHttpActionResult GetAllInfo(FormUserInfoRequest data) { try { data.UserBaseId = _currentUserId; ItemResponse <string> response = new ItemResponse <string> { Item = _formUserInfoService.GetInfo(data) }; return(Ok(response)); } catch (Exception ex) { return(BadRequest(ex.Message)); } }
public string GetInfo(FormUserInfoRequest data) { string item = ""; DataProvider.ExecuteCmd("dbo.UserProfile_GetInfoFromDropDown", inputParamMapper: (SqlParameterCollection inputs) => { inputs.Add(SqlDbParameter.Instance.BuildParameter("@userBaseId", data.UserBaseId, SqlDbType.Int)); inputs.Add(SqlDbParameter.Instance.BuildParameter("@dbColumns", data.DbColumns, SqlDbType.NVarChar, 2000 )); }, singleRecordMapper: (IDataReader reader, short resultSet) => { item = reader.GetString(0); }); return(item); }