private void ImageToPdf(Document myDocument, out System.IO.MemoryStream stream, out iTextSharp.text.Image gif, int chart)
{
stream = new System.IO.MemoryStream();
switch (chart)
{
case 1:
Chart1.SaveImage(stream, System.Drawing.Imaging.ImageFormat.Jpeg);
break;
case 2:
Chart2.SaveImage(stream, System.Drawing.Imaging.ImageFormat.Jpeg);
break;
case 3:
Chart3.SaveImage(stream, System.Drawing.Imaging.ImageFormat.Jpeg);
break;
case 4:
Chart4.SaveImage(stream, System.Drawing.Imaging.ImageFormat.Jpeg);
break;
case 5:
Chart5.SaveImage(stream, System.Drawing.Imaging.ImageFormat.Jpeg);
break;
}
Chart1.SaveImage(stream, System.Drawing.Imaging.ImageFormat.Jpeg);
gif = iTextSharp.text.Image.GetInstance(stream.ToArray());
gif.Alignment = Element.ALIGN_CENTER;
//gif.ScaleAbsolute(10, 10);
}
private void loadChart5()
{
string queryString = (@"SELECT *
FROM
(
SELECT[pitchno],
[pitcher],
[pitchtype]
FROM[dbo].[pitchData]
WHERE pitchcall = 'StrikeCalled'
) AS SourceTable PIVOT(COUNT([pitchno]) FOR [pitchtype] IN([Splitter],
[Fastball],
[Sinker],
[ChangeUp],
[Cutter],
[Curveball],
[Slider])) AS PivotTable;" );
DataTable ChartData5 = new DataTable();
using (SqlConnection connection = new SqlConnection(connectionString))
{
connection.Open();
using (SqlDataAdapter sqlQueryAdapter = new SqlDataAdapter(queryString, connection))
{
sqlQueryAdapter.SelectCommand.CommandTimeout = 120;
DataSet dataSet = new DataSet();
sqlQueryAdapter.Fill(dataSet);
connection.Close();
ChartData5 = dataSet.Tables[0];
}
}
DataView dv = new DataView(ChartData5);
Chart5.DataSource = dv;
Chart5.DataBind();
foreach (Series cs in Chart5.Series)
{
Debug.WriteLine(cs.Name);
cs.ChartType = SeriesChartType.StackedColumn;
}
//Setting width of line
Chart5.Series[0].BorderWidth = 10;
}
private void LoadChartData4()
{
Chart5.ChartAreas[0].AxisX.MajorGrid.Enabled = false;
Chart5.ChartAreas[0].AxisY.MajorGrid.Enabled = false;
string query = "SELECT comment_type,Ccount from tbl_cat_wise_comment ";
SqlDataAdapter da = new SqlDataAdapter(query, con);
DataTable table = new DataTable();
da.Fill(table);
DataView dv = table.DefaultView;
Chart5.DataBind();
Chart5.Series["Series1"].Points.DataBindXY(dv, "comment_type", dv, "Ccount");
getdata1();
}
protected void DropDownList5_SelectedIndexChanged(object sender, EventArgs e)
{
if (!DropDownList3.SelectedValue.Equals("-1") && !DropDownList4.SelectedValue.Equals("-1") && !DropDownList5.SelectedValue.Equals("-1"))
{
GridView7.Visible = true;
Chart5.Visible = true;
GridView7.DataBind();
Chart5.DataBind();
Label8.Text = DropDownList3.SelectedItem.Text + " " + DropDownList5.SelectedItem.Text + " Result Summary";
if (GridView7.Rows.Count == 0)
{
Label8.Text = "No Results";
}
}
else
{
Label8.Visible = false;
GridView7.Visible = false;
Chart5.Visible = false;
}
}
private void View6_DataBind()
{
Label31.Text = DropDownList13.SelectedItem.Text;
Label32.Text = DropDownList14.SelectedItem.Text;
Label30.Text = DropDownList12.SelectedItem.Text + ": " + DropDownList13.SelectedItem.Text + " Vs " + DropDownList14.SelectedItem.Text;
GridView8.DataSource = SqlDataSource16;
GridView8.DataBind();
GridView9.DataBind();
GridView9.Visible = true;
Chart5.DataSource = SqlDataSource16;
Chart5.DataBind();
if (Chart5.Series[0].Points.Count > 0 || Chart5.Series[1].Points.Count > 0)
{
Label31.Text = DropDownList13.SelectedItem.Text;
Label32.Text = DropDownList14.SelectedItem.Text;
Label31.Visible = true;
Label32.Visible = true;
}
Chart5.Visible = true;
}
protected void DropDownList3_SelectedIndexChanged(object sender, EventArgs e)
{
//chart 5
string pitchcall = DropDownList3.SelectedValue.ToString();
Debug.WriteLine(pitchcall);
string queryString = (@"SELECT *
FROM
(
SELECT[pitchno],
[pitcher],
[pitchtype]
FROM[dbo].[pitchData]
WHERE pitchcall = @pitchcall
) AS SourceTable PIVOT(COUNT([pitchno]) FOR [pitchtype] IN([Splitter],
[Fastball],
[Sinker],
[ChangeUp],
[Cutter],
[Curveball],
[Slider])) AS PivotTable;" );
DataTable ChartData5 = new DataTable();
using (SqlConnection connection = new SqlConnection(connectionString))
{
connection.Open();
using (SqlDataAdapter sqlQueryAdapter = new SqlDataAdapter(queryString, connection))
{
sqlQueryAdapter.SelectCommand.Parameters.AddWithValue("@pitchcall", pitchcall);
sqlQueryAdapter.SelectCommand.CommandTimeout = 120;
DataSet dataSet = new DataSet();
sqlQueryAdapter.Fill(dataSet);
connection.Close();
ChartData5 = dataSet.Tables[0];
}
}
DataView dv = new DataView(ChartData5);
Chart5.DataSource = dv;
Chart5.DataBind();
foreach (Series cs in Chart5.Series)
{
cs.Enabled = false;
Debug.WriteLine(cs.Name);
cs.ChartType = SeriesChartType.StackedColumn;
foreach (DataPoint point in cs.Points)
{
Debug.WriteLine("pitcher: " + (double)point.YValues.GetValue(0));
if ((double)point.YValues.GetValue(0) != 0)
{
Debug.WriteLine("not empty");
cs.Enabled = true;
}
}
}
//Setting width of line
Chart5.Series[0].BorderWidth = 10;
}
