private void btnExport_Click(object sender, EventArgs e) { if (DialogResult.OK == saveFileDialog1.ShowDialog()) { var data1 = General.GetQueryable <Customer>(c => c.BlackList == true).OrderBy(c => c.Name); var query = (from a in data1 select new { Name = a.Name, Phone = a.TelephoneNo, MobileNo = a.MobileNo, Address = a.Address1, }).ToList(); radGridView1.DataSource = query; exporter = new RadGridViewExcelExporter(); BackgroundWorker worker = new BackgroundWorker(); worker.DoWork += new DoWorkEventHandler(worker_DoWork); worker.RunWorkerCompleted += new RunWorkerCompletedEventHandler(bg_RunWorkerCompleted); worker.RunWorkerAsync(saveFileDialog1.FileName); exporter.Progress += new ProgressHandler(exportProgress); this.btnExport.Enabled = false; } }
void btnExport_Click(object sender, EventArgs e) { try { if (DialogResult.OK == saveFileDialog1.ShowDialog()) { if (radGridView1 == null) { InitializeExportGrid(); } radGridView1.Columns.Clear(); radGridView1.Columns.Add(new GridViewTextBoxColumn("MonthCommencing", "MonthCommencing")); radGridView1.Columns.Add(new GridViewTextBoxColumn("OperatorLicenceNumber", "OperatorLicenceNumber")); radGridView1.Columns.Add(new GridViewTextBoxColumn("OperatorName", "OperatorName")); radGridView1.Columns.Add(new GridViewTextBoxColumn("PrivateHireLicenceNumber", "PrivateHireLicenceNumber")); radGridView1.Columns.Add(new GridViewTextBoxColumn("FirstName", "FirstName")); radGridView1.Columns.Add(new GridViewTextBoxColumn("Surname", "Surname")); // string Message = string.Empty; DateTime?dtFrom = dtpFromDate.Value.ToDateorNull(); DateTime?dtTill = dtpToDate.Value.ToDateorNull(); int BookingStatusId = 0; string MonthCommencing = string.Empty; if (dtFrom.Value == null) { Message = "Required : From Date"; } if (dtTill.Value == null) { if (!string.IsNullOrEmpty(Message)) { Message = "Required : To Date"; } else { Message += Environment.NewLine;// "Required : To Date"; Message += "Required : To Date"; } } if (!string.IsNullOrEmpty(Message)) { ENUtils.ShowMessage(Message); return; } MonthCommencing = string.Format("{0:dd/MM/yyyy}", dtFrom.Value) + "-" + string.Format("{0:dd/MM/yyyy}", dtTill.Value); if (opAll.IsChecked) { BookingStatusId = 0; } if (opCompleted.IsChecked) { BookingStatusId = Enums.BOOKINGSTATUS.DISPATCHED.ToInt(); } if (opCancelled.IsChecked) { BookingStatusId = Enums.BOOKINGSTATUS.CANCELLED.ToInt(); } // using (TaxiDataContext db = new TaxiDataContext()) { var list = db.stp_OperatorPrivateHireDriverRecord(ddlSubCompany.SelectedValue.ToInt(), dtFrom.Value, dtTill.Value + TimeSpan.Parse("23:59:59"), BookingStatusId, MonthCommencing).ToList(); // grdLister.DataSource = list; radGridView1.RowCount = list.Count; for (int i = 0; i < list.Count; i++) { radGridView1.Rows[i].Cells["MonthCommencing"].Value = list[i].MonthCommencing; radGridView1.Rows[i].Cells["OperatorLicenceNumber"].Value = list[i].OperatorLicenceNumber; radGridView1.Rows[i].Cells["OperatorName"].Value = list[i].OperatorName; radGridView1.Rows[i].Cells["PrivateHireLicenceNumber"].Value = list[i].PrivateHireLicenceNumber; radGridView1.Rows[i].Cells["FirstName"].Value = list[i].FirstName; radGridView1.Rows[i].Cells["Surname"].Value = list[i].Surname; } } ExportToExcelML export = new ExportToExcelML(this.radGridView1); export.ExportVisualSettings = true; export.HiddenColumnOption = HiddenOption.ExportAsHidden; export.HiddenColumnOption = Telerik.WinControls.UI.Export.HiddenOption.DoNotExport; export.ExcelCellFormatting += new Telerik.WinControls.UI.Export.ExcelML.ExcelCellFormattingEventHandler(export_ExcelCellFormatting); // // //radGridView1.Columns["PickupDate"].HeaderText = "Pickup Date-Time"; //radGridView1.Columns["From"].HeaderText = "Pick-up Address"; //radGridView1.Columns["To"].HeaderText = "Drop-off Address"; radGridView1.Columns["MonthCommencing"].HeaderText = "Month Commencing"; radGridView1.Columns["OperatorLicenceNumber"].HeaderText = "Operator Licence Number"; radGridView1.Columns["OperatorName"].HeaderText = "Operator Name"; radGridView1.Columns["PrivateHireLicenceNumber"].HeaderText = "Private Hire Licence Number"; radGridView1.Columns["FirstName"].HeaderText = "First Name"; //CompanyName exporter = new RadGridViewExcelExporter(); BackgroundWorker worker = new BackgroundWorker(); worker.DoWork += new DoWorkEventHandler(worker_DoWork); worker.RunWorkerCompleted += new RunWorkerCompletedEventHandler(bg_RunWorkerCompleted); worker.RunWorkerAsync(saveFileDialog1.FileName); exporter.Progress += new ProgressHandler(exportProgress); this.btnExport.Enabled = false; } } catch (Exception ex) { ENUtils.ShowMessage(ex.Message); } }
private void btnExport_Click(object sender, EventArgs e) { try { if (DialogResult.OK == saveFileDialog1.ShowDialog()) { radGridView1.Columns.Clear(); radGridView1.Rows.Clear(); radGridView1.Columns.Add(new GridViewTextBoxColumn("RefNo", "RefNo")); radGridView1.Columns.Add(new GridViewTextBoxColumn("ComplainDate", "ComplainDate")); radGridView1.Columns.Add(new GridViewTextBoxColumn("CustomerName", "CustomerName")); radGridView1.Columns.Add(new GridViewTextBoxColumn("PhoneNumber", "PhoneNumber")); radGridView1.Columns.Add(new GridViewTextBoxColumn("ResultDescription", "ResultDescription")); radGridView1.Columns.Add(new GridViewTextBoxColumn("ComplainDescription", "ComplainDescription")); radGridView1.Columns.Add(new GridViewTextBoxColumn("ComplaintAgainst", "ComplaintAgainst")); // radGridView1.Columns.Add(new GridViewTextBoxColumn("PhoneNumber", "PhoneNumber")); string searchTxt = txtSearch.Text.ToStr().ToLower().Trim(); string col = ddlColumns.Text.ToStr().Trim().ToLower(); if (searchTxt.Length < 3) { searchTxt = string.Empty; } bool col_ref = false; bool col_name = false; bool col_date = false; if (col == "refrence no") { col_ref = true; } if (col == "controller name") { col_name = true; } if (col == "complain date") { col_date = true; } var data1 = listOfBookingComplaints != null?listOfBookingComplaints.AsEnumerable() : General.GetQueryable <Complaint>(null).AsEnumerable(); var query = (from a in data1 where (col_ref && (a.RefNo.ToLower().Contains(searchTxt) || searchTxt == string.Empty)) || (col_name && (a.CustomerName.ToLower().Contains(searchTxt) || searchTxt == string.Empty)) || (col_date && (a.ComplainDateTime.ToStr().Contains(searchTxt) || searchTxt == string.Empty)) select new { //string.Format("{0:dd/MMM/yyyy}", a.LostDate).ToStr(), RefNo = a.RefNo, ComplainDate = " " + string.Format(" {0:dd/MM/yyyy} ", a.ComplainDateTime) + " ", CustomerName = a.CustomerName, PhoneNumber = a.CustomerPhoneNo, ComplainDescription = a.ComplainDescription, ResultDescription = a.ResultDescription, ComplaintAgainst = a.ComplaintBy == 1 ? "Driver - " + a.Fleet_Driver.DriverNo : a.ComplaintBy == 2 ? "Controller - " + a.ControllerName : "Account - " + a.Gen_Company.CompanyName }).OrderByDescending(c => c.ComplainDate).ToList(); radGridView1.RowCount = query.Count; for (int i = 0; i < query.Count; i++) { radGridView1.Rows[i].Cells["RefNo"].Value = query[i].RefNo; radGridView1.Rows[i].Cells["ComplainDate"].Value = query[i].ComplainDate; radGridView1.Rows[i].Cells["CustomerName"].Value = query[i].CustomerName; radGridView1.Rows[i].Cells["PhoneNumber"].Value = query[i].PhoneNumber; radGridView1.Rows[i].Cells["ComplaintAgainst"].Value = query[i].ComplaintAgainst; radGridView1.Rows[i].Cells["ResultDescription"].Value = query[i].ResultDescription; radGridView1.Rows[i].Cells["ComplainDescription"].Value = query[i].ComplainDescription; //radGridView1.Rows[i].Cells["PhoneNumber"].Value = query[i].PhoneNumber; } exporter = new RadGridViewExcelExporter(); BackgroundWorker worker = new BackgroundWorker(); // worker.DoWork += new DoWorkEventHandler(worker_DoWork); // worker.RunWorkerCompleted += new RunWorkerCompletedEventHandler(bg_RunWorkerCompleted); worker.DoWork += new DoWorkEventHandler(worker_DoWork); worker.RunWorkerCompleted += new RunWorkerCompletedEventHandler(worker_RunWorkerCompleted); worker.RunWorkerAsync(saveFileDialog1.FileName); exporter.Progress += new ProgressHandler(exportProgress); this.btnExport.Enabled = false; } } catch (Exception ex) { ENUtils.ShowMessage(ex.Message); } }
private void btnExport_Click(object sender, EventArgs e) { try { if (DialogResult.OK == saveFileDialog1.ShowDialog()) { if (radGridView1 == null) { InitializeExportGrid(); } DateTime recentDays = DateTime.Now.AddDays(-1); // radGridView1.VirtualMode = true; radGridView1.Columns.Clear(); radGridView1.Columns.Add(new GridViewTextBoxColumn("RefNo", "RefNo")); radGridView1.Columns.Add(new GridViewTextBoxColumn("PickupDate", "PickupDate")); radGridView1.Columns.Add(new GridViewTextBoxColumn("From", "From")); radGridView1.Columns.Add(new GridViewTextBoxColumn("To", "To")); radGridView1.Columns.Add(new GridViewTextBoxColumn("Customer", "Customer")); radGridView1.Columns.Add(new GridViewTextBoxColumn("Telephone", "Telephone")); radGridView1.Columns.Add(new GridViewTextBoxColumn("Account", "Account")); radGridView1.Columns.Add(new GridViewTextBoxColumn("Vehicle", "Vehicle")); radGridView1.Columns.Add(new GridViewTextBoxColumn("Price", "Price")); radGridView1.Columns.Add(new GridViewTextBoxColumn("Status", "Status")); int bookingstatusId = ddlColumns.SelectedValue.ToInt(); DateTime?fromDate = dtpFromDate.Value.ToDateorNull(); DateTime?toDate = dtpToDate.Value.ToDateorNull(); var data1 = General.GetQueryable <Booking>(c => ( (fromDate == null || c.PickupDateTime.Value.Date >= fromDate) && (toDate == null || c.PickupDateTime.Value.Date <= toDate) ) && c.BookingTypeId == Enums.BOOKING_TYPES.WEB && (bookingstatusId == 0 || c.BookingStatusId == bookingstatusId) ).OrderByDescending(c => c.PickupDateTime).AsEnumerable(); var query = (from a in data1 select new { RefNo = a.BookingNo, PickupDate = " " + string.Format(" {0:dd/MM/yyyy HH:mm} ", a.PickupDateTime) + " ", From = a.FromDoorNo != string.Empty ? a.FromDoorNo + " - " + a.FromAddress : a.FromAddress, To = a.ToDoorNo != string.Empty ? a.ToDoorNo + " - " + a.ToAddress : a.ToAddress, Customer = a.CustomerName, Telephone = a.CustomerPhoneNo != string.Empty ? " " + string.Format(" {0:dd/MM/yyyy HH:mm} ", a.CustomerPhoneNo) + " " : " " + string.Format(" {0:dd/MM/yyyy HH:mm} ", a.CustomerMobileNo) + " ", Account = a.CompanyId != null? a.Gen_Company.CompanyName:"", Vehicle = a.Fleet_VehicleType != null ? a.Fleet_VehicleType.VehicleType : "", Price = a.FareRate, Status = a.BookingStatus.StatusName }).ToList(); radGridView1.RowCount = query.Count; for (int i = 0; i < query.Count; i++) { radGridView1.Rows[i].Cells["RefNo"].Value = query[i].RefNo; radGridView1.Rows[i].Cells["PickupDate"].Value = query[i].PickupDate; radGridView1.Rows[i].Cells["From"].Value = query[i].From; radGridView1.Rows[i].Cells["To"].Value = query[i].To; radGridView1.Rows[i].Cells["Customer"].Value = query[i].Customer; radGridView1.Rows[i].Cells["Telephone"].Value = query[i].Telephone; radGridView1.Rows[i].Cells["Account"].Value = query[i].Account; radGridView1.Rows[i].Cells["Vehicle"].Value = query[i].Vehicle; radGridView1.Rows[i].Cells["Price"].Value = query[i].Price; radGridView1.Rows[i].Cells["Status"].Value = query[i].Status; } radGridView1.Columns["RefNo"].HeaderText = "Ref #"; radGridView1.Columns["PickupDate"].HeaderText = "Pickup Date-Time"; radGridView1.Columns["From"].HeaderText = "Pick-up Address"; radGridView1.Columns["To"].HeaderText = "Drop-off Address"; exporter = new RadGridViewExcelExporter(); BackgroundWorker worker = new BackgroundWorker(); worker.DoWork += new DoWorkEventHandler(worker_DoWork); worker.RunWorkerCompleted += new RunWorkerCompletedEventHandler(bg_RunWorkerCompleted); worker.RunWorkerAsync(saveFileDialog1.FileName); exporter.Progress += new ProgressHandler(exportProgress); this.btnExport.Enabled = false; } } catch (Exception ex) { ENUtils.ShowMessage(ex.Message); } }
private void btnExport_Click(object sender, EventArgs e) { try { if (DialogResult.OK == saveFileDialog1.ShowDialog()) { if (radGridView1 == null) { InitializeExportGrid(); } radGridView1.Columns.Clear(); radGridView1.Columns.Add(new GridViewTextBoxColumn("DriverNo", "DriverNo")); radGridView1.Columns.Add(new GridViewTextBoxColumn("NetTotal", "NetTotal")); radGridView1.Columns.Add(new GridViewTextBoxColumn("Rent", "Rent")); radGridView1.Columns.Add(new GridViewTextBoxColumn("AccountBookings", "AccountBookings")); radGridView1.Columns.Add(new GridViewTextBoxColumn("Balance", "Balance")); radGridView1.Columns.Add(new GridViewTextBoxColumn("OfficeToPay", "OfficeToPay")); radGridView1.Columns.Add(new GridViewTextBoxColumn("DriverToPay", "DriverToPay")); radGridView1.Columns.Add(new GridViewTextBoxColumn("BalanceBF", "BalanceBF")); //radGridView1.Columns.Add(new GridViewTextBoxColumn("Total", "Total")); //radGridView1.Columns.Add(new GridViewTextBoxColumn("Active", "Active")); //this.radGridView1.Columns["Telephone"].ExcelExportType = Telerik.WinControls.UI.Export.DisplayFormatType.Text; //this.radGridView1.Columns["Telephone"].ExcelExportType = DisplayFormatType.Custom; // radGridView1.DataSource = query; using (TaxiDataContext db = new TaxiDataContext()) { var list = db.stp_IncomeStatement().ToList(); // grdLister.DataSource = list; radGridView1.RowCount = list.Count; for (int i = 0; i < list.Count; i++) { radGridView1.Rows[i].Cells["DriverNo"].Value = list[i].DriverNo; radGridView1.Rows[i].Cells["NetTotal"].Value = list[i].NetTotal; radGridView1.Rows[i].Cells["Rent"].Value = list[i].Rent; radGridView1.Rows[i].Cells["AccountBookings"].Value = list[i].AccountBookings; radGridView1.Rows[i].Cells["Balance"].Value = list[i].Balance; radGridView1.Rows[i].Cells["OfficeToPay"].Value = list[i].OfficeToPay; radGridView1.Rows[i].Cells["DriverToPay"].Value = list[i].DriverToPay; radGridView1.Rows[i].Cells["BalanceBF"].Value = list[i].BalanceBF; // radGridView1.Rows[i].Cells["Telephone"].ViewInfo.; //radGridView1.Rows[i].Cells["Telephone"].Value = (radGridView1.Rows[i].Cells["Telephone"].Value.ToString().Replace(".", "")); } } // this.radGridView1.Columns["Telephone"].ExcelExportType = DisplayFormatType.Fixed; //this.radGridView1.Columns["Telephone"].ExcelExportType = DisplayFormatType.Custom; ExportToExcelML export = new ExportToExcelML(this.radGridView1); export.ExportVisualSettings = true; export.HiddenColumnOption = HiddenOption.ExportAsHidden; export.HiddenColumnOption = Telerik.WinControls.UI.Export.HiddenOption.DoNotExport; export.ExcelCellFormatting += new Telerik.WinControls.UI.Export.ExcelML.ExcelCellFormattingEventHandler(export_ExcelCellFormatting); // // //radGridView1.Columns["DriverNo"].HeaderText = "Driver No"; //radGridView1.Columns["AccountBookings"].HeaderText = "Account Bookings"; //radGridView1.Columns["OfficeToPay"].HeaderText = "Office To Pay"; //radGridView1.Columns["BalanceBF"].HeaderText = "Balance B/F"; //radGridView1.Columns["DriverToPay"].HeaderText = "Driver To Pay"; radGridView1.Columns["DriverNo"].HeaderText = "Driver"; radGridView1.Columns["AccountBookings"].HeaderText = "A/C Bookings"; radGridView1.Columns["OfficeToPay"].HeaderText = "Office To Pay"; radGridView1.Columns["BalanceBF"].HeaderText = "Blnc B/F"; radGridView1.Columns["DriverToPay"].HeaderText = "Drv To Pay"; // //CompanyName exporter = new RadGridViewExcelExporter(); BackgroundWorker worker = new BackgroundWorker(); worker.DoWork += new DoWorkEventHandler(worker_DoWork); worker.RunWorkerCompleted += new RunWorkerCompletedEventHandler(bg_RunWorkerCompleted); worker.RunWorkerAsync(saveFileDialog1.FileName); exporter.Progress += new ProgressHandler(exportProgress); this.btnExport.Enabled = false; } } catch (Exception ex) { ENUtils.ShowMessage(ex.Message); } }
private void btnExport_Click(object sender, EventArgs e) { try { if (DialogResult.OK == saveFileDialog1.ShowDialog()) { if (radGridView1 == null) { InitializeExportGrid(); } DateTime recentDays = DateTime.Now.AddDays(-1); // radGridView1.VirtualMode = true; radGridView1.Columns.Clear(); radGridView1.Columns.Add(new GridViewTextBoxColumn("RefNo", "RefNo")); radGridView1.Columns.Add(new GridViewTextBoxColumn("PickupDate", "PickupDate")); radGridView1.Columns.Add(new GridViewTextBoxColumn("From", "From")); radGridView1.Columns.Add(new GridViewTextBoxColumn("To", "To")); radGridView1.Columns.Add(new GridViewTextBoxColumn("Customer", "Customer")); radGridView1.Columns.Add(new GridViewTextBoxColumn("Telephone", "Telephone")); radGridView1.Columns.Add(new GridViewTextBoxColumn("MobileNo", "MobileNo")); radGridView1.Columns.Add(new GridViewTextBoxColumn("Account", "Account")); radGridView1.Columns.Add(new GridViewTextBoxColumn("Vehicle", "Vehicle")); radGridView1.Columns.Add(new GridViewTextBoxColumn("Price", "Price")); radGridView1.Columns.Add(new GridViewTextBoxColumn("Drv", "Drv")); radGridView1.Columns.Add(new GridViewTextBoxColumn("Status", "Status")); int bookingstatusId = ddlColumns.SelectedValue.ToInt(); DateTime?fromDate = dtpFromDate.Value.ToDateorNull(); DateTime?toDate = dtpToDate.Value.ToDateorNull(); using (TaxiDataContext db = new TaxiDataContext()) { var query = (from a in db.GetTable <ArchiveBooking>().Where(c => (bookingstatusId == 0 || c.BookingStatusId == bookingstatusId) && ((fromDate == null || c.PickupDateTime.Value.Date >= fromDate) && (toDate == null || c.PickupDateTime.Value.Date <= toDate) ) ) join b in db.GetTable <Fleet_VehicleType>() on a.VehicleTypeId equals b.Id join ee in db.GetTable <BookingStatus>() on a.BookingStatusId equals ee.Id join c in db.GetTable <Fleet_Driver>() on a.DriverId equals c.Id into table2 from z in table2.DefaultIfEmpty() join d in db.GetTable <Gen_Company>() on a.CompanyId equals d.Id into table3 from acc in table3.DefaultIfEmpty() select new { Id = a.Id, RefNumber = a.BookingNo, BookingDate = a.BookingDate, PickupDate = a.PickupDateTime, Passenger = a.CustomerName, TelephoneNo = a.CustomerPhoneNo, MobileNo = a.CustomerMobileNo, From = a.FromDoorNo != string.Empty ? a.FromDoorNo + " - " + a.FromAddress : a.FromAddress, To = a.ToDoorNo != string.Empty ? a.ToDoorNo + " - " + a.ToAddress : a.ToAddress, Fare = a.FareRate, Account = acc != null ? acc.CompanyName : "", Driver = z != null ? z.DriverNo : "", DriverId = a.DriverId, Vehicle = b.VehicleType, Status = ee.StatusName, StatusColor = ee.BackgroundColor, BookingTypeId = a.BookingTypeId, VehicleBgColor = b.BackgroundColor, VehicleTextColor = b.TextColor, BackgroundColor1 = acc.BackgroundColor, TextColor1 = acc.TextColor, FromLocTypeId = a.FromLocTypeId, ToLocTypeId = a.ToLocTypeId, }).OrderByDescending(c => c.PickupDate).ToList(); radGridView1.RowCount = query.Count; for (int i = 0; i < query.Count; i++) { radGridView1.Rows[i].Cells["RefNo"].Value = query[i].RefNumber; radGridView1.Rows[i].Cells["PickupDate"].Value = " " + string.Format("{0:dd/MM/yyyy HH:mm}", query[i].PickupDate) + " "; radGridView1.Rows[i].Cells["From"].Value = query[i].From; radGridView1.Rows[i].Cells["To"].Value = query[i].To; radGridView1.Rows[i].Cells["Customer"].Value = query[i].Passenger; radGridView1.Rows[i].Cells["Telephone"].Value = " " + query[i].TelephoneNo + " "; radGridView1.Rows[i].Cells["MobileNo"].Value = " " + query[i].MobileNo + " "; radGridView1.Rows[i].Cells["Account"].Value = query[i].Account; radGridView1.Rows[i].Cells["Vehicle"].Value = query[i].Vehicle; radGridView1.Rows[i].Cells["Drv"].Value = query[i].Driver; radGridView1.Rows[i].Cells["Price"].Value = query[i].Fare; radGridView1.Rows[i].Cells["Status"].Value = query[i].Status; } radGridView1.Columns["RefNo"].HeaderText = "Ref #"; radGridView1.Columns["PickupDate"].HeaderText = "Pickup Date-Time"; radGridView1.Columns["From"].HeaderText = "Pick-up Address"; radGridView1.Columns["To"].HeaderText = "Drop-off Address"; exporter = new RadGridViewExcelExporter(); BackgroundWorker worker = new BackgroundWorker(); worker.DoWork += new DoWorkEventHandler(worker_DoWork); worker.RunWorkerCompleted += new RunWorkerCompletedEventHandler(bg_RunWorkerCompleted); worker.RunWorkerAsync(saveFileDialog1.FileName); exporter.Progress += new ProgressHandler(exportProgress); this.btnExport.Enabled = false; } } } catch (Exception ex) { ENUtils.ShowMessage(ex.Message); } }
private void btnExport_Click(object sender, EventArgs e) { try { if (DialogResult.OK == saveFileDialog1.ShowDialog()) { radGridView1.Columns.Clear(); radGridView1.Rows.Clear(); radGridView1.Columns.Add(new GridViewTextBoxColumn("RefNo", "RefNo")); radGridView1.Columns.Add(new GridViewTextBoxColumn("LostDate", "LostDate")); radGridView1.Columns.Add(new GridViewTextBoxColumn("Complaint", "Complaint")); radGridView1.Columns.Add(new GridViewTextBoxColumn("Disposition", "Disposition")); radGridView1.Columns.Add(new GridViewTextBoxColumn("Result", "Result")); string searchTxt = txtSearch.Text.ToStr().ToLower().Trim(); string col = ddlColumns.Text.ToStr().Trim().ToLower(); if (searchTxt.Length < 3) { searchTxt = string.Empty; } bool col_lost = false; bool col_Decs = false; bool col_Name = false; if (col == "lost no") { col_lost = true; } if (col == "item description") { col_Decs = true; } if (col == "customer") { col_Name = true; } var list = (from a in General.GetQueryable <LostProperty>(null) where (col_lost && (a.LPNo.ToLower().Contains(searchTxt) || searchTxt == string.Empty)) || (col_Decs && (a.Complaint.ToLower().Contains(searchTxt) || searchTxt == string.Empty)) || (col_Name && (a.CustomerName.ToLower().Contains(searchTxt) || searchTxt == string.Empty)) select new { //Id = a.Id, RefNo = a.LPNo, LPDate = " " + string.Format(" {0:dd/MM/yyyy} ", a.ReportedDate) + " ", LostDate = " " + string.Format(" {0:dd/MM/yyyy} ", a.LostDate) + " ", Complaint = a.Complaint, Disposition = a.Disposition, Result = a.Result //CustomerName = a.CustomerName, //ItemDecs = a.Complaint }).ToList(); // this.radGridView1.DataSource = list; radGridView1.RowCount = list.Count; for (int i = 0; i < list.Count; i++) { radGridView1.Rows[i].Cells["RefNo"].Value = list[i].RefNo; radGridView1.Rows[i].Cells["LostDate"].Value = list[i].LostDate; radGridView1.Rows[i].Cells["Complaint"].Value = list[i].Complaint; radGridView1.Rows[i].Cells["Disposition"].Value = list[i].Disposition; radGridView1.Rows[i].Cells["Result"].Value = list[i].Result; } exporter = new RadGridViewExcelExporter(); BackgroundWorker worker = new BackgroundWorker(); //worker.DoWork += new DoWorkEventHandler(worker_DoWork); //worker.RunWorkerCompleted += new RunWorkerCompletedEventHandler(worker_RunWorkerCompleted); worker.DoWork += new DoWorkEventHandler(worker_DoWork); worker.RunWorkerCompleted += new RunWorkerCompletedEventHandler(worker_RunWorkerCompleted); worker.RunWorkerAsync(saveFileDialog1.FileName); exporter.Progress += new ProgressHandler(exportProgress); this.btnExport.Enabled = false; } } catch (Exception ex) { } }
private void btnExport_Click(object sender, EventArgs e) { try { if (DialogResult.OK == saveFileDialog1.ShowDialog()) { if (radGridView1 == null) { InitializeExportGrid(); } DateTime recentDays = DateTime.Now.AddDays(-1); // radGridView1.VirtualMode = true; radGridView1.Columns.Clear(); radGridView1.Columns.Add(new GridViewTextBoxColumn("PickupDate", "PickupDate")); radGridView1.Columns.Add(new GridViewTextBoxColumn("From", "From")); radGridView1.Columns.Add(new GridViewTextBoxColumn("To", "To")); radGridView1.Columns.Add(new GridViewTextBoxColumn("Customer", "Customer")); radGridView1.Columns.Add(new GridViewTextBoxColumn("Telephone", "Telephone")); radGridView1.Columns.Add(new GridViewTextBoxColumn("Driver", "Driver")); radGridView1.Columns.Add(new GridViewTextBoxColumn("Vehicle", "Vehicle")); radGridView1.Columns.Add(new GridViewTextBoxColumn("Price", "Price")); var data1 = General.GetQueryable <Booking>(c => // && // ( // c.BookingStatusId == Enums.BOOKINGSTATUS.PENDING || c.BookingStatusId == Enums.BOOKINGSTATUS.WAITING || c.BookingStatusId==Enums.BOOKINGSTATUS.ONHOLD // || c.BookingStatusId == Enums.BOOKINGSTATUS.NOTACCEPTED || c.BookingStatusId == Enums.BOOKINGSTATUS.REJECTED || c.BookingStatusId == Enums.BOOKINGSTATUS.BID //) (c.BookingTypeId == 13) && (c.SubcompanyId == AppVars.DefaultBookingSubCompanyId || AppVars.DefaultBookingSubCompanyId == 0) ) .OrderByDescending(c => c.PickupDateTime).AsEnumerable(); var query = (from a in data1 select new { PickupDate = " " + string.Format(" {0:dd/MM/yyyy HH:mm} ", a.PickupDateTime) + " ", From = a.FromDoorNo != string.Empty ? a.FromDoorNo + " - " + a.FromAddress : a.FromAddress, To = a.ToDoorNo != string.Empty ? a.ToDoorNo + " - " + a.ToAddress : a.ToAddress, Customer = a.CustomerName, Telephone = a.CustomerPhoneNo != string.Empty ? " " + string.Format(" {0:dd/MM/yyyy HH:mm} ", a.CustomerPhoneNo) + " " : " " + string.Format(" {0:dd/MM/yyyy HH:mm} ", a.CustomerMobileNo) + " ", Driver = a.Fleet_Driver != null ? a.Fleet_Driver.DriverNo : "", Vehicle = a.Fleet_VehicleType != null ? a.Fleet_VehicleType.VehicleType:"", Price = a.FareRate }).ToList(); //radGridView1.DataSource = query; radGridView1.RowCount = query.Count; for (int i = 0; i < query.Count; i++) { radGridView1.Rows[i].Cells["PickupDate"].Value = query[i].PickupDate; radGridView1.Rows[i].Cells["From"].Value = query[i].From; radGridView1.Rows[i].Cells["To"].Value = query[i].To; radGridView1.Rows[i].Cells["Customer"].Value = query[i].Customer; radGridView1.Rows[i].Cells["Telephone"].Value = query[i].Telephone; radGridView1.Rows[i].Cells["Driver"].Value = query[i].Driver; radGridView1.Rows[i].Cells["Vehicle"].Value = query[i].Vehicle; radGridView1.Rows[i].Cells["Price"].Value = query[i].Price; } radGridView1.Columns["PickupDate"].HeaderText = "Pickup Date-Time"; radGridView1.Columns["From"].HeaderText = "Pick-up Address"; radGridView1.Columns["To"].HeaderText = "Drop-off Address"; exporter = new RadGridViewExcelExporter(); BackgroundWorker worker = new BackgroundWorker(); worker.DoWork += new DoWorkEventHandler(worker_DoWork); worker.RunWorkerCompleted += new RunWorkerCompletedEventHandler(bg_RunWorkerCompleted); worker.RunWorkerAsync(saveFileDialog1.FileName); exporter.Progress += new ProgressHandler(exportProgress); this.btnExport.Enabled = false; } } catch (Exception ex) { ENUtils.ShowMessage(ex.Message); } }
private void btnExport_Click(object sender, EventArgs e) { try { if (DialogResult.OK == saveFileDialog1.ShowDialog()) { if (radGridView1 == null) { InitializeExportGrid(); } radGridView1.Columns.Clear(); radGridView1.Columns.Add(new GridViewTextBoxColumn("AccountName", "AccountName")); radGridView1.Columns.Add(new GridViewTextBoxColumn("Address", "Address")); //this.radGridView1.Columns["Telephone"].ExcelExportType = Telerik.WinControls.UI.Export.DisplayFormatType.Text; //this.radGridView1.Columns["Telephone"].ExcelExportType = DisplayFormatType.Custom; // radGridView1.DataSource = query; var list = (from a in General.GetQueryable <Gen_Company>(null) orderby a.CompanyName select new { CompanyName = a.CompanyName, Address = a.Address }).ToList(); radGridView1.RowCount = list.Count; for (int i = 0; i < list.Count; i++) { radGridView1.Rows[i].Cells["AccountName"].Value = list[i].CompanyName; radGridView1.Rows[i].Cells["Address"].Value = list[i].Address; // radGridView1.Rows[i].Cells["Telephone"].ViewInfo.; //radGridView1.Rows[i].Cells["Telephone"].Value = (radGridView1.Rows[i].Cells["Telephone"].Value.ToString().Replace(".", "")); } // this.radGridView1.Columns["Telephone"].ExcelExportType = DisplayFormatType.Fixed; //this.radGridView1.Columns["Telephone"].ExcelExportType = DisplayFormatType.Custom; ExportToExcelML export = new ExportToExcelML(this.radGridView1); export.ExportVisualSettings = true; export.HiddenColumnOption = HiddenOption.ExportAsHidden; export.HiddenColumnOption = Telerik.WinControls.UI.Export.HiddenOption.DoNotExport; export.ExcelCellFormatting += new Telerik.WinControls.UI.Export.ExcelML.ExcelCellFormattingEventHandler(export_ExcelCellFormatting); // // //radGridView1.Columns["PickupDate"].HeaderText = "Pickup Date-Time"; //radGridView1.Columns["From"].HeaderText = "Pick-up Address"; //radGridView1.Columns["To"].HeaderText = "Drop-off Address"; radGridView1.Columns["AccountName"].HeaderText = "Account Name"; //Me.RadGridView1.Columns(0).ExcelExportType = Export.DisplayFormatType.Text //CompanyName exporter = new RadGridViewExcelExporter(); BackgroundWorker worker = new BackgroundWorker(); worker.DoWork += new DoWorkEventHandler(worker_DoWork); worker.RunWorkerCompleted += new RunWorkerCompletedEventHandler(bg_RunWorkerCompleted); worker.RunWorkerAsync(saveFileDialog1.FileName); exporter.Progress += new ProgressHandler(exportProgress); this.btnExport.Enabled = false; } } catch (Exception ex) { ENUtils.ShowMessage(ex.Message); } }
private void btnExport_Click(object sender, EventArgs e) { try { if (DialogResult.OK == saveFileDialog1.ShowDialog()) { if (radGridView1 == null) { InitializeExportGrid(); } radGridView1.Columns.Clear(); radGridView1.Columns.Add(new GridViewTextBoxColumn("DriverNo", "DriverNo")); radGridView1.Columns.Add(new GridViewTextBoxColumn("DriverName", "Name")); radGridView1.Columns.Add(new GridViewTextBoxColumn("VehicleType", "Vehicle")); radGridView1.Columns.Add(new GridViewTextBoxColumn("Owed", "Owed")); radGridView1.Columns.Add(new GridViewTextBoxColumn("Paid", "Paid")); radGridView1.Columns.Add(new GridViewTextBoxColumn("CurrentBalance", "C Balance")); //radGridView1.Columns.Add(new GridViewTextBoxColumn("Driver", "Driver")); //radGridView1.Columns.Add(new GridViewTextBoxColumn("Vehicle", "Vehicle")); //radGridView1.Columns.Add(new GridViewTextBoxColumn("Price", "Price")); using (TaxiDataContext db = new TaxiDataContext()) { var query = db.stp_DriverCommissionPaymentSummary().ToList(); radGridView1.RowCount = query.Count; for (int i = 0; i < query.Count; i++) { // radGridView1.Rows[i].Cells["PickupDate"].Value = " " + string.Format(" {0:dd/MM/yyyy HH:mm} ", query[i].PickupDate) + " "; radGridView1.Rows[i].Cells["DriverNo"].Value = query[i].DriverNo.Replace("=", "").Trim(); radGridView1.Rows[i].Cells["DriverName"].Value = query[i].DriverName.Replace("=", "").Trim(); radGridView1.Rows[i].Cells["VehicleType"].Value = query[i].VehicleType.Replace("=", "").Trim(); //radGridView1.Rows[i].Cells["Customer"].Value = query[i].Customer.Replace("=", "").Trim(); //radGridView1.Rows[i].Cells["Telephone"].Value = string.Format(" {0:F0} ", query[i].Telephone) + "."; //" " + string.Format(" {0:dd/MM/yyyy HH:mm} ", query[i].Telephone.Replace("=", "").Trim()) + " "; radGridView1.Rows[i].Cells["Owed"].Value = query[i].Owed; radGridView1.Rows[i].Cells["Paid"].Value = query[i].Paid; radGridView1.Rows[i].Cells["CurrentBalance"].Value = query[i].CurrentBalance; // radGridView1.Rows[i].Cells["Telephone"].ViewInfo.; //radGridView1.Rows[i].Cells["Telephone"].Value = (radGridView1.Rows[i].Cells["Telephone"].Value.ToString().Replace(".", "")); } } ExportToExcelML export = new ExportToExcelML(this.radGridView1); export.ExportVisualSettings = true; export.HiddenColumnOption = HiddenOption.ExportAsHidden; export.HiddenColumnOption = Telerik.WinControls.UI.Export.HiddenOption.DoNotExport; export.ExcelCellFormatting += new Telerik.WinControls.UI.Export.ExcelML.ExcelCellFormattingEventHandler(export_ExcelCellFormatting); // radGridView1.Columns["DriverNo"].HeaderText = "Driver No"; radGridView1.Columns["DriverName"].HeaderText = "Name"; radGridView1.Columns["VehicleType"].HeaderText = "Vehicle"; //grdLister.Columns["LastStatementNo"].HeaderText = "Last Statement No"; radGridView1.Columns["CurrentBalance"].HeaderText = "C Balance"; // //grdLister.Columns["PickupDate"].HeaderText = "Pickup Date-Time"; //radGridView1.Columns["From"].HeaderText = "Pick-up Address"; //radGridView1.Columns["To"].HeaderText = "Drop-off Address"; //radGridView1.Columns["CompanyName"].HeaderText = "Account"; //Me.RadGridView1.Columns(0).ExcelExportType = Export.DisplayFormatType.Text //CompanyName exporter = new RadGridViewExcelExporter(); BackgroundWorker worker = new BackgroundWorker(); worker.DoWork += new DoWorkEventHandler(worker_DoWork); worker.RunWorkerCompleted += new RunWorkerCompletedEventHandler(bg_RunWorkerCompleted); worker.RunWorkerAsync(saveFileDialog1.FileName); exporter.Progress += new ProgressHandler(exportProgress); this.btnExport.Enabled = false; } } catch (Exception ex) { } }