public async Task <Item> GetItemById(string itemId)
{
using (var inventoryDataContext = new InventoryDataContext())
{
return(await inventoryDataContext.Items.FirstOrDefaultAsync(x => x.Id == Convert.ToInt32(itemId)));
}
}
public async Task <List <Item> > GetAllItems()
{
using (var inventoryDataContext = new InventoryDataContext())
{
return(await inventoryDataContext.Items.ToListAsync());
}
}
public async Task <int> AddItem(Item item)
{
using (var inventoryDataContext = new InventoryDataContext())
{
await inventoryDataContext.Items.AddAsync(item);
await inventoryDataContext.SaveChangesAsync();
return(item.Id);
}
}
public async Task <bool> RemoveItem(string itemId)
{
using (var inventoryDataContext = new InventoryDataContext())
{
var itemToBeDeleted = await inventoryDataContext.Items.FirstOrDefaultAsync(x => x.Id == Convert.ToInt32(itemId));
if (itemToBeDeleted != null)
{
inventoryDataContext.Items.Remove(itemToBeDeleted);
await inventoryDataContext.SaveChangesAsync();
return(true);
}
return(false);
}
}
public async Task <bool> UpdateItem(Item item)
{
using (var inventoryDataContext = new InventoryDataContext())
{
var itemToBeUpdated = await inventoryDataContext.Items.FirstOrDefaultAsync(x => x.Id == item.Id);
if (itemToBeUpdated != null)
{
itemToBeUpdated.Price = item.Price;
itemToBeUpdated.Name = item.Name;
itemToBeUpdated.Description = item.Description;
await inventoryDataContext.SaveChangesAsync();
return(true);
}
return(false);
}
}
