public void CleanStorage()
{
KeepTracking(Trace_StorageCleaning);
using (CourtDBContext dbContext = new CourtDBContext())
{
dbContext.BulkDelete(dbContext.CourtRegions);
}
}
private void InsertAllLocations(Dictionary <string, CourtDistrict> districtsSaved, IEnumerable <IChangeableData> districtsRaw)
{
KeepTracking(Trace_SaveLocations);
List <CourtLocation> locationsToSave = SetParentIdToLocations(districtsSaved, districtsRaw);
using (CourtDBContext dbContext = new CourtDBContext())
dbContext.BulkInsert(locationsToSave);
}
private void InsertAllRegions(IEnumerable <IChangeableData> regionsRaw)
{
KeepTracking(Trace_SaveRegions);
Dictionary <string, CourtRegion> regionDictionary = null;
CourtDBContext dbContext = new CourtDBContext();
using (dbContext)
{
dbContext.BulkInsert(regionsRaw.Cast <CourtRegion>());
regionDictionary = dbContext.CourtRegions.ToDictionary(x => x.Name);
}
InsertAllDistricts(regionDictionary, regionsRaw);
}
private void InsertAllDistricts(Dictionary <string, CourtRegion> regionsSaved, IEnumerable <IChangeableData> regionsRaw)
{
KeepTracking(Trace_SaveDistricts);
List <CourtDistrict> districtsWithParentId = SetParentIdToDistricts(regionsSaved, regionsRaw);
Dictionary <string, CourtDistrict> savedDistricts = null;
using (CourtDBContext dbContext = new CourtDBContext())
{
dbContext.BulkInsert(districtsWithParentId);
savedDistricts = dbContext.CourtDistricts.ToDictionary(x => logger.WarnFormat(Warn_DuplicatedDataFound, x.Name, x.Value));
}
InsertAllLocations(savedDistricts, districtsWithParentId);
}
public IEnumerable <IChangeableData> GetData()
{
KeepTracking(Trace_AllCurtRegionsLoad);
using (CourtDBContext dbContext = new CourtDBContext())
{
logger.InfoFormat(Trace_GetDbData,
dbContext.Database.Connection.Database,
dbContext.Database.Connection.DataSource);
return(dbContext.CourtRegions.Include("CourtDistricts")
.Include("CourtDistricts.CourtLocations")
.ToList());
}
}
