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()); }