public ActionResult EditChartVal(ChartTemplate chartTemplate) { chart resultChart = db.charts.Where(s => s.ID == chartTemplate.id).FirstOrDefault <chart>(); resultChart.name = chartTemplate.name; db.Entry(resultChart).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); var intentionVal = db.intentions.Where(p => p.chartID == chartTemplate.id); foreach (var intenDim in intentionVal) // update intention table { db.intentions.Remove(intenDim); } db.Entry(resultChart).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); if (chartTemplate.comparison) { intention tableIntention = new intention(); tableIntention.chartID = chartTemplate.id; tableIntention.intention1 = "Comparison"; db.intentions.Add(tableIntention); db.SaveChanges(); } if (chartTemplate.composition) { intention tableIntention = new intention(); tableIntention.chartID = chartTemplate.id; tableIntention.intention1 = "Composition"; db.intentions.Add(tableIntention); db.SaveChanges(); } if (chartTemplate.distribution) { intention tableIntention = new intention(); tableIntention.chartID = chartTemplate.id; tableIntention.intention1 = "Distribution"; db.intentions.Add(tableIntention); db.SaveChanges(); } if (chartTemplate.relationship) { intention tableIntention = new intention(); tableIntention.chartID = chartTemplate.id; tableIntention.intention1 = "Relationship"; db.intentions.Add(tableIntention); db.SaveChanges(); } foreach (var dimList in chartTemplate.dimentionList) { chartDimension chartDim = db.chartDimensions.Where(s => s.chartID == chartTemplate.id).Where(p => p.dimensionIndex == dimList.dimensionIndex).FirstOrDefault <chartDimension>(); chartDim.isContinuous = Convert.ToInt32(dimList.dimensionIndex); db.Entry(chartDim).State = System.Data.Entity.EntityState.Modified; try { db.SaveChanges(); } catch (Exception e) { } var dimContext = db.dimensionContexts.Where(s => s.dimensionID == dimList.dimensionIndex); foreach (var listDimContext in dimContext) { db.dimensionContexts.Remove(listDimContext); } try { db.SaveChanges(); }catch (Exception e) { } if (dimList.cardinalityAny) { dimensionContext dimCon = new dimensionContext(); dimCon.dimensionID = dimList.dimensionIndex; dimCon.context = "Any"; db.dimensionContexts.Add(dimCon); } if (dimList.contextTimeseries) { dimensionContext dimCon = new dimensionContext(); dimCon.dimensionID = dimList.dimensionIndex; dimCon.context = "Time series"; db.dimensionContexts.Add(dimCon); } if (dimList.contextNumeric) { dimensionContext dimCon = new dimensionContext(); dimCon.dimensionID = dimList.dimensionIndex; dimCon.context = "Numeric"; db.dimensionContexts.Add(dimCon); } if (dimList.contextNominal) { dimensionContext dimCon = new dimensionContext(); dimCon.dimensionID = dimList.dimensionIndex; dimCon.context = "Nominal"; db.dimensionContexts.Add(dimCon); } if (dimList.contextLocation) { dimensionContext dimCon = new dimensionContext(); dimCon.dimensionID = dimList.dimensionIndex; dimCon.context = "Location"; db.dimensionContexts.Add(dimCon); } } try { db.SaveChanges(); } catch (Exception e) { } return(RedirectToAction("ChartList", "Admin")); }
/** * put new chart into the database */ public ActionResult AddNewChartNameVal(List <DimensionTemplate> dimList) { string val = ""; ChartTemplate sessionModel = (ChartTemplate)Session["dimensionData"]; chart chartTable = new chart(); chartTable.name = sessionModel.name; db.charts.Add(chartTable); db.SaveChanges(); if (sessionModel.comparison) { intention tableIntention = new intention(); tableIntention.chartID = chartTable.ID; tableIntention.intention1 = "Comparison"; db.intentions.Add(tableIntention); db.SaveChanges(); val += ",comparison added"; } if (sessionModel.composition) { intention tableIntention = new intention(); tableIntention.chartID = chartTable.ID; tableIntention.intention1 = "Composition"; db.intentions.Add(tableIntention); db.SaveChanges(); val += ",composition added"; } if (sessionModel.distribution) { intention tableIntention = new intention(); tableIntention.chartID = chartTable.ID; tableIntention.intention1 = "Distribution"; db.intentions.Add(tableIntention); db.SaveChanges(); val += ",distribution added"; } if (sessionModel.relationship) { intention tableIntention = new intention(); tableIntention.chartID = chartTable.ID; tableIntention.intention1 = "Relationship"; db.intentions.Add(tableIntention); db.SaveChanges(); val += ",relationip added"; } foreach (var item in dimList) { item.dimensionIndex++; chartDimension tableChartDimension = new chartDimension(); tableChartDimension.chartID = chartTable.ID; tableChartDimension.dimensionIndex = item.dimensionIndex; tableChartDimension.isContinuous = Convert.ToInt32(item.isContineous); db.chartDimensions.Add(tableChartDimension); db.SaveChanges(); if (item.isSelected) { dimensionCount tableDimensionCount = new dimensionCount(); tableDimensionCount.chartID = chartTable.ID; tableDimensionCount.count = item.dimensionIndex; db.dimensionCounts.Add(tableDimensionCount); db.SaveChanges(); val += ",isselected added"; } if (item.cardinalityAny) { chartDimensionCardinality tableChartDimensionCardinality = new chartDimensionCardinality(); tableChartDimensionCardinality.dimensionID = tableChartDimension.ID; tableChartDimensionCardinality.cardinality = "Any"; db.chartDimensionCardinalities.Add(tableChartDimensionCardinality); db.SaveChanges(); } else { if (item.cardinalityHigh) { chartDimensionCardinality tableChartDimensionCardinality = new chartDimensionCardinality(); tableChartDimensionCardinality.dimensionID = tableChartDimension.ID; tableChartDimensionCardinality.cardinality = "High"; db.chartDimensionCardinalities.Add(tableChartDimensionCardinality); db.SaveChanges(); } if (item.cardinalityMedium) { chartDimensionCardinality tableChartDimensionCardinality = new chartDimensionCardinality(); tableChartDimensionCardinality.dimensionID = tableChartDimension.ID; tableChartDimensionCardinality.cardinality = "Medium"; db.chartDimensionCardinalities.Add(tableChartDimensionCardinality); db.SaveChanges(); } if (item.cardinalityLow) { chartDimensionCardinality tableChartDimensionCardinality = new chartDimensionCardinality(); tableChartDimensionCardinality.dimensionID = tableChartDimension.ID; tableChartDimensionCardinality.cardinality = "Low"; db.chartDimensionCardinalities.Add(tableChartDimensionCardinality); db.SaveChanges(); } } if (item.contextLocation) { dimensionContext tableDimensionContext = new dimensionContext(); tableDimensionContext.dimensionID = tableChartDimension.ID; tableDimensionContext.context = "Location"; db.dimensionContexts.Add(tableDimensionContext); db.SaveChanges(); } if (item.contextNominal) { dimensionContext tableDimensionContext = new dimensionContext(); tableDimensionContext.dimensionID = tableChartDimension.ID; tableDimensionContext.context = "Nominal"; db.dimensionContexts.Add(tableDimensionContext); db.SaveChanges(); } if (item.contextNumeric) { dimensionContext tableDimensionContext = new dimensionContext(); tableDimensionContext.dimensionID = tableChartDimension.ID; tableDimensionContext.context = "Numeric"; db.dimensionContexts.Add(tableDimensionContext); db.SaveChanges(); } if (item.contextPercentage) { dimensionContext tableDimensionContext = new dimensionContext(); tableDimensionContext.dimensionID = tableChartDimension.ID; tableDimensionContext.context = "Percentage"; db.dimensionContexts.Add(tableDimensionContext); db.SaveChanges(); } if (item.contextTimeseries) { dimensionContext tableDimensionContext = new dimensionContext(); tableDimensionContext.dimensionID = tableChartDimension.ID; tableDimensionContext.context = "Time series"; db.dimensionContexts.Add(tableDimensionContext); db.SaveChanges(); } } return(RedirectToAction("ChartList", "Admin")); }