private void LoadChartData2()
{
Chart2.ChartAreas[0].AxisX.MajorGrid.Enabled = false;
Chart2.ChartAreas[0].AxisY.MajorGrid.Enabled = false;
string query = "SELECT City_nm,Count from tbl_stat_datewise_cnt";
SqlDataAdapter da = new SqlDataAdapter(query, con);
DataTable table = new DataTable();
da.Fill(table);
DataView dv = table.DefaultView;
Chart2.DataBind();
Chart2.Series["Series1"].Points.DataBindXY(dv, "City_nm", dv, "Count");
gv_data.DataMember = "tbl_stat_datewise_cnt";
gv_data.DataSource = table;
gv_data.DataBind();
}
protected void medchart_SelectedIndexChanged(object sender, EventArgs e)
{
//SqlConnection con = new SqlConnection(WebConfigurationManager.ConnectionStrings["medDb"].ConnectionString);
//con.Open();
//SqlCommand command = new SqlCommand("Select Sales.Purchase_Date, SUM() from MedicineMaster", con);
//SqlDataReader reader = command.ExecuteReader();
if (medchart.SelectedValue != "Month" && medchart.SelectedValue != "Select")
{
SqlConnection con = new SqlConnection(WebConfigurationManager.ConnectionStrings["medDb"].ConnectionString);
con.Open();
SqlCommand command = new SqlCommand("Select Sales.Purchase_Date,SUM(SalesInfo.Quantity) as whatis from Sales,SalesInfo where SalesInfo.Sales_ID = Sales.Sales_ID AND SalesInfo.Med_ID=@id and Sales.Purchase_Date > @temp group by Sales.Purchase_Date ", con);
command.Parameters.AddWithValue("@temp", DateTime.Now.AddDays(-30));
command.Parameters.AddWithValue("@id", medchart.SelectedValue);
SqlDataReader reader = command.ExecuteReader();
if(!reader.Read())
{
er.Text = "No Value Found For the MedID";
}
reader.Close();
SqlDataReader reader2 = command.ExecuteReader();
Chart2.DataSource = reader2;
Chart2.Series["Series1"].XValueMember = "Purchase_Date";
Chart2.Series["Series1"].YValueMembers = "whatis";
Chart2.ChartAreas[0].AxisX.LabelStyle.Format = "MM-dd";
Chart2.DataBind();
reader2.Close();
}
else if(medchart.SelectedValue != "Select")
{
SqlConnection con = new SqlConnection(WebConfigurationManager.ConnectionStrings["medDb"].ConnectionString);
con.Open();
SqlCommand command = new SqlCommand("Select Sales.Purchase_Date,SUM(SalesInfo.Quantity) as whatis from Sales,SalesInfo where SalesInfo.Sales_ID = Sales.Sales_ID and Sales.Purchase_Date > @temp group by Sales.Purchase_Date ", con);
command.Parameters.AddWithValue("@temp", DateTime.Now.AddDays(-30));
SqlDataReader reader = command.ExecuteReader();
Chart2.DataSource = reader;
Chart2.Series["Series1"].XValueMember = "Purchase_Date";
Chart2.Series["Series1"].YValueMembers = "whatis";
Chart2.ChartAreas[0].AxisX.LabelStyle.Format = "MM-dd";
Chart2.DataBind();
reader.Close();
}
}
protected void DropDownList2_SelectedIndexChanged(object sender, EventArgs e)
{
switch (DropDownList1.SelectedIndex)
{
case 0:
Chart2.Series[0].ChartType = System.Web.UI.DataVisualization.Charting.SeriesChartType.Bar;
break;
case 1:
Chart2.Series[0].ChartType = System.Web.UI.DataVisualization.Charting.SeriesChartType.Pie;
break;
case 2:
Chart2.Series[0].ChartType = System.Web.UI.DataVisualization.Charting.SeriesChartType.Area;
break;
default:
Chart2.Series[0].ChartType = System.Web.UI.DataVisualization.Charting.SeriesChartType.Column;
break;
}
switch (DropDownList2.SelectedIndex)
{
case 0:
SqlDataSource2.SelectCommand = $"SELECT [ZipCode], count([id]) as count FROM [Donation] WHERE Veg = 'True' GROUP BY [ZipCode]";
break;
case 1:
SqlDataSource2.SelectCommand = $"SELECT [ZipCode], count([id]) as count FROM [Donation] WHERE Cooked = 'True' GROUP BY [ZipCode]";
break;
case 2:
SqlDataSource2.SelectCommand = $"SELECT [ZipCode], sum([Weight]) as count FROM [Donation] GROUP BY [ZipCode]";
break;
case 3:
SqlDataSource2.SelectCommand = $"SELECT [ZipCode], count([id]) as count FROM [Donation] WHERE Price IS NOT NULL GROUP BY [ZipCode]";
break;
default:
break;
}
Chart2.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
//userID = Convert.ToInt32(Request.Cookies.Get(0).Value);
//userID = 1012;//kc testing
userID = Convert.ToInt32(Request.QueryString["userID"]);
//int count = Request.Cookies.Count;
//fifthInjury.Text = "test" + userID + "-" + count;
Chart.Series["Series1"].YValueMembers = "# of Activities";
Chart.Series["Series1"].XValueMember = "# of Weeks";
Chart1.Series["Series1"].YValueMembers = "# of Activities";
Chart1.Series["Series1"].XValueMember = "# of Weeks";
Chart2.Series["Series1"].YValueMembers = "# of Activities";
Chart2.Series["Series1"].XValueMember = "# of Weeks";
Chart3.Series["Series1"].YValueMembers = "# of Activities";
Chart3.Series["Series1"].XValueMember = "# of Weeks";
try
{
Chart.DataSource = dbObject.GetActivityData(userID, 1, "strength");
Chart1.DataSource = dbObject.GetActivityData(userID, 1, "cardio");
Chart2.DataSource = dbObject.GetActivityData(userID, 1, "health");
Chart3.DataSource = dbObject.GetActivityData(userID, 1, "sleep");
}
catch (NullReferenceException ex)
{
System.Diagnostics.Debug.WriteLine(ex.Message);
Response.Redirect("Login.aspx");
}
Chart.DataBind();
Chart1.DataBind();
Chart2.DataBind();
Chart3.DataBind();
showInjuries();
showWorkout();
foreach (string name in HealthInputSessionVariables.Activity.Keys)
{
foreach (float value in HealthInputSessionVariables.Activity.Values)
{
Label myLabel = new Label();
myLabel.ID = "lbl" + name;
myLabel.Text = value.ToString();
}
}
}
private void FillData_BarChart()
{
DataTable dt = CM_Main.GetData("COLUMNCHART1");
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
Chart2.DataSource = dt;
Chart2.Series["Series1"].XValueMember = "FULL_NAME";
Chart2.Series["Series1"].YValueMembers = "NUMBEROFJOBS";
Chart2.DataBind();
Chart2.Series["Series1"].ChartType = SeriesChartType.Column;
// Chart2.Series["Series1"]["DrawingStyle"] = "Emboss";
// Chart2.ChartAreas["ChartArea2"].Area3DStyle.Enable3D = true;
// Chart2.ChartAreas["ChartArea2"].AxisX.Interval = 1;
// Chart2.Series["Series1"].Points[i].Color = Color.FromArgb(48, 54, 65);
Chart2.ChartAreas["ChartArea2"].AxisX.MajorGrid.Enabled = false;
Chart2.ChartAreas["ChartArea2"].AxisY.MajorGrid.Enabled = false;
Chart2.ChartAreas["ChartArea2"].AxisX.LineWidth = 0;
Chart2.ChartAreas["ChartArea2"].AxisY.LineWidth = 0;
Chart2.ChartAreas["ChartArea2"].AxisX.LabelStyle.Enabled = false;
Chart2.ChartAreas["ChartArea2"].AxisY.LabelStyle.Enabled = false;
Chart2.ChartAreas["ChartArea2"].AxisY.MajorTickMark.Enabled = false;
Chart2.ChartAreas["ChartArea2"].AxisY.MinorTickMark.Enabled = false;
Chart2.ChartAreas["ChartArea2"].AxisX.MajorTickMark.Enabled = false;
Chart2.ChartAreas["ChartArea2"].AxisX.MinorTickMark.Enabled = false;
Chart2.Series["Series1"].IsValueShownAsLabel = false;
}
Chart2.Series["Series1"].ToolTip = "#VALX : #VALY";//new
}
}
private void LoadChartData()
{
Chart2.ChartAreas[0].AxisX.MajorGrid.Enabled = false;
Chart2.ChartAreas[0].AxisY.MajorGrid.Enabled = false;
string query = "SELECT * from tbl_cat_comp_graph ";
SqlDataAdapter da = new SqlDataAdapter(query, con);
DataTable table = new DataTable();
da.Fill(table);
DataView dv = table.DefaultView;
Chart2.DataBind();
Chart2.Series["Sony"].Points.DataBindXY(dv, "Ddate", dv, "cat1");
Chart2.Series["Canon"].Points.DataBindXY(dv, "Ddate", dv, "cat2");
Chart2.Series["Nikon"].Points.DataBindXY(dv, "Ddate", dv, "cat3");
getdata();
}
private void getRevenueChart()
{
using (SqlConnection conn = new SqlConnection(connStr))
{
SqlCommand cmd2 = new SqlCommand
("SELECT SUM(Payment.TotalPayed) AS Revenue, MONTH(Payment.DateOfPurchase) AS Monthly FROM Payment Group BY MONTH(Payment.DateOfPurchase)", conn);
conn.Open();
SqlDataReader rdr2 = cmd2.ExecuteReader();
// Specify the column name that contains values for X-Axis
Chart2.Series["Series2"].XValueMember = "Monthly";
// Specify the column name that contains values for Y-Axis
Chart2.Series["Series2"].YValueMembers = "Revenue";
// Set the datasource
Chart2.DataSource = rdr2;
// Finally call DataBind()
Chart2.DataBind();
}
}
public void DataBindChart2()
{
if (job2Result != null && job2Result.Count > 0)
{
Dictionary <string, float> selected = new Dictionary <string, float>();
job2Result.Where(t => t.Key.Split('-')[0].Equals(DropDownList1.SelectedValue))
.OrderBy(t => t.Value)
.ToList()
.ForEach(t =>
{
selected.Add(t.Key.Split('-')[1], t.Value);
});
Chart2.DataSource = selected;
Chart2.Series["Series1"].XValueMember = "Key";
Chart2.Series["Series1"].YValueMembers = "Value";
Chart2.DataBind();
}
}
private void _setGraphFual(DataSet iDsSet)
{
DundasCharts.DundasChartBase(Chart2, ChartImageType.Flash, 300, 300
, BorderSkinStyle.None, Color.FromArgb(181, 64, 1), 0
, Color.FromArgb(247, 243, 247)
, Color.FromArgb(0xFF, 0xFF, 0xFE), Color.FromArgb(0x20, 0x80, 0xD0), ChartDashStyle.Solid
, -1
, Dundas.Charting.WebControl.ChartHatchStyle.None, Dundas.Charting.WebControl.GradientType.None, Dundas.Charting.WebControl.AntiAliasing.Graphics);
Series series1 = DundasCharts.CreateSeries(Chart2, "Series1", "Default", "", null, SeriesChartType.Funnel, 0, Color.FromArgb(0x5A, 0x7D, 0xDE), Color.FromArgb(0x4A, 0x58, 0x7E), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64));
Chart2.Series["Series1"].Type = SeriesChartType.Funnel;
// Set funnel Y values style
Chart2.Series["Series1"]["FunnelStyle"] = "YIsHeight";
// Set funnel data point labels style
Chart2.Series["Series1"]["FunnelLabelStyle"] = "Outside";
// Place labels on the left side
Chart2.Series["Series1"]["FunnelOutsideLabelPlacement"] = "Left";
// Set gap between points
Chart2.Series["Series1"]["FunnelPointGap"] = "2";
// Set minimum point height
Chart2.Series["Series1"]["FunnelMinPointHeight"] = "1";
// Set 3D mode
Chart2.ChartAreas["Default"].Area3DStyle.Enable3D = true;
// Set 3D angle
Chart2.Series["Series1"]["Funnel3DRotationAngle"] = "7";
// Set 3D drawing style
Chart2.Series["Series1"]["Funnel3DDrawingStyle"] = "CircularBase";
Chart2.DataSource = iDsSet;
Chart2.Series[series1.Name].ValueMembersY = "PRICE";
Chart2.Series[series1.Name].ValueMemberX = "CODE";
Chart2.DataBind();
}
private void LoadChartData2()
{
string from = ddl_frommonth.Text + "/" + ddl_fromdate.Text + "/" + ddl_fromyear.Text;
string to = ddl_tomonth.Text + "/" + ddl_todate.Text + "/" + ddl_toyear.Text;
Chart2.ChartAreas[0].AxisX.MajorGrid.Enabled = false;
Chart2.ChartAreas[0].AxisY.MajorGrid.Enabled = false;
string query = "SELECT Ddate,Vcount from tbl_show_all_graph where Ddate between '" + from + "' AND '" + to + "'";
SqlDataAdapter da = new SqlDataAdapter(query, con);
DataTable table = new DataTable();
da.Fill(table);
DataView dv = table.DefaultView;
Chart2.DataBind();
Chart2.Series["Series1"].Points.DataBindXY(dv, "Ddate", dv, "VCount");
getdata();
}
protected void Page_Load(object sender, EventArgs e)
{
DataTable dt1 = CreateDataTable("旷课", "");
Chart1.DataSource = dt1;
Chart1.Series[0].YValueMembers = "number";
Chart1.Series[0].XValueMember = "department";
Chart1.DataBind();
DataTable dt2 = CreateDataTable("迟到", "");
Chart2.DataSource = dt2;
Chart2.Series[0].YValueMembers = "number";
Chart2.Series[0].XValueMember = "department";
Chart2.DataBind();
}
public void loadchart2()
{
try
{
SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder();
builder.ConnectionString = ConfigurationManager.AppSettings["connsr"];
using (SqlConnection connection = new SqlConnection(builder.ConnectionString))
{
connection.Open();
StringBuilder sb = new StringBuilder();
//sb.Append("SELECT TOP 1 label, confidence, ConnectionDeviceGenerationId, EnqueuedTime, inserttime FROM visionkitinputs order by EnqueuedTime desc");
sb.Append("select max(EnqueuedTime) as EnqueuedTime, Avg(confidence) as confidence ");
sb.Append("from visionkitinputs ");
sb.Append("where EnqueuedTime between dateadd(dd,-1,getUTCdate()) and getUTCdate() ");
sb.Append("group by DATEPART(hour, EnqueuedTime) ");
sb.Append("order by EnqueuedTime desc");
String sql = sb.ToString();
using (SqlCommand command = new SqlCommand(sql, connection))
{
using (SqlDataReader reader = command.ExecuteReader())
{
Chart2.DataSource = reader;
Chart2.Series[0].YValueMembers = "confidence";
Chart2.Series[0].XValueMember = "EnqueuedTime";
Chart2.DataBind();
}
}
}
}
catch (Exception ex)
{
errortxt.Text = "Error: " + ex.Message.ToString() + System.Environment.NewLine;
errortxt.Text += "Error: " + ex.StackTrace.ToString() + System.Environment.NewLine;
//throw ex;
}
}
protected void DropDownList2_SelectedIndexChanged(object sender, EventArgs e)
{
if (!DropDownList2.SelectedValue.Equals("-1"))
{
GridView6.Visible = true;
GridView5.Visible = true;
Chart2.Visible = true;
Label4.Text = DropDownList2.SelectedItem.Text + "Overall Results";
GridView5.DataBind();
GridView6.DataBind();
Chart2.DataBind();
}
else
{
GridView6.Visible = false;
GridView5.Visible = false;
Chart2.Visible = false;
Label4.Text = "No Semester Selected!";
}
}
protected void Button1_Click(object sender, EventArgs e)
{
Chart1.DataSource = sv.DemLuot(int.Parse(DropDownList1.SelectedValue));
Chart1.Legends.Add("average_marks").Title = "Biểu đồ lượt thuê xe";
Chart1.ChartAreas["ChartArea1"].AxisY.Title = " Số Lượt Thuê";
Chart1.ChartAreas["ChartArea1"].AxisX.Title = "Xe";
Chart1.Series["SoLuot"].XValueMember = "Xe";
Chart1.Series["SoLuot"].YValueMembers = "SoLuot";
Chart1.DataBind();
Chart2.DataSource = sv.ThongKeTienTam(int.Parse(DropDownList1.SelectedValue));
Chart2.Legends.Add("average_marks").Title = "Biểu đồ doanh thu xe";
Chart2.ChartAreas["ChartArea1"].AxisY.Title = "Tiền doanh thu";
Chart2.ChartAreas["ChartArea1"].AxisX.Title = "Xe";
Chart2.Series["VND"].XValueMember = "BangSo";
Chart2.Series["VND"].YValueMembers = "ThanhTien";
Chart2.DataBind();
Literal1.Text = "Doanh Thu trong tháng : " + sv.ThongKeTienThang(int.Parse(DropDownList1.SelectedValue)) + " VND";;
}
protected void Page_Load(object sender, EventArgs e)
{
// istatikler için çartların sonuçlarının toplanması.
Chart1.DataSource = getdata1();
Chart1.DataBind();
Repeater1.DataSource = getdata();
Repeater1.DataBind();
Chart1.ChartAreas[0].AxisX.Title = "gender";
Chart1.ChartAreas[0].AxisY.Title = "picture2";
Chart2.DataSource = getdata2();
Chart2.DataBind();
Chart2.ChartAreas[0].AxisX.Title = "gender";
Chart2.ChartAreas[0].AxisY.Title = "picture1";
basligiAl();
Chart3.DataSource = getdata3();
Chart3.DataBind();
Chart3.ChartAreas[0].AxisX.Title = "age_group";
Chart3.ChartAreas[0].AxisY.Title = "picture1";
Chart4.DataSource = getdata4();
Chart3.DataBind();
Chart4.ChartAreas[0].AxisX.Title = "age_group";
Chart4.ChartAreas[0].AxisY.Title = "picture2";
}
protected void FillCharts()
{
DataTable dt = GetData("select * from dbo.top10_Origin");
Chart1.Series[0].ChartType = SeriesChartType.Pie;
Chart1.DataSource = dt;
Chart1.Series.First().XValueMember = "Origin";
Chart1.Series.First().YValueMembers = "Count";
Chart1.DataBind();
Chart1.ChartAreas["ChartArea1"].BackColor = System.Drawing.Color.Transparent;
dt.Clear();
dt = GetData("select * from dbo.flightCount");
Chart2.Series[0].ChartType = SeriesChartType.Pie;
Chart2.DataSource = dt;
Chart2.Series.First().XValueMember = "Code";
Chart2.Series.First().YValueMembers = "Flight Count";
Chart2.DataBind();
Chart2.ChartAreas["ChartArea1"].BackColor = System.Drawing.Color.Transparent;
dt.Clear();
dt = GetData("select * from dbo.avgDelay");
Chart3.Series[0].ChartType = SeriesChartType.Column;
Chart3.DataSource = dt;
Chart3.Series.First().XValueMember = "Code";
Chart3.Series.First().YValueMembers = "Average Delay";
Chart3.DataBind();
Chart3.ChartAreas["ChartArea1"].BackColor = System.Drawing.Color.Transparent;
}
protected void ListarGrafico()
{
string IDE_OBJETIVO = string.Empty;
if (ddlObejtivos.SelectedIndex == 0)
{
IDE_OBJETIVO = string.Empty;
}
else
{
IDE_OBJETIVO = ddlObejtivos.SelectedValue.ToString();
}
BL_RRHH_DESEMPENIO_OBJETIVOS obj = new BL_RRHH_DESEMPENIO_OBJETIVOS();
DataTable dtResultado = new DataTable();
dtResultado.Clear();
dtResultado = obj.uspSEL_RRHH_DESEMPENIO_GRAFICO(lblPersonal.Text, Convert.ToInt32(Session["ANIO"]), IDE_OBJETIVO);
DataTable dt = dtResultado;
/*
* string[] x = new string[dt.Rows.Count];
* int[] y = new int[dt.Rows.Count];
*
* for (int i = 0; i < dt.Rows.Count; i++)
* {
* x[i] = dt.Rows[i]["OBJ"].ToString();
* y[i] = Convert.ToInt32(dt.Rows[i]["AVANCE"]);
* }
* Chart1.Series["Series1"].Points.DataBindXY(x, y);
*
* Chart1.Series[0].ChartType = SeriesChartType.Column;
* Chart1.Series["Series1"].Label = "#PERCENT";
* Chart1.Series[0].LegendText = "#VALX";
* Chart1.ChartAreas["ChartArea1"].Area3DStyle.Enable3D = true;
* Chart1.Legends["Series1"].Enabled = true;
*
*
* string[] x2 = new string[dt.Rows.Count];
* int[] y2 = new int[dt.Rows.Count];
* string[] l2 = new string[dt.Rows.Count];
* for (int i = 0; i < dt.Rows.Count; i++)
* {
* x2[i] = dt.Rows[i]["obj2"].ToString();
* y2[i] = Convert.ToInt32(dt.Rows[i]["TOTAL_TRANSCURRIDOS"]);
* l2[i] = dt.Rows[i]["LEYENDA_TRANSCURRIDOS"].ToString();
*
* }
* Chart2.Series[0].Points.DataBindXY(x2, y2);
* Chart2.Series[0].ToolTip = l2.ToString();
* Chart2.Series[0].IsValueShownAsLabel = true;
* Chart2.Series[0].ChartType = SeriesChartType.Column;
*/
//Chart1.ResetAutoValues();
Chart1.Series[0].Points.Clear();
Chart1.Series["Series1"].Points.Clear();
Chart1.ResetAutoValues();
Chart1.DataSource = dtResultado;
Chart1.DataBind();
Chart1.Series[0].IsValueShownAsLabel = true;
//Chart1.Series["Series1"].Label = "#PERCENT";
Chart2.DataSource = dtResultado;
Chart2.DataBind();
Chart2.Series[0].IsValueShownAsLabel = true;
Chart2.Series[1].IsValueShownAsLabel = true;
Chart2.Series[0].LegendText = "Días transcurridos";
Chart2.Series[1].LegendText = "Total de días";
}
protected void Page_Load(object sender, EventArgs e)
{
Chart.Series["Series1"].YValueMembers = "# of Activities";
Chart.Series["Series1"].XValueMember = "# of Weeks";
Chart1.Series["Series1"].YValueMembers = "# of Activities";
Chart1.Series["Series1"].XValueMember = "# of Weeks";
Chart2.Series["Series1"].YValueMembers = "# of Activities";
Chart2.Series["Series1"].XValueMember = "# of Weeks";
Chart3.Series["Series1"].YValueMembers = "# of Activities";
Chart3.Series["Series1"].XValueMember = "# of Weeks";
try
{
Chart.DataSource = dbObject.GetActivityData(((SessionData)Session["User_Data"])._loginID, 1, "strength");
Chart1.DataSource = dbObject.GetActivityData(((SessionData)Session["User_Data"])._loginID, 1, "cardio");
Chart2.DataSource = dbObject.GetActivityData(((SessionData)Session["User_Data"])._loginID, 1, "health");
Chart3.DataSource = dbObject.GetActivityData(((SessionData)Session["User_Data"])._loginID, 1, "sleep");
}
catch (NullReferenceException ex)
{
System.Diagnostics.Debug.WriteLine(ex.Message);
Response.Redirect("Login.aspx");
}
Chart.DataBind();
Chart1.DataBind();
Chart2.DataBind();
Chart3.DataBind();
showInjuries();
showWorkout();
if (!IsPostBack)
{
dictInjury.Add("Head", 0);
dictInjury.Add("Right Shoulder", 0);
dictInjury.Add("Right Elbow", 0);
dictInjury.Add("Right Hand", 0);
dictInjury.Add("Right Knee", 0);
dictInjury.Add("Right Foot", 0);
dictInjury.Add("Abdomen", 0);
dictInjury.Add("Left Shoulder", 0);
dictInjury.Add("Left Elbow", 0);
dictInjury.Add("Left Knee", 0);
dictInjury.Add("Left Foot", 0);
dictInjury.Add("Neck", 0);
dictInjury.Add("Left Shoulder Blade", 0);
dictInjury.Add("Left Forearm", 0);
dictInjury.Add("Lumbar", 0);
dictInjury.Add("Thoracic", 0);
dictInjury.Add("Left Heel", 0);
dictInjury.Add("Right Heel", 0);
dictInjury.Add("Right Shoulder Blade", 0);
dictInjury.Add("Right Forearm", 0);
dictInjury.Add("Left Hand", 0);
}
foreach (string name in HealthInputSessionVariables.Activity.Keys)
{
foreach (float value in HealthInputSessionVariables.Activity.Values)
{
Label myLabel = new Label();
myLabel.ID = "lbl" + name;
myLabel.Text = value.ToString();
}
}
}
private void buildBarChart(string country, string type, DateTime dateStart, DateTime dateEnd)
{
String myConnect = ConfigurationManager.ConnectionStrings["EADPConnectionString2"].ToString();
SqlConnection myConn = new SqlConnection(myConnect);
DataSet ds = new DataSet();
String strSQL = "SELECT location, avg(cost) as cost FROM [dbo].[Trip] ";
if (!country.Equals("All"))
{
strSQL += "where location = @paraCountry ";
strSQL += "and status != 'Cancelled' ";
}
if (!type.Equals("All") && (!country.Equals("All")))
{
strSQL += "and triptype = @paratype ";
strSQL += "and status != 'Cancelled' ";
}
else if (!type.Equals("All") && (country.Equals("All")))
{
strSQL += "where triptype = @paratype ";
strSQL += "and status != 'Cancelled' ";
}
if ((!dateStart.Equals("") || (!dateEnd.Equals(""))) && (country.Equals("All")) && (type.Equals("All")))
{
strSQL += "where TRIPSTART BETWEEN @paradateStart and @paradateEnd ";
strSQL += "and status != 'Cancelled' ";
}
else if ((!dateStart.Equals("") || (!dateEnd.Equals(""))) && (!country.Equals("All")) && (type.Equals("All")))
{
strSQL += "and TRIPSTART BETWEEN @paradateStart and @paradateEnd ";
strSQL += "and status != 'Cancelled' ";
}
else if ((!dateStart.Equals("") || (!dateEnd.Equals(""))) && (country.Equals("All")) && (!type.Equals("All")))
{
strSQL += "and TRIPSTART BETWEEN @paradateStart and @paradateEnd ";
strSQL += "and status != 'Cancelled' ";
}
else if ((!dateStart.Equals("") || (!dateEnd.Equals(""))) && (!country.Equals("All")) && (!type.Equals("All")))
{
strSQL += "and TRIPSTART BETWEEN @paradateStart and @paradateEnd ";
strSQL += "and status != 'Cancelled' ";
}
strSQL += "group by location";
SqlDataAdapter da = new SqlDataAdapter(strSQL.ToString(), myConn);
if (!country.Equals("All"))
{
da.SelectCommand.Parameters.AddWithValue("@paraCountry", country);
}
if (!type.Equals("All"))
{
da.SelectCommand.Parameters.AddWithValue("@paratype", type);
}
if (!dateStart.Equals(""))
{
da.SelectCommand.Parameters.AddWithValue("@paradateStart", dateStart);
}
if (!dateEnd.Equals(""))
{
da.SelectCommand.Parameters.AddWithValue("@paradateEnd", dateEnd);
}
da.Fill(ds, "tripTable");
Chart2.DataSource = ds;
Chart2.DataBind();
string imgPathing2 = HttpContext.Current.Request.PhysicalApplicationPath + tmpChartName2;
Chart2.SaveImage(imgPathing2);
}
private void _setGraph(DataSet dsPie, DataSet dsLine)
{
// Line GRAPH
DundasCharts.DundasChartBase(Chart2, ChartImageType.Flash, 550, 300
, BorderSkinStyle.Emboss, Color.FromArgb(181, 64, 1), 2
, Color.FromArgb(0xFF, 0xFF, 0xFE)
, Color.FromArgb(0xFF, 0xFF, 0xFE), Color.FromArgb(0x20, 0x80, 0xD0), ChartDashStyle.Solid
, -1
, ChartHatchStyle.None, GradientType.TopBottom, AntiAliasing.None);
Series[] oasrType = new Series[dsLine.Tables[0].Rows.Count];
int intLP = 0;
foreach (DataRow row in dsLine.Tables[0].Rows)
{
oasrType[intLP] = DundasCharts.CreateSeries(Chart2, "Series" + intLP.ToString(), Chart2.ChartAreas[0].Name,
row["GBN_NM"].ToString(), null, SeriesChartType.Line, 3,
GetChartColor(intLP), GetChartColor(intLP), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64));
for (int colIndex = 1; colIndex < dsLine.Tables[0].Columns.Count; colIndex++)
{
string columnName = dsLine.Tables[0].Columns[colIndex].ColumnName;
double YVal = double.Parse(row[columnName].ToString());
Chart2.Series[oasrType[intLP].Name].Points.AddXY(columnName, YVal);
}
intLP += 1;
}
DundasAnimations.DundasChartBase(Chart2, AnimationTheme.None, -1, -1, false, 1);
for (int i = 0; i < oasrType.Length; i++)
{
if (i == 0)
{
DundasAnimations.GrowingAnimation(Chart2, oasrType[i], 0.5, 1.0, true);
}
else
{
DundasAnimations.GrowingAnimation(Chart2, oasrType[i], i + 0.1, 1.0, true);
}
oasrType[i].MarkerStyle = GetMarkerStyle(i);
oasrType[i].MarkerColor = GetChartColor(i);
oasrType[i].MarkerBorderColor = GetChartColor(i);
}
Chart2.ChartAreas[0].AxisY.LabelStyle.Format = "#,###";
Chart2.DataSource = dsLine.Tables[0].DefaultView;
Chart2.DataBind();
// PIE GRAPH
DundasCharts.DundasChartBase(Chart1, ChartImageType.Flash, 250, 300
, BorderSkinStyle.Emboss, Color.FromArgb(181, 64, 1), 2
, Color.FromArgb(0xFF, 0xFF, 0xFE)
, Color.FromArgb(0xFF, 0xFF, 0xFE), Color.FromArgb(0x20, 0x80, 0xD0), ChartDashStyle.Solid
, -1
, ChartHatchStyle.None, GradientType.TopBottom, AntiAliasing.None);
Series serPie = DundasCharts.CreateSeries(Chart1, "Series1", "Default", "고객상태별점유율", null, SeriesChartType.Pie, 1, Color.FromArgb(0x5A, 0x7D, 0xDE), Color.FromArgb(0x4A, 0x58, 0x7E), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64));
Chart1.Series[serPie.Name].ValueMemberX = "GBN_NM";
Chart1.Series[serPie.Name].ValueMembersY = "FNL_QNT";
serPie.FontColor = Color.White;
Chart1.DataSource = dsPie;
Chart1.DataBind();
}
protected void btnBargraph_Click(object sender, EventArgs e)
{
if (ddlFocusgroup.Text == "All" && ddlCatagory.Text == "All")
{
Chart2.DataSourceID = "ShowAll";
}
else
if (ddlFocusgroup.Text == "All")
{
Chart2.DataSourceID = "SqlDataAllforFocusGroup";
}
else
if (ddlCatagory.Text == "All")
{
Chart2.DataSourceID = "SqlDataAllforCatagory";
}
else
{
Chart2.DataSourceID = "SqlDSDummary";
}
Chart2.DataBind();
Chart2.Visible = true;
GridView2.Columns[0].Visible = true;
btnBargraph.Enabled = false;
btnDetaildDispplay.Visible = true;
/*SqlConnection conn = new SqlConnection();
* conn.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionString"].ToString();
* SqlCommand cmd = new SqlCommand();
* cmd.Connection = conn;
*
* cmd.CommandText =
* "SELECT AVG(Responses.Response) AS 'Average' FROM Responses INNER JOIN Question ON Responses.ID = Question.ID WHERE Question.Focus_Group='" +
* ddlFocusgroup.Text +"'" +
* "AND Question.Catagory ='"+ ddlCatagory.Text+"'";
*
*
* conn.Open();
* SqlDataReader rdr=cmd.ExecuteReader();
*
* List<int> average = new List<int>();
*
* while(rdr.Read())
* {
*
* average.Add(Convert.ToInt32(rdr["Average"]));
* }
* conn.Close();
*
* Session["Average"] = average;
* Response.Redirect("DetailedDisplay.aspx");
*
* conn.Close();*/
//Session["Focus_Group"] = ddlFocusgroup.Text;
//Session["Catagory"] = ddlCatagory.Text;
//Response.Redirect("BarChart.aspx");
}
protected void EmployeeViewButton_Click(object sender, EventArgs e)
{
int pid = getpersonalid(EnameTextBox.Text);
string empid = getemployeeid(pid);
//load attendance record
loadattendance(EmpFromDate.Text, EmpToDate.Text);
DataTable dt = new DataTable();
dt.Columns.Add("Date");
dt.Columns.Add("PunchInTime");
dt.Columns.Add("PunchOutTime");
dt.Columns.Add("Status");
int fullday = 0;
int halfday = 0;
int absent = 0;
foreach (var attendance in attendances)
{
if (attendance.EmployeeId.Equals(empid))
{
DataRow row = dt.NewRow();
row["Date"] = attendance.PunchInDate.ToShortDateString();
row["PunchInTime"] = attendance.PunchInTime;
row["PunchOutTime"] = attendance.PunchOutTime;
if (attendance.WorkingHours == 8.0)
{
fullday++;
row["Status"] = "Present(Full Day)";
}
else if (attendance.WorkingHours == 4.0)
{
halfday++;
row["Status"] = "Present(Half Day)";
}
else if (attendance.WorkingHours == 0.0)
{
absent++;
row["Status"] = "Absent";
}
dt.Rows.Add(row);
}
}
GridView1.DataSource = dt;
GridView1.DataBind();
//bind data with chart
DataTable dt1 = new DataTable();
dt1.Columns.Add("Status");
dt1.Columns.Add("Days");
List <string> status = new List <string>();
status.Add("Present(Full Day)"); status.Add("Present(Half Day)"); status.Add("Absent");
List <int> days = new List <int>();
days.Add(fullday); days.Add(halfday); days.Add(absent);
for (int i = 0; i < 3; i++)
{
DataRow row = dt1.NewRow();
row["Status"] = status[i];
row["Days"] = days[i];
dt1.Rows.Add(row);
}
Chart2.DataSource = dt1;
Chart2.DataBind();
PrintButton.Visible = true;
}
protected void btest_Click(object sender, EventArgs e)
{
MySqlConnection conexion = new MySqlConnection(con);
conexion.Open();
Boolean band = false;
MySqlCommand query = conexion.CreateCommand();
query.CommandText = "SELECT * FROM bitacoraencabezado";
MySqlDataReader red = query.ExecuteReader();
Boolean band2 = false;
Boolean band3 = false;
Boolean band4 = false;
while (red.Read())
{
if (ddllista.SelectedIndex == 1)
{
if (string.Compare(txfecha1.Text, red["fecha"].ToString()) != 0 && string.Compare(txfecha2.Text, red["fecha"].ToString()) != 0)
{
band = true;
}
}
else
{
if (ddllista.SelectedIndex == 2)
{
if (string.Compare(txfecha1.Text, red["fecha"].ToString()) != 0 && string.Compare(txfecha2.Text, red["fecha"].ToString()) != 0)
{
band2 = true;
}
}
else
{
if (ddllista.SelectedIndex == 3)
{
if (string.Compare(txfecha1.Text, red["fecha"].ToString()) != 0 && string.Compare(txfecha2.Text, red["fecha"].ToString()) != 0)
{
band3 = true;
}
}
else
{
if (ddllista.SelectedIndex == 4)
{
if (string.Compare(txfecha1.Text, red["fecha"].ToString()) != 0 && string.Compare(txfecha2.Text, red["fecha"].ToString()) != 0)
{
band4 = true;
}
}
else
{
if (ddllista.SelectedIndex == 0)
{
Response.Write("<script language=javascript>alert('No has seleccionado ninguna opción de consulta')</script>");
break;
}
}
}
}
}
}
if (band)
{
MySqlConnection conex = new MySqlConnection(con);
conex.Open();
MySqlCommand quer = conex.CreateCommand();
quer.CommandText = "SELECT hs,hr,tiemporuta, fecha FROM bitacoraencabezado where fecha BETWEEN '" + txfecha1.Text + "' and '" + txfecha2.Text + "'";
MySqlDataReader re = quer.ExecuteReader();
Chart1.Visible = true;
string aux1, aux2;
int sum = 0, cont = 0;
double totalh;
while (re.Read())
{
aux1 = re["hs"].ToString();
aux2 = re["hr"].ToString();
String[] shs = aux1.Split(':');
String[] shr = aux2.Split(':');
int dmin = (Convert.ToInt32(shr[1]) - Convert.ToInt32(shs[1]));
if (dmin < 0)
{
dmin = dmin + 60;
}
int dhor = ((Convert.ToInt32(shr[0]) - Convert.ToInt32(shs[0])) * 60);
int dh = dmin + dhor;
sum = sum + dh;
cont = cont + 1;
Chart1.DataSource = re;
Chart1.Series["X"].XValueMember = "";
Chart1.Series["Y"].YValueMembers = "tiemporuta";
Chart1.DataBind();
}
conex.Close();
totalh = sum / cont;
}
if (band2)
{
MySqlConnection conex = new MySqlConnection(con);
conex.Open();
MySqlCommand quer = conex.CreateCommand();
quer.CommandText = "SELECT kmInic,KmFin,kmrec FROM bitacoraencabezado where fecha BETWEEN '" + txfecha1.Text + "' and '" + txfecha2.Text + "'";
MySqlDataReader re = quer.ExecuteReader();
Chart2.Visible = true;
List <int> por = new List <int>();
while (re.Read())
{
Double kmi = Convert.ToDouble(re["kmInic"].ToString());
Double kmf = Convert.ToDouble(re["kmFin"].ToString());
//double kmin = double.Parse(kmi);
//double kmfin = double.Parse(kmf);
por.Add((Convert.ToInt32(re["kmrec"].ToString())));
Double tot = kmf - kmi;
String total = Convert.ToString(tot);
Chart2.DataSource = re;
Chart2.Series["X"].XValueMember = "";
Chart2.Series["Y"].YValueMembers = "kmrec";
Chart2.DataBind();
}
conex.Close();
int x = por.Count;
int sum = 0, totalp;
foreach (int li in por)
{
sum = sum + li;
}
totalp = sum / x;
}
else
{
}
if (band3)
{
MySqlConnection conex = new MySqlConnection(con);
conex.Open();
MySqlCommand quer = conex.CreateCommand();
quer.CommandText = "SELECT noRem from bitacoraencabezado where fecha BETWEEN '" + txfecha1.Text + "' and '" + txfecha2.Text + "'";
MySqlDataReader re = quer.ExecuteReader();
Chart3.Visible = true;
while (re.Read())
{
Chart3.DataSource = re;
Chart3.Series["X"].XValueMember = "";
Chart3.Series["Y"].YValueMembers = "noRem";
Chart3.DataBind();
}
quer.CommandText = "SELECT count(noRem) from bitacoraencabezado ";
}
else
{
}
if (band4)
{
}
else
{
}
conexion.Close();
}
protected void ddlChart_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
if (ddlChart.SelectedValue == "Chart1")
{
Chart1.Visible = true;
DataTable _dt = _objChartMasterManager.LeaveChart().Tables[0];
Chart1.DataSource = _dt;
Chart1.Series[0].YValueMembers = "LeaveAllowed";
Chart1.Series[0].IsValueShownAsLabel = true;
Chart1.Series[1].YValueMembers = "LeaveTypeId";
Chart1.Series[0].XValueMember = "LeaveTypeId";
Chart1.ChartAreas["ChartArea1"].AxisY.Interval = 2;
Chart1.DataBind();
}
else if (ddlChart.SelectedValue == "Chart2")
{
Chart2.Visible = true;
DataTable _dt2 = _objChartMasterManager.DesignationChart().Tables[0];
Chart2.DataSource = _dt2;
Chart2.Series[0].YValueMembers = "EmployeeId";
Chart2.Series[0].XValueMember = "Designation";
Chart2.ChartAreas["ChartArea2"].AxisY.Interval = 1;
Chart2.DataBind();
}
else if (ddlChart.SelectedValue == "Chart3")
{
Chart3.Visible = true;
DataTable _dt3 = _objChartMasterManager.DepartmentChart().Tables[0];
Chart3.DataSource = _dt3;
Chart3.Series[0].YValueMembers = "EmployeeId";
Chart3.Series[0].XValueMember = "Department";
Chart3.ChartAreas["ChartArea3"].AxisY.Interval = 1;
Chart3.DataBind();
}
else if (ddlChart.SelectedValue == "Chart4")
{
//Chart4.Visible = true;
//DataTable _dt4 = _objChartMasterManager.YearlyJoinChart().Tables[0];
//Chart4.DataSource = _dt4;
//Chart4.Series[0].YValueMembers = "EmployeeId";
//Chart4.Series[0].IsValueShownAsLabel = true;
//Chart4.Series[0].XValueMember = "JoiningDate";
//Chart4.ChartAreas["ChartArea4"].AxisY.Interval = 1;
//Chart4.DataBind();
Chart4.Visible = true;
DataTable _dt4 = _objChartMasterManager.YearlyJoinChart().Tables[0];
Chart4.DataSource = _dt4;
Chart4.Series[0].YValueMembers = "EmployeeId";
// Chart4.Series[0].IsValueShownAsLabel = true;
Chart4.Legends.IsUniqueName("ABC...............");
Chart4.Series[0].XValueMember = "JoiningDate";
Chart4.ChartAreas["ChartArea4"].AxisY.Interval = 2;
Chart4.DataBind();
}
}
catch (Exception ex)
{
lblMsg.Text = "" + ex.Message.ToString();
}
}
protected void Button1_Click(object sender, EventArgs e)
{
GridView1.Visible = false;
Button1.Visible = false;
string apid = Request.QueryString["apid"].ToString();
DataTable dt = cs.select("select * from rating where apid='" + apid + "' and status!='fraud' ");
for (int i = 0; i < dt.Rows.Count; i++)
{
string review = dt.Rows[i]["comment"].ToString();
string[] tmp = review.Split(' ');
int ngcount = review.Count();
int ccv = 0;
int negcunt = 0;
int poscount = 0;
int posv = 0;
DataTable ng = cs.select("select * from negativedataset");
if (ng.Rows.Count > 0)
{
int h = tmp.Length;
for (int j = 0; j < tmp.Length; j++)
{
int flag = 0;
string cc = tmp[j].ToLower();
string negwrd = "";
for (int f = 0; f < cc.Length; f++)
{
if (cc[f] >= 'a' && cc[f] <= 'z')
{
negwrd += cc[f];
}
}
for (int n = 0; n < ng.Rows.Count; n++)
{
string neg = ng.Rows[n]["negativewords"].ToString().ToLower();
if (neg == negwrd)
{
negcunt = negcunt + 1;
}
ccv = negcunt;
//Label1.Text = ccv.ToString();
}
}
}
DataTable vb = cs.select("select * from positivewords");
//int h = tmp.Length;
for (int j = 0; j < tmp.Length; j++)
{
string cc = tmp[j].ToLower();
string postwrd = "";
for (int f = 0; f < cc.Length; f++)
{
if (cc[f] >= 'a' && cc[f] <= 'z')
{
postwrd += cc[f];
}
}
for (int n = 0; n < vb.Rows.Count; n++)
{
string pos = vb.Rows[n]["positivewords"].ToString().ToLower();
if (pos == postwrd)
{
poscount = poscount + 1;
}
posv = poscount;
//Label1.Text = posv.ToString();
}
}
if (ccv > posv)
{
//Label1.Text = "negative";
int rid = Convert.ToInt32(dt.Rows[i]["rid"]);
int a = cs.insert("update rating set status='negative' where rid='" + rid + "' ");
}
else if (ccv < posv)
{
//Label1.Text = "positive";
int rid = Convert.ToInt32(dt.Rows[i]["rid"]);
int a = cs.insert("update rating set status='positive' where rid='" + rid + "' ");
}
else
{
//Label1.Text = "neutral";
int rid = Convert.ToInt32(dt.Rows[i]["rid"]);
int a = cs.insert("update rating set status='neutral' where rid='" + rid + "' ");
}
}
DataTable fd = cs.select("select distinct status, count(status) as negative from rating where apid='" + apid + "' and status='negative' group by status union select distinct status, count(status) as positive from rating where apid='" + apid + "' and status = 'positive' group by status union select distinct status, count(status) as neutral from rating where apid='" + apid + "' and status = 'neutral' group by status");
Chart2.DataSource = fd;
Chart2.Series[0].ChartType = SeriesChartType.RangeColumn;
//Chart2.Legends[0].Enabled = true;
Chart2.Series[0].XValueMember = "status";
Chart2.Series[0].YValueMembers = "negative";
Chart2.DataBind();
}
private void CargarGrafico(string strTipoGrafico, DataTable dtDatos, DataTable dtParam)
{
DataTable dt = new DataTable();
DataRow row;
UsersTreatments.StrCon = axVarSes.Lee <string>("strCon");
UsersTreatments.UserId = Convert.ToInt32(axVarSes.Lee <string>("strPersonId"));
UsersTreatments.BodyPartId = Convert.ToInt32(axVarSes.Lee <string>("strBodyPartId"));
UsersTreatments.InjuryId = Convert.ToInt32(axVarSes.Lee <string>("strInjuryId"));
UsersTreatments.WaveId = Convert.ToInt32(axVarSes.Lee <string>("strWaveId"));
UsersTreatments.TreatmentId = Convert.ToInt32(axVarSes.Lee <string>("strTreatmentId"));
int i, j;
Chart2.Visible = true;
gvDatos2.Visible = true;
gvDatos2.DataSource = UsersTreatments.SeeInjuryProgress();
gvDatos2.DataBind();
try
{
for (i = 1; i <= Convert.ToInt16(dtParam.Rows[0][5]); i++)
{
dt.Columns.Add("Valor" + i);
}
dt.Columns.Add("Descripcion");
for (i = 0; i < gvDatos2.Rows.Count; i++)
{
row = dt.NewRow();
//for (j = 1; j <= Convert.ToInt16(dtParam.Rows[0][5]); j++)
//{
row["Valor" + 1] = gvDatos2.Rows[i].Cells[4].Text; // j+3
//}
row["Descripcion"] = Server.HtmlDecode(gvDatos2.Rows[i].Cells[5].Text);
dt.Rows.Add(row);
}
Chart2.DataSource = dt;
// Adicionar las series
Chart2.Series.Clear();
for (i = 1; i <= Convert.ToInt16(dtParam.Rows[0][5]); i++)
{
Chart2.Series.Add("Series" + i);
}
for (i = 1; i <= Convert.ToInt16(dtParam.Rows[0][5]); i++)
{
Chart2.Series["Series" + i].YValueMembers = "Valor" + i;
Chart2.Series["Series" + i].XValueMember = "Descripcion";
}
// Definir intervalo del eje X
Chart2.ChartAreas[0].AxisX.Interval = 1;
Chart2.ChartAreas[0].AxisX.IntervalAutoMode = IntervalAutoMode.VariableCount;
// Definir título y pie
Chart2.Titles.Clear();
Chart2.Titles.Add(dtParam.Rows[0][0].ToString());
Chart2.Titles[0].Font = new Font("Arial", 18, FontStyle.Bold);
Chart2.Titles[0].ShadowOffset = 0; // true
Chart2.Titles[0].ShadowColor = Color.Black;
Chart2.Titles.Add(axVarSes.Lee <string>("StrInjury"));
Chart2.Titles[1].Alignment = ContentAlignment.BottomCenter;
Chart2.Titles[1].Font = new Font("Arial", 10, FontStyle.Bold);
Chart2.Titles.Add(dtParam.Rows[0]["fecha"].ToString());
Chart2.Titles[2].Alignment = ContentAlignment.BottomCenter;
Chart2.Titles[2].Font = new Font("Arial", 10, FontStyle.Bold);
switch (strTipoGrafico)
{
case "1":
for (i = 1; i <= Convert.ToInt16(dtParam.Rows[0][5]); i++)
{
Chart2.Series["Series" + i].ChartType = SeriesChartType.Line;
Chart2.Series["Series" + i].BorderWidth = 3;
Chart2.Series["Series" + i].IsValueShownAsLabel = true;
Chart2.Series["Series" + i].IsVisibleInLegend = true;
Chart2.Series["Series" + i]["DrawingStyle"] = "Cylinder";
}
break;
case "2":
for (i = 1; i <= Convert.ToInt16(dtParam.Rows[0][5]); i++)
{
Chart2.Series["Series" + i].ChartType = SeriesChartType.Bar;
Chart2.Series["Series" + i]["DrawingStyle"] = "Cylinder";
}
break;
case "3":
for (i = 1; i <= Convert.ToInt16(dtParam.Rows[0][5]); i++)
{
Chart2.Series["Series" + i].ChartType = SeriesChartType.Line;
}
break;
case "4":
for (i = 1; i <= Convert.ToInt16(dtParam.Rows[0][5]); i++)
{
Chart2.Series["Series" + i].ChartType = SeriesChartType.Area;
}
break;
case "5":
for (i = 1; i <= Convert.ToInt16(dtParam.Rows[0][5]); i++)
{
Chart2.Series["Series" + i].ChartType = SeriesChartType.FastLine;
}
break;
case "6":
for (i = 1; i <= Convert.ToInt16(dtParam.Rows[0][5]); i++)
{
Chart2.Series["Series" + i].ChartType = SeriesChartType.Point;
}
break;
case "7":
for (i = 1; i <= Convert.ToInt16(dtParam.Rows[0][5]); i++)
{
Chart2.Series["Series" + i].ChartType = SeriesChartType.Doughnut;
Chart2.Series[0]["PieLabelStyle"] = "Outside";
}
break;
default:
for (i = 1; i <= Convert.ToInt16(dtParam.Rows[0][5]); i++)
{
Chart2.Series["Series" + i].ChartType = SeriesChartType.Point;
}
break;
}
Chart2.ChartAreas["ChartArea1"].AxisX.Title = dtParam.Rows[0][4].ToString();
Chart2.ChartAreas["ChartArea1"].AxisX.TitleFont = new Font("Arial", 12, FontStyle.Bold);
Chart2.ChartAreas["ChartArea1"].AxisX.MinorGrid.Enabled = false;
Chart2.ChartAreas["ChartArea1"].AxisX.MajorGrid.Enabled = false;
Chart2.ChartAreas["ChartArea1"].AxisX.MinorTickMark.Enabled = false;
Chart2.ChartAreas["ChartArea1"].AxisX.MajorTickMark.Enabled = false;
Chart2.ChartAreas["ChartArea1"].BackColor = Color.AliceBlue;
Chart2.ChartAreas["ChartArea1"].BackSecondaryColor = Color.White;
Chart2.ChartAreas["ChartArea1"].BackGradientStyle = GradientStyle.TopBottom;
Chart2.ChartAreas["ChartArea1"].AxisY.Title = dtParam.Rows[0][3].ToString();
Chart2.ChartAreas["ChartArea1"].AxisY.TitleFont = new Font("Arial", 12, FontStyle.Bold);
Chart2.Legends["ChartLegends1"].Docking = Docking.Bottom;
Chart2.Legends["ChartLegends1"].Alignment = StringAlignment.Center;
Chart2.BorderSkin.SkinStyle = BorderSkinStyle.Emboss;
//for (i = 1; i <= Convert.ToInt16(dtParam.Rows[0][5]); i++)
//{
Chart2.Series["Series" + 1].IsVisibleInLegend = true;
Chart2.Series["Series" + 1].LegendText = gvDatos2.Columns[4].HeaderText; //i+3
//}
Chart2.DataBind();
}
catch (Exception e)
{
Chart2.Visible = false;
throw;
}
}
private void DataBindChart()
{
DataSet d = r.getAllModuleByTerm("Jan-2014");
DataTable ds = new DataTable();
ds.Columns.Add("quiz");
ds.Columns.Add("marks");
//for (int i = 0; i < d.Tables[0].Rows.Count; i++)
//{
// DataRow dr = ds.NewRow();
// dr["quiz"] = d.Tables[0].Rows[i][0].ToString();
// dr["marks"] = d.Tables[0].Rows[i][1].ToString();
// ds.Rows.Add(dr);
//}
//Chart1.DataSource = ds;
//Chart1.DataBind();
for (int j = 0; j < d.Tables.Count; j++)
{
Series sr = new Series();
sr["q"] = d.Tables[j].ToString();
// DataRow dr1= d.Tables[j].NewRow();
//dr1["quiz1"] = d.Tables[j].Rows[j][0].ToString();
//sr.Points.AddXY(dr1["quiz1"], j);
for (int i = 0; i < d.Tables[j].Rows.Count; i++)
{
DataRow dr = ds.NewRow();
dr["quiz"] = d.Tables[j].Rows[i][0].ToString();
dr["marks"] = d.Tables[j].Rows[i][1].ToString();
sr.Points.AddXY(dr["quiz"].ToString(), Convert.ToDouble(dr["marks"].ToString()));
ds.Rows.Add(dr);
}
Chart1.Series.Add(sr);
}
Chart1.DataSource = ds;
Chart1.DataBind();
Chart2.DataSource = ds;
Chart2.DataBind();
//Google Chart
DataTable dsChartData = ds;
StringBuilder strScript = new StringBuilder();
strScript.Append(@"<script type='text/javascript'>
google.load('visualization', '1', {packages: ['corechart']});</script>
<script type='text/javascript'>
function drawVisualization() {
var data = google.visualization.arrayToDataTable([
['quiz', 'marks'],");
foreach (DataRow row in dsChartData.Rows)
{
strScript.Append("['" + row["quiz"] + "'," + row["marks"] + "],");
}
strScript.Remove(strScript.Length - 1, 1);
strScript.Append("]);");
strScript.Append("var options = { title : 'Monthly Coffee Production by Country', vAxis: {title: 'Cups'}, hAxis: {title: 'Month'}, seriesType: 'bars', series: {3: {type: 'area'}} };");
strScript.Append(" var chart = new google.visualization.ComboChart(document.getElementById('chart_div')); chart.draw(data, options); } google.setOnLoadCallback(drawVisualization);");
strScript.Append(" </script>");
ltScripts.Text = strScript.ToString();
//Pie Chart
StringBuilder strScript1 = new StringBuilder();
strScript1.Append(@"<script type='text/javascript'>
google.load('visualization', '1', {packages: ['corechart']}); </script>
<script type='text/javascript'>
function drawChart() {
var data = google.visualization.arrayToDataTable([
['quiz', 'marks'],");
foreach (DataRow row in dsChartData.Rows)
{
strScript1.Append("['" + row["quiz"] + "'," + row["marks"] + "],");
}
strScript1.Remove(strScript1.Length - 1, 1);
strScript1.Append("]);");
strScript1.Append(@" var options = {
title: 'My Daily Schedule',
is3D: true,
}; ");
strScript1.Append(@"var chart = new google.visualization.PieChart(document.getElementById('piechart_3d'));
chart.draw(data, options);
}
google.setOnLoadCallback(drawChart);
");
strScript1.Append(" </script>");
ltScripts.Text = strScript1.ToString();
}
private void FillAllChartsAndGrids(string QueryDate, string QueryLocation1, string QueryLocation2)
{
string connectionString = WebConfigurationManager.ConnectionStrings["procyk01ConnectionString"].ConnectionString;
try
{
//~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
string sql = "SELECT complaint, CT ";
sql += "FROM complaints ";
sql += "WHERE (complaintdate = '" + QueryDate + "') AND (neighborhood = '" + QueryLocation1 + "') ";
if (CheckBox1.Checked == true)
{
sql += "AND complaint NOT IN ('GENERAL CONSTRUCTION', 'NONCONST', 'PAINT - PLASTER', 'PLUMBING', 'ELECTRIC', 'HEATING') ";
}
;
sql += "ORDER BY CT DESC LIMIT 10";
OdbcConnection con1 = new OdbcConnection(connectionString);
OdbcCommand cmdO = new OdbcCommand(sql, con1);
con1.Open();
OdbcDataReader reader1 = cmdO.ExecuteReader();
Chart1.DataSource = reader1;
Chart1.DataBind();
Chart1.Series["Series1"].ToolTip = "#VALX\nCount: #VALY";
reader1.Close();
con1.Close();
//~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
string sql2 = "SELECT complaint, CT ";
sql2 += "FROM complaints ";
sql2 += "WHERE (complaintdate = '" + QueryDate + "') AND (neighborhood = '" + QueryLocation2 + "') ";
if (CheckBox2.Checked == true)
{
sql2 += "AND complaint NOT IN ('GENERAL CONSTRUCTION', 'NONCONST', 'PAINT - PLASTER', 'PLUMBING', 'ELECTRIC', 'HEATING') ";
}
;
sql2 += "ORDER BY CT DESC LIMIT 10";
OdbcConnection con2 = new OdbcConnection(connectionString);
OdbcCommand cmd2 = new OdbcCommand(sql2, con2);
con2.Open();
OdbcDataReader reader2 = cmd2.ExecuteReader();
Chart2.DataSource = reader2;
Chart2.DataBind();
Chart2.Series["Series1"].ToolTip = "#VALX\nCount: #VALY";
reader2.Close();
con2.Close();
//~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
string sql3 = "SELECT Neighborhood, ZipCode, AvgIncome, BelowPovertyLine, Population ";
sql3 += "FROM Demographics WHERE (Neighborhood = '" + QueryLocation1 + "') ";
sql3 += "ORDER BY ZipCode";
OdbcConnection con3 = new OdbcConnection(connectionString);
OdbcCommand cmd3 = new OdbcCommand(sql3, con3);
con3.Open();
OdbcDataReader reader3 = cmd3.ExecuteReader();
GridView2.DataSource = reader3;
GridView2.DataBind();
reader3.Close();
con3.Close();
//~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
string sql4 = "SELECT Neighborhood, ZipCode, AvgIncome, BelowPovertyLine, Population ";
sql4 += "FROM Demographics WHERE (Neighborhood = '" + QueryLocation2 + "') ";
sql4 += "ORDER BY ZipCode";
OdbcConnection con4 = new OdbcConnection(connectionString);
OdbcCommand cmd4 = new OdbcCommand(sql4, con4);
con4.Open();
OdbcDataReader reader4 = cmd4.ExecuteReader();
GridView1.DataSource = reader4;
GridView1.DataBind();
reader4.Close();
con4.Close();
Label1.Text = QueryLocation1;
Label2.Text = QueryLocation2;
}
finally
{
//con1.Close();
}
}
private void LOAD_DASHBOARD()
{
DataTable DT = new DataTable();
DT = DASH.Select_Asset_By_Location();
Chart1.DataSource = DT;
Chart1.Series["Series1"].XValueMember = "DashDesc";
Chart1.Series["Series1"].YValueMembers = "cnt";
Chart1.Series["Series1"]["PieLabelStyle"] = "outside";
Chart1.DataBind();
Chart1.Style.Add("width", "100%");
lblC1Total.Text = "Total Assets: " + String.Format("{0:#,##0}", DT.Compute("Sum(cnt)", ""));
DataTable DT2 = new DataTable();
DT2 = DASH.Select_Asset_By_Area();
Chart2.DataSource = DT2;
Chart2.Series["Series1"].XValueMember = "DashDesc";
Chart2.Series["Series1"].YValueMembers = "cnt";
Chart2.Series["Series1"]["PieLabelStyle"] = "outside";
Chart2.DataBind();
Chart2.Style.Add("width", "100%");
lblC2Total.Text = "Total Assets: " + String.Format("{0:#,##0}", DT2.Compute("Sum(cnt)", ""));
DataTable DT3 = new DataTable();
DT3 = DASH.Select_Stock_Level();
Chart3.DataSource = DT3;
Chart3.Series["Series1"].XValueMember = "CATEGORY";
Chart3.Series["Series1"].YValueMembers = "CNT";
Chart3.Series["Series1"]["PieLabelStyle"] = "outside";
Chart3.DataBind();
Chart3.Style.Add("width", "100%");
//lblC3Total.Text = "Total Assets: " + String.Format("{0:#,##0}", DT3.Compute("Sum(CNT)", ""));
DataTable DT4 = new DataTable();
DT4 = DASH.Select_Budget_Actual();
ViewState["xBudget"] = DT4;
Chart4.DataSource = DT4;
Chart4.Series["Budget"].XValueMember = "NAME";
Chart4.Series["Budget"].YValueMembers = "BUDGET";
Chart4.Series["Actual"].XValueMember = "NAME";
Chart4.Series["Actual"].YValueMembers = "ACTUAL";
Chart4.DataBind();
Chart4.Style.Add("width", "100%");
grdView.DataSource = DT4;
grdView.DataBind();
DataTable DT5 = new DataTable();
DT5 = DASH.Get_Critical();
ViewState["xCritical"] = DT5;
grdCritical.DataSource = DT5;
grdCritical.DataBind();
lblCritical.Text = DT5.Rows.Count.ToString();
DataTable DT6 = new DataTable();
DT6 = DASH.Get_Overstocked();
ViewState["xOverstocked"] = DT6;
grdOverstocked.DataSource = DT6;
grdOverstocked.DataBind();
lblOverstocked.Text = DT6.Rows.Count.ToString();
DataTable DT7 = new DataTable();
DT7 = DASH.Get_Asset_By_Location();
ViewState["xByLocation"] = DT7;
grdByLocation.DataSource = DT7;
grdByLocation.DataBind();
lblByLocation.Text = DT7.Rows.Count.ToString();
lblStockSummary.Text = DT7.Compute("Sum(CNT)", "").ToString();
//COUNTS
DataTable DT10 = new DataTable();
DT10 = DASH.Get_OpenPO_Count();
lblOpenPo.Text = DT10.Rows[0][0].ToString();
DataTable DT11 = new DataTable();
DT11 = DASH.Get_POReceiving_Count();
lblPOReceiving.Text = DT11.Rows[0][0].ToString();
DataTable DT12 = new DataTable();
DT12 = DASH.Get_FATMApproval_Count();
lblFATMApproval.Text = DT12.Rows[0][0].ToString();
DataTable DT13 = new DataTable();
DT13 = DASH.Get_InTransit_Count();
lblInTransit.Text = DT13.Rows[0][0].ToString();
}
private void BindGrid(string table)
{
DataTable dt = new DataTable();
using (SqlConnection con = new SqlConnection(constr))
{
using (SqlCommand cmd = new SqlCommand("SELECT top 5 * FROM " + table))
{
using (SqlDataAdapter sda = new SqlDataAdapter())
{
DataTable dtCloned = new DataTable();
cmd.Connection = con;
sda.SelectCommand = cmd;
sda.Fill(dt);
ViewState["dt"] = dt;
}
}
if (table == "Hosts")
{
Hosts.DataSource = dt;
Hosts.DataBind();
string[] x = new string[dt.Rows.Count];
int[] y = new int[dt.Rows.Count];
for (int i = 0; i < dt.Rows.Count; i++)
{
x[i] = dt.Rows[i][0].ToString();
y[i] = i;
}
Chart2.Series[0].Points.DataBindXY(x, y);
Chart2.Series[0].ChartType = SeriesChartType.Pie;
Chart2.ChartAreas["ChartArea1"].Area3DStyle.Enable3D = true;
//Chart2.Legends[0].Enabled = true;
Chart2.DataSource = dt;
Chart2.DataBind();
Chart1.Series[0].Points.DataBindXY(x, y);
Chart1.Series[0].ChartType = SeriesChartType.Pyramid;
Chart1.ChartAreas["ChartArea1"].Area3DStyle.Enable3D = true;
//Chart1.Legends[0].Enabled = true;
Chart1.DataSource = dt;
Chart1.DataBind();
Chart3.Series[0].Points.DataBindXY(x, y);
Chart3.Series[0].ChartType = SeriesChartType.Column;
Chart3.ChartAreas["ChartArea1"].Area3DStyle.Enable3D = true;
//Chart3.Legends[0].Enabled = true;
Chart3.DataSource = dt;
Chart3.DataBind();
Chart4.Series[0].Points.DataBindXY(x, y);
Chart4.Series[0].ChartType = SeriesChartType.Doughnut;
Chart4.ChartAreas["ChartArea1"].Area3DStyle.Enable3D = true;
//Chart4.Legends[0].Enabled = true;
Chart4.DataSource = dt;
Chart4.DataBind();
}
else if (table == "Applications")
{
Applications.DataSource = dt;
Applications.DataBind();
}
else if (table == "Storage")
{
Storage.DataSource = dt;
Storage.DataBind();
}
else if (table == "Databases")
{
Databases.DataSource = dt;
Databases.DataBind();
}
}
}
