public async Task Add(Item item) { using (var context = new Connection(connectionString)) { context.Items.Add(item); await context.SaveChangesAsync(); } }
public async Task Delete(int ItemId) { using (var context = new Connection(connectionString)) { Item item = context.Items.Where(i => i.ItemId == ItemId).FirstOrDefault(); if (item != null) { context.Entry(item).State = EntityState.Deleted; } await context.SaveChangesAsync(); } }
public async Task Update(int itemId, Item item) { using (var context = new Connection(connectionString)) { Item OldItem = context.Items.Where(i => i.ItemId == itemId).FirstOrDefault(); if (OldItem != null) { OldItem.Name = item.Name; context.Entry(OldItem).State = EntityState.Modified; } await context.SaveChangesAsync(); } }