private void dgCases_row_DoubleClick(object sender, MouseButtonEventArgs e)
{
DataGridRow row = sender as DataGridRow;
string caseNumber = ((System.Data.DataRowView)row.Item)[0].ToString();
MySqlDataAdapter adapter = CasesDB.GetDataAdapterCaseContent(caseNumber);
DataTable dt = new DataTable("datamuncher_case_content");
adapter.Fill(dt);
dgContentCase.ItemsSource = dt.DefaultView;
}
private void export(string caseNumber = "")
{
MySqlDataAdapter adapterCase = CasesDB.GetDataAdapterCases(caseNumber);
DataTable dtCase = new DataTable("zaken");
adapterCase.Fill(dtCase);
XLWorkbook workbook = new XLWorkbook();
workbook.Worksheets.Add(dtCase);
if (chkIncFilenames.IsChecked.HasValue && chkIncFilenames.IsChecked.Value)
{
foreach (DataRow row in dtCase.Rows)
{
string tmpCase = row[0].ToString();
MySqlDataAdapter adapterCaseContent = CasesDB.GetDataAdapterCaseContent(tmpCase);
DataTable dtCaseContent = new DataTable($"zaak_{tmpCase}");
adapterCaseContent.Fill(dtCaseContent);
workbook.Worksheets.Add(dtCaseContent);
}
}
SaveFileDialog ofd = new SaveFileDialog()
{
RestoreDirectory = true,
DefaultExt = "xlsx",
Filter = "Excel Files Files (*.xlsx)|*.xlsx|All Files (*.*)|*.*",
};
if (ofd.ShowDialog() == DialogResult.OK)
{
workbook.SaveAs(ofd.FileName);
}
}
