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