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