string GoogleChartData(IEnumerable <Keeper> keepers)
{
var dt = new Google.DataTable.Net.Wrapper.DataTable();
dt.AddColumn(new Column(ColumnType.Date, "Date", "Date"));
dt.AddColumn(new Column(ColumnType.Number, "Count", "Count"));
foreach (var item in keepers)
{
Google.DataTable.Net.Wrapper.Row row = dt.NewRow();
row.AddCellRange(new Cell[]
{
new Cell(item.Date),
new Cell(item.Count),
});
dt.AddRow(row);
}
return(dt.GetJson());
}
private string JsonData(FehappGaugedcatchment amaxData)
{
var dt = new Google.DataTable.Net.Wrapper.DataTable();
dt.AddColumn(new Column(ColumnType.String, "Mondate", "Monitoring Date"));
dt.AddColumn(new Column(ColumnType.Number, "Flow", "Flow"));
foreach (var item in Catchment.FehappAmaxdata)
{
Row r = dt.NewRow();
r.AddCellRange(new Cell[]
{
new Cell(item.Mondate),
new Cell(item.Flow)
});
dt.AddRow(r);
}
return(dt.GetJson());
// return jsonAmax = JsonConvert.SerializeObject(amaxData, Formatting.Indented,
// new JsonSerializerSettings(){
// ReferenceLoopHandling = Newtonsoft.Json.ReferenceLoopHandling.Ignore
// });;
}
// 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);
}
// 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);
}
// 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);
}
