public IQueryable <VariantValue> GetVariantValues([ScopedService] MundoBalloonContext mundoBalloonContext,
[Service] IMapper mapper, int variantId)
{
var variantValues = mundoBalloonContext.VariantValues.Where(vv => vv.VariantId == variantId);
return(mapper.ProjectTo <VariantValue>(variantValues));
}
public IQueryable <Product> GetAllProducts([ScopedService] MundoBalloonContext mundoBalloonContext,
[Service] IMapper mapper)
{
var products = mundoBalloonContext.Products;
return(mapper.ProjectTo <Product>(products));
}
public IQueryable <ProductCategory> GetProductCategories([ScopedService] MundoBalloonContext mundoBalloonContext,
[Service] IMapper mapper)
{
var productsCategories = mundoBalloonContext.ProductCategories;
return(mapper.ProjectTo <ProductCategory>(productsCategories));
}
public User?GetLoggedInUser([ScopedService] MundoBalloonContext mundoBalloonContext,
[Service] IMapper mapper, [GlobalStateAttribute("currentUser")] CurrentUser currentUser)
{
var result = mundoBalloonContext.Users.Where(u => u.UserId == currentUser.UserId);
var user = result.FirstOrDefault();
return(mapper.Map <User>(user));
}
public ProductVariant?GetProductVariantById([ScopedService] MundoBalloonContext mundoBalloonContext,
[Service] IMapper mapper, int productVariantId)
{
var productVariant = mundoBalloonContext.ProductVariants
.Include(pv => pv.ProductVariantMedia)
.Include(pv => pv.ProductVariantValues)
.FirstOrDefault(p => p.ProductVariantId == productVariantId);
return(productVariant != null?mapper.Map <ProductVariant>(productVariant) : null);
}
protected RepositoriesFixture(IUsersRepository usersRepository)
{
UsersRepository = usersRepository;
const string connectionString = "Server=localhost;Database=mundoBalloon_test;User=root;Password=#Labs2013;";
var builder = new DbContextOptionsBuilder <MundoBalloonContext>();
builder.UseMySql(connectionString, new MySqlServerVersion("8.0.22"));
var options = builder.Options;
MundoBalloonContext = new MundoBalloonContext(options);
}
public Product?GetProductById([ScopedService] MundoBalloonContext mundoBalloonContext,
[Service] IMapper mapper, int productId)
{
var product = mundoBalloonContext.Products
.Include(p => p.ProductCategory)
.Include(p => p.ProductVariants)
.ThenInclude(pv => pv.ProductVariantMedia)
.IgnoreAutoIncludes()
.FirstOrDefault(p => p.ProductId == productId);
return(product != null?mapper.Map <Product>(product) : null);
}
public IQueryable <ProductEntity> GetProductsEntity([ScopedService] MundoBalloonContext mundoBalloonContext,
[Service] IMapper mapper)
{
var products = mundoBalloonContext.Products.Select(p => new ProductEntity
{
ProductId = p.ProductId,
Name = p.ProductName ?? string.Empty,
Description = p.ProductDescription ?? string.Empty,
Price = p.Price,
ProductCategoryId = p.ProductCategoryId
});
return(products);
}
public IQueryable <ProductVariantEntity> GetProductVariantsEntityById(
[ScopedService] MundoBalloonContext mundoBalloonContext,
[Service] IMapper mapper, int productId)
{
var products = mundoBalloonContext.ProductVariants.Where(pv => pv.ProductId == productId).Select(p =>
new ProductVariantEntity
{
ProductVariantId = p.ProductVariantId,
Sku = p.Sku ?? string.Empty,
ProductId = p.ProductId,
Price = p.Price,
Name = p.ProductVariantName ?? string.Empty,
Description = p.ProductVariantDescription ?? string.Empty
});
return(products);
}
public IQueryable <Variant> GetVariants([ScopedService] MundoBalloonContext mundoBalloonContext,
[Service] IMapper mapper)
{
return(mapper.ProjectTo <Variant>(mundoBalloonContext.Variants));
}
public IQueryable <CountryCode> GetCountryCodes([ScopedService] MundoBalloonContext mundoBalloonContext)
{
return(mundoBalloonContext.CountryCodes.Where(cc => cc.Supported == true));
}
