protected void Page_Load(object sender, EventArgs e) { SalesOrderDataAccess db = new SalesOrderDataAccess(); var orders = db.GetAllOrders(); var customers = orders.Select(order => order.CustomerName).ToArray(); var netAmount = orders.Select(order => order.TotalSum).ToList(); var netTax = orders.Select(order => order.Tax).ToList(); List <object> amount = new List <object>(); List <object> tax = new List <object>(); List <object> categories = new List <object>(); netAmount.ForEach(delegate(decimal net) { amount.Add((object)net); }); netTax.ForEach(delegate(decimal net) { tax.Add((object)net); }); DotNet.Highcharts.Highcharts chart = new DotNet.Highcharts.Highcharts("chart") .InitChart(new Chart { Height = 300, Width = 600, DefaultSeriesType = ChartTypes.Line, ClassName = "chart" }) .SetTitle(new Title { Text = "Sales Orders By Company", X = -20 }) .SetXAxis(new XAxis { Categories = customers }) .SetYAxis(new YAxis { Title = new YAxisTitle { Text = "In Dollars" }, }) .SetSeries(new Series[] { new Series { Name = "Amount", Data = new Data(amount.ToArray()) }, new Series { Name = "Tax", Data = new Data(tax.ToArray()) }, }); ltrChart.Text = chart.ToHtmlString(); }
public void SetGraph() { List <cstPackingTime> lsShipInfo = Obj.call.GetPackingTimeQuantity(); String[] Sarray = new string[lsShipInfo.Count]; object[] Times = new object[lsShipInfo.Count]; for (int i = 0; i <= lsShipInfo.Count - 1; i++) { Sarray[i] = lsShipInfo[i].ShippingNumber.ToString(); String s = lsShipInfo[i].TimeSpend.ToString(); String[] t = s.Split(new char[] { ':', 'H', 'S', 'M' }); String timess = t[2].Trim() + "." + t[4].Trim(); Decimal D = Convert.ToDecimal(timess); Times[i] = Math.Round(D, 2); } #region Graph DotNet.Highcharts.Highcharts chart = new DotNet.Highcharts.Highcharts("chart") .InitChart(new Chart { Type = ChartTypes.Line }) .SetTitle(new Title { Text = "Shipment packing Time" }) .SetXAxis(new XAxis { Categories = Sarray, Title = new XAxisTitle { Text = "Shipment Numbers" }, Min = 10 }) .SetLegend(new Legend { VerticalAlign = VerticalAligns.Bottom }) .SetYAxis(new YAxis { Title = new YAxisTitle { Text = "Time in (Min.Sec)" } }) .SetSeries(new Series { Data = new Data(Times), Name = "Time Taken" }); #endregion ltrChart.Text = chart.ToHtmlString(); }
protected void Page_Load(object sender, EventArgs e) { SalesOrderDataAccess db = new SalesOrderDataAccess(); var orders = db.GetAllOrders(); var customers = orders.Select(order => order.CustomerName).ToArray(); var netAmount = orders.Select(order => order.TotalSum).ToList(); var netTax = orders.Select(order => order.Tax).ToList(); List<object> amount = new List<object>(); List<object> tax = new List<object>(); List<object> categories = new List<object>(); netAmount.ForEach(delegate(decimal net) { amount.Add((object)net); }); netTax.ForEach(delegate(decimal net) { tax.Add((object)net); }); DotNet.Highcharts.Highcharts chart = new DotNet.Highcharts.Highcharts("chart") .InitChart(new Chart { Height = 300, Width = 600, DefaultSeriesType = ChartTypes.Line, ClassName = "chart" }) .SetTitle(new Title { Text = "Sales Orders By Company", X = -20 }) .SetXAxis(new XAxis { Categories = customers }) .SetYAxis(new YAxis { Title = new YAxisTitle { Text = "In Dollars" }, }) .SetSeries(new Series[] { new Series { Name = "Amount", Data = new Data(amount.ToArray()) }, new Series { Name = "Tax", Data = new Data(tax.ToArray()) }, }); ltrChart.Text = chart.ToHtmlString(); }
public void SetGraph() { List <cstStationToatlPacked> _lsTotalPacekedPerStation = Obj.Rcall.GetStationTotalPaked(); gvStationInfo.DataSource = _lsTotalPacekedPerStation.ToList(); gvStationInfo.DataBind(); Series[] sr = new Series[_lsTotalPacekedPerStation.Count]; // chart Veriables String[] StationNames = new string[_lsTotalPacekedPerStation.Count]; for (int i = 0; i < _lsTotalPacekedPerStation.Count; i++) { sr[i] = new Series { Name = _lsTotalPacekedPerStation[i].StationName, Data = new Data(new object[] { _lsTotalPacekedPerStation[i].TotalPacked, _lsTotalPacekedPerStation[i].PartiallyPacked }) }; } DotNet.Highcharts.Highcharts chart = new DotNet.Highcharts.Highcharts("Chart") .InitChart(new DotNet.Highcharts.Options.Chart { Type = ChartTypes.Bar, BackgroundColor = new BackColorOrGradient(System.Drawing.Color.White), Height = 400, }) .SetXAxis(new DotNet.Highcharts.Options.XAxis { Categories = (new string[] { "Packed", "Partially Packed" }), Title = new XAxisTitle { Text = "Packi", Style = "fontSize: '15px', fontFamily: 'Verdana', color: 'Black'" } }) .SetTitle(new Title { Text = "Station Information ", Style = "fontSize: '30px',fontFamily: 'Verdana', fontBold: 'true', color: 'Black' " }) .SetYAxis(new YAxis { Title = new YAxisTitle { Text = "Staion Names", Style = "fontSize: '15px', fontFamily: 'Verdana', color: 'Black'" }, }) .SetSeries(sr); ltrChart.Text = chart.ToHtmlString(); }
static void Main(string[] args) { DotNet.Highcharts.Highcharts chart = new DotNet.Highcharts.Highcharts("chart") .SetXAxis(new XAxis { Categories = new[] { "Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", "Dec" } }) .SetSeries(new Series { Data = new Data(new object[] { 29.9, 71.5, 106.4, 129.2, 144.0, 176.0, 135.6, 148.5, 216.4, 194.1, 95.6, 54.4 }) }); string text = chart.ToHtmlString(); System.IO.File.AppendAllText(@"C:\Users\Ben\Desktop\chart.html", text); }
protected void Render_Chart(string name) { string[] created_time = created_time1.Select(a => a).ToArray(); object[] _like = Array.ConvertAll(likes, x => (object)x); object[] _comments = Array.ConvertAll(Comments, x => (object)x); object[] _links = Array.ConvertAll(link, x => (object)x); Array.Reverse(created_time); Array.Reverse(_like); Array.Reverse(_comments); Array.Reverse(link); string sear = searchBox.Text; DotNet.Highcharts.Highcharts chart = new DotNet.Highcharts.Highcharts("chart").InitChart(new Chart { ZoomType = ZoomTypes.X, SpacingRight = 20, DefaultSeriesType = ChartTypes.Line }) .SetTitle(new Title { Text = "Instagram " + " for: " + UserName, X = -20 }) .SetSubtitle(new Subtitle { Text = "Click and drag in the plot area to zoom in ", X = -20 }).SetXAxis(new XAxis { Categories = new[] { ConvertToString(created_time) }, Labels = new XAxisLabels { Step = null } }) .SetSeries(new[] { new Series { Type = ChartTypes.Spline, Data = new Data(_like), Name = "likes:", }, new Series { Type = ChartTypes.Column, Data = new Data(_comments), Name = "comments:", }, } ); ltChart1.Text = chart.ToHtmlString(); ExportCSV.Visible = true; Result.Visible = true; }
/// <summary> /// Creates the Html for a Chart using Restore data /// </summary> /// <returns></returns> public string RestoreByNuGetVersionChart() { string[] blobNames = { "Restore7Day.json", "Restore-Dependency7Day.json" }; List <string> xValues = new List <string>(); List <object> yValues = new List <Object>(); ReportHelpers.GetValuesFromBlobs(blobNames, StorageAccount, ContainerName, out xValues, out yValues); List <DotNet.Highcharts.Options.Series> seriesSet = new List <DotNet.Highcharts.Options.Series>(); seriesSet.Add(new DotNet.Highcharts.Options.Series { Data = new Data(yValues.ToArray()) }); DotNet.Highcharts.Highcharts installChart = ReportHelpers.GetBarChart(seriesSet, xValues, "Restores_Per_NuGet_Version"); string installChartHtml = installChart.ToHtmlString(); return(installChartHtml); }
private void loadSummaryPieChart() { queryString = "select count(*) as count, CASE greatest(Neutral,Happy,Sad,Angry,Surprised,Scared,Disgusted)" + " WHEN Neutral THEN 'Neutral'" + " WHEN Happy THEN 'Happy'" + " WHEN Sad THEN 'Sad'" + " WHEN Angry THEN 'Angry'" + " WHEN Surprised THEN 'Surprised'" + " WHEN Scared THEN 'Scared'" + " WHEN Disgusted THEN 'Disgusted'" + " else 'Unknown'" + " END AS maxColumn from alef.emotions where Student_id=" + studentId + " and Timestamp BETWEEN " + start + " AND " + end + " group by maxColumn;"; DataTable data = loadDatafromDB(queryString); var percentages = new List <object[]>(); double totalNumOfRecords = 0; foreach (DataRow dr in data.Rows) { totalNumOfRecords += Convert.ToDouble(dr["count"]); } foreach (DataRow dr in data.Rows) { double percentage = Math.Round((((Convert.ToDouble(dr["count"])) / totalNumOfRecords) * 100.0), 2); percentages.Add(new object[] { dr["maxColumn"].ToString(), percentage.ToString() }); } Title title = new DotNet.Highcharts.Options.Title(); title.Text = ""; DotNet.Highcharts.Highcharts chart2 = new DotNet.Highcharts.Highcharts("chart2").SetTitle(title); chart2.SetSeries(new Series { Type = DotNet.Highcharts.Enums.ChartTypes.Pie, Data = new Data(percentages.ToArray()) }); ltrChart2.Text = chart2.ToHtmlString(); }
private void generateGraph(ConfigDAO configs, Literal literal) { DataTable data = loadDatafromDB(queryString); Object[] intensities = new Object[data.Rows.Count]; string[] timestamps = new string[data.Rows.Count]; int index = 0; foreach (DataRow dr in data.Rows) { intensities[index] = (dr[configs.emotion].ToString() != "") ? dr[configs.emotion] : null; timestamps[index] = dr["Timestamp"].ToString(); index++; } Series[] serieses = new Series[1]; Series dataSeries = new Series { Data = new Data(intensities) }; dataSeries.Color = configs.color; dataSeries.Name = configs.emotion; serieses[0] = dataSeries; Title title = new DotNet.Highcharts.Options.Title(); title.Text = configs.graphTitle; XAxis xAxis = new XAxis(); xAxis.Categories = timestamps; xAxis.TickInterval = 200; DotNet.Highcharts.Highcharts chart = new DotNet.Highcharts.Highcharts(configs.chartName).SetXAxis(xAxis).SetSeries(serieses).SetTitle(title); literal.Text = chart.ToHtmlString(); }
protected void Page_Load(object sender, EventArgs e) { /* get data */ DataTable dt = PostOrmDB.GetTop10MentionKeyword(); var query = dt.AsEnumerable() .GroupBy(row => new { Text = row.Field<string>("keyword_value"), Keyword = row.Field<int>("KeywordId"), Senti = row.Field<int>("SentiLabel") }) .Select(grp => new { Text = grp.Key.Text, Keyword = grp.Key.Keyword, Senti = grp.Key.Senti, Count = grp.Count() }); List<string> ltext = new List<string>(); List<string> lkeyword = new List<string>(); List<int> lpos = new List<int>(); List<int> lnor = new List<int>(); List<int> lneg = new List<int>(); /* * get value of pos/nor/neg */ /* foreach (var senti in query) { if (!lkeyword.Contains(senti.Keyword.ToString())) { lkeyword.Add(senti.Keyword.ToString()); if (senti.Senti == 0 || senti.Senti == 1) { lneg.Add(senti.Count); } else{ lneg.Add(0); } if (senti.Senti == 2) { lnor.Add(senti.Count); } else{ lnor.Add(0); } if (senti.Senti == 3 || senti.Senti == 4) { lpos.Add(senti.Count); } else { lpos.Add(0); } } else { if (senti.Senti == 0 || senti.Senti == 1) { lneg[lneg.Count-1]=senti.Count; } if (senti.Senti == 2) { lnor[lnor.Count - 1] = senti.Count; } if (senti.Senti == 3 || senti.Senti == 4) { lpos[lpos.Count - 1] = senti.Count; } } } * */ foreach (var senti in query) { if (!ltext.Contains(senti.Text)) { ltext.Add(senti.Text); if (senti.Senti == 0 || senti.Senti == 1) { lneg.Add(senti.Count); } else { lneg.Add(0); } if (senti.Senti == 2) { lnor.Add(senti.Count); } else { lnor.Add(0); } if (senti.Senti == 3 || senti.Senti == 4) { lpos.Add(senti.Count); } else { lpos.Add(0); } } else { if (senti.Senti == 0 || senti.Senti == 1) { lneg[lneg.Count - 1] = senti.Count; } if (senti.Senti == 2) { lnor[lnor.Count - 1] = senti.Count; } if (senti.Senti == 3 || senti.Senti == 4) { lpos[lpos.Count - 1] = senti.Count; } } } List<string> lstr = new List<string>(); /* foreach (var item in lkeyword) { lstr.Add(item.ToString()); } */ foreach (var item in ltext) { lstr.Add(item); } //string[] o_keyword = lstr.ToArray(); string[] o_text = lstr.ToArray(); object[] o_neg = lneg.Cast<object>().ToArray(); object[] o_nor = lnor.Cast<object>().ToArray(); object[] o_pos = lpos.Cast<object>().ToArray(); /* Display chart * */ DotNet.Highcharts.Highcharts chart = new DotNet.Highcharts.Highcharts("chart") .InitChart(new Chart { DefaultSeriesType = DotNet.Highcharts.Enums.ChartTypes.Bar }) .SetTitle(new Title { Text = "Distribution of Top 10 Keywords In A Week" }) //.SetXAxis(new XAxis { Categories = o_keyword }) .SetXAxis(new XAxis { Categories = o_text }) .SetPlotOptions(new PlotOptions { Column = new PlotOptionsColumn { Stacking = Stackings.Normal } }) .SetSeries(new[] { new Series { Name = "Negative", Data = new Data(o_neg) }, new Series { Name = "Normal", Data = new Data(o_nor) }, new Series { Name = "Positive", Data = new Data(o_pos) } }); huyChart.Text = chart.ToHtmlString(); }
protected void Render_Chart() { //initialising sql variables string constring; SqlConnection myConn; string commandText; SqlCommand myComm; SqlDataReader reader; double Budget = 80000; StringBuilder Periodbuildstring = new StringBuilder(); StringBuilder databuildstring = new StringBuilder(); StringBuilder fieldbuildstring = new StringBuilder(); //get the data for the period and other parameters in arrray done //call optimiser and it will give optspends done //initalise the highchart and generate the graph done //save the data to the campaign table for the campaign created //save the data to the other media table (campaign id, spendouts )etc fields //getting the data from the database constring = WebConfigurationManager.ConnectionStrings["phasingSQL"].ToString(); myConn = new SqlConnection(constring); commandText = "select period, Salesbase, carryover, Upliftmax, spendhalf from MediaChannelPlan"; myComm = new SqlCommand(commandText, myConn); myConn.Open(); reader = myComm.ExecuteReader(); Periodbuildstring.Append(",\\,"); databuildstring.Append(",,,,\\,"); //Creating the Fields Input string Fields = ",Period,SalesBase,Carryover,UpliftMax,SpendHalf"; char delimiter = ','; string[] FieldsInput = Fields.Split(delimiter); Object[] chartValues = new Object[6]; // declare an object for the chart rendering if (reader.HasRows) { while (reader.Read()) { Periodbuildstring.Append(reader["Period"]); Periodbuildstring.Append("\\,"); databuildstring.Append(reader["SalesBase"]); databuildstring.Append(","); databuildstring.Append(reader["Carryover"]); databuildstring.Append(","); databuildstring.Append(reader["UpliftMax"]); databuildstring.Append(","); databuildstring.Append(reader["SpendHalf"]); databuildstring.Append("\\,"); } } //Creating the Text data Periodbuildstring.Remove(Periodbuildstring.Length - 2, 2); string TextData = Periodbuildstring.ToString(); char txtdelimiter = '\\'; string[] TextRows = TextData.Split(txtdelimiter); char delimit = ','; string[,] TextInput = new string[TextRows.Count(), TextRows[0].Split(delimit).Count()]; for (int i = 0; i < TextRows.Count(); i++) { for (int j = 1; j < TextRows[i].Split(delimit).Count(); j++) { TextInput[i, j] = TextRows[i].Split(delimit)[j]; } } //Creating the Numeric data databuildstring.Remove(databuildstring.Length - 2, 2); string NumData = databuildstring.ToString(); char numdelimiter = '\\'; string[] NumRows = NumData.Split(numdelimiter); double[,] NumInput = new double[NumRows.Count(), TextRows[0].Split(delimit).Count() + 3]; for (int i = 0; i < NumRows.Count(); i++) { for (int j = 1; j < NumRows[i].Split(delimit).Count(); j++) { if (NumRows[i].Split(delimit)[j] == "") { NumInput[i, j] = double.NaN; } else { NumInput[i, j] = Convert.ToDouble(NumRows[i].Split(delimit)[j]); } } } //Calling the Optimiser and setting Inputs and creating Optimising the budget Optimiser.Opt testOpt = new Optimiser.Opt(); string optSuccess; optSuccess = testOpt.SetInputs(FieldsInput, TextInput, NumInput).ToString(); optSuccess = testOpt.Optimise(Budget); double[] result = testOpt.GetOptSpends(); for (int i = 0; i < result.Length - 1; i++) { chartValues[i] = result[i]; } //Declaring Highchart chart and creating the Highcharts DotNet.Highcharts.Highcharts chart = new DotNet.Highcharts.Highcharts("chart") .InitChart(new Chart { DefaultSeriesType = ChartTypes.Column }) .SetTitle(new Title { //Text = "Monthly Number of Pizza", Text = "Monthly Budget", X = -20 }) .SetSubtitle(new Subtitle { Text = "Source: Mindshare database", X = -20 }) .SetXAxis(new XAxis { Categories = new[] { "W1", "W2", "W3", "W4", "W5", "W6" } }) .SetPlotOptions(new PlotOptions { Column = new PlotOptionsColumn { Stacking = Stackings.Normal } }) .SetSeries(new[] { //Name = "# Pizza", //Data = new Data(chartValues) // Here we put the dbase data into the chart new Series { Name = "Ads ON TV", Data = new Data(chartValues) }, new Series { Name = "Newspaper ADS", Data = new Data(chartValues) }, new Series { Name = "Magazine Ads", Data = new Data(chartValues) }, new Series { Name = "Social Networking Ads", Data = new Data(chartValues) } }); chrtMyChart.Text = chart.ToHtmlString(); // Let's visualize the chart into the webform. }
protected void Render_Chart() { // define the connection string string constringpm = "Data Source=192.168.112.10;Initial Catalog=AI_10143;User ID=sa;Password=10143"; string constringcw = "Data Source=192.168.111.10;Initial Catalog=AI_10112;User ID=sa;Password=10112"; string constringnk = "Data Source=192.168.114.10;Initial Catalog=AI_10115;User ID=sa;Password=10115"; string constringbn = "Data Source=192.168.115.10;Initial Catalog=AI_10126;User ID=sa;Password=10126"; // Declare the SQL connection SqlConnection myConnpm = new SqlConnection(constringpm); // and add a query string for retrieving the data. //string commandText = "select period, count(pizza) from pizzaDB group by period order by period"; string commandTextpm = "SELECT MONTH(BOOKING_DATE) ,COUNT([BOOKING_NO]) FROM [Vgh-ids-Booking] where YEAR(BOOKING_DATE) = '2019' group by MONTH(BOOKING_DATE) order by MONTH(BOOKING_DATE) asc"; SqlCommand myCommpm = new SqlCommand(commandTextpm, myConnpm); // Open the connection myConnpm.Open(); // and execute the query SqlDataReader readerpm = myCommpm.ExecuteReader(); Object[] chartValuespm = new Object[12]; // declare an object for the chart rendering if (readerpm.HasRows) { while (readerpm.Read()) { // GetValue() returns the data row from the query // So: // GetValue(0) will contain the month number [<em>month(eaten_Pizza) as Mese</em>] // GetValue(1) will contain the number of eaten pizzas [<em>count(eaten_Pizza)</em>] chartValuespm[(Int32)readerpm.GetValue(0) - 1] = readerpm.GetValue(1); // minus 1 because the array starts from 0, whenever the months start from 1 } } else { Console.WriteLine("No rows found."); } readerpm.Close(); // close the reader // Declare the SQL connection SqlConnection myConncw = new SqlConnection(constringcw); // and add a query string for retrieving the data. //string commandText = "select period, count(pizza) from pizzaDB group by period order by period"; string commandTextcw = "SELECT MONTH(BOOKING_DATE) ,COUNT([BOOKING_NO]) FROM [Vgh-ids-Booking] where YEAR(BOOKING_DATE) = '2019' group by MONTH(BOOKING_DATE) order by MONTH(BOOKING_DATE) asc"; SqlCommand myCommcw = new SqlCommand(commandTextcw, myConncw); // Open the connection myConncw.Open(); // and execute the query SqlDataReader readercw = myCommcw.ExecuteReader(); Object[] chartValuescw = new Object[12]; // declare an object for the chart rendering if (readercw.HasRows) { while (readercw.Read()) { // GetValue() returns the data row from the query // So: // GetValue(0) will contain the month number [<em>month(eaten_Pizza) as Mese</em>] // GetValue(1) will contain the number of eaten pizzas [<em>count(eaten_Pizza)</em>] chartValuescw[(Int32)readercw.GetValue(0) - 1] = readercw.GetValue(1); // minus 1 because the array starts from 0, whenever the months start from 1 } } else { Console.WriteLine("No rows found."); } readercw.Close(); // close the reader // Declare the SQL connection SqlConnection myConnnk = new SqlConnection(constringnk); // and add a query string for retrieving the data. //string commandText = "select period, count(pizza) from pizzaDB group by period order by period"; string commandTextnk = "SELECT MONTH(BOOKING_DATE) ,COUNT([BOOKING_NO]) FROM [Vgh-ids-Booking] where YEAR(BOOKING_DATE) = '2019' group by MONTH(BOOKING_DATE) order by MONTH(BOOKING_DATE) asc"; SqlCommand myCommnk = new SqlCommand(commandTextnk, myConnnk); // Open the connection myConnnk.Open(); // and execute the query SqlDataReader readernk = myCommnk.ExecuteReader(); Object[] chartValuesnk = new Object[12]; // declare an object for the chart rendering if (readernk.HasRows) { while (readernk.Read()) { // GetValue() returns the data row from the query // So: // GetValue(0) will contain the month number [<em>month(eaten_Pizza) as Mese</em>] // GetValue(1) will contain the number of eaten pizzas [<em>count(eaten_Pizza)</em>] chartValuesnk[(Int32)readernk.GetValue(0) - 1] = readernk.GetValue(1); // minus 1 because the array starts from 0, whenever the months start from 1 } } else { Console.WriteLine("No rows found."); } readernk.Close(); // close the reader // Declare the SQL connection SqlConnection myConnbn = new SqlConnection(constringbn); // and add a query string for retrieving the data. //string commandText = "select period, count(pizza) from pizzaDB group by period order by period"; string commandTextbn = "SELECT MONTH(BOOKING_DATE) ,COUNT([BOOKING_NO]) FROM [Vgh-ids-Booking] where YEAR(BOOKING_DATE) = '2019' group by MONTH(BOOKING_DATE) order by MONTH(BOOKING_DATE) asc"; SqlCommand myCommbn = new SqlCommand(commandTextbn, myConnbn); // Open the connection myConnbn.Open(); // and execute the query SqlDataReader readerbn = myCommbn.ExecuteReader(); Object[] chartValuesbn = new Object[12]; // declare an object for the chart rendering if (readerbn.HasRows) { while (readerbn.Read()) { // GetValue() returns the data row from the query // So: // GetValue(0) will contain the month number [<em>month(eaten_Pizza) as Mese</em>] // GetValue(1) will contain the number of eaten pizzas [<em>count(eaten_Pizza)</em>] chartValuesbn[(Int32)readerbn.GetValue(0) - 1] = readerbn.GetValue(1); // minus 1 because the array starts from 0, whenever the months start from 1 } } else { Console.WriteLine("No rows found."); } readerbn.Close(); // close the reader // Declare the HighCharts object DotNet.Highcharts.Highcharts chart = new DotNet.Highcharts.Highcharts("chart").InitChart(new Chart { DefaultSeriesType = ChartTypes.Column }) .SetTooltip(new Tooltip { //HeaderFormat = "", //PointFormat = "", //FooterFormat = "", // <tr><td style="color:{series.color};padding:0">{series.name}: </ td > ' + //'<td style="padding:0"><b>{point.y:.1f} mm</b></td></tr>' Enabled = true, UseHTML = true, Shared = true }) .SetPlotOptions(new PlotOptions { Column = new PlotOptionsColumn { PointPadding = 0.2, BorderWidth = 0 } }) .SetTitle(new Title { Text = "Booking in Monthly", X = -20 }) .SetSubtitle(new Subtitle { Text = "Source: Booking DB", X = -20 }) .SetXAxis(new XAxis { Categories = new[] { "Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", "Dec" } }) .SetYAxis(new YAxis { Title = new YAxisTitle { Text = "จำนวน Booking", Style = "background: '#ffffff'" } }) .SetSeries(new[] { new Series { Name = "ปากเกร็ด-เมืองทอง", Data = new Data(chartValuespm) // Here we put the dbase data into the chart }, new Series { Name = "แจ้งวัฒนะ", Data = new Data(chartValuescw) // Here we put the dbase data into the chart }, new Series { Name = "หนองแขม", Data = new Data(chartValuesnk) // Here we put the dbase data into the chart }, new Series { Name = "บางกอกน้อย", Data = new Data(chartValuesbn) // Here we put the dbase data into the chart } }); container.InnerHtml = chart.ToHtmlString(); // Let's visualize the chart into the webform. }
protected void Calculate(object sender, EventArgs e) { double L,C,A; var mydata = new ArrayList(); ; /* if (Inductance.Text.Length > 0 && Capacitance.Text.Length > 0) { A = Convert.ToDouble(Inductance.Text) + Convert.ToDouble(Capacitance.Text); Answer.Text = A.ToString("0.000"); } else { Answer.Text = "Invalid Input"; } //Debug.Write("Calculate Pressed\n"); * * */ //s = Inductance.Text; //C = Double.TryParse(s, L); if (Double.TryParse(Inductance.Text, out L)) { } if( (Double.TryParse(Capacitance.Text,out C))&&(Double.TryParse(Inductance.Text, out L))) { //A = L + C; A = 1.0 / (6.2831853 * Math.Sqrt(L * C/1000)); Answer.Text = A.ToString("0.000") + " MHz"; for( int i = 0; i < 10; i++ ) { //mydata.Add(1.0 * i); mydata.Add( 1.0 / (6.2831853 * Math.Sqrt(L * C/1000 * 0.2 * (i+1)))); } } else { Answer.Text = "Invalid Input"; } DotNet.Highcharts.Highcharts chart = new DotNet.Highcharts.Highcharts("chart") .InitChart(new Chart { DefaultSeriesType = ChartTypes.Line, Height = 300, MarginRight = 130, //MarginBottom = 25, ClassName = "chart" }) .SetTitle(new Title { Text = "Resonant Frequency", X = -20 }) .SetXAxis(new XAxis { Categories = new[] { "20%","40%","60%","80%","100%","120%","140%","160%","180%","200%" }, //Categories = mydata; Title = new XAxisTitle {Text = "% Capacitance"}, Min = 0, Max = 9, //TickLength = 20, //TickWidth = 20, //MinTickInterval = 20 TickInterval = 1 } ) .SetYAxis(new YAxis { Title = new YAxisTitle { Text = "Frequency MHz" }, PlotLines = new [] { new YAxisPlotLines { Value = 0, Width = 1, //Color = ColorTranslator.FromHtml("808080") } } } ) .SetSeries(new Series { // Data = new Data(new object[] { 29.9, 71.5, 106.4, 129.2, 144.0, 176.0, 135.6, 148.5, 216.4, 194.1, 95.6, 54.4 }) //Data = new Data(new object mydata); Data = new Data(new object[] { mydata[0], mydata[1], mydata[2], mydata[3], mydata[4], mydata[5],mydata[6], mydata[7], mydata[8], mydata[9]}) }); ltrChart.Text = chart.ToHtmlString(); }
private void loadEmotionGraph() { queryString = "select Neutral,Happy,Sad,Angry,Surprised,Scared,Disgusted,Timestamp from alef.emotions where Student_id= " + studentId + " and Timestamp BETWEEN " + start + " AND " + end + "; "; DataTable data = loadDatafromDB(queryString); Object[] neutralIntensities = new Object[data.Rows.Count]; Object[] happyIntensities = new Object[data.Rows.Count]; Object[] sadIntensities = new Object[data.Rows.Count]; Object[] angryIntensities = new Object[data.Rows.Count]; Object[] surprisedIntensities = new Object[data.Rows.Count]; Object[] scaredIntensities = new Object[data.Rows.Count]; Object[] disgustedIntensities = new Object[data.Rows.Count]; string[] timestamps = new string[data.Rows.Count]; int index = 0; foreach (DataRow dr in data.Rows) { neutralIntensities[index] = (dr["Neutral"].ToString() != "") ? dr["Neutral"] : null; happyIntensities[index] = (dr["Happy"].ToString() != "") ? dr["Happy"] : null; sadIntensities[index] = (dr["Sad"].ToString() != "") ? dr["Sad"] : null; angryIntensities[index] = (dr["Angry"].ToString() != "") ? dr["Angry"] : null; surprisedIntensities[index] = (dr["Surprised"].ToString() != "") ? dr["Surprised"] : null; scaredIntensities[index] = (dr["Scared"].ToString() != "") ? dr["Scared"] : null; disgustedIntensities[index] = (dr["Disgusted"].ToString() != "") ? dr["Disgusted"] : null; timestamps[index] = dr["Timestamp"].ToString(); index++; } Series[] serieses = new Series[7]; Series neutralDataSeries = new Series { Data = new Data(neutralIntensities) }; neutralDataSeries.Name = "Neutral"; Series happyDataSeries = new Series { Data = new Data(happyIntensities) }; happyDataSeries.Name = "Happy"; Series sadDataSeries = new Series { Data = new Data(sadIntensities) }; sadDataSeries.Name = "Sad"; Series angryDataSeries = new Series { Data = new Data(angryIntensities) }; angryDataSeries.Name = "Angry"; Series surprisedDataSeries = new Series { Data = new Data(surprisedIntensities) }; surprisedDataSeries.Name = "Surprised"; Series scaredDataSeries = new Series { Data = new Data(scaredIntensities) }; scaredDataSeries.Name = "Scared"; Series disgustedDataSeries = new Series { Data = new Data(disgustedIntensities) }; disgustedDataSeries.Name = "Disgusted"; serieses[0] = neutralDataSeries; serieses[1] = happyDataSeries; serieses[2] = sadDataSeries; serieses[3] = angryDataSeries; serieses[4] = surprisedDataSeries; serieses[5] = scaredDataSeries; serieses[6] = disgustedDataSeries; Title title = new DotNet.Highcharts.Options.Title(); title.Text = "Emotion Summary"; XAxis xAxis = new XAxis(); xAxis.Categories = timestamps; xAxis.TickInterval = 200; DotNet.Highcharts.Highcharts chart = new DotNet.Highcharts.Highcharts("chart1").SetXAxis(xAxis).SetSeries(serieses).SetTitle(title); ltrChart.Text = chart.ToHtmlString(); }
// GET: ChartDemo public ActionResult Index() { var table = new DataTable(); var dt = @"select FirstName +' '+ LastName UserName,sum(AmountOfSales) Count from Users u inner join Sales s on s.UserId=u.UserId Where s.IsApproved=1 group by FirstName,LastName order by Count desc"; using (var dbx = new BayiPuanContext()) { var cmd = dbx.Database.Connection.CreateCommand(); var sql = dt; cmd.CommandText = sql; cmd.Connection.Open(); table.Load(cmd.ExecuteReader()); DataSet ds = new DataSet(); ds.Tables.Add(table); DotNet.Highcharts.Highcharts chart = new DotNet.Highcharts.Highcharts("chart") .InitChart(new Chart { DefaultSeriesType = ChartTypes.Column }) .SetTitle(new Title { Text = "Satış Raporu" }) .SetXAxis(new XAxis { //Categories = new[] { "Ocak", "Şubat", "Mart", "Nisan", "Mayıs", "Haziran", "Temmuz", "Ağustos", "Eylül", "Ekim", "Kasım", "Aralık" } Categories = table.AsEnumerable().Select(r => r.Field <string>("UserName").ToString()).ToArray() }) .SetYAxis(new YAxis { Title = new YAxisTitle { Text = "Satılan Ürün Miktarı" }, PlotLines = new[] { new YAxisPlotLines { Value = 0, Width = 1, Color = ColorTranslator.FromHtml("#808080") } } }) .SetSeries( new Series[] { new Series { Name = "Satılan", Data = new Data( table.AsEnumerable().Select(r => r.Field <int>("Count")).Cast <object>().ToArray() ) } } ); ViewData["chart"] = chart.ToHtmlString(); return(View()); } }
private void plotRAMData() { //RAM graph DotNet.Highcharts.Highcharts RAMChart = new DotNet.Highcharts.Highcharts("chart1").InitChart(new Chart { ZoomType = DotNet.Highcharts.Enums.ZoomTypes.Y, Type = DotNet.Highcharts.Enums.ChartTypes.Columnrange, Inverted = true }) .SetXAxis(new[] { new XAxis { Type = DotNet.Highcharts.Enums.AxisTypes.Linear, Max = 350, Reversed = false, Title = new XAxisTitle { Text = "Dose values [µGy]" } } }).SetYAxis(new[] { new YAxis { Type = DotNet.Highcharts.Enums.AxisTypes.Datetime, Title = new YAxisTitle { Text = "Date" } } }); RAMChart.SetTitle(new Title { Text = "RAM and CPD" }) .SetTooltip(new Tooltip { PointFormat = "{point.low:%e %b, %y} - {point.high:%e %b, %y}", HeaderFormat = "<b>{series.name}:</b>{point.x}<br />" }); RAMChart.SetSeries(new[] { new Series { Name = "CPD", Data = new Data(cpd), Color = System.Drawing.Color.Red }, new Series { Name = "SM-1", Data = new Data(loc1), }, new Series { Name = "SM-2", Data = new Data(loc2) }, new Series { Name = "SM-3", Data = new Data(loc3) }, new Series { Name = "SM-4", Data = new Data(loc4) } }); ltrRAM.Text = RAMChart.ToHtmlString(); }
// GET: UserHome public ActionResult Index(int id) { if (User.Identity.IsAuthenticated == false || GeneralHelpers.GetUserId() != id.ToString()) { return(RedirectToAction("SignOut", "Account")); } if (GeneralHelpers.GetUserId() == null || GeneralHelpers.GetUserId() == "") { return(RedirectToAction("SignIn", "Account")); } var product = _productQueryableRepository.Table.AsNoTracking().ToList(); var sale = _saleQueryableRepository.Table.AsNoTracking().ToList(); var gift = _giftQueryableRepository.Table.AsNoTracking().ToList(); var buyGift = _buyQueryableRepository.Table.AsNoTracking().ToList(); var user = _userQueryableRepository.Table.AsNoTracking().ToList(); List <Campaign> campaign = _campaignQueryableRepository.Table.AsNoTracking().ToList(); var score = _scroreQueryableRepository.Table.AsNoTracking().ToList(); var order = 0; var vm = new ViewModel { totalWon = (from s in score select new { s.UserId, s.ScoreTotal }).Where(p => p.UserId == id) .GroupBy(w => w.UserId) .Select(y => new ProductPoint { UserId = y.Key, SumPoint = y.Sum(x => x.ScoreTotal), //SumPointToMoney = y.Sum(x => x.AmountOfSales * x.Point * x.PointToMoney) }).ToList(), spentPoint = (from b in buyGift join g in gift on b.GiftId equals g.GiftId select new { b.UserId, b.IsApproved, g.GiftPoint }).Where(x => x.UserId == id && x.IsApproved == true) .GroupBy(w => w.UserId) .Select(y => new SpentPoint() { UserId = y.Key, SpendPoint = y.Sum(x => x.GiftPoint) }).ToList(), saleRankings = (from s in sale join u in user on s.UserId equals u.UserId select new { u.UserId, u.FirstName, u.LastName, s.AmountOfSales, s.IsApproved }).Where(x => x.IsApproved == true).GroupBy(x => new { x.UserId, x.FirstName, x.LastName }) .Select(y => new SalesRanking() { UserId = y.Key.UserId, SaleOrder = order + 1, FirstName = y.Key.FirstName, LastName = y.Key.LastName, SumSale = y.Sum(x => x.AmountOfSales) }).AsEnumerable().OrderByDescending(x => x.SumSale) }; //puan hesaplama Yöntemi //Yapılan satış miktarı * Puan //a. Toplam kazanılan puan //b. Harcanan puan //c. Kalan puan decimal remaining = vm.totalWon.Sum(t => t.SumPoint) - vm.spentPoint.Sum(s => s.SpendPoint); decimal remainingTomoney = vm.totalWon.Sum(t => t.SumPointToMoney) - vm.spentPoint.Sum(s => s.SumPointToMoney); vm.remainingScore = remaining; vm.remainingScoreToMoney = remainingTomoney; //d. Kampanya bilgileri vm.CampaignView = campaign; //e. Duyurular //f. Satış sıralamaları Chart var table = new DataTable(); var dt = @"select Top 10 FirstName +' '+ LastName UserName,sum(AmountOfSales) Count from Users u inner join Sales s on s.UserId=u.UserId Where s.IsApproved=1 group by FirstName,LastName order by Count desc"; using (var dbx = new BayiPuanContext()) { var cmd = dbx.Database.Connection.CreateCommand(); var sql = dt; cmd.CommandText = sql; cmd.Connection.Open(); table.Load(cmd.ExecuteReader()); DataSet ds = new DataSet(); ds.Tables.Add(table); } DotNet.Highcharts.Highcharts chart = new DotNet.Highcharts.Highcharts("chart") .InitChart(new Chart { DefaultSeriesType = ChartTypes.Column, }) .SetTitle(new Title { Text = "En İyi İlk 10" }) .SetXAxis(new XAxis { //Categories = new[] { "Ocak", "Şubat", "Mart", "Nisan", "Mayıs", "Haziran", "Temmuz", "Ağustos", "Eylül", "Ekim", "Kasım", "Aralık" } Categories = table.AsEnumerable().Select(r => r.Field <string>("UserName").ToString()).ToArray() }) .SetYAxis(new YAxis { Title = new YAxisTitle { Text = "Satılan Ürün Miktarı" }, PlotLines = new[] { new YAxisPlotLines { Value = 0, Width = 1, Color = ColorTranslator.FromHtml("#808080") } } }) .SetSeries( new Series[] { new Series { Name = "Toplam Ürün Satış Sayıları", Data = new Data( table.AsEnumerable().Select(r => r.Field <int>("Count")).Cast <object>().ToArray() ) } } ); ViewData["chart"] = chart.ToHtmlString(); return(View(vm)); }
private void DrawLoginChart() { bll.Action = "LOGIN"; DataTable dt = bll.LoginTrailsView(); for (int x = 0; x < dt.Rows.Count; x++) { DateTime date = DateTime.Parse(dt.Rows[x][0].ToString()); if (date.Year == DateTime.Now.Year) { if (date.Month == 01) { january++; } if (date.Month == 02) { february++; } if (date.Month == 03) { march++; } if (date.Month == 04) { april++; } if (date.Month == 05) { may++; } if (date.Month == 06) { june++; } if (date.Month == 07) { july++; } if (date.Month == 08) { august++; } if (date.Month == 09) { september++; } if (date.Month == 10) { october++; } if (date.Month == 11) { november++; } if (date.Month == 12) { december++; } } } DotNet.Highcharts.Highcharts login = new DotNet.Highcharts.Highcharts("login") .InitChart(new Chart { DefaultSeriesType = ChartTypes.Line }) .SetXAxis(new XAxis { Categories = new[] { "Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", "Dec" } }) .SetSeries(new Series { Name = "Number of Users for " + DateTime.Now.Year, Data = new Data(new object[] { january, february, march, april, may, june, july, august, september, october, november, december }) }) .SetExporting(new Exporting { Enabled = true, Filename = "Number of Users for " + DateTime.Now.Year }) .SetTitle(new Title { Text = "Number of Users for " + DateTime.Now.Year }); ltrLineChart.Text = login.ToHtmlString(); }
private void DrawBarChart() { DataTable dt = bll.ServiceProviderNumberOfRatings(); List <string> serviceProviderList = new List <string>(); List <object> happyList = new List <object>(); List <object> sadList = new List <object>(); List <object> totalList = new List <object>(); for (int counter = 0; counter < dt.Rows.Count; counter++) { string rating = dt.Rows[counter][1].ToString(); string serviceProvider = dt.Rows[counter][2].ToString(); if (counter != 0) { string previousServiceProvider = dt.Rows[counter - 1][2].ToString(); if (counter != (dt.Rows.Count - 1)) { string nextServiceProvider = dt.Rows[counter + 1][2].ToString(); if (serviceProvider != previousServiceProvider && serviceProvider != nextServiceProvider) { serviceProviderList.Add(dt.Rows[counter][2].ToString()); if (rating.Equals("happy")) { happyList.Add(dt.Rows[counter][0].ToString()); sadList.Add("0"); } else { sadList.Add(dt.Rows[counter][0].ToString()); happyList.Add("0"); } } else if (serviceProvider == nextServiceProvider) { serviceProviderList.Add(dt.Rows[counter][2].ToString()); if (rating.Equals("happy")) { happyList.Add(dt.Rows[counter][0].ToString()); sadList.Add(dt.Rows[counter + 1][0].ToString()); } else { sadList.Add(dt.Rows[counter][0].ToString()); happyList.Add(dt.Rows[counter + 1][0].ToString()); } } } } else if (counter == 0) { string nextServiceProvider = bll.NumberOfRatingsPerServiceProviderAndLocation().Rows[counter + 1][2].ToString(); if (serviceProvider != nextServiceProvider) { serviceProviderList.Add(dt.Rows[counter][2].ToString()); if (rating.Equals("happy")) { happyList.Add(dt.Rows[counter][0].ToString()); sadList.Add("0"); } else { sadList.Add(dt.Rows[counter][0].ToString()); happyList.Add("0"); } } } } for (int a = 0; a < happyList.Count; a++) { totalList.Add(int.Parse(happyList[a].ToString()) + int.Parse(sadList[a].ToString())); } DotNet.Highcharts.Highcharts summaryRatings = new DotNet.Highcharts.Highcharts("summaryRatings") .InitChart(new Chart { DefaultSeriesType = ChartTypes.Bar }) .SetXAxis(new XAxis { Categories = serviceProviderList.ToArray() }) .SetYAxis(new YAxis { StackLabels = new YAxisStackLabels { Enabled = true } }) .SetPlotOptions(new PlotOptions { Bar = new PlotOptionsBar { Stacking = Stackings.Normal, DataLabels = new PlotOptionsBarDataLabels { Enabled = true } } }) .SetTooltip(new Tooltip { Formatter = "function () { return '<b>' + this.x + '</b><br/>' + this.series.name + ': ' + this.y + '<br/>' + 'Total: ' + this.point.stackTotal; }" }) .SetSeries(new[] { new Series { Name = "Sad", Data = new Data(sadList.ToArray()), Color = System.Drawing.Color.FromArgb(255, 217, 30, 24) }, new Series { Name = "Happy", Data = new Data(happyList.ToArray()), Color = System.Drawing.Color.FromArgb(255, 244, 208, 63) } }) .SetExporting(new Exporting { Enabled = true, Filename = "Summary of Ratings (" + DateTime.Now + ")" }) .SetTitle(new Title { Text = "Summary of Ratings (" + DateTime.Now + ")" }); ltrBarChart.Text = summaryRatings.ToHtmlString(); }
protected void Calculate(object sender, EventArgs e) { double L, C, A; var mydata = new ArrayList(); ; /* * if (Inductance.Text.Length > 0 && Capacitance.Text.Length > 0) * { * * A = Convert.ToDouble(Inductance.Text) + Convert.ToDouble(Capacitance.Text); * Answer.Text = A.ToString("0.000"); * } * else * { * Answer.Text = "Invalid Input"; * } * //Debug.Write("Calculate Pressed\n"); * * */ //s = Inductance.Text; //C = Double.TryParse(s, L); if (Double.TryParse(Inductance.Text, out L)) { } if ((Double.TryParse(Capacitance.Text, out C)) && (Double.TryParse(Inductance.Text, out L))) { //A = L + C; A = 1.0 / (6.2831853 * Math.Sqrt(L * C / 1000)); Answer.Text = A.ToString("0.000") + " MHz"; for (int i = 0; i < 10; i++) { //mydata.Add(1.0 * i); mydata.Add(1.0 / (6.2831853 * Math.Sqrt(L * C / 1000 * 0.2 * (i + 1)))); } } else { Answer.Text = "Invalid Input"; } DotNet.Highcharts.Highcharts chart = new DotNet.Highcharts.Highcharts("chart") .InitChart(new Chart { DefaultSeriesType = ChartTypes.Line, Height = 300, MarginRight = 130, //MarginBottom = 25, ClassName = "chart" }) .SetTitle(new Title { Text = "Resonant Frequency", X = -20 }) .SetXAxis(new XAxis { Categories = new[] { "20%", "40%", "60%", "80%", "100%", "120%", "140%", "160%", "180%", "200%" }, //Categories = mydata; Title = new XAxisTitle { Text = "% Capacitance" }, Min = 0, Max = 9, //TickLength = 20, //TickWidth = 20, //MinTickInterval = 20 TickInterval = 1 } ) .SetYAxis(new YAxis { Title = new YAxisTitle { Text = "Frequency MHz" }, PlotLines = new [] { new YAxisPlotLines { Value = 0, Width = 1, //Color = ColorTranslator.FromHtml("808080") } } } ) .SetSeries(new Series { // Data = new Data(new object[] { 29.9, 71.5, 106.4, 129.2, 144.0, 176.0, 135.6, 148.5, 216.4, 194.1, 95.6, 54.4 }) //Data = new Data(new object mydata); Data = new Data(new object[] { mydata[0], mydata[1], mydata[2], mydata[3], mydata[4], mydata[5], mydata[6], mydata[7], mydata[8], mydata[9] }) }); ltrChart.Text = chart.ToHtmlString(); }
private void DrawPieChart() { bll.ServiceProviderID = ddlChartServiceProvider.SelectedValue; bll.LocationID = ddlChartLocation.SelectedValue; DataTable dt = bll.FilterPieChart(); List <string> serviceProviderList = new List <string>(); List <object> happyList = new List <object>(); List <object> sadList = new List <object>(); if (dt.Rows.Count == 2) { string rating = dt.Rows[0][1].ToString(); if (rating.Equals("happy")) { happyList.Add(dt.Rows[0][0].ToString()); sadList.Add(dt.Rows[1][0].ToString()); } else { sadList.Add(dt.Rows[0][0].ToString()); happyList.Add(dt.Rows[1][0].ToString()); } } else if (dt.Rows.Count == 1) { string rating = dt.Rows[0][1].ToString(); if (rating.Equals("happy")) { happyList.Add(dt.Rows[0][0].ToString()); sadList.Add("0"); } else if (rating.Equals("sad")) { sadList.Add(dt.Rows[0][0].ToString()); happyList.Add("0"); } } else { happyList.Add("0"); sadList.Add("0"); } DotNet.Highcharts.Highcharts chart = new DotNet.Highcharts.Highcharts("chart") .InitChart(new Chart { DefaultSeriesType = ChartTypes.Pie }) .SetPlotOptions(new PlotOptions { Pie = new PlotOptionsPie { DataLabels = new PlotOptionsPieDataLabels { Enabled = true, Format = "<b>{point.name}</b>: {point.percentage:.0f} %", } } }) .SetYAxis(new YAxis { Max = (int.Parse(happyList[0].ToString()) + int.Parse(sadList[0].ToString())) }) .SetTitle(new Title { Text = ddlChartServiceProvider.SelectedItem + ": " + ddlChartLocation.SelectedItem }) .SetSeries(new[] { new Series { Name = "Ratings", Data = new Data(new object[] { new DotNet.Highcharts.Options.Point { Name = "Sad", Y = int.Parse(sadList[0].ToString()), Color = System.Drawing.Color.FromArgb(255, 217, 30, 24) }, new DotNet.Highcharts.Options.Point { Name = "Happy", Y = int.Parse(happyList[0].ToString()), Color = System.Drawing.Color.FromArgb(255, 244, 208, 63), Sliced = true, Selected = true } }) } }); ltrPieChart.Text = chart.ToHtmlString(); }
public void ShipmentCountGraph() { List <cstUserShipmentCount> _lsShipmetCount = Obj.Rcall.GetUserTotalPakedPerDay().OrderByDescending(x => x.Datepacked).ToList(); List <String> lsDistinctNames = _lsShipmetCount.Select(x => x.UserName).Distinct().ToList(); List <DateTime> lsDistinctDates = _lsShipmetCount.Select(x => x.Datepacked).Distinct().ToList(); String[] strCatagories = new string[lsDistinctDates.Count]; Series[] Seri = new Series[lsDistinctNames.Count()]; int si = 0; object[] lobj = new object[lsDistinctDates.Count]; foreach (String Namei in lsDistinctNames) { List <Object> lso = new List <object>(); foreach (DateTime Dt in lsDistinctDates) { cstUserShipmentCount Shipc = new cstUserShipmentCount(); Shipc = _lsShipmetCount.SingleOrDefault(i => i.UserName == Namei && i.Datepacked == Dt); if (Shipc == null) { lso.Add(0); } else { lso.Add(Shipc.ShipmentCount); } } lso.CopyTo(lobj); Series Seris = new Series { Name = Namei, Data = new Data(lobj.ToArray()) }; Seri[si] = Seris; si++; } for (int i = 0; i < lsDistinctDates.Count; i++) { strCatagories[i] = lsDistinctDates[i].ToString("MMM dd, yyyy"); } DotNet.Highcharts.Highcharts Chart = new DotNet.Highcharts.Highcharts("Chart") .InitChart(new Chart { Type = ChartTypes.Line, }) .SetTitle(new Title { Text = "Shipment Packing Count" }) .SetXAxis(new XAxis { Categories = (strCatagories), Title = new XAxisTitle { Text = "Packing Dates" } }) .SetYAxis(new YAxis { Title = new YAxisTitle { Text = "Shipments packed" } }) .SetSeries(Seri); ltrTodayspacking.Text = Chart.ToHtmlString(); }
private void plotConsolidatedData() { //All data graph DotNet.Highcharts.Highcharts chart = new DotNet.Highcharts.Highcharts("chart").InitChart(new Chart { ZoomType = DotNet.Highcharts.Enums.ZoomTypes.X, }) .SetXAxis(new[] { new XAxis { Id = "Month Axes", Categories = datesList, Labels = new XAxisLabels { Step = 15, StaggerLines = 1 } // MinRange=30*24 } //, new XAxis // { // Id="RAM_X", // Type=DotNet.Highcharts.Enums.AxisTypes.Datetime, // // Max=350 // } }); chart.SetTitle(new Title { Text = "Space Weather and Altitude" }); chart.SetSeries(new[] { new Series { YAxis = "Sunspot", XAxis = "Month Axes", Name = "Smoothed SSN", Data = new Data(smoothedSSNList) // PlotOptionsLine=new PlotOptionsLine{PointInterval=24*24*3600000, PointStart=new PointStart(Convert.ToDateTime(datesList[0]))} }, // new Series // { // Name="CPD", // Data = new Data(cpd2), // Color= System.Drawing.Color.Red, // Type=DotNet.Highcharts.Enums.ChartTypes.Columnrange, // XAxis="RAM_X", // YAxis="RAM_Y", // PlotOptionsColumnrange=new PlotOptionsColumnrange{ // Tooltip=new PlotOptionsColumnrangeTooltip{ // PointFormat = "{point.low:%e %b, %y} - {point.high:%e %b, %y}", // HeaderFormat = "<b>{series.name}:</b>{point.y}<br />" //} // } // {PointFormat = "{point.low:%e %b, %y} - {point.high:%e %b, %y}", //HeaderFormat = "<b>{series.name}:</b>{point.x}<br />"}) // }, new Series { XAxis = "Month Axes", YAxis = "Altitude", Name = "Altitude", Data = new Data(altitudeList) }, new Series { XAxis = "Month Axes", YAxis = "Sunspot", Name = "Monthly SSN", Data = new Data(monthlySSNList) }, new Series { XAxis = "Month Axes", YAxis = "Altitude", Name = "Average Dose Values", Data = new Data(avgDoseInAllDataList) } }); chart.SetYAxis(new[] { new YAxis { Id = "Sunspot", Min = 0, Max = 400, TickInterval = 25, Title = new YAxisTitle { Text = "Sunspot Number" } }, new YAxis { Id = "Altitude", Min = 0, Max = 500, TickInterval = 30, Opposite = true, Title = new YAxisTitle { Text = "Altitude [km] and dose values [µGy]" } }, // new YAxis{ // Type=DotNet.Highcharts.Enums.AxisTypes.Linear, // Id="RAM_Y", //} }); ltrChart.Text = chart.ToHtmlString(); }
protected void Page_Load(object sender, EventArgs e) { /* get data */ DataTable dt = PostOrmDB.GetTop10MentionKeyword(); var query = dt.AsEnumerable() .GroupBy(row => new { Text = row.Field <string>("keyword_value"), Keyword = row.Field <int>("KeywordId"), Senti = row.Field <int>("SentiLabel") }) .Select(grp => new { Text = grp.Key.Text, Keyword = grp.Key.Keyword, Senti = grp.Key.Senti, Count = grp.Count() }); List <string> ltext = new List <string>(); List <string> lkeyword = new List <string>(); List <int> lpos = new List <int>(); List <int> lnor = new List <int>(); List <int> lneg = new List <int>(); /* * get value of pos/nor/neg */ /* * foreach (var senti in query) * { * if (!lkeyword.Contains(senti.Keyword.ToString())) * { * lkeyword.Add(senti.Keyword.ToString()); * * if (senti.Senti == 0 || senti.Senti == 1) * { * lneg.Add(senti.Count); * } * else{ * lneg.Add(0); * } * if (senti.Senti == 2) * { * lnor.Add(senti.Count); * } * else{ * lnor.Add(0); * } * * if (senti.Senti == 3 || senti.Senti == 4) * { * lpos.Add(senti.Count); * } * else * { * lpos.Add(0); * } * * } * else * { * if (senti.Senti == 0 || senti.Senti == 1) * { * lneg[lneg.Count-1]=senti.Count; * } * * if (senti.Senti == 2) * { * lnor[lnor.Count - 1] = senti.Count; * } * * if (senti.Senti == 3 || senti.Senti == 4) * { * lpos[lpos.Count - 1] = senti.Count; * } * * } * * } * */ foreach (var senti in query) { if (!ltext.Contains(senti.Text)) { ltext.Add(senti.Text); if (senti.Senti == 0 || senti.Senti == 1) { lneg.Add(senti.Count); } else { lneg.Add(0); } if (senti.Senti == 2) { lnor.Add(senti.Count); } else { lnor.Add(0); } if (senti.Senti == 3 || senti.Senti == 4) { lpos.Add(senti.Count); } else { lpos.Add(0); } } else { if (senti.Senti == 0 || senti.Senti == 1) { lneg[lneg.Count - 1] = senti.Count; } if (senti.Senti == 2) { lnor[lnor.Count - 1] = senti.Count; } if (senti.Senti == 3 || senti.Senti == 4) { lpos[lpos.Count - 1] = senti.Count; } } } List <string> lstr = new List <string>(); /* * foreach (var item in lkeyword) * { * lstr.Add(item.ToString()); * } */ foreach (var item in ltext) { lstr.Add(item); } //string[] o_keyword = lstr.ToArray(); string[] o_text = lstr.ToArray(); object[] o_neg = lneg.Cast <object>().ToArray(); object[] o_nor = lnor.Cast <object>().ToArray(); object[] o_pos = lpos.Cast <object>().ToArray(); /* Display chart * */ DotNet.Highcharts.Highcharts chart = new DotNet.Highcharts.Highcharts("chart") .InitChart(new Chart { DefaultSeriesType = DotNet.Highcharts.Enums.ChartTypes.Bar }) .SetTitle(new Title { Text = "Distribution of Top 10 Keywords In A Week" }) //.SetXAxis(new XAxis { Categories = o_keyword }) .SetXAxis(new XAxis { Categories = o_text }) .SetPlotOptions(new PlotOptions { Column = new PlotOptionsColumn { Stacking = Stackings.Normal } }) .SetSeries(new[] { new Series { Name = "Negative", Data = new Data(o_neg) }, new Series { Name = "Normal", Data = new Data(o_nor) }, new Series { Name = "Positive", Data = new Data(o_pos) } }); huyChart.Text = chart.ToHtmlString(); }