void crossFreqResults_Completed(object sender, EventArgs e) { InvokeOperation <FrequencyAndCrossTable> result = (InvokeOperation <FrequencyAndCrossTable>)sender; Exception ex = null; if (result.HasError) { result.MarkErrorAsHandled(); ex = result.Error; } //else //{ FrequencyAndCrossTable returnedData = ((InvokeOperation <FrequencyAndCrossTable>)sender).Value; _crossandfreqCompleted(returnedData, ex); //} }
//private void MeansCrossTabDataCompleted(List<CrossTabResponseObjectDto> result, Exception e) //{ // if (e != null) // { // this.NotifyError("There is an error", e); // } // else // { // this.crossTabTable = result; // this.Notify(MeansCrossTabDataLoadedEvent, new NotificationEventArgs<Exception>()); // } //} private void GetCrossTabAndFreqCompleted(FrequencyAndCrossTable result, Exception e) { if (e != null) { NotificationEventArgs <Exception> notification = new NotificationEventArgs <Exception>("", e); this.Notify(ErrorNotice, notification); } else { NotificationEventArgs <Exception> notification = new NotificationEventArgs <Exception>("", e); this.FreqAndCrossTable = result; if (this.FreqAndCrossTable != null) { this.Notify(FreqAndCrossTableLoadedEvent, new NotificationEventArgs <Exception>()); } else { this.Notify(ErrorNotice, new NotificationEventArgs <Exception>(SharedStrings.NO_RECORDS_SELECTED)); } } }
// 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); }