private void GetUserChart()
{
var model = _prov.GetDashboardData();
Libero.FusionCharts.Column2DChart bar = new Column2DChart();
bar.Background.BgColor = "ffffff";
bar.ChartTitles.Caption = "User/Agent";
bar.Template = new Libero.FusionCharts.Template.OfficeDarkTemplate();
//bar.Animation.Animation = false;
DataTable dtUserchart = new DataTable();
dtUserchart.Columns.Add("Date");
dtUserchart.Columns.Add("Value");
foreach (var item in model)
{
dtUserchart.Rows.Add(new object[] { "Agent", item.TotalAgent });
dtUserchart.Rows.Add(new object[] { "User", item.TotalUser });
dtUserchart.Rows.Add(new object[] { "Online", Membership.GetNumberOfUsersOnline() });
dtUserchart.Rows.Add(new object[] { "Locked", item.LockedUser });
dtUserchart.Rows.Add(new object[] { "Pending", item.UnapprovedUser });
}
bar.DataSource = dtUserchart;
bar.DataTextField = "Date";
bar.DataValueField = "Value";
ViewData["UserChart"] = bar;
}
private void SegmentSales()
{
DateTime fromdate = (DateTime)Session["DBFromDate"];
DateTime toDate = (DateTime)Session["DBToDate"];
var obj = (TravelSession)Session["TravelPortalSessionInfo"];
var segmentsalesObj = ent.Air_DB_GetSegmentSales(fromdate, toDate, null);
Libero.FusionCharts.Column2DChart bar = new Column2DChart();
bar.Background.BgColor = "ffffff";
bar.ChartTitles.Caption = "Segment Count";
bar.ChartTitles.SubCaption = fromdate.ToString(System.Web.Configuration.WebConfigurationManager.AppSettings["DateFormat"]) + " - " + toDate.ToString(System.Web.Configuration.WebConfigurationManager.AppSettings["DateFormat"]);
bar.Template = new Libero.FusionCharts.Template.OfficeDarkTemplate();
//bar.Animation.Animation = false;
bar.BarsVisibility.RotateNames = true;
DataTable dtSegmentSales = new DataTable();
dtSegmentSales.Columns.Add("Segment");
dtSegmentSales.Columns.Add("Count");
foreach (var item in segmentsalesObj)
{
dtSegmentSales.Rows.Add(new object[] { item.Segment, item.Count });
}
bar.DataSource = dtSegmentSales;
bar.DataTextField = "Segment";
bar.DataValueField = "Count";
ViewData["SegmentChart"] = bar;
}
private void CappingChart()
{
var da = ent.Air_Dash_GetCappingInfo();
Libero.FusionCharts.Column2DChart chart = new Column2DChart();
chart.Background.BgColor = "ffffff";
chart.ChartTitles.Caption = "Capping Status";
chart.NumberFormat.DecimalPrecision = 0;
chart.Template = new Libero.FusionCharts.Template.OfficeDarkTemplate();
chart.BarsVisibility.RotateNames = true;
DataTable dt = new DataTable();
dt.Columns.Add("AirlineCode");
dt.Columns.Add("TotalNumberOfCAP");
foreach (var item in da)
{
dt.Rows.Add(new object[] { item.AirlineCode, item.TotalNumberOfCAP, });
}
chart.DataSource = dt;
chart.DataTextField = "AirlineCode";
chart.DataValueField = "TotalNumberOfCAP";
ViewData["CappingChart"] = chart;
}
protected void Grafica()
{
string titulo = "Gráfica de total metros cúbicos por día";
// Create a chart
Column2DChart oChart = new Column2DChart();
// Set properties
oChart.Background.BgColor = "ffffff";
oChart.Background.BgAlpha = 50;
oChart.ChartTitles.Caption = titulo;
oChart.ChartTitles.SubCaption = "RD";
// Set a template
oChart.Template = new Libero.FusionCharts.Template.OfficeTemplate();
// Set data
DataSet1TableAdapters.GetAguaSuperficial_PERCENTTableAdapter db = new DataSet1TableAdapters.GetAguaSuperficial_PERCENTTableAdapter();
DataTable dtSample = db.GetData();
oChart.DataSource = dtSample;
oChart.DataTextField = "PRESA";
oChart.DataValueField = "PRODUCCION";
// Link the WebControl and the Chart
chtTopSalles.ShowChart(oChart);
}
