public void AddUpdateConfigEntries(ConfigMultiEntries request)
{
using (var context = new TICPuppyLoveDbContext())
{
using (var dbContextTransaction = context.Database.BeginTransaction())
{
context.dbTransaction = dbContextTransaction;
ConfigDTO cdto = new ConfigDTO { configs = request.ConfigEntries };
//set inserts first
cdto.CreateRefConfigNewUserIntances();
if (cdto.refConfigEntries.Count() > 0)
{
context.Add(cdto);
}
//now do updates
cdto.CreateRefConfigUpdateInstances();
if (cdto.refConfigEntries.Count() > 0)
{
context.Update(cdto);
}
// everything good, commit transaction
dbContextTransaction.Commit();
}
}
}
public Int32 DeleteConfigurations(ConfigMultiEntries request)
{
Int32 response = -1;
using (var context = new TICPuppyLoveDbContext())
{
using (var dbContextTransaction = context.Database.BeginTransaction())
{
context.dbTransaction = dbContextTransaction;
ConfigDTO cdto = new ConfigDTO { configs = request.ConfigEntries };
cdto.refConfigEntries = context.GetRefConfigData();
cdto.refConfigEntries = cdto.GetSpecificRefConfigs();
context.Ref_Config.RemoveRange(cdto.refConfigEntries);
response = context.SaveChanges();
// everything good, commit transaction
dbContextTransaction.Commit();
}
}
return response;
}