private void FillCombo()
{
ComboFunctions.FillDriverNoCombo(ddl_Driver, c => c.DriverTypeId == 1 && (c.SubcompanyId == AppVars.DefaultDriverSubCompanyId || AppVars.DefaultDriverSubCompanyId == 0));
dtpFromDate.Value = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1);
dtpTillDate.Value = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.LastDayOfMonthValue());
dtpTillDate.Value = dtpTillDate.Value.Value.AddHours(23).AddMinutes(59);
}
private void ddlDriver_Enter(object sender, EventArgs e)
{
if (ddlDriver.DataSource == null)
{
ComboFunctions.FillDriverNoCombo(ddlDriver);
}
}
private void FillDriverNoComboIfNull()
{
if (ddlDriver.DataSource == null)
{
ComboFunctions.FillDriverNoCombo(ddlDriver, null);
}
}
private void FillCombo()
{
ComboFunctions.FillDriverWeeklyRentHistoryCombo(ddlDateRange);
ComboFunctions.FillDriverNoCombo(ddlDriver);
//ComboFunctions.FillDriverNoCombo(ddlDriver, c => c.DriverTypeId == 1);
}
//void DropDownListElement_TextChanging(object sender, TextChangingEventArgs e)
//{
// //this.ddl_Driver.DropDownListElement.TextBox.cle.Filter = ClearFilterItem;
// //this.ddl_Driver.Filter = FilterItem;
// string s = ddl_Driver.Text;
// this.ddl_Driver.FilterExpression = "DriverName LIKE '%" + s + "%'";
//}
//private bool FilterItem(RadListDataItem item)
//{
// if (item == null)
// return false;
// if (item.Text.Contains(ddl_Driver.DropDownListElement.TextBox.TextBoxItem.Text))
// {
// return true;
// }
// return false;
//}
private void LoadData()
{
try
{
ComboFunctions.FillDriverNoCombo(ddl_Driver);
}
catch (Exception ex)
{
}
}
void frmPlotDriver_Shown(object sender, EventArgs e)
{
if (IsPlotting)
{
if (AppVars.objPolicyConfiguration.EnablePDA.ToBool())
{
ComboFunctions.FillFreezePlottedDriverNoCombo(ddl_Driver);
}
else
{
ComboFunctions.FillDriverNoCombo(ddl_Driver);
}
ComboFunctions.FillZonesPlottedCombo(ddlZone);
ComboFunctions.FillVehicleCombo(ddlVehicle);
}
else
{
Pg_Ordering.Item.Visibility = Telerik.WinControls.ElementVisibility.Collapsed;
Pg_Main.Text = "Un-Plot";
ddlZone.Enabled = false;
ddlVehicle.Enabled = false;
lblZone.Enabled = false;
var list1 = General.GetQueryable <Fleet_DriverQueueList>(a => a.DriverId != null && a.Status == true);
var query = from a in list1
orderby a.QueueDateTime
select new
{
Id = a.Id,
DriverNo = a.Fleet_Driver.DriverNo + " - " + a.Fleet_Driver.DriverName,
};
ComboFunctions.FillCombo(query.ToList(), ddl_Driver, "DriverNo", "Id");
}
ddl_Driver.RootElement.Focus();
ddl_Driver.RootElement.Children[0].Focus();
IsFormLoaded = true;
if (DriverId != 0)
{
DriverQueueBO objMaster = new DriverQueueBO();
objMaster.GetByPrimaryKey(DriverId);
ddl_Driver.SelectedValue = objMaster.Current.DriverId.ToInt();
ddlZone.SelectedValue = objMaster.Current.ZoneId.ToInt();
ddlVehicle.SelectedValue = objMaster.Current.FleetMasterId.ToInt();
}
}
public frmShifts()
{
InitializeComponent();
objdriver = new DriverBO();
objMaster = new DriverShiftsBO();
FormateShiftGride();
ComboFunctions.FillDriverNoCombo(ddlDriver);
ComboFunctions.FillDriverShiftsCombo(ddlShifts);
grdShifts.CellDoubleClick += new GridViewCellEventHandler(grdShifts_CellDoubleClick);
grdShifts.CommandCellClick += new CommandCellClickEventHandler(grid_CommandCellClick);
}
private void rptfrmDriverLoginHistory_Load(object sender, EventArgs e)
{
try
{
ComboFunctions.FillDriverNoCombo(ddl_Driver);
dtpFromDate.Value = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1);
dtpTillDate.Value = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.LastDayOfMonthValue());
}
catch (Exception ex)
{
}
}
public frmDriverTransactionReport(int val)
{
InitializeComponent();
IsCheck = val;
this.Load += new EventHandler(frmInvoiceReport_Load);
ComboFunctions.FillDriverNoCombo(ddlCompany);
dtpFromDate.Value = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1);
dtpTillDate.Value = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.LastDayOfMonthValue());
}
private void rptfrmJobHistoryReport_Load_1(object sender, EventArgs e)
{
try
{
ComboFunctions.FillDriverNoCombo(ddl_Driver);
ComboFunctions.FillVehicleTypeCombo(ddlVehicle);
dtpFromDate.Value = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1);
dtpTillDate.Value = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.LastDayOfMonthValue());
}
catch (Exception ex)
{
}
}
public frmAllocateDriver(long ID, int openFrom)
{
InitializeComponent();
ObjMaster = new BookingBO();
ObjMaster.GetByPrimaryKey(ID);
ComboFunctions.FillDriverNoCombo(ddl_Driver);
// ComboFunctions.FillDriverNoQueueCombo(ddl_Driver);
DisplayRecord();
this.Shown += new EventHandler(frmAllocateDriver_Shown);
this.KeyDown += new KeyEventHandler(frmAllocateDriver_KeyDown);
this.IsOpenFrom = openFrom;
}
public frmDriverMonthlyRentReport()
{
InitializeComponent();
ComboFunctions.FillDriverNoCombo(ddlDriver, c => c.DriverTypeId == 1);
// rdoMonyhly.IsChecked = true;
int Month = DateTime.Now.Month.ToInt();
string Year = DateTime.Now.Year.ToStr();
dtpFromDate.Value = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1);
dtpTillDate.Value = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.LastDayOfMonthValue());
}
public frmDriverMonthlyCommisionReport()
{
InitializeComponent();
this.Load += new EventHandler(frmInvoiceReport_Load);
ComboFunctions.FillDriverNoCombo(ddlDriver, c => c.DriverTypeId == 2);
rdoMonyhly.IsChecked = true;
int Month = DateTime.Now.Month.ToInt();
string Year = DateTime.Now.Year.ToStr();
ddlWeekMonths.SelectedIndex = Month.ToInt();
ddlMonth.SelectedIndex = Month.ToInt();
ddlYear.SelectedText = Year.ToStr();
ddlYear.Select();
}
void chkAllDriver_ToggleStateChanged(object sender, StateChangedEventArgs args)
{
if (args.ToggleState == ToggleState.On)
{
ddlDriver.SelectedValue = null;
ddlDriver.Enabled = false;
//ddlAllDriver.SelectedValue = 0;
}
else
{
if (ddlDriver.DataSource == null)
{
ComboFunctions.FillDriverNoCombo(ddlDriver);
}
ddlDriver.Enabled = true;
}
}
public frmDriverCommisionTransactionExpensesReport3(int val)
{
InitializeComponent();
IsCheck = val;
this.Load += new EventHandler(frmInvoiceReport_Load);
ComboFunctions.FillDriverNoCombo(ddlCompany);
if (ddlCompany.SelectedValue == null)
{
pnlCriteria.Visible = false;
}
dtpFromDate.Value = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1);
dtpTillDate.Value = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.LastDayOfMonthValue());
}
private void LoadAndSelectDriver()
{
try
{
ComboFunctions.FillDriverNoCombo(ddl_Driver);
// ComboFunctions.FillDriverNoQueueCombo(ddl_Driver);
IsLoaded = true;
if (this.SelectedDriverId != null)
{
ddl_Driver.SelectedValue = this.SelectedDriverId;
}
}
catch (Exception ex)
{
}
}
private void FillCombo()
{
ComboFunctions.FillDriverCommissionCollectionHistoryCombo(ddlDateRange);
//ComboFunctions.FillDriverNoCombo(ddlDriver);
ComboFunctions.FillDriverNoCombo(ddlDriver, c => c.DriverTypeId == 2);
}
private void frmDriverJobLogReport_Load(object sender, EventArgs e)
{
try
{
dtpFromDate.Value = DateTime.Now.Date;
dtpFromTime.Value = DateTime.Now.Date;
dtpTillDate.Value = DateTime.Now.Date;
dtpTillTime.Value = DateTime.Now.Date;
ComboFunctions.FillDriverNoCombo(ddl_Driver);
GridViewTextBoxColumn col = new GridViewTextBoxColumn();
col.IsVisible = false;
col.Name = "Id";
grdLister.Columns.Add(col);
GridViewDateTimeColumn colDt = new GridViewDateTimeColumn();
colDt.Name = "PickupDate";
colDt.ReadOnly = true;
colDt.HeaderText = "Pickup Date-Time";
grdLister.Columns.Add(colDt);
col = new GridViewTextBoxColumn();
// col.IsVisible = false;
col.ReadOnly = true;
col.HeaderText = "Ref #";
col.Name = "RefNumber";
grdLister.Columns.Add(col);
col = new GridViewTextBoxColumn();
// col.IsVisible = false;
col.HeaderText = "Vehicle";
col.Name = "Vehicle";
col.ReadOnly = true;
grdLister.Columns.Add(col);
col = new GridViewTextBoxColumn();
// col.IsVisible = false;
col.ReadOnly = true;
col.HeaderText = "Pickup Point";
col.Name = "PickupPoint";
grdLister.Columns.Add(col);
col = new GridViewTextBoxColumn();
// col.IsVisible = false;
col.ReadOnly = true;
col.HeaderText = "Destination";
col.Name = "Destination";
grdLister.Columns.Add(col);
GridViewDecimalColumn colD = new GridViewDecimalColumn();
colD.DecimalPlaces = 2;
colD.Minimum = 0;
colD.ReadOnly = true;
colD.HeaderText = "Total";
colD.Name = "Total";
colD.Maximum = 9999999;
colD.FormatString = "{0:#,###0.00}";
grdLister.Columns.Add(colD);
(grdLister.Columns["PickUpDate"] as GridViewDateTimeColumn).CustomFormat = "dd/MM/yyyy HH:mm";
(grdLister.Columns["PickUpDate"] as GridViewDateTimeColumn).FormatString = "{0:dd/MM/yyyy HH:mm}";
grdLister.Columns["PickUpDate"].Width = 130;
grdLister.Columns["RefNumber"].Width = 50;
grdLister.Columns["Vehicle"].Width = 70;
grdLister.Columns["PickUpPoint"].Width = 200;
grdLister.Columns["Destination"].Width = 200;
grdLister.Columns["Charges"].Width = 45;
grdLister.Columns["Total"].Width = 40;
grdLister.Columns["PickUpDate"].HeaderText = "Pickup Date-Time";
grdLister.Columns["RefNumber"].HeaderText = "Ref #";
grdLister.Columns["PickUpPoint"].HeaderText = "Pickup Point";
grdLister.AllowEditRow = true;
}
catch (Exception ex)
{
}
}
public void FillCombo()
{
ComboFunctions.FillDriverNoCombo(ddlDrivers);
}
private void FillCombo()
{
ComboFunctions.FillDriverNoCombo(ddlDriver);
ddlDriver.PopupOpened += new EventHandler(ddlDriver_PopupOpened);
}
private void FillCombo()
{
ComboFunctions.FillDriverNoCombo(ddlDrivers, c => c.DriverTypeId == 1);
ComboFunctions.FillRentPayReasonCombo(ddlRentPayReason);
}
private void FillDriver()
{
ComboFunctions.FillDriverNoCombo(ddlDriver);
}
private void FillCombo()
{
ComboFunctions.FillDriverNoCombo(ddlDrivers, c => c.DriverTypeId == 2);
// ComboFunctions.FillCommissionReasonCombo(ddlCommissionPayReason);
}
void frmDriverReport_Load(object sender, EventArgs e)
{
ComboFunctions.FillUsersCombo(ddlController);
ComboFunctions.FillDriverNoCombo(ddl_Driver, c => c.HasPDA != null && c.HasPDA == true);
dtpFromDate.Value = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1);
dtpTillDate.Value = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.LastDayOfMonthValue());
GridViewTextBoxColumn col = new GridViewTextBoxColumn();
col.IsVisible = false;
col.Name = COLS.DRIVERID;
grdLister.Columns.Add(col);
col = new GridViewTextBoxColumn();
// col.IsVisible = false;
col.ReadOnly = true;
col.HeaderText = "Action";
col.Name = COLS.ACTION;
grdLister.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.ReadOnly = true;
col.HeaderText = "Drv";
col.Name = COLS.DRIVERNO;
grdLister.Columns.Add(col);
GridViewDateTimeColumn colDt = new GridViewDateTimeColumn();
colDt.Name = COLS.PICKUPDATETIME;
colDt.ReadOnly = true;
colDt.HeaderText = "Pickup Date Time";
grdLister.Columns.Add(colDt);
col = new GridViewTextBoxColumn();
col.HeaderText = "Pickup Point";
col.Name = COLS.PICKUPPOINT;
col.ReadOnly = true;
grdLister.Columns.Add(col);
col = new GridViewTextBoxColumn();
// col.IsVisible = false;
col.ReadOnly = true;
col.Name = "Destination";
col.HeaderText = COLS.DESTINATION;
grdLister.Columns.Add(col);
colDt = new GridViewDateTimeColumn();
colDt.Name = COLS.BLOCKEDON;
colDt.ReadOnly = true;
colDt.HeaderText = "Blocked On";
grdLister.Columns.Add(colDt);
colDt = new GridViewDateTimeColumn();
colDt.Name = COLS.UNBLOCKEDON;
colDt.ReadOnly = true;
colDt.HeaderText = "UnBlocked On";
grdLister.Columns.Add(colDt);
col = new GridViewTextBoxColumn();
col.Name = COLS.UNBLOCKBY;
col.ReadOnly = true;
col.HeaderText = "UnBlock By";
grdLister.Columns.Add(col);
//(grdLister.Columns[COLS.PICKUPDATETIME] as GridViewDateTimeColumn).CustomFormat = "dd/MM/yyyy HH:mm";
// (grdLister.Columns[COLS.PICKUPDATETIME] as GridViewDateTimeColumn).FormatString = "{0:dd/MM/yyyy HH:mm}";
(grdLister.Columns[COLS.PICKUPDATETIME] as GridViewDateTimeColumn).CustomFormat = "dd/MM/yyyy HH:mm";
(grdLister.Columns[COLS.PICKUPDATETIME] as GridViewDateTimeColumn).FormatString = "{0:dd/MM/yyyy HH:mm}";
(grdLister.Columns[COLS.BLOCKEDON] as GridViewDateTimeColumn).CustomFormat = "dd/MM/yyyy HH:mm";
(grdLister.Columns[COLS.BLOCKEDON] as GridViewDateTimeColumn).FormatString = "{0:dd/MM/yyyy HH:mm}";
(grdLister.Columns[COLS.UNBLOCKEDON] as GridViewDateTimeColumn).CustomFormat = "dd/MM/yyyy HH:mm";
(grdLister.Columns[COLS.UNBLOCKEDON] as GridViewDateTimeColumn).FormatString = "{0:dd/MM/yyyy HH:mm}";
grdLister.Columns[COLS.DRIVERNO].Width = 60;
grdLister.Columns[COLS.PICKUPPOINT].Width = 160;
grdLister.Columns[COLS.DESTINATION].Width = 160;
grdLister.Columns[COLS.PICKUPDATETIME].Width = 100;
grdLister.Columns[COLS.BLOCKEDON].Width = 130;
grdLister.Columns[COLS.UNBLOCKEDON].Width = 130;
grdLister.Columns[COLS.UNBLOCKBY].Width = 100;
grdLister.Columns[COLS.ACTION].Width = 100;
grdLister.AllowEditRow = true;
}
void frmDriverReport_Load(object sender, EventArgs e)
{
if (AppVars.listUserRights.Count(c => c.formName == this.Name && c.functionId == "SPECIAL") > 0)
{
ChkRent.Visible = true;
txtRent.Visible = true;
}
// ViewReport();
ComboFunctions.FillDriverNoCombo(ddl_Driver, c => c.DriverTypeId == 1 && (c.SubcompanyId == AppVars.DefaultDriverSubCompanyId || AppVars.DefaultDriverSubCompanyId == 0));
dtpFromDate.Value = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1);
dtpTillDate.Value = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.LastDayOfMonthValue());
dtpTillDate.Value = dtpTillDate.Value.Value.AddHours(23).AddMinutes(59);
ComboFunctions.FillSubCompanyCombo(ddlSubCompany);
if (ddlSubCompany.Items.Count > 1)
{
ddlSubCompany.SelectedIndex = 1;
}
else
{
ddlSubCompany.SelectedIndex = 0;
}
GridViewTextBoxColumn col = new GridViewTextBoxColumn();
col.IsVisible = false;
col.Name = "Id";
grdLister.Columns.Add(col);
GridViewDateTimeColumn colDt = new GridViewDateTimeColumn();
colDt.Name = "PickupDate";
colDt.ReadOnly = true;
colDt.HeaderText = "Pickup Date-Time";
grdLister.Columns.Add(colDt);
col = new GridViewTextBoxColumn();
// col.IsVisible = false;
col.ReadOnly = true;
col.HeaderText = "Ref #";
col.Name = "RefNumber";
grdLister.Columns.Add(col);
col = new GridViewTextBoxColumn();
// col.IsVisible = false;
col.HeaderText = "Vehicle";
col.Name = "Vehicle";
col.ReadOnly = true;
grdLister.Columns.Add(col);
col = new GridViewTextBoxColumn();
// col.IsVisible = false;
col.ReadOnly = true;
col.Name = "Account";
col.HeaderText = "Account";
grdLister.Columns.Add(col);
col = new GridViewTextBoxColumn();
// col.IsVisible = false;
col.ReadOnly = true;
col.HeaderText = "Pickup Point";
col.Name = "PickupPoint";
grdLister.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.ReadOnly = true;
col.HeaderText = "Via";
col.Name = "Via";
grdLister.Columns.Add(col);
col = new GridViewTextBoxColumn();
// col.IsVisible = false;
col.ReadOnly = true;
col.HeaderText = "Destination";
col.Name = "Destination";
grdLister.Columns.Add(col);
GridViewDecimalColumn colD = new GridViewDecimalColumn();
colD.DecimalPlaces = 2;
colD.Minimum = 0;
colD.HeaderText = "Charges";
colD.Name = "Charges";
colD.Maximum = 9999999;
colD.FormatString = "{0:#,###0.00}";
grdLister.Columns.Add(colD);
colD = new GridViewDecimalColumn();
colD.DecimalPlaces = 2;
colD.Minimum = 0;
colD.HeaderText = "Parking";
colD.Name = "Parking";
colD.Maximum = 9999999;
colD.FormatString = "{0:#,###0.00}";
grdLister.Columns.Add(colD);
colD = new GridViewDecimalColumn();
colD.DecimalPlaces = 2;
colD.Minimum = 0;
colD.HeaderText = "Waiting";
colD.Name = "Waiting";
colD.Maximum = 9999999;
colD.FormatString = "{0:#,###0.00}";
grdLister.Columns.Add(colD);
colD = new GridViewDecimalColumn();
colD.DecimalPlaces = 2;
colD.Minimum = 0;
colD.HeaderText = "Extra Drop";
colD.Name = "ExtraDrop";
colD.Maximum = 9999999;
colD.FormatString = "{0:#,###0.00}";
grdLister.Columns.Add(colD);
colD = new GridViewDecimalColumn();
colD.DecimalPlaces = 2;
colD.Minimum = 0;
colD.HeaderText = "M & G";
colD.Name = "MeetAndGreet";
colD.Maximum = 9999999;
colD.IsVisible = false;
colD.FormatString = "{0:#,###0.00}";
grdLister.Columns.Add(colD);
colD = new GridViewDecimalColumn();
colD.DecimalPlaces = 2;
colD.Minimum = 0;
colD.HeaderText = "Congtion Charge";
colD.Name = "CongtionCharge";
colD.Maximum = 9999999;
colD.IsVisible = false;
colD.FormatString = "{0:#,###0.00}";
grdLister.Columns.Add(colD);
colD = new GridViewDecimalColumn();
colD.DecimalPlaces = 2;
colD.Minimum = 0;
colD.ReadOnly = true;
colD.HeaderText = "Total";
colD.Name = "Total";
colD.Maximum = 9999999;
colD.FormatString = "{0:#,###0.00}";
colD.Expression = "Charges+MeetAndGreet+CongtionCharge+ExtraDrop";
grdLister.Columns.Add(colD);
colD = new GridViewDecimalColumn();
colD.DecimalPlaces = 2;
colD.Minimum = 0;
colD.ReadOnly = true;
colD.HeaderText = "Amount";
colD.Name = "Amount";
colD.Maximum = 9999999;
colD.FormatString = "{0:#,###0.00}";
grdLister.Columns.Add(colD);
// grdLister.Columns["Id"].IsVisible = false;
(grdLister.Columns["PickUpDate"] as GridViewDateTimeColumn).CustomFormat = "dd/MM/yyyy HH:mm";
(grdLister.Columns["PickUpDate"] as GridViewDateTimeColumn).FormatString = "{0:dd/MM/yyyy HH:mm}";
grdLister.Columns["PickUpDate"].Width = 90;
grdLister.Columns["RefNumber"].Width = 40;
grdLister.Columns["Vehicle"].Width = 45;
grdLister.Columns["Account"].Width = 60;
grdLister.Columns["PickUpPoint"].Width = 85;
grdLister.Columns["Via"].Width = 40;
grdLister.Columns["Destination"].Width = 85;
grdLister.Columns["Charges"].Width = 45;
grdLister.Columns["Parking"].Width = 45;
grdLister.Columns["Waiting"].Width = 50;
grdLister.Columns["ExtraDrop"].Width = 55;
grdLister.Columns["MeetAndGreet"].Width = 40;
grdLister.Columns["CongtionCharge"].Width = 85;
grdLister.Columns["Total"].Width = 40;
grdLister.Columns["Amount"].Width = 50;
grdLister.Columns["PickUpDate"].HeaderText = "Pickup Date-Time";
grdLister.Columns["RefNumber"].HeaderText = "Ref #";
grdLister.Columns["PickUpPoint"].HeaderText = "Pickup Point";
grdLister.Columns["ExtraDrop"].HeaderText = "Extra Drop";
grdLister.Columns["MeetAndGreet"].HeaderText = "M & G";
grdLister.Columns["CongtionCharge"].HeaderText = "Congtion Charge";
AddUpdateColumn(grdLister);
grdLister.AllowEditRow = true;
}
void frmIncomeReport_Load(object sender, EventArgs e)
{
// ViewReport();
TimeSpan tillTime = TimeSpan.Zero;
TimeSpan.TryParse("23:59:59", out tillTime);
dtpTillDate.Value = (new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.LastDayOfMonthValue()).Date);
dtptilltime.Value = dtpTillDate.Value.Value.Date + tillTime;
ComboFunctions.FillDriverNoCombo(ddlDriver);
ComboFunctions.FillSubCompanyCombo(ddlSubCompany);
dtpFromDate.Value = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1);
dtpTillDate.Value = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.LastDayOfMonthValue());
GridViewTextBoxColumn col = new GridViewTextBoxColumn();
col.IsVisible = false;
col.Name = "Id";
grdLister.Columns.Add(col);
GridViewDateTimeColumn colDt = new GridViewDateTimeColumn();
colDt.Name = "PickupDate";
colDt.ReadOnly = true;
colDt.HeaderText = "Pickup Date-Time";
grdLister.Columns.Add(colDt);
col = new GridViewTextBoxColumn();
// col.IsVisible = false;
col.ReadOnly = true;
col.HeaderText = "Ref #";
col.Name = "RefNumber";
grdLister.Columns.Add(col);
col = new GridViewTextBoxColumn();
// col.IsVisible = false;
col.HeaderText = "Vehicle";
col.Name = "Vehicle";
col.ReadOnly = true;
grdLister.Columns.Add(col);
col = new GridViewTextBoxColumn();
// col.IsVisible = false;
col.ReadOnly = true;
col.Name = "Account";
col.HeaderText = "Account";
grdLister.Columns.Add(col);
col = new GridViewTextBoxColumn();
// col.IsVisible = false;
col.ReadOnly = true;
col.HeaderText = "Pickup Point";
col.Name = "PickupPoint";
grdLister.Columns.Add(col);
//Via
col = new GridViewTextBoxColumn();
// col.IsVisible = false;
col.ReadOnly = true;
col.HeaderText = "Via";
col.Name = "Via";
grdLister.Columns.Add(col);
col = new GridViewTextBoxColumn();
// col.IsVisible = false;
col.ReadOnly = true;
col.HeaderText = "Destination";
col.Name = "Destination";
grdLister.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.IsVisible = false;
col.HeaderText = "Comm";
col.Name = COLS.Comm;
grdLister.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.IsVisible = false;
col.HeaderText = COLS.DriverId;
col.Name = COLS.DriverId;
grdLister.Columns.Add(col);
col = new GridViewTextBoxColumn();
// col.IsVisible = false;
col.ReadOnly = true;
col.HeaderText = COLS.Driver;
col.Name = COLS.Driver;
grdLister.Columns.Add(col);
GridViewDecimalColumn colD = new GridViewDecimalColumn();
colD.DecimalPlaces = 2;
colD.Minimum = 0;
colD.ReadOnly = true;
colD.HeaderText = "Charges";
colD.Name = "Charges";
colD.Maximum = 9999999;
colD.FormatString = "{0:#,###0.00}";
grdLister.Columns.Add(colD);
colD = new GridViewDecimalColumn();
colD.DecimalPlaces = 2;
colD.Minimum = 0;
colD.ReadOnly = true;
colD.HeaderText = "Parking";
colD.Name = "Parking";
colD.Maximum = 9999999;
colD.FormatString = "{0:#,###0.00}";
grdLister.Columns.Add(colD);
colD = new GridViewDecimalColumn();
colD.DecimalPlaces = 2;
colD.Minimum = 0;
colD.ReadOnly = true;
colD.HeaderText = "Waiting";
colD.Name = "Waiting";
colD.Maximum = 9999999;
colD.FormatString = "{0:#,###0.00}";
grdLister.Columns.Add(colD);
colD = new GridViewDecimalColumn();
colD.DecimalPlaces = 2;
colD.Minimum = 0;
colD.ReadOnly = true;
colD.HeaderText = "Extra Drop";
colD.Name = "ExtraDrop";
colD.Maximum = 9999999;
colD.FormatString = "{0:#,###0.00}";
grdLister.Columns.Add(colD);
//colD = new GridViewDecimalColumn();
//colD.DecimalPlaces = 2;
//colD.Minimum = 0;
//colD.HeaderText = "M & G";
//colD.ReadOnly = true;
//colD.Name = "MeetAndGreet";
//colD.Maximum = 9999999;
//colD.FormatString = "{0:#,###0.00}";
//grdLister.Columns.Add(colD);
//colD = new GridViewDecimalColumn();
//colD.DecimalPlaces = 2;
//colD.Minimum = 0;
//colD.ReadOnly = true;
//colD.HeaderText = "Congestion";
//colD.Name = "CongtionCharge";
//colD.Maximum = 9999999;
//colD.FormatString = "{0:#,###0.00}";
//grdLister.Columns.Add(colD);
colD = new GridViewDecimalColumn();
colD.DecimalPlaces = 2;
colD.Minimum = 0;
colD.ReadOnly = true;
colD.ReadOnly = true;
colD.HeaderText = "Total";
colD.Name = "Total";
colD.Maximum = 9999999;
colD.FormatString = "{0:#,###0.00}";
colD.Expression = "Charges+Parking+Waiting+ExtraDrop";
//colD.Expression = "Charges+Parking+Waiting+ExtraDrop+MeetAndGreet+CongtionCharge";
grdLister.Columns.Add(colD);
// grdLister.Columns["Id"].IsVisible = false;
(grdLister.Columns["PickUpDate"] as GridViewDateTimeColumn).CustomFormat = "dd/MM/yyyy HH:mm";
(grdLister.Columns["PickUpDate"] as GridViewDateTimeColumn).FormatString = "{0:dd/MM/yyyy HH:mm}";
grdLister.Columns["PickUpDate"].Width = 90;
grdLister.Columns["RefNumber"].Width = 40;
grdLister.Columns["Vehicle"].Width = 50;
grdLister.Columns["Account"].Width = 60;
grdLister.Columns["PickUpPoint"].Width = 110;
grdLister.Columns["Destination"].Width = 110;
grdLister.Columns[COLS.Driver].Width = 40;
grdLister.Columns["Charges"].Width = 45;
grdLister.Columns["Parking"].Width = 45;
grdLister.Columns["Waiting"].Width = 50;
grdLister.Columns["ExtraDrop"].Width = 60;
//grdLister.Columns["MeetAndGreet"].Width = 60;
//grdLister.Columns["CongtionCharge"].Width = 70;
grdLister.Columns["Total"].Width = 40;
grdLister.Columns["Via"].Width = 80;
grdLister.Columns["PickUpDate"].HeaderText = "Pickup Date-Time";
grdLister.Columns["RefNumber"].HeaderText = "Ref #";
grdLister.Columns["PickUpPoint"].HeaderText = "Pickup Point";
grdLister.Columns["ExtraDrop"].HeaderText = "Extra Drop";
}
void frmDriverReport_Load(object sender, EventArgs e)
{
// ViewReport();
ComboFunctions.FillDriverNoCombo(ddl_Driver, c => c.DriverTypeId == 1);
dtpFromDate.Value = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1);
dtpTillDate.Value = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.LastDayOfMonthValue());
GridViewTextBoxColumn col = new GridViewTextBoxColumn();
col.Width = 60;
col.ReadOnly = true;
col.HeaderText = "Drv";
col.Name = COLS.DrvNo;
grdLister.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.Width = 100;
col.ReadOnly = true;
col.HeaderText = "Acc 1";
col.Name = COLS.AccountCode;
grdLister.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.Width = 100;
col.ReadOnly = true;
col.HeaderText = "Acc 2";
col.Name = COLS.AccountCode2;
grdLister.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.Width = 100;
col.ReadOnly = true;
col.HeaderText = "Acc 3";
col.Name = COLS.AccountCode3;
grdLister.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.Width = 100;
col.ReadOnly = true;
col.HeaderText = "Acc 4";
col.Name = COLS.AccountCode4;
grdLister.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.Width = 100;
col.ReadOnly = true;
col.HeaderText = "Acc 5";
col.Name = COLS.AccountCode5;
grdLister.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.Width = 100;
col.ReadOnly = true;
col.HeaderText = "Acc 6";
col.Name = COLS.AccountCode6;
grdLister.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.Width = 100;
col.ReadOnly = true;
col.HeaderText = "Acc 7";
col.Name = COLS.AccountCode7;
grdLister.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.Width = 100;
col.ReadOnly = true;
col.HeaderText = "Acc 8";
col.Name = COLS.AccountCode8;
grdLister.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.Width = 100;
col.ReadOnly = true;
col.HeaderText = "Acc 9";
col.Name = COLS.AccountCode9;
grdLister.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.Width = 100;
col.ReadOnly = true;
col.HeaderText = "Acc 10";
col.Name = COLS.AccountCode10;
grdLister.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.IsVisible = false;
// col.Width = 200;
col.ReadOnly = true;
col.Name = COLS.Account;
col.HeaderText = "Account";
grdLister.Columns.Add(col);
GridViewDecimalColumn colD = new GridViewDecimalColumn();
colD.IsVisible = false;
colD.Width = 110;
colD.DecimalPlaces = 0;
colD.Minimum = 0;
colD.HeaderText = "Total Jobs";
colD.Name = COLS.TotalJobs;
colD.Maximum = 9999999;
grdLister.Columns.Add(colD);
colD = new GridViewDecimalColumn();
colD.Width = 90;
colD.DecimalPlaces = 2;
colD.Minimum = 0;
colD.HeaderText = "Amount";
colD.Name = COLS.Amount;
colD.Maximum = 9999999;
colD.FormatString = "{0:#,###0.00}";
grdLister.Columns.Add(colD);
colD = new GridViewDecimalColumn();
colD.Width = 90;
colD.DecimalPlaces = 2;
colD.Minimum = 0;
colD.HeaderText = "Balance";
colD.Name = COLS.Balance;
colD.Maximum = 9999999;
colD.FormatString = "{0:#,###0.00}";
grdLister.Columns.Add(colD);
}
private void LoadDate()
{
dtpFromDate.Value = DateTime.Now.ToDate();
dtpTillDate.Value = DateTime.Now.ToDate();
ComboFunctions.FillDriverNoCombo(ddl_Driver);
}