private void ExportAccepted() { try { if (DialogResult.OK == saveFileDialog1.ShowDialog()) { this.btn_export_accepted.Enabled = false; for (int a = 0; a < grdAcceptedJob.Columns.Count; a++) { grdAcceptedJob.Columns[a].Width = 80; } ClsExportGridView objClsExportGridView = new ClsExportGridView(this.grdAcceptedJob, saveFileDialog1.FileName); objClsExportGridView.ApplyCellFormatting = true; string headerText = "Date Range : " + string.Format("{0:dd-MMM-yy}", dtp_TransferredFrom.Value) + " to " + string.Format("{0:dd-MMM-yy}", dtp_TranferredTo.Value); objClsExportGridView.Heading = headerText; objClsExportGridView.TitleFontSize = 18; objClsExportGridView.TitleBackColor = Color.Red; objClsExportGridView.TitleForeColor = Color.White; //objClsExportGridView.HeaderBackColor = Color.Black; objClsExportGridView.HeaderForeColor = Color.White; objClsExportGridView.ExportExcel(); //objClsExportGridView.ExportExcelAsync(radProgressBar1); objClsExportGridView = null; this.btn_export_accepted.Enabled = true; for (int a = 0; a < grdAcceptedJob.Columns.Count; a++) { grdAcceptedJob.Columns[a].Width = 160; } } } catch (Exception ex) { RadMessageBox.Show(ex.Message); } }
private void ExpoerOperatorVehicleRecord() { try { if (DialogResult.OK == saveFileDialog2.ShowDialog()) { this.btnExport2.Enabled = false; grdOperatorVehicleRecord.Columns["OperatorLicenceNumber"].Width = 110; grdOperatorVehicleRecord.Columns["MonthCommencing"].Width = 90; grdOperatorVehicleRecord.Columns["OperatorName"].Width = 90; grdOperatorVehicleRecord.Columns["VehicleMake"].Width = 90; grdOperatorVehicleRecord.Columns["VehicleRegistrationMark"].Width = 100; grdOperatorVehicleRecord.Columns["PHCVehicle"].Width = 90; ClsExportGridView objClsExportGridView = new ClsExportGridView(grdOperatorVehicleRecord, saveFileDialog2.FileName); string headerText = "Date Range : " + string.Format("{0:dd-MMM-yy}", dtpFromDate2.Value) + " to " + string.Format("{0:dd-MMM-yy}", dtpToDate2.Value); objClsExportGridView.Heading = headerText; objClsExportGridView.TitleFontSize = 18; objClsExportGridView.ApplyCellFormatting = true; objClsExportGridView.TitleBackColor = Color.Red; objClsExportGridView.TitleForeColor = Color.White; objClsExportGridView.HeaderBackColor = Color.Black; objClsExportGridView.HeaderForeColor = Color.White; objClsExportGridView.ExportExcel(); objClsExportGridView = null; this.btnExport2.Enabled = true; IsOperatorVehicleRecordExported = true; //grdOperatorVehicleRecord.Columns["PHCVehicle"].HeaderText = "PHC Vehicle"; } } catch (Exception ex) { RadMessageBox.Show(ex.Message); } }
private void btnexport_Click(object sender, EventArgs e) { try { saveFileDialog1.Filter = "Excel File (*.xls)|*.xls|AdvExcel File (*.xlsx)|*.xlsx"; saveFileDialog1.Title = "Save File"; saveFileDialog1.FileName = "SageInvoice"; if (saveFileDialog1.ShowDialog() == DialogResult.OK) { PopulateGrid(); grdLister.Columns["InvoiceType"].Width = 70; grdLister.Columns["InvoiceType"].HeaderText = "invoice type"; grdLister.Columns["AccountCode"].Width = 70; grdLister.Columns["AccountCode"].HeaderText = "account code"; grdLister.Columns["SageNo"].Width = 50; grdLister.Columns["SageNo"].HeaderText = "sage no."; grdLister.Columns["BlankField"].HeaderText = ""; grdLister.Columns["InvoiceDate"].Width = 60; grdLister.Columns["InvoiceDate"].HeaderText = "invoice date"; grdLister.Columns["InvoiceNo"].Width = 70; grdLister.Columns["InvoiceNo"].HeaderText = "invoice npo."; grdLister.Columns["SoftwareName"].Width = 120; grdLister.Columns["SoftwareName"].HeaderText = "software name."; grdLister.Columns["InvoiceTotal"].Width = 70; grdLister.Columns["InvoiceTotal"].HeaderText = "invoice total"; grdLister.Columns["TaxCode"].Width = 50; grdLister.Columns["TaxCode"].HeaderText = "tax code"; grdLister.Columns["Vat"].Width = 40; grdLister.Columns["Vat"].HeaderText = "vat"; string heading = string.Empty; // heading = string.Format("{0:dd/MM/yyyy hh:mm tt}", dtF) + " till " + string.Format("{0:dd/MM/yyyy hh:mm tt}", dtT); ClsExportGridView obj = new ClsExportGridView(grdLister, saveFileDialog1.FileName); obj.ApplyCellFormatting = false; obj.ApplyCustomCellFormatting = true; // obj.Heading = heading; obj.ExportExcelAsync(); } } catch { } }
private void ExportOperatorPrivateHireDriverRecord() { try { if (DialogResult.OK == saveFileDialog1.ShowDialog()) { this.btnExport.Enabled = false; grdOperatorPrivateHireDriverRecord.Columns["OperatorLicenceNumber"].Width = 110; grdOperatorPrivateHireDriverRecord.Columns["MonthCommencing"].HeaderText = "Month"; grdOperatorPrivateHireDriverRecord.Columns["MonthCommencing"].Width = 40; grdOperatorPrivateHireDriverRecord.Columns["OperatorName"].Width = 90; grdOperatorPrivateHireDriverRecord.Columns["FirstName"].Width = 80; grdOperatorPrivateHireDriverRecord.Columns["PrivateHireLicenceNumber"].Width = 100; grdOperatorPrivateHireDriverRecord.Columns["Surname"].Width = 80; grdOperatorPrivateHireDriverRecord.Columns["Surname2"].Width = 60; ClsExportGridView objClsExportGridView = new ClsExportGridView(this.grdOperatorPrivateHireDriverRecord, saveFileDialog1.FileName); objClsExportGridView.ApplyCellFormatting = true; string headerText = "Date Range : " + string.Format("{0:dd-MMM-yy}", dtpFromDate.Value) + " to " + string.Format("{0:dd-MMM-yy}", dtpToDate.Value); objClsExportGridView.Heading = headerText; objClsExportGridView.TitleFontSize = 18; objClsExportGridView.TitleBackColor = Color.Red; objClsExportGridView.TitleForeColor = Color.White; //objClsExportGridView.HeaderBackColor = Color.Black; objClsExportGridView.HeaderForeColor = Color.White; objClsExportGridView.ExportExcel(); //objClsExportGridView.ExportExcelAsync(radProgressBar1); objClsExportGridView = null; this.btnExport.Enabled = true; grdOperatorPrivateHireDriverRecord.Columns["OperatorLicenceNumber"].Width = 160; grdOperatorPrivateHireDriverRecord.Columns["MonthCommencing"].Width = 160; grdOperatorPrivateHireDriverRecord.Columns["OperatorName"].Width = 170; grdOperatorPrivateHireDriverRecord.Columns["FirstName"].Width = 150; grdOperatorPrivateHireDriverRecord.Columns["PrivateHireLicenceNumber"].Width = 180; grdOperatorPrivateHireDriverRecord.Columns["Surname"].Width = 110; grdOperatorPrivateHireDriverRecord.Columns["Surname2"].Width = 80; grdOperatorPrivateHireDriverRecord.Columns["MonthCommencing"].HeaderText = "Month Commencing"; } } catch (Exception ex) { RadMessageBox.Show(ex.Message); } }
void btnExportXL_Click(object sender, EventArgs e) { if (grdDriverJobsList.Rows.Count == 0) { return; } try { saveFileDialog1.Filter = "Excel File (*.xls)|*.xls|AdvExcel File (*.xlsx)|*.xlsx"; saveFileDialog1.Title = "Save File"; saveFileDialog1.FileName = "Driver Booking Stats"; if (saveFileDialog1.ShowDialog() == DialogResult.OK) { //grdLister.Columns["IsPaid"].IsVisible = false; //grdLister.Columns["Paid"].IsVisible = true; ////grdLister.Columns["btnUpdate"].IsVisible = false; //grdLister.Columns[COLS.Active].Width = 50; //grdLister.Columns[COLS.Rent].Width = 60; //grdLister.Columns[COLS.DriverNo].Width = 50; //grdLister.Columns[COLS.PreviousBalance].Width = 85; //grdLister.Columns[COLS.Adjustment].Width = 60; //grdLister.Columns[COLS.Collection].Width = 60; //grdLister.Columns[COLS.AgentCommission].Width = 70; //grdLister.Columns[COLS.OldAgentBalance].Width = 90; //grdLister.Columns[COLS.Total].Width = 45; //grdLister.Columns[COLS.Paid].Width = 35; //var row = grdLister.Rows.OrderByDescending(c => c.Cells["ToDate"].Value.ToDate()).FirstOrDefault(); //DateTime? dtCurrent = row.Cells["FromDate"].Value.ToDate(); //DateTime dtEnd = row.Cells["ToDate"].Value.ToDate(); Microsoft.Reporting.WinForms.ReportParameter[] param = new Microsoft.Reporting.WinForms.ReportParameter[1]; string heading = string.Empty; heading = "" + string.Format("from {0:dd/MM/yyyy}", dtpFromDate.Value) + " till " + string.Format("{0:dd/MM/yyyy}", dtpTillDate.Value); ClsExportGridView obj = new ClsExportGridView(grdDriverJobsList, saveFileDialog1.FileName); obj.ApplyCellFormatting = true; obj.ApplyCustomCellFormatting = true; obj.Heading = heading; obj.ExportExcelAsync(radProgressBar1); //obj.ConditionalFormattingObject = new StyleDataRowConditionalFormattingObject(); //obj.ConditionalFormattingObject.ConditionFormattingColumnName = "Paid"; //obj.ConditionalFormattingObject.RowBackColor = Color.LightGreen; //obj.ConditionalFormattingObject.RowForeColor = Color.Black; //obj.ConditionalFormattingObject.TValue = "Paid"; //if (obj.ExportExcel()) //{ // RadDesktopAlert alert = new RadDesktopAlert(); // alert.CaptionText = "Export"; // alert.ContentText = "<html> <b><span style=font-size:medium><color=Blue>Export Successfully</span></b></html>"; // alert.Show(); //} //grdLister.Columns["IsPaid"].IsVisible = true; //grdLister.Columns["Paid"].IsVisible = false; // grdLister.Columns["IsPaid"].IsVisible = false; // grdLister.Columns["Paid"].IsVisible = true; } } catch (Exception ex) { ENUtils.ShowMessage(ex.Message); } finally { SetDefaultColumnSettings(); } }
void btnExportExcel_Click(object sender, EventArgs e) { if (grdLister.Rows.Count == 0) { return; } try { saveFileDialog1.Filter = "Excel File (*.xls)|*.xls|AdvExcel File (*.xlsx)|*.xlsx"; saveFileDialog1.Title = "Save File"; saveFileDialog1.FileName = "Driver Weekly Rent History"; if (saveFileDialog1.ShowDialog() == DialogResult.OK) { grdLister.Columns["IsPaid"].IsVisible = false; grdLister.Columns["Paid"].IsVisible = true; //grdLister.Columns["btnUpdate"].IsVisible = false; grdLister.Columns["Active"].Width = 35; grdLister.Columns["Active"].HeaderText = "Active"; grdLister.Columns["DriverNo"].Width = 38; grdLister.Columns["DriverNo"].HeaderText = "Driver"; grdLister.Columns["AccountBookings"].Width = 70; grdLister.Columns["AccountBookings"].HeaderText = "A/C Bookings"; grdLister.Columns["TotalRentCommission"].Width = 60; grdLister.Columns["OfficeToPay"].Width = 70; grdLister.Columns["PreviousBalance"].Width = 65; // grdLister.Columns["Total"].Width = 80; grdLister.Columns["DriverToPay"].Width = 70; grdLister.Columns["Paid"].Width = 30; var row = grdLister.Rows.OrderByDescending(c => c.Cells["ToDate"].Value.ToDate()).FirstOrDefault(); DateTime?dtCurrent = row.Cells["FromDate"].Value.ToDate(); DateTime dtEnd = row.Cells["ToDate"].Value.ToDate(); Microsoft.Reporting.WinForms.ReportParameter[] param = new Microsoft.Reporting.WinForms.ReportParameter[1]; string heading = string.Empty; heading = "Driver Weekly Rent History - " + string.Format("from {0:dd/MM/yyyy}", dtCurrent) + " until " + string.Format("{0:dd/MM/yyyy}", dtEnd); ClsExportGridView obj = new ClsExportGridView(grdLister, saveFileDialog1.FileName); obj.ApplyCellFormatting = true; obj.ConditionalFormattingObject = new StyleDataRowConditionalFormattingObject(); obj.ConditionalFormattingObject.ConditionFormattingColumnName = "Paid"; obj.ConditionalFormattingObject.RowBackColor = Color.LightGreen; obj.ConditionalFormattingObject.RowForeColor = Color.Black; obj.ConditionalFormattingObject.TValue = "Paid"; obj.Heading = heading; if (obj.ExportExcel()) { RadDesktopAlert alert = new RadDesktopAlert(); alert.CaptionText = "Export"; alert.ContentText = "<html> <b><span style=font-size:medium><color=Blue>Export Successfully</span></b></html>"; alert.Show(); } SetDefaultColumnSettings(); } } catch (Exception ex) { SetDefaultColumnSettings(); ENUtils.ShowMessage(ex.Message); } }