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