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)
{
}
}
