protected void btnExport_Click(object sender, EventArgs e)
{
Guid g = Guid.NewGuid();
string guid = g.ToString().Replace("-", "");
string imgDir = Server.MapPath("~/images/imageTemp/");
string imageUrl = imgDir + guid + ".JPG";
if (Directory.Exists(imgDir) == false)
{
Directory.CreateDirectory(imgDir);
}
Chart1.SaveImage(imageUrl);
Microsoft.Reporting.WebForms.ReportParameter[] ReportParameters = new Microsoft.Reporting.WebForms.ReportParameter[3];
ReportParameters[0] = new Microsoft.Reporting.WebForms.ReportParameter("ReportParameter1", "file:///" + Server.MapPath("~/images/imageTemp/") + guid + ".JPG");
ReportParameters[1] = new Microsoft.Reporting.WebForms.ReportParameter("ReportParameter2", "我的报表！");
ReportParameters[2] = new Microsoft.Reporting.WebForms.ReportParameter("ReportParameter3", "我的报表！");
ReportViewer1.LocalReport.SetParameters(ReportParameters);
//if (File.Exists(imageUrl))
//{
// File.Delete(imageUrl);
//}
}
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);
}
protected void btnExportar_Click(object sender, EventArgs e)
{
try
{
Chart1.SaveImage(Server.MapPath("/" + Chart1.Titles[0].Text.Replace(":", "") + ".jpg"));
Response.AppendHeader("content-disposition", "attachment; filename= " + Chart1.Titles[0].Text.Replace(":", "") + ".jpg");
Response.TransmitFile(Server.MapPath("/" + Chart1.Titles[0].Text.Replace(":", "") + ".jpg"));
Response.Flush();
}
finally
{
File.Delete(Server.MapPath("/" + Chart1.Titles[0].Text.Replace(":", "") + ".jpg"));
}
}
protected void Button1_Click(object sender, EventArgs e)
{
string tmpChartName = "reports/temp/CallsStatistics.jpg";
string imgPath = HttpContext.Current.Request.PhysicalApplicationPath + tmpChartName;
Chart1.SaveImage(imgPath);
string imgPath2 = Request.Url.GetLeftPart(UriPartial.Authority) + (Request.Url.GetLeftPart(UriPartial.Authority) == "http://gw.wilstream.ru"?(":81"):"") + VirtualPathUtility.ToAbsolute("~/" + tmpChartName);
Response.Clear();
Response.ContentType = "application/vnd.ms-excel";
Response.AddHeader("Content-Disposition", "attachment; filename=CallsStatistics.xls;");
StringWriter stringWrite = new StringWriter();
HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);
string headerTable = @"<Table><tr><td><img src='" + imgPath2 + @"' \></td></tr></Table>";
Response.Write(headerTable);
Response.Write(stringWrite.ToString());
Response.End();
}
protected void btnPrint_Click(object sender, EventArgs e)
{
ds = GetTeamName(Convert.ToInt32(Session["team"]));
if (ds.Tables["Team"].Rows.Count > 0)
{
TeamName = ds.Tables["Team"].Rows[0]["T_TeamName"].ToString();
}
BindRUPieChart();
Document pdfDoc = new Document(PageSize.A3, 10f, 10f, 10f, 0f);
PdfWriter.GetInstance(pdfDoc, Response.OutputStream);
pdfDoc.Open();
using (MemoryStream stream = new MemoryStream())
{
Chart1.SaveImage(stream, ChartImageFormat.Png);
iTextSharp.text.Image chartImage = iTextSharp.text.Image.GetInstance(stream.GetBuffer());
chartImage.ScalePercent(75f);
pdfDoc.Add(chartImage);
}
pdfDoc.Close();
Response.ContentType = "application/pdf";
if (Session["access"].ToString() == "3" || Session["access"].ToString() == "2" || Session["access"].ToString() == "1")
{
Response.AddHeader("content-disposition", "attachment;" +
"filename=Resource Utilisation - " + TeamName + ".pdf");
}
else
{
Response.AddHeader("content-disposition", "attachment;" +
"filename=Client Usage - " + TeamName + ".pdf");
}
Response.Cache.SetCacheability(HttpCacheability.NoCache);
Response.Write(pdfDoc);
Response.End();
}
protected void exportpdf_btn_Click(object sender, EventArgs e)
{
Document Doc = new Document(PageSize.A4, 10f, 10f, 10f, 0f);
PdfWriter.GetInstance(Doc, Response.OutputStream);
Doc.Open();
using (MemoryStream memoryStream = new MemoryStream())
{
Chart1.SaveImage(memoryStream, ChartImageFormat.Png);
iTextSharp.text.Image img = iTextSharp.text.Image.GetInstance(memoryStream.GetBuffer());
img.ScalePercent(75f);
Doc.Add(img);
Doc.Close();
Response.ContentType = "application/pdf";
Response.AddHeader("content-disposition", "attachment;filename=Chart.pdf");
Response.Cache.SetCacheability(HttpCacheability.NoCache);
Response.Write(Doc);
Response.End();
}
}
private void buildPieChart(string country)
{
String myConnect = ConfigurationManager.ConnectionStrings["EADPConnectionString2"].ToString();
SqlConnection myConn = new SqlConnection(myConnect);
DataSet ds = new DataSet();
String strSQL = "SELECT COUNT([Diploma]) NoOfStudents, [Diploma] FROM interview i ";
strSQL += "INNER JOIN[Register] R on i.tripid = r.tripid ";
strSQL += "INNER JOIN[Student] S on r.adminNo = s.adminNo ";
strSQL += "INNER JOIN[trip] T on i.tripid = t.tripid ";
if (!country.Equals("All"))
{
strSQL += "where location = @paraCountry and [studentchoice] = 'accepted' ";
}
else
{
strSQL += "where [studentchoice] = 'accepted' ";
}
strSQL += "Group By [Diploma]";
SqlDataAdapter da = new SqlDataAdapter(strSQL.ToString(), myConn);
if (!country.Equals("All"))
{
da.SelectCommand.Parameters.AddWithValue("@paraCountry", country);
}
da.Fill(ds, "tripTable");
Chart1.DataSource = ds;
Chart1.DataBind();
string imgPathing2 = HttpContext.Current.Request.PhysicalApplicationPath + tmpChartName1;
Chart1.SaveImage(imgPathing2);
}
protected void Button1_Click(object sender, EventArgs e)
{
Chart1.SaveImage(Server.MapPath("../chartImage/") + "BarChart.JPG");
Chart2.SaveImage(Server.MapPath("../chartImage/") + "PChart.JPG");
}
public void SaveChartImage(Stream stream)
{
Chart1.SaveImage(stream);
}
private void PrintChart()
{
ds = GetTeamName(Convert.ToInt32(Session["team"]));
if (ds.Tables["Team"].Rows.Count > 0)
{
TeamName = ds.Tables["Team"].Rows[0]["T_TeamName"].ToString();
}
BindPieChart1();
Document pdfDoc = new Document(PageSize.A3, 10f, 10f, 10f, 0f);
PdfWriter.GetInstance(pdfDoc, Response.OutputStream);
pdfDoc.Open();
using (MemoryStream stream = new MemoryStream())
{
//iTextSharp.text.Image gif = iTextSharp.text.Image.GetInstance(imagePath);
//gif.ScalePercent(24f);
//gif.Alignment = iTextSharp.text.Image.ALIGN_RIGHT;
Chart1.SaveImage(stream, ChartImageFormat.Png);
iTextSharp.text.Image chartImage = iTextSharp.text.Image.GetInstance(stream.GetBuffer());
chartImage.ScalePercent(75f);
//pdfDoc.Add(gif);
pdfDoc.Add(chartImage);
}
pdfDoc.Close();
Response.ContentType = "application/pdf";
if (type == "TeamClientsUsage")
{
Response.AddHeader("content-disposition", "attachment;" +
"filename=RTM Client Usage - " + TeamName + ".pdf");
}
else if (type == "Tasks")
{
Response.AddHeader("content-disposition", "attachment;" +
"filename=RTM Task Usage - " + TeamName + ".pdf");
}
Response.Cache.SetCacheability(HttpCacheability.NoCache);
Response.Write(pdfDoc);
Response.End();
//Response.ContentType = "application/pdf";
//Response.AddHeader("content-disposition", "inline;filename=TestPage.pdf");
////Response.AddHeader("content-disposition", "attachment;filename=TestPage.pdf");
//Response.Cache.SetCacheability(HttpCacheability.NoCache);
//StringWriter sw = new StringWriter();
//HtmlTextWriter hw = new HtmlTextWriter(sw);
//this.Page.RenderControl(hw);
//StringReader sr = new StringReader(sw.ToString());
//Document pdfDoc = new Document(PageSize.A4, 10f, 10f, 100f, 0f);
//HTMLWorker htmlparser = new HTMLWorker(pdfDoc);
//PdfWriter.GetInstance(pdfDoc, Response.OutputStream);
//pdfDoc.Open();
////htmlparser.Parse(sr);
//pdfDoc.Close();
//Response.Write(pdfDoc);
//Response.End();
}
private void show()
{
DateTime dt22 = DateTime.Now;
string xx = dt22.ToString("yyyyMMddhhmmss");
DataRow dr = null;
DataTable dt = new DataTable();
dt.Columns.Add("Date", typeof(DateTime));
dt.Columns.Add("data", typeof(decimal));
dt.Columns.Add("CountryCode", typeof(string));
dr = dt.NewRow();
dr[0] = DateTime.Parse("01/01/2017 12:10:45");
dr[1] = (decimal)30 / 100;
dr[2] = "GB";
dt.Rows.Add(dr);
dr = dt.NewRow();
dr[0] = DateTime.Parse("02/01/2017 12:10:45");
dr[1] = (decimal)09 / 100;
dr[2] = "GB";
dt.Rows.Add(dr);
dr = dt.NewRow();
dr[0] = DateTime.Parse("03/01/2017 12:10:45");
dr[1] = (decimal)15 / 100;
dr[2] = "GB";
dt.Rows.Add(dr);
dr = dt.NewRow();
dr[0] = DateTime.Parse("04/01/2017 12:10:45");
dr[1] = (decimal)22 / 100;
dr[2] = "GB";
dt.Rows.Add(dr);
dr = dt.NewRow();
dr[0] = DateTime.Parse("05/01/2017 12:10:45");
dr[1] = (decimal)13 / 100;
dr[2] = "GB";
dt.Rows.Add(dr);
dr = dt.NewRow();
dr[0] = DateTime.Parse("06/01/2017 12:10:45");
dr[1] = (decimal)22 / 100;
dr[2] = "GB";
dt.Rows.Add(dr);
dr = dt.NewRow();
dr[0] = DateTime.Parse("07/01/2017 12:10:45");
dr[1] = (decimal)07 / 100;
dr[2] = "GB";
dt.Rows.Add(dr);
dr = dt.NewRow();
dr[0] = DateTime.Parse("08/01/2017 12:10:45");
dr[1] = (decimal)11 / 100;
dr[2] = "GB";
dt.Rows.Add(dr);
dr = dt.NewRow();
dr[0] = DateTime.Parse("09/01/2017 12:10:45");
dr[1] = (decimal)12 / 100;
dr[2] = "GB";
dt.Rows.Add(dr);
dr = dt.NewRow();
dr[0] = DateTime.Parse("10/01/2017 12:10:45");
dr[1] = (decimal)17 / 100;
dr[2] = "GB";
dt.Rows.Add(dr);
dr = dt.NewRow();
dr[0] = DateTime.Parse("11/01/2017 12:10:45");
dr[1] = (decimal)19 / 100;
dr[2] = "GB";
dt.Rows.Add(dr);
dr = dt.NewRow();
dr[0] = DateTime.Parse("12/01/2017 12:10:45");
dr[1] = (decimal)02 / 100;
dr[2] = "GB";
dt.Rows.Add(dr);
dr = dt.NewRow();
dr[0] = DateTime.Parse("13/01/2017 12:10:45");
dr[1] = (decimal)01 / 100;
dr[2] = "GB";
dt.Rows.Add(dr);
dr = dt.NewRow();
dr[0] = DateTime.Parse("14/01/2017 12:10:45");
dr[1] = (decimal)0;
dr[2] = "GB";
dt.Rows.Add(dr);
dr = dt.NewRow();
dr[0] = DateTime.Parse("15/01/2017 12:10:45");
dr[1] = (decimal)0;
dr[2] = "GB";
dt.Rows.Add(dr);
dr = dt.NewRow();
dr[0] = DateTime.Parse("16/01/2017 12:10:45");
dr[1] = (decimal)07 / 100;
dr[2] = "GB";
dt.Rows.Add(dr);
dr = dt.NewRow();
dr[0] = DateTime.Parse("17/01/2017 12:10:45");
dr[1] = (decimal)19 / 100;
dr[2] = "GB";
dt.Rows.Add(dr);
dr = dt.NewRow();
dr[0] = DateTime.Parse("18/01/2017 12:10:45");
dr[1] = (decimal).2;
dr[2] = "GB";
dt.Rows.Add(dr);
dr = dt.NewRow();
dr[0] = DateTime.Parse("19/01/2017 12:10:45");
dr[1] = (decimal)23 / 100;
dr[2] = "GB";
dt.Rows.Add(dr);
dr = dt.NewRow();
dr[0] = DateTime.Parse("20/01/2017 12:10:45");
dr[1] = (decimal)35 / 100;
dr[2] = "GB";
dt.Rows.Add(dr);
//Chart1.BorderSkin.SkinStyle = System.Windows.Forms.DataVisualization.Charting.BorderSkinStyle.Emboss;
////Chart1.BorderSkin.SkinStyle = BorderSkinStyle.Emboss;
//Chart1.BorderlineColor = System.Drawing.Color.FromArgb(26, 59, 105);
//Chart1.BorderlineWidth = 3;
//Chart1.BackColor = Color.NavajoWhite;
//Chart1.ChartAreas.Add("chtArea");
Chart1.ChartAreas[0].AxisX.Title = "NPS Dates";
Chart1.ChartAreas[0].AxisX.LabelStyle.Angle = -60;
Chart1.ChartAreas[0].AxisX.TitleFont = new System.Drawing.Font("Verdana", 11, System.Drawing.FontStyle.Bold);
Chart1.ChartAreas[0].AxisX.Interval = 1;
//Chart1.ChartAreas[0].AxisX.LabelStyle.Format = "MyAxisXCustomFormat";
Chart1.ChartAreas[0].AxisY.Title = "NPS Values";
Chart1.ChartAreas[0].AxisY.TitleFont = new System.Drawing.Font("Verdana", 11, System.Drawing.FontStyle.Bold);
Chart1.ChartAreas[0].AxisY.LabelStyle.Format = "P";
Chart1.ChartAreas[0].BorderDashStyle = System.Windows.Forms.DataVisualization.Charting.ChartDashStyle.Solid;
Chart1.ChartAreas[0].BorderWidth = 2;
//Chart1.Legends.Add("UnitPrice");
//Chart1.Series.Add("UnitPricexxx");
//Chart1.Series[0].Palette = ChartColorPalette.Bright;
Chart1.Series[0].ChartType = System.Windows.Forms.DataVisualization.Charting.SeriesChartType.Line;
Chart1.Series[0].Points.DataBindXY(dt.DefaultView, "Date", dt.DefaultView, "Data");
//Chart1.Series[0].IsVisibleInLegend = true;
Chart1.Series[0].IsValueShownAsLabel = true;
Chart1.Series[0].ToolTip = "Data Point Y Value: #VALY{G}";
// Setting Line Width
Chart1.Series[0].BorderWidth = 3;
Chart1.Series[0].Color = Color.Red;
Chart1.ChartAreas[0].AxisX.MajorGrid.LineWidth = 0;
//Chart1.ChartAreas[0].AxisY.MajorGrid.LineWidth = 0;
// Setting Line Shadow
//Chart1.Series[0].ShadowOffset = 5;
//Legend Properties
Chart1.Legends[0].LegendStyle = System.Windows.Forms.DataVisualization.Charting.LegendStyle.Table;
Chart1.Legends[0].TableStyle = System.Windows.Forms.DataVisualization.Charting.LegendTableStyle.Wide;
Chart1.Legends[0].Docking = System.Windows.Forms.DataVisualization.Charting.Docking.Bottom;
Chart1.Width = 500;
Chart1.Height = 300;
Chart1.SaveImage(@"D:\test\chart.png", ChartImageFormat.Png);
}
private void savePlot()
{
Chart1.SaveImage(fileLocation + "\\" + fileName + "_" + sensorName + "_" + wavelengthValue + ".png", ChartImageFormat.Png);
}