public static StatisticsInfoRowVM CreateTotalRow(CategoryInfoCollection collection, string title, string effectivePercent = EDOConstants.EMPTY_CURSOR)
{
StatisticsInfoRowVM row = new StatisticsInfoRowVM();
row.Column1 = title;
row.Column2 = collection.TotalFrequencyString;
row.Column3 = collection.TotalPercentString;
row.Column4 = effectivePercent;
return(row);
}
public static StatisticsInfoRowVM CreateMultipleAnswerMissingValueTotalRow(CategoryInfoCollection collection)
{
StatisticsInfoRowVM row = new StatisticsInfoRowVM();
row.Column2 = Resources.TotalInvalidValues;
row.Column3 = collection.TotalFrequencyString;
row.Column4 = collection.TotalPercentString;
row.Column5 = EDOConstants.EMPTY_CURSOR;
row.Column6 = EDOConstants.EMPTY_CURSOR;
row.Column7 = EDOConstants.EMPTY_CURSOR;
return(row);
}
private DocxTableRowParam CreateTotalRow(CategoryInfoCollection collection, ValueConverter converter, string title, string effectivePercent = EDOConstants.EMPTY_CURSOR, bool writeCode = true)
{
DocxTableRowParam rowParam = new DocxTableRowParam();
if (writeCode)
{
rowParam.Add();
}
rowParam.Add(title);
rowParam.AddRight(converter.ToString(collection.TotalFrequencyString));
rowParam.AddRight(converter.ToString(collection.TotalPercentString));
rowParam.AddRight(converter.ToString(effectivePercent));
return(rowParam);
}
private DocxTableRowParam CreateMultiAnswerTotalRow(CategoryInfoCollection collection, ValueConverter converter, string title, string percent, string effectivePercent)
{
DocxTableRowParam rowParam = new DocxTableRowParam();
rowParam.Add();
rowParam.Add();
rowParam.Add(title);
rowParam.AddRight(converter.ToString(collection.TotalFrequencyString));
rowParam.AddRight(converter.ToString(percent));
rowParam.AddRight(converter.ToString(EDOConstants.EMPTY_CURSOR));
rowParam.AddRight(converter.ToString(effectivePercent));
rowParam.AddRight(converter.ToString(EDOConstants.EMPTY_CURSOR));
return(rowParam);
}
public static ObservableCollection <StatisticsInfoRowVM> CreateMultipleAnswerRows(StatisticsInfo statisticsInfo)
{
ObservableCollection <StatisticsInfoRowVM> rows = new ObservableCollection <StatisticsInfoRowVM>();
CategoryInfoCollection[] collections = CategoryInfoCollection.Create(statisticsInfo);
// normal values
CategoryInfoCollection normalCollection = collections[1];
foreach (CategoryInfo normalInfo in normalCollection)
{
StatisticsInfoRowVM row = CreateMultipleAnswerCategoryInfoRow(normalInfo);
rows.Add(row);
}
// normal values subtotal
StatisticsInfoRowVM subTotalRow = CreateMultipleAnswerNormalValueTotalRow(normalCollection);
rows.Add(subTotalRow);
// missing values
CategoryInfoCollection missingCollection = collections[2];
foreach (CategoryInfo missingInfo in missingCollection)
{
StatisticsInfoRowVM row = CreateMultipleAnswerCategoryInfoRow(missingInfo);
rows.Add(row);
}
// missing values subtotal
subTotalRow = CreateMultipleAnswerMissingValueTotalRow(missingCollection);
rows.Add(subTotalRow);
// total responses row
CategoryInfoCollection totalCollection = collections[0];
StatisticsInfoRowVM totalResponseRow = CreateMultipleAnswerTotalResponsesRow(totalCollection);
rows.Add(totalResponseRow);
// total samples row
StatisticsInfoRowVM totalSamplesRow = CreateMultipleAnswerTotalSamplesRow(statisticsInfo.SummaryInfo.TotalCasesString);
rows.Add(totalSamplesRow);
return(rows);
}
public ObservableCollection <StatisticsInfoRowVM> CreateSingleAnswerOrDateTimeRows(StatisticsInfo statisticsInfo)
{
ObservableCollection <StatisticsInfoRowVM> rows = new ObservableCollection <StatisticsInfoRowVM>();
CategoryInfoCollection[] collections = CategoryInfoCollection.Create(statisticsInfo);
// normal values
CategoryInfoCollection normalCollection = collections[1];
foreach (CategoryInfo categoryInfo in normalCollection)
{
StatisticsInfoRowVM row = CreateCategoryInfoRow(categoryInfo);
rows.Add(row);
}
// normal values subtotal
StatisticsInfoRowVM subTotalRow = CreateTotalRow(normalCollection, Resources.TotalValidValues, normalCollection.FullPercent);
rows.Add(subTotalRow);
// missing values
CategoryInfoCollection missingCollection = collections[2];
foreach (CategoryInfo categoryInfo in missingCollection)
{
StatisticsInfoRowVM row = CreateCategoryInfoRow(categoryInfo);
rows.Add(row);
}
// missing values subtotal
subTotalRow = CreateTotalRow(missingCollection, Resources.TotalInvalidValues);
rows.Add(subTotalRow);
// total
CategoryInfoCollection totalCollection = collections[0];
StatisticsInfoRowVM totalRow = CreateTotalRow(totalCollection, Resources.TotalAll);
rows.Add(totalRow);
return(rows);
}
public void RefreshCategories()
{
XDocument doc = XDocument.Load(CategoryUrl);
CategoryInfoCollection categories = new CategoryInfoCollection(this, doc.Element("categories").Elements("categoryInfo"));
ZCache.InsertCache(CategoryCacheKey, categories, Marketplace.CacheTime);
}
private void WriteChoicesSingleAnswerVariable(Body body, CodebookVariable codebookVariable, bool writeCode = true)
{
WriteVariableInfo(body, codebookVariable.FirstVariable);
WriteQuestionInfo(body, codebookVariable.Question);
Paragraph p = CreateEmptyParagraph();
body.Append(p);
Table table = CreateTable();
body.Append(table);
DocxTableRowParam rowParam = new DocxTableRowParam();
if (writeCode)
{
rowParam.Add(Resources.CodeNumber);
}
rowParam.Add(Resources.BranchSentence);
rowParam.Add(Resources.Frequency);
rowParam.Add(Resources.TotalPercent);
rowParam.Add(Resources.TotalEffectivePercent);
table.Append(rowParam.CreateTableRow());
StatisticsInfo statisticsInfo = codebookVariable.StatisticsInfo;
if (statisticsInfo == null)
{
statisticsInfo = StatisticsUtils.CreateDummyChoicesSingleAnswerStatisticsInfo(codebookVariable);
}
ValueConverter converter = new ValueConverter()
{
HasData = codebookVariable.HasData
};
CategoryInfoCollection[] collections = CategoryInfoCollection.Create(statisticsInfo);
// normal values
CategoryInfoCollection normalCollection = collections[1];
foreach (CategoryInfo normalInfo in normalCollection)
{
rowParam = CreateNormalCategoryInfoRow(normalInfo, converter, writeCode);
table.Append(rowParam.CreateTableRow());
}
// normal values subtotal
rowParam = CreateTotalRow(normalCollection, converter, Resources.TotalValidValues, normalCollection.FullPercent, writeCode);
table.Append(rowParam.CreateTableRow());
// missing values
CategoryInfoCollection missingCollection = collections[2];
foreach (CategoryInfo missingInfo in missingCollection)
{
rowParam = CreateMissingOrEmptyCategoryInfoRow(missingInfo, converter, writeCode);
table.Append(rowParam.CreateTableRow());
}
// missing values subtotal
rowParam = CreateTotalRow(missingCollection, converter, Resources.TotalInvalidValues, EDOConstants.EMPTY_CURSOR, writeCode);
table.Append(rowParam.CreateTableRow());
// total
CategoryInfoCollection totalCollection = collections[0];
rowParam = CreateTotalRow(totalCollection, converter, Resources.TotalAll, EDOConstants.EMPTY_CURSOR, writeCode);
table.Append(rowParam.CreateTableRow());
}
private void WriteChoicesMultiAnswerVariable(Body body, CodebookVariable codebookVariable)
{
WriteQuestionInfo(body, codebookVariable.Question);
Paragraph p = CreateEmptyParagraph();
body.Append(p);
Table table = CreateTable();
body.Append(table);
DocxTableRowParam rowParam = new DocxTableRowParam();
rowParam.Add(Resources.VariableName);
rowParam.Add(Resources.CodeNumber);
rowParam.Add(Resources.BranchSentence);
rowParam.Add(Resources.Frequency);
rowParam.Add(Resources.Percent);
rowParam.Add(Resources.CasePercent);
rowParam.Add(Resources.EffectivePercent);
rowParam.Add(Resources.EffectiveCasePercent);
table.Append(rowParam.CreateTableRow());
StatisticsInfo statisticsInfo = codebookVariable.StatisticsInfo;
if (statisticsInfo == null)
{
statisticsInfo = StatisticsUtils.CreateDummyChoicesMultiAnswerStatisticsInfo(codebookVariable);
}
CategoryInfoCollection[] collections = CategoryInfoCollection.Create(statisticsInfo);
ValueConverter converter = new ValueConverter()
{
HasData = codebookVariable.HasData
};
// normal values
CategoryInfoCollection normalCollection = collections[1];
foreach (CategoryInfo normalInfo in normalCollection)
{
rowParam = CreateMultiAnswerCategoryInfoRow(normalInfo, converter, true);
table.Append(rowParam.CreateTableRow());
}
// normal values subtotal
rowParam = CreateMultiAnswerTotalRow(normalCollection, converter, Resources.TotalValidValues, normalCollection.TotalPercentString, normalCollection.FullPercent);
table.Append(rowParam.CreateTableRow());
// missing values
CategoryInfoCollection missingCollection = collections[2];
foreach (CategoryInfo missingInfo in missingCollection)
{
rowParam = CreateMultiAnswerCategoryInfoRow(missingInfo, converter, false);
table.Append(rowParam.CreateTableRow());
}
// missing values subtotal
rowParam = CreateMultiAnswerTotalRow(missingCollection, converter, Resources.TotalInvalidValues, normalCollection.TotalPercentString, EDOConstants.EMPTY_CURSOR);
table.Append(rowParam.CreateTableRow());
CategoryInfoCollection totalCollection = collections[0];
// total responses
rowParam = CreateMultiAnswerTotalRow(totalCollection, converter, Resources.TotalResponses, totalCollection.FullPercent, EDOConstants.EMPTY_CURSOR);
table.Append(rowParam.CreateTableRow());
// total samples
rowParam = CreateMultiAnswerTotalRow(totalCollection, converter, Resources.TotalSamples, EDOConstants.EMPTY_CURSOR, EDOConstants.EMPTY_CURSOR);
table.Append(rowParam.CreateTableRow());
}
