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