private void ToExcel_SingleSectionWise()
{
//****Maximum Progressber Process Declare**********;
progressBar1.Maximum = 9;
//*********************Array Define*********************
string[] SectionNames = { "b2b", "b2cl", "b2cs", "cdnr", "cdnur", "at", "exem", "hsn", "docs" };
//*********************Data Table Array Define*********************
DataTable[] lstDT =
{
B2BFormate.B2BInvoiceGenerate(_FirstDate.ToString("dd-MMM-yyyy"), _LastDate.ToString("dd-MMM-yyyy")),
B2CLFormate.B2CLInvoiceGenerate(_FirstDate.ToString("dd-MMM-yyyy"), _LastDate.ToString("dd-MMM-yyyy")),
B2CSFormate.B2CSInvoiceGenerate(_FirstDate.ToString("dd-MMM-yyyy"), _LastDate.ToString("dd-MMM-yyyy")),
CDNRFormate.CDNRnvoiceGenerate(_FirstDate.ToString("dd-MMM-yyyy"), _LastDate.ToString("dd-MMM-yyyy")),
CDNURFormate.CDNURnvoiceGenerate(_FirstDate.ToString("dd-MMM-yyyy"), _LastDate.ToString("dd-MMM-yyyy")),
ATFormate.ATInvoiceGenerate(_FirstDate.ToString("dd-MMM-yyyy"), _LastDate.ToString("dd-MMM-yyyy")),
EXEMPFormate.EXEMInvoiceGenerate(_FirstDate.ToString("dd-MMM-yyyy"), _LastDate.ToString("dd-MMM-yyyy")),
HSNFormate.HSNInvoiceGenerate(_FirstDate.ToString("dd-MMM-yyyy"), _LastDate.ToString("dd-MMM-yyyy")),
DOCSFormate.DOCSInvoiceGenerate(_FirstDate.ToString("dd-MMM-yyyy"), _LastDate.ToString("dd-MMM-yyyy")),
};
//*******Create <ToEX ToEX = delegate> Delegate variable***************
ToEX ToEX = delegate
{
FolderBrowserDialog sfd = new FolderBrowserDialog();
if (sfd.ShowDialog() == DialogResult.OK)
{
Cursor = Cursors.WaitCursor;
string path = sfd.SelectedPath + "\\Section_wise_CSV_files"; // or whatever
if (!Directory.Exists(path))
{
Directory.CreateDirectory(path);
}
int i = 0;
foreach (string item in SectionNames)
{
ExportToExcel_SingleSectionWise(path + "\\" + item + ".csv", lstDT[i], item);
//**********method wise progressber increase**********
progressBar1.Value = ++MethodExecutioncount;
i++;
}
Cursor = Cursors.Default;
progressBar1.Value = 0;
MessageBox.Show("Export Successfull");
}
};
//*******point <ToEX ToEX = delegate> Delegate variable***************
ToEX();
}
private void b2BREPORTToolStripMenuItem_Click(object sender, EventArgs e)
{
mActiveMenuberName = "B2B";
dgvView.DataSource = B2BFormate.B2BInvoiceGenerate(_FirstDate.ToString("dd-MMM-yyyy"), _LastDate.ToString("dd-MMM-yyyy"));
GriedDesign();
}