private TwoxTwoTableDTO CreateDTO(GadgetParameters gp, DashboardHelper dh, DataTable table) { int YesRowIndexExp = 1; int NoRowIndexExp = 0; int YesRowIndexOut = 1; int NoRowIndexOut = 2; if (dh.GetColumnType(gp.MainVariableName.ToString()).ToLower() != "system.string") { YesRowIndexExp = FindYesRowIndex(table); NoRowIndexExp = FindNoRowIndex(table); } if (dh.GetColumnType(gp.CrosstabVariableName.ToString()).ToLower() != "system.string") { YesRowIndexOut = FindYesColIndex(table); NoRowIndexOut = FindNoColIndex(table); } TwoxTwoTableDTO ttDTO = new TwoxTwoTableDTO { Yy = int.Parse(table.Rows[YesRowIndexExp][YesRowIndexOut].ToString()), Yn = int.Parse(table.Rows[YesRowIndexExp][NoRowIndexOut].ToString()), Ny = int.Parse(table.Rows[NoRowIndexExp][YesRowIndexOut].ToString()), Nn = int.Parse(table.Rows[NoRowIndexExp][NoRowIndexOut].ToString()) }; //Yy = int.Parse(table.Rows[1][1].ToString()), // Yn = int.Parse(table.Rows[1][2].ToString()), // Ny = int.Parse(table.Rows[0][1].ToString()), // Nn = int.Parse(table.Rows[0][2].ToString()) //ttDTO.Rows[0, 1] = int.Parse(table.Rows[0][1].ToString()); //ttDTO.Rows[0, 2] = int.Parse(table.Rows[0][2].ToString()); //ttDTO.Rows[1, 1] = int.Parse(table.Rows[1][1].ToString()); //ttDTO.Rows[1, 2] = int.Parse(table.Rows[1][2].ToString()); ttDTO.ColumnName1 = table.Columns[1].ColumnName; ttDTO.ColumnName2 = table.Columns[2].ColumnName; return(ttDTO); }
//void Swap2x2RowValues(DataTable table) //{ // if (table.Rows.Count > 2 || table.Columns.Count > 3) // { // return; // cannot do an invalid 2x2 table // } // object row1Col1 = table.Rows[0][1]; // object row1Col2 = table.Rows[0][2]; // object row2Col1 = table.Rows[1][1]; // object row2Col2 = table.Rows[1][2]; // table.Rows[0][1] = row2Col1; // table.Rows[0][2] = row2Col2; // table.Rows[1][1] = row1Col1; // table.Rows[1][2] = row1Col2; // object firstRowName = table.Rows[0][0]; // table.Rows[0][0] = table.Rows[1][0]; // table.Rows[1][0] = firstRowName; //} //void Swap2x2ColValues(DataTable table) //{ // if (table.Rows.Count > 2 || table.Columns.Count > 3) // { // return; // cannot do an invalid 2x2 table // } // object row1Col1 = table.Rows[0][1]; // object row1Col2 = table.Rows[0][2]; // object row2Col1 = table.Rows[1][1]; // object row2Col2 = table.Rows[1][2]; // table.Rows[0][1] = row1Col2; // table.Rows[0][2] = row1Col1; // table.Rows[1][1] = row2Col2; // table.Rows[1][2] = row2Col1; // string firstColumnName = table.Columns[1].ColumnName; // string secondColumnName = table.Columns[2].ColumnName; // table.Columns[1].ColumnName = "_COL1_"; // table.Columns[2].ColumnName = "_COL2_"; // table.Columns[1].ColumnName = secondColumnName; // table.Columns[2].ColumnName = firstColumnName; //} private TwoxTwoAndMxNResultsSet Setup2x2(GadgetParameters gadgetOptions, TwoxTwoAndMxNResultsSet resultSet) { GridCells gridCells = new GridCells(); TwoxTwoTableDTO table = resultSet.TwoxTwoTableDTO; DataTable dt = resultSet.FreqResultsDataTable; if (table != null) // && table.Rows.Length != 0) { //if (gadgetOptions.InputVariableList.ContainsKey("smarttable") && gadgetOptions.InputVariableList["smarttable"].Equals("true")) //{ // CheckLabels(table); //} gridCells.yyVal = Convert.ToInt32(dt.Rows[0][1].ToString()); //table.Yy; gridCells.ynVal = Convert.ToInt32(dt.Rows[0][2].ToString()); //table.Yn; gridCells.nyVal = Convert.ToInt32(dt.Rows[1][1].ToString()); //table.Ny; gridCells.nnVal = Convert.ToInt32(dt.Rows[1][2].ToString()); //table.Nn; gridCells.ntVal = gridCells.nnVal + gridCells.nyVal; gridCells.ytVal = gridCells.yyVal + gridCells.ynVal; gridCells.ttVal = gridCells.ytVal + gridCells.ntVal; gridCells.tyVal = gridCells.yyVal + gridCells.nyVal; gridCells.tnVal = gridCells.ynVal + gridCells.nnVal; if (gridCells.ytVal != 0) { gridCells.yyRowPct = 1.0 * gridCells.yyVal / gridCells.ytVal; gridCells.ynRowPct = 1.0 * gridCells.ynVal / gridCells.ytVal; } if (gridCells.ntVal != 0) { gridCells.nyRowPct = 1.0 * gridCells.nyVal / gridCells.ntVal; gridCells.nnRowPct = 1.0 * gridCells.nnVal / gridCells.ntVal; } if (gridCells.tyVal != 0) { gridCells.yyColPct = 1.0 * gridCells.yyVal / gridCells.tyVal; gridCells.nyColPct = 1.0 * gridCells.nyVal / gridCells.tyVal; } if (gridCells.tnVal != 0) { gridCells.ynColPct = 1.0 * gridCells.ynVal / gridCells.tnVal; gridCells.nnColPct = 1.0 * gridCells.nnVal / gridCells.tnVal; } if (gridCells.ttVal != 0) { gridCells.tyRowPct = 1.0 * gridCells.tyVal / gridCells.ttVal; gridCells.tnRowPct = 1.0 * gridCells.tnVal / gridCells.ttVal; gridCells.ytColPct = 1.0 * gridCells.ytVal / gridCells.ttVal; gridCells.ntColPct = 1.0 * gridCells.ntVal / gridCells.ttVal; } if (gridCells.tyVal > 0 && gridCells.tnVal > 0 && gridCells.ytVal > 0 && gridCells.ntVal > 0) { //gridCells.singleTableResults = new StatisticsRepository.cTable().SigTable( // (double)gridCells.yyVal, (double)gridCells.ynVal, // (double)gridCells.nyVal, (double)gridCells.nnVal, 0.95); StatisticsRepository.cTable.SingleTableResults stab = new StatisticsRepository.cTable().SigTable( (double)gridCells.yyVal, (double)gridCells.ynVal, (double)gridCells.nyVal, (double)gridCells.nnVal, 0.95); //gridCells.singleTableResults = new MySingleTableResults() //{ // ChiSquareMantel2P = stab.ChiSquareMantel2P, // ChiSquareUncorrected2P = stab.ChiSquareUncorrected2P, // ChiSquareMantelVal = stab.ChiSquareMantel2P //} gridCells.singleTableResults = new MySingleTableResults() { ChiSquareMantel2P = stab.ChiSquareMantel2P, ChiSquareMantelVal = stab.ChiSquareMantelVal, ChiSquareUncorrected2P = stab.ChiSquareUncorrected2P, ChiSquareUncorrectedVal = stab.ChiSquareUncorrectedVal, ChiSquareYates2P = stab.ChiSquareYates2P, ChiSquareYatesVal = stab.ChiSquareYatesVal, ErrorMessage = stab.ErrorMessage, FisherExact2P = stab.FisherExact2P, FisherExactP = stab.FisherExactP, MidP = stab.MidP, OddsRatioEstimate = stab.OddsRatioEstimate, OddsRatioLower = stab.OddsRatioLower, OddsRatioMLEEstimate = stab.OddsRatioMLEEstimate, OddsRatioMLEFisherLower = stab.OddsRatioMLEFisherLower, OddsRatioMLEFisherUpper = stab.OddsRatioMLEFisherUpper, OddsRatioMLEMidPLower = stab.OddsRatioMLEMidPLower, OddsRatioMLEMidPUpper = stab.OddsRatioMLEMidPUpper, OddsRatioUpper = stab.OddsRatioUpper, RiskDifferenceEstimate = stab.RiskDifferenceEstimate, RiskDifferenceLower = stab.RiskDifferenceLower, RiskDifferenceUpper = stab.RiskDifferenceUpper, RiskRatioEstimate = stab.RiskRatioEstimate, RiskRatioLower = stab.RiskRatioLower, RiskRatioUpper = stab.RiskRatioUpper }; } } if (gridCells.singleTableResults != null && !string.IsNullOrEmpty(gridCells.singleTableResults.ErrorMessage)) { //this.Dispatcher.BeginInvoke(new SimpleCallback(ClearSingleResults)); //this.Dispatcher.BeginInvoke(new ShowErrorMessage(ShowError), gridCells.singleTableResults.ErrorMessage); // this.Dispatcher.BeginInvoke(new RenderFinishWithErrorDelegate(RenderFinishWithError), gridCells.singleTableResults.ErrorMessage); // RenderFinishWithError(gridCells.singleTableResults.ErrorMessage); // resultSet.AddError(thisStringLiterals.RenderFinishWithError, gridCells.singleTableResults.ErrorMessage); //stopwatch.Stop(); //Debug.Print("2x2 table gadget took " + stopwatch.Elapsed.ToString() + " seconds to complete with " + dashboardHelper.RecordCount.ToString() + " records and the following filters:"); //Debug.Print(dashboardHelper.DataFilters.GenerateDataFilterString()); } else { // RenderGridCells(gridCells, table); // RenderFinish(); resultSet.GridCells = gridCells; } return(resultSet); }
public TwoxTwoAndMxNResultsSet EvaluateData(GadgetParameters clientGadgetOptions, List <EwavDataFilterCondition> ewavDataFilters, List <EwavRule_Base> rules) { TwoxTwoAndMxNResultsSet twoxTwoResultsSet = new TwoxTwoAndMxNResultsSet(); bool exceededMaxColumns = false; twoxTwoResultsSet.exceededMaxColumns = exceededMaxColumns; try { GadgetParameters gadgetOptions = new GadgetParameters(); gadgetOptions = Utilities.Clone <GadgetParameters>(clientGadgetOptions); gadgetOptions.ShouldIncludeFullSummaryStatistics = false; gadgetOptions.ShouldSortHighToLow = false; gadgetOptions.ShouldUseAllPossibleValues = false; gadgetOptions.StrataVariableNames = new List <string>(); if (gadgetOptions.InputVariableList.ContainsKey("smarttable")) { smartTable = Convert.ToBoolean(gadgetOptions.InputVariableList["smarttable"].ToString()); } DashboardHelper dashboardHelper = new DashboardHelper(gadgetOptions, ewavDataFilters, rules); var candidateRules = rules.Where(rule => rule.VaraiableName == gadgetOptions.MainVariableName); // before push > deprecate the use of MainVariableName List <string> groupVariables = new List <string>(); if (candidateRules.Count() > 0) { var groupVariableCandidate = candidateRules.ToList()[0]; // before push > interate through list if (groupVariableCandidate.VaraiableDataType == "GroupVariable") { groupVariables = ((EwavRule_GroupVariable)groupVariableCandidate).Items.Select(i => i.VarName).ToList(); } } List <string> allGroupFields = dashboardHelper.GetAllGroupsAsList(); string firstColumnName = string.Empty; int columnCount = gadgetOptions.ColumnNames.Count; if (gadgetOptions.ColumnNames.Count() > 0) { firstColumnName = gadgetOptions.ColumnNames[0].VarName; } Dictionary <DataTable, List <DescriptiveStatistics> > stratifiedFrequencyTables = new Dictionary <DataTable, List <DescriptiveStatistics> >(); if (groupVariables.Count == 0) { groupVariables.Add(gadgetOptions.MainVariableName); } gadgetOptions.MainVariableNames = new List <string>(); Dictionary <DataTable, List <DescriptiveStatistics> > tableDictionary = new Dictionary <DataTable, List <DescriptiveStatistics> >(); foreach (string groupVariableName in groupVariables) { gadgetOptions.MainVariableNames.Add(groupVariableName); gadgetOptions.MainVariableName = groupVariableName; tableDictionary = dashboardHelper.GenerateFrequencyTable(gadgetOptions); if (tableDictionary.Count > 0) { foreach (KeyValuePair <DataTable, List <DescriptiveStatistics> > kvp in tableDictionary) { stratifiedFrequencyTables.Add(kvp.Key, kvp.Value); } if (tableDictionary.Count > 0) { var table = tableDictionary.First().Key; if (table.Rows.Count == 2 && table.Columns.Count == 3) { twoxTwoResultsSet.Is2x2 = true; } else { twoxTwoResultsSet.Is2x2 = false; } } } } if (stratifiedFrequencyTables == null || stratifiedFrequencyTables.Count == 0) { return(twoxTwoResultsSet); } else { List <DescriptiveStatistics> statsList = new List <DescriptiveStatistics>(); DataTable table; foreach (KeyValuePair <DataTable, List <DescriptiveStatistics> > tableKvp in stratifiedFrequencyTables) { statsList = tableKvp.Value; table = tableKvp.Key; CreateSmartTable(table); twoxTwoResultsSet.FreqResultsDataTable = table; TwoxTwoTableDTO twoxTwoTableDTO = this.CreateDTO(gadgetOptions, dashboardHelper, table); twoxTwoResultsSet.TwoxTwoTableDTO = twoxTwoTableDTO; twoxTwoResultsSet = this.Setup2x2(clientGadgetOptions, twoxTwoResultsSet); twoxTwoResultsSet.AddResult(table, gadgetOptions.CrosstabVariableName, statsList, twoxTwoResultsSet.GridCells); double count = 0; foreach (DescriptiveStatistics ds in tableKvp.Value) { count = count + ds.Observations; } if (count == 0 && stratifiedFrequencyTables.Count == 1) { return(twoxTwoResultsSet); } } } } catch (Exception ex) { twoxTwoResultsSet.Errors.Add(new MyString(ex.Message)); } return(twoxTwoResultsSet); }
// public void PortThistoClient(StringLiterals sl) { } public void PortClassToClient4(TwoxTwoTableDTO gp) { }