public async Task <GetShopDto> Handle(GetShopByIdQuery request, CancellationToken cancellationToken)
{
var shop = await repository.GetById(request.Id);
if (shop == null)
{
throw new ArgumentNullException(nameof(request));
}
List <int> ingredientsId = await context.JoinIngredientShop
.Where(p => p.ShopsId == request.Id)
.Select(p => p.IngredientsId)
.ToListAsync(cancellationToken);
GetShopDto shopDto = new GetShopDto()
{
Id = shop.Id,
Name = shop.Name,
LocationX = shop.LocationX,
LocationY = shop.LocationY,
};
foreach (int i in ingredientsId)
{
IngredientsFromShop ingredient = await context
.Ingredients
.FindAsync(i, cancellationToken);
GetIngredientDto getIngredientDto = new GetIngredientDto();
getIngredientDto.Id = ingredient.Id;
getIngredientDto.Name = ingredient.Name;
getIngredientDto.Price = ingredient.Price;
//voi lua si cantitatea specifica ingredientului din shopul respectiv
int quantity = context.JoinIngredientShop
.Where(p => (p.IngredientsId == ingredient.Id) && (p.ShopsId == shopDto.Id))
.Select(p => p.Quantity)
.FirstOrDefault();
getIngredientDto.Quantity = quantity;
shopDto.Ingredients.Add(getIngredientDto);
}
return(shopDto);
}
public async Task <IEnumerable <GetShopDto> > Handle(GetShopsQuery request, CancellationToken cancellationToken)
{
var shops = repository.GetAll();
List <GetShopDto> listShops = new List <GetShopDto>();
foreach (var shop in shops)
{
List <int> ingredientsId = context.JoinIngredientShop
.Where(p => p.ShopsId == shop.Id)
.Select(p => p.IngredientsId)
.ToList();
GetShopDto shopDto = new GetShopDto()
{
Id = shop.Id,
Name = shop.Name,
LocationX = shop.LocationX,
LocationY = shop.LocationY,
};
foreach (int i in ingredientsId)
{
IngredientsFromShop ingredient = await context.Ingredients.FindAsync(i);
GetIngredientDto getIngredientDto = new GetIngredientDto();
getIngredientDto.Id = ingredient.Id;
getIngredientDto.Name = ingredient.Name;
getIngredientDto.Price = ingredient.Price;
//voi lua si cantitatea specifica ingredientului din shopul respectiv
int quantity = context.JoinIngredientShop
.Where(p => (p.IngredientsId == ingredient.Id) && (p.ShopsId == shopDto.Id))
.Select(p => p.Quantity)
.FirstOrDefault();
getIngredientDto.Quantity = quantity;
shopDto.Ingredients.Add(getIngredientDto);
}
listShops.Add(shopDto);
}
return(listShops);
}
