public async Task <bool> UpdateEntry(T Item)
{
try
{
Context = new zModel();
await Context.Database.BeginTransactionAsync();
Context.Set <T>().Update(Item);
await Context.SaveChangesAsync();
Context.Database.CommitTransaction();
return(true);
}
catch
{
Context.Database.RollbackTransaction();
return(false);
}
}
public async Task <bool> AddEntries(T[] Items)
{
try
{
Context = new zModel();
await Context.Database.BeginTransactionAsync();
await Context.Set <T>().AddRangeAsync(Items);
await Context.SaveChangesAsync();
Context.Database.CommitTransaction();
return(true);
}
catch
{
Context.Database.RollbackTransaction();
return(false);
}
}
public async Task <bool> DeleteEntry(object id)
{
try
{
Context = new zModel();
await Context.Database.BeginTransactionAsync();
T Item = await Context.Set <T>().FindAsync(id);
Context.Set <T>().Remove(Item);
await Context.SaveChangesAsync();
Context.Database.CommitTransaction();
return(true);
}
catch
{
Context.Database.RollbackTransaction();
return(false);
}
}
public async Task <bool> DeleteEntries(T[] Items)
{
try
{
Context = new zModel();
await Context.Database.BeginTransactionAsync();
foreach (T Item in Items)
{
Context.Set <T>().Attach(Item);
Context.Set <T>().Remove(Item);
}
await Context.SaveChangesAsync();
Context.Database.CommitTransaction();
return(true);
}
catch
{
Context.Database.RollbackTransaction();
return(false);
}
}
public async Task <int> SaveChangesAsync()
{
return(await context.SaveChangesAsync());
}