public async Task <Purchase> GetByID(int purchaseID) { using (var context = new PurchaseTrackerContext()) { return(await context.Purchase .FirstOrDefaultAsync(p => p.PurchaseId == purchaseID)); } }
public async Task <int> AddPurchase(Purchase purchase) { using (var context = new PurchaseTrackerContext()) { context.Purchase.Add(purchase); return(await context.SaveChangesAsync()); } }
public async Task <int> DeleteByID(int purchaseID) { using (var context = new PurchaseTrackerContext()) { var purchase = await context.Purchase.FindAsync(purchaseID); context.Entry(purchase).State = EntityState.Deleted; return(await context.SaveChangesAsync()); } }
public async Task <int> UpdatePurchase(Purchase purchase) { using (var context = new PurchaseTrackerContext()) { var updatePurchase = await context.Purchase.FindAsync(purchase.PurchaseId); context.Entry(updatePurchase).CurrentValues.SetValues(purchase); return(await context.SaveChangesAsync()); } }
public async Task <List <Category> > GetAll() { using (var context = new PurchaseTrackerContext()) { var categories = await context.Category .OrderBy(p => p.CategoryName) .ToListAsync(); return(categories); } }
public async Task <List <Purchase> > GetAll() { using (var context = new PurchaseTrackerContext()) { var purchases = await context.Purchase .Include(p => p.Category) .OrderBy(p => p.PurchaseDate) .ToListAsync(); return(purchases); } }