public void DeleteItem <T>(int objectId) where T : class, Core.Interfaces.IObjectIdEntity
{
MyDbContext db = new MyDbContext();
T instance = db.Set <T>().First(a => a.ObjectId == objectId);
db.Set <T>().Remove(instance);
db.SaveChanges();
}
public void DeleteItem <T>(T item) where T : class
{
MyDbContext db = new MyDbContext();
db.Set <T>().Remove(item);
db.SaveChanges();
}
public void SaveItem <T>(T item) where T : class
{
MyDbContext db = new MyDbContext();
db.Set <T>().AddOrUpdate(item);
db.SaveChanges();
}
public void SaveList <T>(List <T> itemList) where T : class
{
MyDbContext db = new MyDbContext();
foreach (var item in itemList)
{
db.Set <T>().AddOrUpdate(item);
}
db.SaveChanges();
}
public void SaveOption(string optionKey, string optionValue)
{
MyDbContext db = new MyDbContext();
Option option = db.Options.FirstOrDefault(o => o.OptionKey == optionKey) ?? new Option();
option.OptionKey = optionKey;
option.OptionValue = optionValue;
db.Set <Option>().AddOrUpdate(option);
db.SaveChanges();
}
public bool DoesItemExist <T>(T item) where T : class, Core.Interfaces.IObjectIdEntity
{
MyDbContext db = new MyDbContext();
return(db.Set <T>().Any(i => i.ObjectId == item.ObjectId));
}
public bool DoesItemExist <T>(int objectId) where T : class, Core.Interfaces.IObjectIdEntity
{
MyDbContext db = new MyDbContext();
return(db.Set <T>().Any(a => a.ObjectId == objectId));
}
public T GetItem <T>(int objectId) where T : class, Core.Interfaces.IObjectIdEntity
{
MyDbContext db = new MyDbContext();
return(db.Set <T>().First(a => a.ObjectId == objectId));
}
public List <T> GetList <T>() where T : class
{
MyDbContext db = new MyDbContext();
return(db.Set <T>().ToList());
}