/**
* second step to edit dimension data
*/
public ActionResult AddNewChartName(ChartTemplate model)
{
//return "comparison" + model.comparison + "composition" + model.composition+"name"+model.name+"dimcount"+model.dimensionCount;
Session["dimensionData"] = model;
ViewData["dimensionCount"] = model.dimentionCountVal;
List <DimensionTemplate> temp = new List <DimensionTemplate>();
for (int i = 0; i < model.dimentionCountVal; i++)
{
DimensionTemplate template = new DimensionTemplate();
template.dimensionIndex = i;
temp.Add(template);
}
return(View(temp));
}
/**
* get detail of single chart
*/
public ActionResult ChartDetails(int id)
{
ViewData["activeMenu"] = "ChartList";
chart result = db.charts.Find(id);
ChartTemplate chartData = new ChartTemplate();
chartData.name = result.name;
// search for intention
List <intention> intensionList = db.intentions.Where(b => b.chartID == id).ToList();
chartData.intentionList = intensionList; // add intention
// search for dimension count
List <dimensionCount> dimensionCount = db.dimensionCounts.Where(b => b.chartID == id).ToList();
chartData.dimensionCount = new List <int>();
foreach (var eachDim in dimensionCount)
{
chartData.dimensionCount.Add(eachDim.count.Value);
}
// search for each dimension
List <chartDimension> dimensionChart = db.chartDimensions.Where(b => b.chartID == id).ToList();
chartData.dimentionList = new List <DimensionTemplate>();
foreach (var item in dimensionChart)
{
DimensionTemplate dimensionTemplate = new DimensionTemplate();
dimensionTemplate.isContineous = Convert.ToBoolean(item.isContinuous); // add is contineous
dimensionTemplate.dimensionIndex = item.dimensionIndex.Value;
// search for cardinality
List <chartDimensionCardinality> dimensionChartCardinality = db.chartDimensionCardinalities.Where(b => b.dimensionID == item.ID).ToList();
dimensionTemplate.cardinalityType = dimensionChartCardinality;
// search for context
List <dimensionContext> dimentionContext = db.dimensionContexts.Where(b => b.dimensionID == item.ID).ToList();
dimensionTemplate.contextType = dimentionContext;
chartData.dimentionList.Add(dimensionTemplate);
}
return(View(chartData));
}
public ActionResult EditChart(int id)
{
ChartTemplate chartTemplate = new ChartTemplate();
chartTemplate.id = id;
var resultChart = db.charts.Where(p => p.ID == id);
foreach (var item in resultChart)
{
chartTemplate.name = item.name; // update from chart table
}
var intentionVal = db.intentions.Where(p => p.chartID == id);
foreach (var intenDim in intentionVal) // update intention table
{
if (intenDim.intention1 == "Comparison")
{
chartTemplate.comparison = true;
}
else
{
chartTemplate.comparison = false;
}
if (intenDim.intention1 == "Composition")
{
chartTemplate.composition = true;
}
else
{
chartTemplate.composition = false;
}
if (intenDim.intention1 == "Distribution")
{
chartTemplate.distribution = true;
}
else
{
chartTemplate.distribution = false;
}
if (intenDim.intention1 == "Relationship")
{
chartTemplate.relationship = true;
}
else
{
chartTemplate.relationship = false;
}
}
var chartDim = db.chartDimensions.Where(p => p.chartID == id);
chartTemplate.dimentionList = new List <DimensionTemplate>();
foreach (var itemDim in chartDim)
{
DimensionTemplate dimention = new DimensionTemplate();
if (itemDim.isContinuous == 1)
{
dimention.isContineous = true;
}
else
{
dimention.isContineous = false;
}
dimention.dimensionIndex = itemDim.dimensionIndex.Value;
var contextDim = db.dimensionContexts.Where(d => d.dimensionID == itemDim.ID);
foreach (var contextVar in contextDim)
{
if (contextVar.context == "Location")
{
dimention.contextLocation = true;
}
else
{
dimention.contextLocation = false;
}
if (contextVar.context == "Nominal")
{
dimention.contextNominal = true;
}
else
{
dimention.contextNominal = false;
}
if (contextVar.context == "Numeric")
{
dimention.contextNumeric = true;
}
else
{
dimention.contextNumeric = false;
}
if (contextVar.context == "Percentage")
{
dimention.contextPercentage = true;
}
else
{
dimention.contextPercentage = false;
}
if (contextVar.context == "Time series")
{
dimention.contextTimeseries = true;
}
else
{
dimention.contextTimeseries = false;
}
}
chartTemplate.dimentionList.Add(dimention);
}
return(View(chartTemplate));
}
