Example #1
0
        // POST api/<controller>
        public HttpResponseMessage Post([FromBody]      JObject value)
        {
            CombinedFrequencyDomainService CFDS        = new CombinedFrequencyDomainService();
            HttpResponseMessage            ReturnedObj = null;
            GadgetParameters     GadgetParameters      = null;
            ControllerCommon     CommonClass           = new ControllerCommon();
            List <EwavRule_Base> Rules = new List <EwavRule_Base>();

            JObject gadgetJSON = (JObject)value["gadget"];


            CFDS = new CombinedFrequencyDomainService();
            EwavCombinedFrequencyGadgetParameters CombinedParameters = new EwavCombinedFrequencyGadgetParameters();

            CombinedParameters.CombineMode     = (CombineModeTypes)Enum.Parse(typeof(CombineModeTypes), gadgetJSON["combinedmode"].ToString());
            CombinedParameters.ShowDenominator = Convert.ToBoolean(gadgetJSON["showdenominator"].ToString());
            CombinedParameters.SortHighToLow   = Convert.ToBoolean(gadgetJSON["sort"].ToString());
            CombinedParameters.TrueValue       = (gadgetJSON["truevalue"].ToString().Trim().Length == 0 ? null : value["truevalue"].ToString());


            GadgetParameters = new GadgetParameters();

            GadgetParameters.DatasourceName    = gadgetJSON["@DatasourceName"].ToString();
            GadgetParameters.MainVariableName  = gadgetJSON["mainVariable"].ToString();
            GadgetParameters.InputVariableList = new Dictionary <string, string>();
            GadgetParameters.InputVariableList.Add("tableName", gadgetJSON["@DatasourceName"].ToString());

            GadgetParameters.TableName = CommonClass.GetDatabaseObject(GadgetParameters.DatasourceName);

            string groupVar = gadgetJSON["mainVariable"].ToString();

            List <EwavDataFilterCondition> dashboardFilters = new List <EwavDataFilterCondition>();


            Rules = CommonClass.ReadRules(value);

            dashboardFilters = CommonClass.GetFilters(value);


            GadgetParameters.GadgetFilters = CommonClass.GetFilters(gadgetJSON, true);



            DatatableBag dtBag = CFDS.GenerateCombinedFrequency(CombinedParameters, groupVar, GadgetParameters, dashboardFilters, Rules);

            ReturnedObj = new HttpResponseMessage()
            {
                Content = new StringContent(Newtonsoft.Json.JsonConvert.SerializeObject(dtBag))
            };

            ReturnedObj.Content.Headers.ContentType = new MediaTypeHeaderValue("application/json");


            return(ReturnedObj);
        }
Example #2
0
        // POST api/<controller>
        public HttpResponseMessage Post([FromBody]      JObject value)
        {
            ScatterDomainService ScatterDomainService = new Ewav.Web.Services.ScatterDomainService();
            GadgetParameters     GadgetParameters;
            ControllerCommon     CommonClass = new ControllerCommon();
            List <EwavRule_Base> Rules       = new List <EwavRule_Base>();

            Google.DataTable.Net.Wrapper.DataTable dt = null;
            JObject chartJSON = (JObject)value["chart"];

            List <EwavDataFilterCondition> dashboardFilters = new List <EwavDataFilterCondition>();


            GadgetParameters = new GadgetParameters();

            GadgetParameters.DatasourceName    = chartJSON["@DatasourceName"].ToString();
            GadgetParameters.InputVariableList = new Dictionary <string, string>();

            GadgetParameters.TableName = CommonClass.GetDatabaseObject(GadgetParameters.DatasourceName);

            Mapper Mapper = new Controllers.Mapper();

            GadgetParameters.MainVariableName     = chartJSON["xAxisVariable"].ToString();
            GadgetParameters.CrosstabVariableName = chartJSON["yAxisVariable"].ToString();

            Rules = CommonClass.ReadRules(value);

            dashboardFilters = CommonClass.GetFilters(value);

            GadgetParameters.GadgetFilters = CommonClass.GetFilters(chartJSON, true);

            dt = new Google.DataTable.Net.Wrapper.DataTable();


            ScatterDataDTO ScatterDTO = ScatterDomainService.GenerateTable(
                GadgetParameters,
                dashboardFilters,
                Rules,
                CommonClass.AdvancedDataFilterString);

            //if (ScatterDTO.RegresResults.Variables != null)
            //{
            decimal coefficient = Convert.ToDecimal(ScatterDTO.RegresResults.Variables[0].Coefficient);
            decimal constant    = Convert.ToDecimal(ScatterDTO.RegresResults.Variables[1].Coefficient);

            NumericDataValue newMaxValue = new NumericDataValue();

            newMaxValue.IndependentValue = ScatterDTO.MaxValue.IndependentValue + 1;
            newMaxValue.DependentValue   = (coefficient * ScatterDTO.MaxValue.IndependentValue) + constant;
            NumericDataValue newMinValue = new NumericDataValue();

            newMinValue.IndependentValue = ScatterDTO.MinValue.IndependentValue - 1;
            newMinValue.DependentValue   = (coefficient * ScatterDTO.MinValue.IndependentValue) + constant;


            //}

            dt.AddColumn(new Column(ColumnType.Number, "X", "X"));
            dt.AddColumn(new Column(ColumnType.Number, GadgetParameters.MainVariableName, GadgetParameters.MainVariableName));
            dt.AddColumn(new Column(ColumnType.Number, GadgetParameters.CrosstabVariableName, GadgetParameters.CrosstabVariableName));

            Row r = dt.NewRow();

            r.AddCellRange(new Cell[]
            {
                new Cell(newMinValue.IndependentValue),
                new Cell(newMinValue.DependentValue),
                new Cell(null)
            }
                           );

            dt.AddRow(r);
            r = dt.NewRow();
            r.AddCellRange(new Cell[]
            {
                new Cell(newMaxValue.IndependentValue),
                new Cell(newMaxValue.DependentValue),
                new Cell(null)
            }
                           );

            dt.AddRow(r);
            foreach (var item in ScatterDTO.DataValues)
            {
                r = dt.NewRow();
                r.AddCellRange(new Cell[]
                {
                    new Cell(item.IndependentValue),
                    new Cell(null),
                    new Cell(item.DependentValue)
                }
                               );
                dt.AddRow(r);
            }



            var obj = new HttpResponseMessage()
            {
                Content = new StringContent(dt.GetJson())
            };


            obj.Content.Headers.ContentType = new MediaTypeHeaderValue("application/json");

            return(obj);
        }
Example #3
0
        // POST api/<controller>
        public HttpResponseMessage Post([FromBody]      JObject value)
        {
            LinearRegressionDomainService LinearRegressionDomainService = new LinearRegressionDomainService();
            GadgetParameters     GadgetParameters;
            ControllerCommon     CommonClass = new ControllerCommon();
            List <EwavRule_Base> Rules       = new List <EwavRule_Base>();

            JObject gadgetJSON = (JObject)value["gadget"];

            List <EwavDataFilterCondition> dashboardFilters = new List <EwavDataFilterCondition>();


            GadgetParameters = new GadgetParameters();

            GadgetParameters.DatasourceName    = gadgetJSON["@DatasourceName"].ToString();
            GadgetParameters.InputVariableList = new Dictionary <string, string>();

            GadgetParameters.TableName = CommonClass.GetDatabaseObject(GadgetParameters.DatasourceName);

            Mapper Mapper = new Controllers.Mapper();



            Rules = CommonClass.ReadRules(value);

            dashboardFilters = CommonClass.GetFilters(value);

            GadgetParameters.GadgetFilters = CommonClass.GetFilters(gadgetJSON, true);


            List <string> columnNames = new List <string>();
            Dictionary <string, string> inputVariableList = Mapper.MapJSONToRegressionInputVariableList(gadgetJSON);

            foreach (KeyValuePair <string, string> kvp in inputVariableList)
            {
                if (kvp.Value.ToLower().Equals("unsorted") || kvp.Value.ToLower().Equals("dependvar") || kvp.Value.ToLower().Equals("weightvar") || kvp.Value.ToLower().Equals("matchvar"))
                {
                    columnNames.Add(kvp.Key);
                }
                else if (kvp.Value.ToLower().Equals("discrete"))
                {
                    columnNames.Add(kvp.Key);
                }
            }
            List <DictionaryDTO> inputDtoList = new List <DictionaryDTO>();


            inputDtoList = Mapper.MapDictToList(inputVariableList);

            LinRegressionResults LinRegressionResults = LinearRegressionDomainService.GetRegressionResult(
                GadgetParameters,
                columnNames,
                inputDtoList,
                dashboardFilters,
                Rules,
                CommonClass.AdvancedDataFilterString);

            LinRegressionResults = Mapper.FormatLinRegressionResults(LinRegressionResults);



            var obj = new HttpResponseMessage()
            {
                Content = new StringContent(Newtonsoft.Json.JsonConvert.SerializeObject(LinRegressionResults))//dt.GetJson())
            };

            obj.Content.Headers.ContentType = new MediaTypeHeaderValue("application/json");

            return(obj);
        }
Example #4
0
        // POST api/<controller>
        public HttpResponseMessage Post([FromBody]      JObject value)
        {
            FrequencyDomainService FrequencyDomainService = new FrequencyDomainService();
            GadgetParameters       GadgetParameters;
            ControllerCommon       CommonClass = new ControllerCommon();
            List <EwavRule_Base>   Rules       = new List <EwavRule_Base>();

            JObject gadgetJSON = (JObject)value["gadget"];


            List <EwavDataFilterCondition> dashboardFilters = new List <EwavDataFilterCondition>();



            GadgetParameters = new GadgetParameters();

            GadgetParameters.DatasourceName    = gadgetJSON["@DatasourceName"].ToString();
            GadgetParameters.MainVariableName  = gadgetJSON["mainVariable"].ToString();
            GadgetParameters.InputVariableList = new Dictionary <string, string>();
            if (gadgetJSON["sort"] != null && gadgetJSON["sort"].ToString() == "highlow")
            {
                GadgetParameters.InputVariableList.Add("sort", "highlow");
                GadgetParameters.ShouldSortHighToLow = true;
            }
            else
            {
                GadgetParameters.ShouldSortHighToLow = false;
            }
            GadgetParameters.InputVariableList.Add("tableName", gadgetJSON["@DatasourceName"].ToString());
            GadgetParameters.InputVariableList.Add("freqvar", gadgetJSON["mainVariable"].ToString());
            GadgetParameters.InputVariableList.Add("allvalues", gadgetJSON["allValues"].ToString());
            GadgetParameters.InputVariableList.Add("freqVar", gadgetJSON["mainVariable"].ToString());
            GadgetParameters.InputVariableList.Add("showconflimits", gadgetJSON["showConfLimits"].ToString());
            GadgetParameters.InputVariableList.Add("showcumulativepercent", gadgetJSON["showCumulativePercent"].ToString());
            GadgetParameters.InputVariableList.Add("includemissing", gadgetJSON["includeMissing"].ToString());
            GadgetParameters.InputVariableList.Add("maxrows", "200");
            GadgetParameters.TableName = CommonClass.GetDatabaseObject(GadgetParameters.DatasourceName);



            if (gadgetJSON["strataVariable"].ToString().Trim().Length > 0)
            {
                List <MyString> StrataList = new List <MyString>();
                MyString        strata     = new MyString();
                strata.VarName = gadgetJSON["strataVariable"].ToString();
                StrataList.Add(strata);
                GadgetParameters.StrataVariableList = StrataList;
            }


            Rules = CommonClass.ReadRules(value);

            dashboardFilters = CommonClass.GetFilters(value);


            GadgetParameters.GadgetFilters = CommonClass.GetFilters(gadgetJSON, true);



            List <FrequencyResultData> FrequencyResultData = FrequencyDomainService.GenerateFrequencyTable(GadgetParameters, dashboardFilters, Rules, CommonClass.AdvancedDataFilterString);

            foreach (var item in FrequencyResultData)
            {
                foreach (var row in item.FrequencyControlDtoList)
                {
                    if ((row.FreqVariable.Split('/').Length > 2 && row.FreqVariable.Split('/').Length < 4) || // Valid Combos:- enumerator/enumerator/enumerator, enumerator-enumerator-enumerator ,
                        (row.FreqVariable.Split('-').Length > 2 && row.FreqVariable.Split('-').Length < 4))                     //Invalid Combos:- enumerator/enumerator, enumerator/enumerator/enumerator/enumerator, enumerator-enumerator, enumerator-enumerator-enumerator-enumerator
                    {
                        row.FreqVariable = DateTime.Parse(row.FreqVariable, CultureInfo.CurrentUICulture).ToShortDateString();
                    }
                    else
                    {
                        row.FreqVariable = row.FreqVariable;
                    }
                }
            }

            FrequencyInfoAndMetaInfo AllInfo = new FrequencyInfoAndMetaInfo();

            AllInfo.FreqResult       = FrequencyResultData;
            AllInfo.GadgetParameters = GadgetParameters;



            var obj = new HttpResponseMessage()
            {
                Content = new StringContent(Newtonsoft.Json.JsonConvert.SerializeObject(AllInfo))//dt.GetJson())
            };

            obj.Content.Headers.ContentType = new MediaTypeHeaderValue("application/json");

            return(obj);
        }
Example #5
0
        // POST api/<controller>
        public HttpResponseMessage Post([FromBody]      JObject value)
        {
            EpiCurveDomainService EpiCurveDomainService = new EpiCurveDomainService();

            Google.DataTable.Net.Wrapper.DataTable dt = null;
            HttpResponseMessage  ReturnedObj          = null;
            GadgetParameters     GadgetParameters     = new GadgetParameters();
            List <EwavRule_Base> Rules       = new List <EwavRule_Base>();
            ControllerCommon     CommonClass = new ControllerCommon();

            JObject chartJSON = (JObject)value["chart"];

            List <EwavDataFilterCondition> dashboardFilters = new List <EwavDataFilterCondition>();
            bool byEpiWeek = false;

            GadgetParameters.MainVariableName     = string.Empty;
            GadgetParameters.WeightVariableName   = string.Empty;
            GadgetParameters.StrataVariableNames  = new List <string>();
            GadgetParameters.CrosstabVariableName = string.Empty;
            GadgetParameters.InputVariableList    = new Dictionary <string, string>();
            GadgetParameters.ShouldSortHighToLow  = false;



            GadgetParameters.DatasourceName = chartJSON["@DatasourceName"].ToString();

            string strataVariable = string.Empty;

            GadgetParameters.MainVariableName = chartJSON["dateVariable"].ToString();


            GadgetParameters.InputVariableList = new Dictionary <string, string>();
            // tablename really menas DatasourName
            GadgetParameters.InputVariableList.Add("tableName", chartJSON["@DatasourceName"].ToString());



            GadgetParameters.ShouldUseAllPossibleValues = false;



            GadgetParameters.InputVariableList.Add("xaxisstart", chartJSON["xAxisStartValue"].ToString());

            GadgetParameters.InputVariableList.Add("xaxisend", chartJSON["xAxisEndValue"].ToString());

            GadgetParameters.InputVariableList.Add("isdatecolumnnumeric", "false");
            GadgetParameters.InputVariableList.Add("dateinterval", chartJSON["dateInterval"].ToString());

            GadgetParameters.CrosstabVariableName = chartJSON["caseStatusVariable"].ToString();

            GadgetParameters.TableName = CommonClass.GetDatabaseObject(GadgetParameters.DatasourceName);

            dashboardFilters = CommonClass.GetFilters(value);

            GadgetParameters.GadgetFilters = CommonClass.GetFilters(chartJSON, true);

            Rules = CommonClass.ReadRules(value);

            if (GadgetParameters.InputVariableList.ContainsKey("isdatecolumnnumeric"))
            {
                byEpiWeek = bool.Parse(GadgetParameters.InputVariableList["isdatecolumnnumeric"]);
            }


            DatatableBag data = EpiCurveDomainService.GetEpiCurveData(GadgetParameters, dashboardFilters, Rules, CommonClass.AdvancedDataFilterString, byEpiWeek, chartJSON["dateVariable"].ToString(), chartJSON["caseStatusVariable"].ToString());



            dt = new Google.DataTable.Net.Wrapper.DataTable();



            dt.AddColumn(new Column(ColumnType.String, "FreqVariable", "FreqVariable"));

            for (int i = 1; i < data.ColumnNameList.Count; i++)
            {
                dt.AddColumn(new Column(ColumnType.Number, "FrequencyColumn" + i, data.ColumnNameList[i].VarName.ToString()));
            }


            foreach (var item in data.RecordList)
            {
                //if (item.Fields[1].VarName.ToString().Length > 0)
                //{
                Row r = dt.NewRow();

                for (int i = 0; i < data.ColumnNameList.Count; i++)
                {
                    string dateValue = item.Fields[i].VarName.ToString();

                    DateTime result = DateTime.Now;

                    if (DateTime.TryParse(dateValue, out result))
                    {
                        switch (chartJSON["dateInterval"].ToString().ToLower())
                        {
                        case "hours":
                            dateValue = result.ToString("g");
                            break;

                        case "months":
                            dateValue = result.ToString("MMM yyyy");
                            break;

                        case "years":
                            dateValue = result.ToString("yyyy");
                            break;

                        default:        //"days"
                            dateValue = result.ToShortDateString();
                            break;
                        }
                    }


                    r.AddCell(new Cell(dateValue));
                }
                //);

                dt.AddRow(r);
                //}
            }

            ReturnedObj = new HttpResponseMessage()
            {
                Content = new StringContent(dt.GetJson())
            };



            ReturnedObj.Content.Headers.ContentType = new MediaTypeHeaderValue("application/json");


            return(ReturnedObj);
        }
Example #6
0
        // POST api/<controller>
        public HttpResponseMessage Post([FromBody]      JObject value)
        {
            XYChartDomainService XYChartDomainService = new XYChartDomainService();

            Google.DataTable.Net.Wrapper.DataTable dt = null;
            HttpResponseMessage  ReturnedObj          = null;
            GadgetParameters     GadgetParameters     = new GadgetParameters();
            List <EwavRule_Base> Rules       = new List <EwavRule_Base>();
            ControllerCommon     CommonClass = new ControllerCommon();

            JObject chartJSON = (JObject)value["chart"];

            List <EwavDataFilterCondition> dashboardFilters = new List <EwavDataFilterCondition>();

            dt = new Google.DataTable.Net.Wrapper.DataTable();

            Rules = CommonClass.ReadRules(value);

            dashboardFilters = CommonClass.GetFilters(value);

            GadgetParameters.GadgetFilters = CommonClass.GetFilters(chartJSON, true);


            GadgetParameters.DatasourceName = chartJSON["@DatasourceName"].ToString();

            string strataVariable = string.Empty;

            if (chartJSON["chartType"].ToString().ToLower() == "stackedcolumn")
            {
                GadgetParameters.MainVariableName = chartJSON["xAxisVariable"].ToString();
                strataVariable = chartJSON["yAxisVariable"].ToString();
            }
            else if (chartJSON["chartType"].ToString().ToLower() == "pareto")
            {
                GadgetParameters.ShouldSortHighToLow = true;
                GadgetParameters.MainVariableName    = chartJSON["singleVariable"].ToString();
                strataVariable = chartJSON["strataVariable"].ToString();
            }
            else
            {
                GadgetParameters.MainVariableName = chartJSON["singleVariable"].ToString();
                strataVariable = chartJSON["strataVariable"].ToString();
            }

            GadgetParameters.InputVariableList  = new Dictionary <string, string>();
            GadgetParameters.WeightVariableName = chartJSON["weightVariable"].ToString();

            GadgetParameters.TableName = CommonClass.GetDatabaseObject(GadgetParameters.DatasourceName);


            if (strataVariable.Trim().Length > 0)
            {
                List <MyString> StrataList = new List <MyString>();
                MyString        strata     = new MyString();
                strata.VarName = strataVariable.ToString(); // chartJSON["strataVariable"].ToString();
                StrataList.Add(strata);
                GadgetParameters.StrataVariableList = StrataList;
            }


            List <FrequencyResultData> FrequencyResultDataList = XYChartDomainService.GenerateFrequencyTable(GadgetParameters, dashboardFilters, Rules, CommonClass.AdvancedDataFilterString);

            double runningPercent = 0, max = 0;

            foreach (var item in FrequencyResultDataList)
            {
                foreach (var row in item.FrequencyControlDtoList)
                {
                    if ((row.FreqVariable.Split('/').Length > 2 && row.FreqVariable.Split('/').Length < 4) || // Valid Combos:- enumerator/enumerator/enumerator, enumerator-enumerator-enumerator ,
                        (row.FreqVariable.Split('-').Length > 2 && row.FreqVariable.Split('-').Length < 4))                     //Invalid Combos:- enumerator/enumerator, enumerator/enumerator/enumerator/enumerator, enumerator-enumerator, enumerator-enumerator-enumerator-enumerator
                    {
                        row.FreqVariable = DateTime.Parse(row.FreqVariable, CultureInfo.CurrentUICulture).ToShortDateString();
                    }
                    else
                    {
                        row.FreqVariable = row.FreqVariable;
                    }

                    if (chartJSON["chartType"].ToString().ToLower() == "pareto")     //this.chartTypeEnum == XYControlChartTypes.Pareto)
                    {
                        max = max + CommonClass.SafeParsetoDou(row.FrequencyColumn); //.SafeParsetoDou();
                    }
                }
            }



            if (FrequencyResultDataList.Count > 1)
            {
                dt.AddColumn(new Column(ColumnType.String, "FreqVariable", "FreqVariable"));

                var DtoCount = FrequencyResultDataList.Count;

                for (int i = 0; i < DtoCount; i++)
                {
                    var columnName = FrequencyResultDataList[i].FrequencyControlDtoList[0].NameOfDtoList;

                    columnName = columnName.Split('=')[1].ToString();


                    dt.AddColumn(new Column(ColumnType.Number, columnName, columnName));
                }

                for (int i = 0; i < FrequencyResultDataList[0].FrequencyControlDtoList.Count; i++)
                {
                    Row r = dt.NewRow();
                    r.AddCell(
                        new Cell(FrequencyResultDataList[0].FrequencyControlDtoList[i].FreqVariable)
                        );
                    for (int j = 0; j < DtoCount; j++)
                    {
                        r.AddCell(
                            new Cell(FrequencyResultDataList[j].FrequencyControlDtoList[i].FrequencyColumn)
                            );
                    }



                    dt.AddRow(r);
                }
            }
            else
            {
                dt.AddColumn(new Column(ColumnType.String, "FreqVariable", "FreqVariable"));
                dt.AddColumn(new Column(ColumnType.Number, "FrequencyColumn", FrequencyResultDataList[0].FrequencyControlDtoList[0].NameOfDtoList));

                if (chartJSON["chartType"].ToString().ToLower() == "pareto") // if chart is Pareto
                {
                    dt.AddColumn(new Column(ColumnType.Number, "mean", "mean"));
                }


                foreach (EwavFrequencyControlDto Frequencydto in FrequencyResultDataList[0].FrequencyControlDtoList)
                {
                    Row r = dt.NewRow();
                    r.AddCellRange(new Cell[]
                    {
                        new Cell(Frequencydto.FreqVariable),
                        new Cell(Frequencydto.FrequencyColumn)    //,
                    }
                                   );

                    if (chartJSON["chartType"].ToString().ToLower() == "pareto")// if chart is Pareto
                    {
                        double meanValue = CommonClass.CalculateMean(Frequencydto.FrequencyColumn, max, runningPercent);
                        meanValue = Math.Round(meanValue, 4);
                        r.AddCell(
                            new Cell(meanValue)
                            );
                        runningPercent = CommonClass.SafeParsetoDou(meanValue.ToString());
                    }
                    dt.AddRow(r);
                }
            }


            ReturnedObj = new HttpResponseMessage()
            {
                Content = new StringContent(dt.GetJson()) //Newtonsoft.Json.JsonConvert.SerializeObject(clientDto))//FrequencyResultData.FrequencyControlDtoList))
            };


            //  return resultAsStr;


            ReturnedObj.Content.Headers.ContentType = new MediaTypeHeaderValue("application/json");


            return(ReturnedObj);
        }
Example #7
0
        // POST api/<controller>
        public HttpResponseMessage Post([FromBody] JObject value)
        {
            MeansDomainService   MeansDomainService = new MeansDomainService();
            GadgetParameters     GadgetParameters;
            ControllerCommon     CommonClass = new ControllerCommon();
            List <EwavRule_Base> Rules       = new List <EwavRule_Base>();

            JObject gadgetJSON = (JObject)value["gadget"];

            List <EwavDataFilterCondition> dashboardFilters = new List <EwavDataFilterCondition>();

            GadgetParameters = new GadgetParameters();

            GadgetParameters.DatasourceName    = gadgetJSON["@DatasourceName"].ToString();
            GadgetParameters.MainVariableName  = gadgetJSON["mainVariable"].ToString();
            GadgetParameters.InputVariableList = new Dictionary <string, string>();
            GadgetParameters.InputVariableList.Add("tableName", gadgetJSON["@DatasourceName"].ToString());
            GadgetParameters.InputVariableList.Add("meansvar", gadgetJSON["mainVariable"].ToString());
            GadgetParameters.MainVariableName = gadgetJSON["mainVariable"].ToString();
            GadgetParameters.InputVariableList.Add("weightvar", gadgetJSON["weightVariable"].ToString());
            GadgetParameters.WeightVariableName = gadgetJSON["weightVariable"].ToString();
            GadgetParameters.InputVariableList.Add("freqVar", gadgetJSON["mainVariable"].ToString());
            GadgetParameters.InputVariableList.Add("crosstabvar", gadgetJSON["crosstabVariable"].ToString());
            GadgetParameters.CrosstabVariableName = gadgetJSON["crosstabVariable"].ToString();
            GadgetParameters.ShouldIncludeFullSummaryStatistics = true;
            if (Convert.ToBoolean(gadgetJSON["showANOVA"].ToString()) == true)
            {
                GadgetParameters.InputVariableList.Add("showanova", "true");
            }
            else
            {
                GadgetParameters.InputVariableList.Add("showanova", "false");
            }


            GadgetParameters.TableName = CommonClass.GetDatabaseObject(GadgetParameters.DatasourceName);


            if (gadgetJSON["strataVariable"].ToString().Trim().Length > 0)
            {
                List <MyString> StrataList = new List <MyString>();
                MyString        strata     = new MyString();
                strata.VarName = gadgetJSON["strataVariable"].ToString();
                StrataList.Add(strata);
                GadgetParameters.StrataVariableList = StrataList;
            }

            Rules = CommonClass.ReadRules(value);

            dashboardFilters = CommonClass.GetFilters(value);

            GadgetParameters.GadgetFilters = CommonClass.GetFilters(gadgetJSON, true);

            string crosstabvar = gadgetJSON["crosstabVariable"].ToString();
            List <FrequencyResultData> FrequencyResultData    = null;
            FrequencyAndCrossTable     FrequencyAndCrossTable = null;

            if (crosstabvar.Length > 0)
            {
                FrequencyAndCrossTable = MeansDomainService.GenerateCrossTableWithFrequencyTable(GadgetParameters, dashboardFilters, Rules, CommonClass.AdvancedDataFilterString);
                FrequencyResultData    = FrequencyAndCrossTable.FrequencyTable;
            }
            else
            {
                FrequencyResultData = MeansDomainService.GenerateFrequencyTable(GadgetParameters, dashboardFilters, Rules, CommonClass.AdvancedDataFilterString);
            }



            foreach (var item in FrequencyResultData)
            {
                foreach (var row in item.FrequencyControlDtoList)
                {
                    if ((row.FreqVariable.Split('/').Length > 2 && row.FreqVariable.Split('/').Length < 4) || // Valid Combos:- enumerator/enumerator/enumerator, enumerator-enumerator-enumerator ,
                        (row.FreqVariable.Split('-').Length > 2 && row.FreqVariable.Split('-').Length < 4))                     //Invalid Combos:- enumerator/enumerator, enumerator/enumerator/enumerator/enumerator, enumerator-enumerator, enumerator-enumerator-enumerator-enumerator
                    {
                        row.FreqVariable = DateTime.Parse(row.FreqVariable, CultureInfo.CurrentUICulture).ToShortDateString();
                    }
                    else
                    {
                        row.FreqVariable = row.FreqVariable;
                    }
                }
            }



            FrequencyInfoAndMetaInfo AllInfo = new FrequencyInfoAndMetaInfo();

            if (crosstabvar.Length > 0)
            {
                FrequencyAndCrossTable.FrequencyTable = FrequencyResultData;
                AllInfo.FreqResult = FrequencyAndCrossTable;
            }
            else
            {
                AllInfo.FreqResult = FrequencyResultData;
            }

            AllInfo.GadgetParameters = GadgetParameters;

            var jsonresult = Newtonsoft.Json.JsonConvert.SerializeObject(AllInfo).Replace("NaN", "null"); // JSON doesnt accept NaN token. It would make it invalid JSON.



            var obj = new HttpResponseMessage()
            {
                Content = new StringContent(jsonresult)//dt.GetJson())
            };

            obj.Content.Headers.ContentType = new MediaTypeHeaderValue("application/json");

            return(obj);
        }
Example #8
0
        // POST api/<controller>
        public HttpResponseMessage Post([FromBody]      JObject value)
        {
            MapClusterDomainService MapClusterDomainService = new MapClusterDomainService();
            GadgetParameters        GadgetParameters;
            ControllerCommon        CommonClass = new ControllerCommon();
            List <EwavRule_Base>    Rules       = new List <EwavRule_Base>();

            JObject gadgetJSON = (JObject)value["gadget"];


            List <EwavDataFilterCondition> dashboardFilters = new List <EwavDataFilterCondition>();



            GadgetParameters = new GadgetParameters();

            GadgetParameters.ShouldIncludeFullSummaryStatistics = true;
            GadgetParameters.ShouldIncludeMissing       = false;
            GadgetParameters.ShouldSortHighToLow        = false;
            GadgetParameters.ShouldUseAllPossibleValues = false;

            GadgetParameters.DatasourceName = gadgetJSON["@DatasourceName"].ToString();
            //GadgetParameters.MainVariableName = gadgetJSON["mainVariable"].ToString();
            GadgetParameters.StrataVariableNames = new List <string>();
            //GadgetParameters.UseAdvancedDataFilter = CommonClass.AdvancedDataFilterString;

            GadgetParameters.TableName = CommonClass.GetDatabaseObject(GadgetParameters.DatasourceName);

            GadgetParameters.InputVariableList = new Dictionary <string, string>();
            GadgetParameters.InputVariableList.Add("lonx", gadgetJSON["longitude"].ToString());
            GadgetParameters.InputVariableList.Add(gadgetJSON["longitude"].ToString(), "listfield");
            GadgetParameters.InputVariableList.Add("laty", gadgetJSON["latitude"].ToString());
            GadgetParameters.InputVariableList.Add(gadgetJSON["latitude"].ToString(), "listfield");
            GadgetParameters.InputVariableList.Add(gadgetJSON["stratifyby"].ToString(), "listfield");


            if (gadgetJSON["stratifyby"].ToString().Trim().Length > 0)
            {
                List <MyString> StrataList = new List <MyString>();
                MyString        strata     = new MyString();
                strata.VarName = gadgetJSON["stratifyby"].ToString();
                StrataList.Add(strata);
                GadgetParameters.StrataVariableList = StrataList;
            }


            Rules = CommonClass.ReadRules(value);

            dashboardFilters = CommonClass.GetFilters(value);


            GadgetParameters.GadgetFilters = CommonClass.GetFilters(gadgetJSON, true);



            List <PointDTOCollection> PDTOList = MapClusterDomainService.GetMapValues(GadgetParameters, dashboardFilters, Rules, CommonClass.AdvancedDataFilterString);



            var obj = new HttpResponseMessage()
            {
                Content = new StringContent(Newtonsoft.Json.JsonConvert.SerializeObject(PDTOList))
            };

            obj.Content.Headers.ContentType = new MediaTypeHeaderValue("application/json");

            return(obj);
        }