private void btnExport_Click(object sender, EventArgs e)
{
using (SaveFileDialog sfd = new SaveFileDialog())
{
sfd.Filter = "Excel Files | *.xlsx";
if (sfd.ShowDialog() == DialogResult.OK)
{
try
{
if (sfd.FileName != "" && sfd.FileName.EndsWith(".xlsx"))
{
var excelProvider = new ExcelProvider();
var fileBytes = excelProvider.ExportQuery("Trustee Report List", _TrusteeReportResults.AsQueryable(), new ExcelStyleSheet());
File.WriteAllBytes(sfd.FileName, fileBytes);
Process.Start(sfd.FileName);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Report Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
}
private void btnExport_Click(object sender, EventArgs e)
{
using (SaveFileDialog sfd = new SaveFileDialog())
{
sfd.Filter = "Excel Files | *.xlsx";
if (sfd.ShowDialog() == DialogResult.OK)
{
try
{
if (sfd.FileName != "" && sfd.FileName.EndsWith(".xlsx"))
{
var excelProvider = new ExcelProvider();
var fileBytes = excelProvider.ExportQuery("BuildingPMDebtor", FilterData(), new ExcelStyleSheet());
File.WriteAllBytes(sfd.FileName, fileBytes);
Process.Start(sfd.FileName);
// MessageBox.Show("Saved Succesfully", "Report", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Report Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
}
private void btnExport_Click(object sender, EventArgs e)
{
using (SaveFileDialog sfd = new SaveFileDialog())
{
sfd.Filter = "Excel Files | *.xlsx";
if (sfd.ShowDialog() == DialogResult.OK)
{
try
{
if (sfd.FileName != "" && sfd.FileName.EndsWith(".xlsx"))
{
var excelProvider = new ExcelProvider();
var results = _AllResults.Select(a => new TransactionSearchModel
{
BuildingPath = a.BuildingPath,
TransactionDate = a.TransactionDate,
AccountNumber = a.AccountNumber,
LinkAccount = (a.LinkAccount == "\0\0\0\0\0\0\0") ? string.Empty : a.LinkAccount, //Pastel handles null values as \0\0\0\0\0\0\0
Reference = a.Refrence,
Description = a.Description,
Amount = a.Amount
}).AsQueryable();
var fileBytes = excelProvider.ExportQuery("Transaction Search", results, new ExcelStyleSheet());
File.WriteAllBytes(sfd.FileName, fileBytes);
Process.Start(sfd.FileName);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Report Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
}
