public async Task <IEnumerable <BaseLookupItem> > GetLookup(BaseLookupParameter parameter)
{
using (var connection = new SqlConnection(ConnectionString))
{
var result = await connection.QueryAsync <BaseLookupItem>(
"Select idfsReference, [Name], strDefault, intOrder from fnReferenceLookup(@LanguageID, @LookupType) Order By IsNull(intOrder, 0), [Name]",
new
{
LookupType = parameter.LookupType.ToString(),
LanguageID = parameter.Language
},
commandType : CommandType.Text);
return(result);
}
}
public async Task <IEnumerable <BaseLookupItem> > GetLookup([FromBody] BaseLookupParameter parameter)
{
return(await _dbService.GetLookup(parameter));
}
