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"));
}
