public async Task <IEnumerable <FlavorView> > Query()
{
try
{
var result = _mapper.Map <IEnumerable <FlavorView> >(await _flavorRepository.Query <Flavor>("Select Id, Name, Price from Flavor order by Name"));
return(result);
}
catch (Exception ex)
{
NotifyError(ex.Message);
return((IEnumerable <FlavorView>)BadRequest(ex.Message));
}
}
private async Task PrepareFlavors(IEnumerable <List <long> > selectFlavors)
{
foreach (var idFlavors in selectFlavors)
{
foreach (var flavorId in idFlavors)
{
var flavors = await _flavorRepository.Query <Flavor>("Select * from Flavor nolock where Id =@flavorId", new { flavorId });
if (!flavors.Any())
{
_notifier.SetNotification(new Notification("Sabor não encontrado"));
return;
}
_flavors.Add(flavors.FirstOrDefault());
}
}
}