public IList<GroupRoot> GetGroupRoots()
{
data = new GroupDataAtDataPointRepository().GetGroupDataProcessed(_parameters.ParentAreaCode,
_parameters.AreaTypeId, _parameters.ProfileId, _parameters.GroupId);
return data.GroupRoots ?? new List<GroupRoot>();
}
public void Process(GroupData data, TimePeriodFormatter timePeriodFormatter)
{
if (data.IsDataOk)
{
try
{
var england = AreaFactory.NewArea(areasReader, AreaCodes.England);
foreach (GroupRoot groupRoot in data.GroupRoots)
{
IndicatorMetadata metadata = data.GetIndicatorMetadataById(groupRoot.IndicatorId);
FormatDataAndStats(groupRoot, metadata, timePeriodFormatter);
new GroupRootComparisonManager
{
PholioReader = pholioReader,
TargetComparer = GetTargetComparer(metadata, groupRoot, england)
}
.CompareToCalculateSignficance(groupRoot, metadata);
new CoreDataProcessor(null).TruncateList(groupRoot.Data);
}
}
catch (Exception ex)
{
ExceptionLog.LogException(ex, "");
}
}
}
public void TestInitIndicatorMetadata()
{
List<Grouping> grouping = new List<Grouping>{
new Grouping { IndicatorId = IndicatorIds.LifeExpectancyAtBirth},
new Grouping { IndicatorId = IndicatorIds.IncidenceOfMalignantMelanoma}
};
GroupData data = new GroupData();
data.InitIndicatorMetadata(IndicatorMetadataRepository.Instance.GetIndicatorMetadataCollection(grouping));
Assert.AreEqual(2, data.IndicatorMetadata.Count);
Assert.IsNotNull(data.GetIndicatorMetadataById(IndicatorIds.LifeExpectancyAtBirth));
Assert.IsNull(data.GetIndicatorMetadataById(IndicatorIds.AdultDrugMisuse));
}
public GroupData Build()
{
GroupData = new GroupData();
try
{
ReadGroupings(GroupDataReader);
if (Groupings.Count > 0)
{
if (AssignAreas)
{
GroupData.Areas = GetChildAreas();
}
GroupData.InitIndicatorMetadata(
IndicatorMetadataRepository.Instance.GetIndicatorMetadataCollection(Groupings));
BuildGroupRoots();
if (AssignData)
{
AssignCoreData();
}
// Assign trend markers
var profileReader = ReaderFactory.GetProfileReader();
ProfileConfig profileConfig = profileReader.GetProfileConfig(ProfileId);
if (profileConfig != null && profileConfig.HasTrendMarkers)
{
AssignRecentTrends();
}
}
else
{
GroupData.Clear();
}
}
catch (Exception ex)
{
ExceptionLog.LogException(ex, "");
}
return GroupData;
}
public void Process(GroupData data)
{
Process(data, new DataPointTimePeriodFormatter());
}
private void WriteCoreData(GroupData data, ParentArea parentArea)
{
if (data.IsDataOk)
{
var valueNoteLookUp = ValueNotes.ToDictionary(x => x.Id, x => x.Text);
// Child areas
var childAreaCodes = data.Areas.Select(x => x.Code).ToArray();
var childAreaCodeToAreaMap = data.Areas.ToDictionary(area => area.Code);
// Worksheets
WorksheetInfo childAreaWorksheet = _profileDataWriter.GetWorksheetInfo(_childAreaTypeSheetName);
WorksheetInfo subnationalWorksheet = _profileDataWriter.GetWorksheetInfo(_subnationalAreaTypeSheetName);
WorksheetInfo nationalWorksheet = _profileDataWriter.GetWorksheetInfo(NationalLabel);
// Subnational areas
ParentDataWriter parentDataWriter = ParentDataWriterFactory.New(_areasReader, _groupDataReader,
subnationalWorksheet, _profileDataWriter, _subnationalAreaType);
var parentAreaDataProvider = new CoreDataSetProviderFactory().New(_parentArea);
// No subnational sheet if direct parent area is country
var isSubnationalSheet = subnationalWorksheet != null;
var areMultipleSubnationalAreasRequired = AreMultipleSubnationalAreasRequired();
foreach (var groupRoot in data.GroupRoots)
{
// Check this data has not already been writen
var key = new GroupRootUniqueKey(groupRoot).Key + parentArea.AreaCode;
if (_groupRootKeys.Contains(key))
{
// This added has already been written
continue;
}
_groupRootKeys.Add(key);
var indicatorMetadata = data.GetIndicatorMetadataById(groupRoot.IndicatorId);
// Adding here means order in metadata sheet is same as in data sheet
AddMetadata(indicatorMetadata);
var timePeriodFormatter = new TimePeriodTextFormatter(indicatorMetadata);
var coreDataCollector = new CoreDataCollector();
var grouping = groupRoot.Grouping.FirstOrDefault();
if (grouping != null)
{
var sex = _labelReader.LookUpSexLabel(grouping.SexId);
var age = _labelReader.LookUpAgeLabel(grouping.AgeId);
var timePeriods = grouping.GetTimePeriodIterator(indicatorMetadata.YearType).TimePeriods;
// Write core data
foreach (TimePeriod timePeriod in timePeriods)
{
string timeString = timePeriodFormatter.Format(timePeriod);
var rowLabels = new RowLabels
{
Age = age,
Sex = sex,
TimePeriod = timeString,
IndicatorName = indicatorMetadata.Descriptive[IndicatorMetadataTextColumnNames.Name],
ValueNoteLookUp = valueNoteLookUp
};
// Write child area data
var coreDataList = _groupDataReader.GetCoreData(grouping, timePeriod, childAreaCodes);
_profileDataWriter.AddData(childAreaWorksheet, rowLabels, coreDataList, childAreaCodeToAreaMap, _areaCodeToParentMap);
// Subnational data
if (isSubnationalSheet)
{
if (areMultipleSubnationalAreasRequired)
{
// Multiple parent areas
var dataList = parentDataWriter.AddMultipleAreaData(rowLabels, grouping, timePeriod,
indicatorMetadata, _areaCodeToParentMap);
coreDataCollector.AddDataList(dataList);
}
else
{
// One parent area
var coreData = parentAreaDataProvider.GetData(grouping, timePeriod, indicatorMetadata);
_profileDataWriter.AddData(subnationalWorksheet, rowLabels, coreData, _parentArea);
coreDataCollector.AddData(coreData);
}
}
// Write national data
var nationalData = new CoreDataSetProviderFactory().New(_nationalArea).GetData(grouping, timePeriod, indicatorMetadata);
_profileDataWriter.AddData(nationalWorksheet, rowLabels, nationalData, _nationalArea);
}
// Write trend data
var trendMarkerWriter = TrendMarkerWriterFactory.New(_profileDataWriter, groupRoot.PolarityId, timePeriods, _profile.HasTrendMarkers);
// Child area trend markers
trendMarkerWriter.WriteChildTrendMarkers(childAreaWorksheet, groupRoot.RecentTrends, childAreaCodes);
// Subnational trend markers
if (isSubnationalSheet)
{
if (areMultipleSubnationalAreasRequired)
{
trendMarkerWriter.WriteMultipleSubnationalTrendMarkers(subnationalWorksheet, grouping,
indicatorMetadata, coreDataCollector, parentDataWriter.CategoryIdAndAreaCodes);
}
else
{
trendMarkerWriter.WriteSingleSubnationalTrendMarker(subnationalWorksheet, grouping,
indicatorMetadata, coreDataCollector);
}
}
// National trend markers
trendMarkerWriter.WriteNationalTrendMarkers(nationalWorksheet, groupRoot.RecentTrends,
_nationalArea.Code);
}
}
}
}