public async Task <int> AddItem(Item item)
{
using (var db = new LoetopiaContext())
{
db.Items.Add(item);
if (await db.SaveChangesAsync() > 0)
{
return(item.ItemId);
}
return(0);
}
}
public async Task <bool> AddAttribute(DataAccess.Attribute attribute)
{
using (var db = new LoetopiaContext())
{
db.Attributes.Add(attribute);
if (await db.SaveChangesAsync() > 0)
{
return(true);
}
return(false);
}
}
public async Task <bool> AddItemAttribute(ItemAttribute itemAttribute)
{
using (var db = new LoetopiaContext())
{
db.ItemAttributes.Add(itemAttribute);
if (await db.SaveChangesAsync() > 0)
{
return(true);
}
return(false);
}
}
public async Task <bool> AddItemImages(int id, byte[] image)
{
using (var db = new LoetopiaContext())
{
db.ItemImages.Add(new ItemImage()
{
ItemId = id, Image = image
});
if (await db.SaveChangesAsync() > 0)
{
return(true);
}
return(false);
}
}
public async Task <bool> RemoveItem(int id)
{
using (var db = new LoetopiaContext())
{
var entity = db.Items.Where(x => x.ItemId == id).FirstOrDefault();
entity.Active = false;
db.Entry(entity).State = EntityState.Modified;
if (await db.SaveChangesAsync() > 0)
{
return(true);
}
return(false);
}
}
public async Task <bool> UpdateItem(int id, Item item)
{
using (var db = new LoetopiaContext())
{
if (id != item.ItemId)
{
return(false);
}
db.Entry(item).State = EntityState.Modified;
if (await db.SaveChangesAsync() > 0)
{
return(true);
}
return(false);
}
}
