/// <summary>
/// Completion for regresion results Table
/// </summary>
/// <param name="result"></param>
/// <param name="e"></param>
private void GetTableCompleted(ScatterDataDTO result, Exception e)
{
if (e != null)
{
NotificationEventArgs <Exception> notification = new NotificationEventArgs <Exception>("", e);
this.Notify(ErrorNotice, notification);
}
else
{
this.RegressionResults = result;
this.Notify(RegressTableLoadedEvent, new NotificationEventArgs <Exception>());
}
}
void sctrCtxtableResults_Completed(object sender, EventArgs e)
{
InvokeOperation <ScatterDataDTO> result = (InvokeOperation <ScatterDataDTO>)sender;
if (result.HasError)
{
ex = result.Error;
result.MarkErrorAsHandled();
}
//else
//{
ScatterDataDTO returnedData = ((InvokeOperation <ScatterDataDTO>)sender).Value;
_tableCompleted(returnedData, null);
//}
}
// 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);
}
