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