private void button6_Click(object sender, EventArgs e)
{
saveFileDialog1.ShowDialog();
if (saveFileDialog1.FileName != "")
{
FileStream fs = (FileStream)saveFileDialog1.OpenFile();
var report = new Report(ctx.V_CityCount.ToReportSource());
report.TextFields.Title = "Raport miast w tabeli adresy";
report.TextFields.SubTitle = "Liczba adresów z poszczególnych miast";
var writer = new DoddleReport.iTextSharp.PdfReportWriter();
writer.WriteReport(report, fs);
}
}
public void Export(List <CandidateControl> cands, List <PartyControl> parts, string path, ExportType type)
{
try
{
using (var fileStream = File.Create($"{path}\\Candidates.{type.ToString()}"))
{
Report candReport = PrepCandReport(cands);
if (type == ExportType.Pdf)
{
var writer = new DoddleReport.iTextSharp.PdfReportWriter();
writer.WriteReport(candReport, fileStream);
}
else
{
var writer = new DoddleReport.Writers.DelimitedTextReportWriter();
DelimitedTextReportWriter.DefaultDelimiter = ",";
writer.WriteReport(candReport, fileStream);
}
}
using (var fileStream = File.Create($"{path}\\Parties.{type.ToString()}"))
{
Report partiesReport = PrepPartyReport(parts);
if (type == ExportType.Pdf)
{
var writer = new DoddleReport.iTextSharp.PdfReportWriter();
writer.WriteReport(partiesReport, fileStream);
}
else
{
var writer = new DoddleReport.Writers.DelimitedTextReportWriter();
DelimitedTextReportWriter.DefaultDelimiter = ",";
writer.WriteReport(partiesReport, fileStream);
}
}
}
catch (Exception ex)
{
_logger.LogError(ex.StackTrace);
}
}
private void btnExport_Click(object sender, EventArgs e)
{
using (var sfd = new SaveFileDialog())
{
if (!String.IsNullOrEmpty(cbInstances.Text))
{
sfd.Filter = "Excel File|*.xlsx|PDF|*.pdf";
if (sfd.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
var trace = auditConfig.Traces.First((t) => t.Instance.DataSource == cbInstances.Text);
var context = new TraceContext(trace, (new ITraceObserver[] { }).ToList());
var columns = new List <int>();
trace.Events.ForEach((evt) => evt.Columns.ToList().ForEach((c) =>
{
if (!columns.Contains(c))
{
columns.Add(c);
}
}));
var ds = fetchData(context, columns);
IReportWriter writer;
if (sfd.FileName.EndsWith(".pdf"))
{
writer = new DoddleReport.iTextSharp.PdfReportWriter();
}
else
{
writer = new DoddleReport.OpenXml.ExcelReportWriter();
}
Export(context, ds, writer, sfd.FileName);
if (MetroMessageBox.Show(this, "Open file?", "Open File", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == System.Windows.Forms.DialogResult.Yes)
{
Process.Start(sfd.FileName);
}
}
}
}
}
