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;
}
public List<ConfigEntry> GetAllConfigurations()
{
List<ConfigEntry> response = new List<ConfigEntry>();
var result = new ConfigDTO();
using (var dbEntities = new TICPuppyLoveDbContext())
{
result.refConfigEntries = dbEntities.GetRefConfigData();
response = result.CreateConfigCollection();
}
return response;
}