public byte[] PrintResultPDF(string userNo)
{
try
{
Config.WebMode = true;
Report rep = new Report();
rep.Load(Server.MapPath("~/App_Data/rptResult.frx"));
using (VShapeUpDataContext _context = new VShapeUpDataContext())
{
var data = (from x in _context.V_ChallengeResult_Reports
where x.UserNo == userNo
select x).ToList().ToDataTable();
rep.RegisterData(data, "Report");
DataBand band = rep.FindObject("Data") as DataBand;
band.DataSource = rep.GetDataSource("Report");
}
if (rep.Report.Prepare())
{
PDFExport pdfExport = new PDFExport();
pdfExport.ShowProgress = false;
pdfExport.Compressed = true;
pdfExport.AllowPrint = true;
pdfExport.EmbeddingFonts = true;
MemoryStream strm = new MemoryStream();
rep.Report.Export(pdfExport, strm);
rep.Dispose();
pdfExport.Dispose();
strm.Position = 0;
return(strm.ToArray());
//ImageExport export = new ImageExport();
//MemoryStream strm = new MemoryStream();
//rep.Report.Export(export, strm);
//rep.Dispose();
//export.Dispose();
//strm.Position = 0;
//return strm.ToArray();
}
else
{
return(null);
}
}
catch (Exception ex)
{
return(null);
}
}
private void Rapor(int id, string path, string xpath, string baslik)
{
WebReport rapor = new WebReport();
string str =
"SELECT B.OlusturmaTarihi, kr.Adi,br.Adi,B.Konu,B.CevapTarihi,B.CevapMesaji, B.BasvuruYolu, B.Mesaj, B.Tur, B.EPosta, B.Gsm, B.TcId, B.Ip, B.GrupId, B.Durum, B.Ad, B.Soyad,gr.Adi " +
" FROM bildirimler B" +
" left join kurumlar kr on kr.id=B.KurumId" +
" left join birimler br on br.id=B.BirimId" +
" left join gruplar gr on gr.id=B.GrupId " + "where B.Id=" + id + "";
var con = new MySqlConnection(WebConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
var cmd = new MySqlCommand(str, con);
MySqlDataAdapter da = new MySqlDataAdapter(cmd);
DataTable Tamami = new DataTable();
da.Fill(Tamami);
rapor.RegisterData(Tamami, "rapor");
string pdfadi = "Bildirim_" + id;
rapor.Report.Load(Server.MapPath(path));
rapor.Report.RegisterData(Tamami, "Tamami");
// rapor.Load("D:/Projeler/idari/cs/KarmedWeb/MerkeziGorusOneri/HastaneOneriWeb/Rapor/rapor.frx");
if (rapor.Report.Prepare())
{
var pdfExport = new PDFExport
{
ShowProgress = false,
Subject = "Subject",
Title = "Rapor",
Compressed = true,
AllowPrint = true,
EmbeddingFonts = true
};
rapor.Report.Export(pdfExport, Server.MapPath(xpath + pdfadi));
pdfExport.Dispose();
string url = @"loadPencere('Rapor/Raporx/Downloader.aspx?dosya={0}','Rapor',1000,500);";
//wr.Report.Print();
X.ResourceManager.AddScript(string.Format(url, pdfadi));
//rapor.Show();
}
}
public static void exportaRelPDF1(String nomeArquivo, String tituloPdf, Report relatorio)
{
try
{
relatorio.Prepare();
PDFExport pdfExport = new PDFExport();
relatorio.PrintSettings.ShowDialog = false;
pdfExport.ShowProgress = false;
// pdfExport.Subject = "NobreSistemas";
pdfExport.Title = tituloPdf;
pdfExport.Compressed = true;
pdfExport.AllowPrint = true;
pdfExport.EmbeddingFonts = true;
MemoryStream strm = new MemoryStream();
relatorio.Export(pdfExport, strm);
SaveFileDialog salvarPDF = new SaveFileDialog();
salvarPDF.Filter = "Arquivos PDF|*.pdf";
salvarPDF.Title = "Salvar Arquivo em PDF";
salvarPDF.FileName = nomeArquivo;//Irá trazer o nome do arquivo preenchido
salvarPDF.ShowDialog();
FileStream arquivoPDF = new FileStream(salvarPDF.FileName, FileMode.Create, FileAccess.Write);
strm.WriteTo(arquivoPDF);
Alert.informacao("Arquivo Salvo com Sucesso!");
arquivoPDF.Close();
relatorio.Dispose();
pdfExport.Dispose();
strm.Position = 0;
}
catch (Exception erro)
{
Alert.erro("Erro ao exportar arquivo PDF \n" + erro.Message);
}
}