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 cDNRFORMATEToolStripMenuItem_Click(object sender, EventArgs e) { mActiveMenuberName = "CDNR"; dgvView.DataSource = CDNRFormate.CDNRnvoiceGenerate(_FirstDate.ToString("dd-MMM-yyyy"), _LastDate.ToString("dd-MMM-yyyy")); GriedDesign(); }