private static string GetSpNameForSourceMaterialLookup(SourceMaterialTypeLookupParameter parameter)
{
string spName;
switch (parameter.LookupType)
{
case SourceMaterialTypeLookupParameter.Material:
spName = "spMaterialTypeTree2";
break;
case SourceMaterialTypeLookupParameter.Source:
spName = "spSourceTypeTree2";
break;
default:
throw new ArgumentOutOfRangeException(nameof(parameter.LookupType));
}
return(spName);
}
public async Task <IEnumerable <SourceMaterialTypeLookupItem> > GetSourceMaterialTypes(SourceMaterialTypeLookupParameter parameter)
{
var spName = GetSpNameForSourceMaterialLookup(parameter);
using (var connection = new SqlConnection(ConnectionString))
{
var result = await connection.QueryAsync <SourceMaterialTypeLookupItem>(spName,
new
{
LanguageID = parameter.Language
},
commandType : CommandType.StoredProcedure);
return(result);
}
}
public async Task <IEnumerable <SourceMaterialTypeLookupItem> > GetSourceMaterialTypeLookup([FromBody] SourceMaterialTypeLookupParameter parameter)
{
return(await _dbService.GetSourceMaterialTypes(parameter));
}
