public async Task <ProductImage> GetFirstImage(int idProduct)
{
using (var db = new WPFSampleDb())
{
return(await db.ProductImages.Where(p => p.ProductId == idProduct).FirstOrDefaultAsync());
}
}
public async Task <Product> GetProductById(int id)
{
using (var db = new WPFSampleDb())
{
return(await db.Products.Where(x => x.Id == id).FirstOrDefaultAsync());
}
}
public async Task <IList <Product> > GetAllProducts()
{
using (var db = new WPFSampleDb())
{
return(await db.Products.ToListAsync());
}
}
public async Task DeleteProductAsync(Product product)
{
using (var db = new WPFSampleDb())
{
db.Products.Remove(product);
await db.SaveChangesAsync();
}
}
public async Task AddProductAsync(Product product)
{
using (var db = new WPFSampleDb())
{
await db.Products.AddAsync(product);
await db.SaveChangesAsync();
}
}
protected override async void OnStartup(StartupEventArgs e)
{
base.OnStartup(e);
//criacao de banco de dados
using (var db = new WPFSampleDb())
{
await db.Database.EnsureCreatedAsync();
}
new Bootstrapper().Run();
}
