public async Task <ActionResult <chart> > Postchart(chart chart)
{
_context.charts.Add(chart);
await _context.SaveChangesAsync();
return(CreatedAtAction("Getchart", new { id = chart.ID }, chart));
}
public async Task <IActionResult> Putchart(int id, chart chart)
{
if (id != chart.ID)
{
return(BadRequest());
}
_context.Entry(chart).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!chartExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public async Task <ActionResult> Statastics()
{
StatasticsDto objstatastic = new StatasticsDto();
var StreameData = await dataAccess.GetUserCountByStream();
List <chart> objChartList = new List <chart>();
foreach (var item in StreameData)
{
chart objCart = new chart();
var MainStream = await dataAccess.GetMainStreamByKey(item.MainStreamId);
objCart.y = item.Count;
objCart.indexLabel = MainStream.MainStreamName;
objChartList.Add(objCart);
}
string ChartDetails = JsonConvert.SerializeObject(objChartList);
objstatastic.ChartJson = ChartDetails;
return(View(objstatastic));
}
public chart GetChart(string zpid, string unittype, string width, string height)
{
try
{
Hashtable p = new Hashtable
{
{ "zws-id", Zwsid },
{ "zpid", zpid },
{ "unit-type", unittype },
{ "width", width },
{ "height", height }
};
chart c = (chart)CallAPI(ZillowURI.Chart, p, typeof(chart));
if (c == null)
{
throw new NullReferenceException("chart API value is null");
}
if (int.Parse(c.message.code) != 0)
{
throw new Exception(string.Format("Zillow Error #{0}: {1}", c.message.code, c.message.text));
}
return(c);
}
catch (Exception ex)
{
Debug.WriteLine(ex.Message);
throw ex;
}
}
public ActionResult DeleteConfirmed(int id)
{
chart chart = db.charts.Find(id);
db.charts.Remove(chart);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "ID,name")] chart chart)
{
if (ModelState.IsValid)
{
db.Entry(chart).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(chart));
}
public ActionResult Create([Bind(Include = "ID,name")] chart chart)
{
if (ModelState.IsValid)
{
db.charts.Add(chart);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(chart));
}
// GET: charts/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
chart chart = db.charts.Find(id);
if (chart == null)
{
return(HttpNotFound());
}
return(View(chart));
}
/**
* 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 async Task <ActionResult <chart> > UpdateChart(chart _chart)
{
//var m = new List<modeltest>();
//_m.Add(new modeltest(){ID =modnew.ID , CompanyName = modnew.CompanyName });
//_m.Concat(m);
var update = _c.Where(x => x.id == _chart.id).FirstOrDefault();
if (update != null)
{
_c.Remove(update);
update.yield = _chart.yield;
_c.Add(update);
}
await SendUpdateChart(_c.OrderBy(x => x.id).ToList());
return(_chart);
}
private void btn_chart_Click(object sender, EventArgs e)
{
ButtonReset();
if (ActiveMdiChild != null)
{
if (this.ActiveMdiChild != mchildForm_Chart)
{
//ActiveMdiChild.Close();
ActiveMdiChild.Hide();
}
mchildForm_Chart = ShowActiveForm(mchildForm_Chart, typeof(chart)) as chart;
mchildForm_Chart.Show();
}
else
{
mchildForm_Chart = ShowActiveForm(mchildForm_Chart, typeof(chart)) as chart;
mchildForm_Chart.Show();
}
btn_chart.BackColor = Color.Red;
}
protected void Page_Load(object sender, EventArgs e)
{
settings lsettings = new settings();
chart lchart = new chart();
chartGraphsGraph[] graph = new chartGraphsGraph[1];
graph[0] = new chartGraphsGraph();
graph[0].gid = "1";
graph[0].title = HttpUtility.UrlEncode("Test Graph %");
graph[0].value = new chartGraphsGraphValue[2];
graph[0].value[0] = new chartGraphsGraphValue ( );
graph[0].value[0].start = 0;
graph[0].value[0].Value = 92.2;
graph[0].value[0].xid = "Question1";
graph[0].value[1] = new chartGraphsGraphValue();
graph[0].value[1].start = 0;
graph[0].value[1].Value = -22.2;
graph[0].value[1].xid = "Question2";
lchart.graphs = graph;
lchart.series = new chartValue[2];
lchart.series[0] = new chartValue();
lchart.series[1] = new chartValue();
lchart.series[0].Value = "Question1";
lchart.series[0].xid = "Question1";
lchart.series[1].Value = "Question2";
lchart.series[1].xid = "Question2";
AmChart.DataSource = new ChartDataSource( lchart, lsettings );
AmChart.DataBind();
AmChartFileSettings.DataSource = new ChartDataSource(lchart, "/testSite/path/chartTestSettings.Xml");
AmChart.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
settings lsettings = new settings();
chart lchart = new chart();
chartGraphsGraph[] graph = new chartGraphsGraph[1];
graph[0] = new chartGraphsGraph();
graph[0].gid = "1";
graph[0].title = HttpUtility.UrlEncode("Test Graph %");
graph[0].value = new chartGraphsGraphValue[2];
graph[0].value[0] = new chartGraphsGraphValue( );
graph[0].value[0].start = 0;
graph[0].value[0].Value = 92.2;
graph[0].value[0].xid = "Question1";
graph[0].value[1] = new chartGraphsGraphValue();
graph[0].value[1].start = 0;
graph[0].value[1].Value = -22.2;
graph[0].value[1].xid = "Question2";
lchart.graphs = graph;
lchart.series = new chartValue[2];
lchart.series[0] = new chartValue();
lchart.series[1] = new chartValue();
lchart.series[0].Value = "Question1";
lchart.series[0].xid = "Question1";
lchart.series[1].Value = "Question2";
lchart.series[1].xid = "Question2";
AmChart.DataSource = new ChartDataSource(lchart, lsettings);
AmChart.DataBind();
AmChartFileSettings.DataSource = new ChartDataSource(lchart, "/testSite/path/chartTestSettings.Xml");
AmChart.DataBind();
}
public void getChartReport(DataTable dt)
{
if (dt == null)
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "", string.Format("var strCharts='{0}';", ""), true);
}
else
{
chart pieChart = new chart();
string strCharts = "[";
int n = 0;
foreach (DataRow dr in dt.Rows)
{
string color = pieChart.getColor(n++);
strCharts += "{ \"category\" : \"" + dr["TypeName"].ToString() + "\", \"data\" : " + dr["BugNo"].ToString() + ", \"color\" : \"" + color + "\" },";
}
strCharts = strCharts.Substring(0, strCharts.Length - 1);
strCharts += "]";
Page.ClientScript.RegisterStartupScript(this.GetType(), "", string.Format("var strCharts='{0}';", strCharts), true);
}
}
public void getChartReport(List <Models.Report11> reportData)
{
if (reportData.Count == 0)
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "", string.Format("var strCharts='{0}';", ""), true);
}
else
{
chart pieChart = new chart();
string strCharts = "[";
int n = 0;
foreach (Models.Report11 item in reportData)
{
string color = pieChart.getColor(n++);
strCharts += "{ \"category\" : \"" + item.TypeName + "\", \"data\" : " + item.BugNo + ", \"color\" : \"" + color + "\" },";
}
strCharts = strCharts.Substring(0, strCharts.Length - 1);
strCharts += "]";
Page.ClientScript.RegisterStartupScript(this.GetType(), "", string.Format("var strCharts='{0}';", strCharts), true);
}
}
public Form3(chart ch)
{
InitializeComponent();
pie = ch;
graphics = pictureBox1.CreateGraphics();
}
/**
* 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"));
}
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"));
}
public GanttChart GetDailyProduction(string cdate, int lineid) //date format : dd/MM/yyyy
{
DateTime startdate = Convert.ToDateTime(cdate);
DateTime enddate = Convert.ToDateTime(cdate).AddDays(1);
IList <OrderDetail> orderdetail = db.OrderDetails
//.Include(o => o.Line)
.Include(o => o.Product)
//.Include(o => o.Shift)
.Where(o => o.CreatedDate.Year == startdate.Year && o.CreatedDate.Month == startdate.Month && o.CreatedDate.Day == startdate.Day && o.LineId == lineid && o.FinalStatus == 1)
.OrderBy(x => x.OrderId).ToList();
var count = orderdetail.Count;
GanttChart objganttchart = new GanttChart();
objganttchart.type = "gantt";
objganttchart.width = "100%";
objganttchart.height = "120";
objganttchart.dataFormat = "json";
dataSource objdatasource = new dataSource();
//chart
chart objchart = new chart();
objchart.theme = "fusion";
objchart.dateformat = "dd/mm/yyyy hh:mn";
objchart.showTaskLabels = 1;
//task
gtask[] arrtask = new gtask[count];
for (int i = 0; i < count; i++)
{
var objtask = new gtask();
objtask.label = orderdetail[i].Product.ProductDesc;
objtask.processid = "A";
objtask.start = orderdetail[i].OrderStartTime.ToString("dd/MM/yyyy HH:mm");
DateTime endtime = orderdetail[i].OrderEndTime ?? DateTime.Now;
objtask.end = endtime.ToString("dd/MM/yyyy HH:mm");
objtask.color = "#" + orderdetail[i].Product.ProductColor;
objtask.alpha = "85";
arrtask[i] = objtask;
}
gtasks objtasks = new gtasks();
objtasks.task = arrtask;
//processes
processes objprocesses = new processes();
process[] arrprocess = new process[1];
process objprocess = new process();
objprocess.label = orderdetail[0].OrderStartTime.ToString("dd/MM/yyyy");
objprocess.id = "A";
arrprocess[0] = objprocess;
objprocesses.isbold = "1";
objprocesses.process = arrprocess;
//categories
categories[] arrcategories = new categories[1];
categories objcategories = new categories();
objcategories.bgalpha = "0";
//category1
category[] arrcategory1 = new category[1];
category objcategory1 = new category();
objcategory1.start = startdate.ToString("dd/MM/yyyy 06:00");
objcategory1.end = enddate.ToString("dd/MM/yyyy 06:00");
objcategory1.label = "";
arrcategory1[0] = objcategory1;
objcategories.category1 = arrcategory1;
//category
category[] arrcategory = new category[24];
int arrcategorycount = arrcategory.Length;
for (int i = 0; i < arrcategorycount; i++)
{
int k = i + 1;
int stime = 6 + i;
int etime = 6 + k;
int starttime = stime >= 24 ? stime - 24 : stime;
int endtime = etime >= 24 ? etime - 24 : etime;
string startimeformat = starttime.ToString().Length == 1 ? "0" + starttime.ToString() + ":00" : starttime.ToString() + ":00";
string endtimeformat = endtime.ToString().Length == 1 ? "0" + endtime.ToString() + ":00" : endtime.ToString() + ":00";
category objcategory = new category();
objcategory.start = stime >= 24 ? enddate.ToString("dd/MM/yyyy " + startimeformat + "") : startdate.ToString("dd/MM/yyyy " + startimeformat + "");
objcategory.end = stime >= 23 ? enddate.ToString("dd/MM/yyyy " + endtimeformat + "") : startdate.ToString("dd/MM/yyyy " + endtimeformat + "");
objcategory.label = startimeformat;
arrcategory[i] = objcategory;
}
objcategories.category = arrcategory;
arrcategories[0] = objcategories;
objdatasource.chart = objchart;
objdatasource.tasks = objtasks;
objdatasource.processes = objprocesses;
objdatasource.categories = arrcategories;
objganttchart.dataSource = objdatasource;
return(objganttchart);
}
