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