private void BindGrid()
{
//in this column we are going to store our RadDropDownButton
//which comes from our CustomCell
GridViewTextBoxColumn editButtonColumn = new GridViewTextBoxColumn("Edit");
editButtonColumn.FieldName = "Edit";
editButtonColumn.ReadOnly = true;
editButtonColumn.HeaderText = "Edit";
editButtonColumn.Width = 200;
radGridView1.MasterTemplate.Columns.Add(editButtonColumn);
GridViewTextBoxColumn textBoxColumn = new GridViewTextBoxColumn("TextBoxColumn");
textBoxColumn.FieldName = "TextBoxColumn";
textBoxColumn.HeaderText = "TextBoxColumn";
textBoxColumn.Width = 200;
radGridView1.MasterTemplate.Columns.Add(textBoxColumn);
GridViewDateTimeColumn dateTimeColumn = new GridViewDateTimeColumn("DateTimeColumn");
dateTimeColumn.FieldName = "DateTimeColumn";
dateTimeColumn.HeaderText = "DateTimeColumn";
dateTimeColumn.Width = 200;
radGridView1.MasterTemplate.Columns.Add(dateTimeColumn);
for (int i = 0; i < 10; i++)
{
radGridView1.Rows.Add(null, "Some Text " + i, DateTime.Now.AddHours(i));
}
}
private GridViewDataColumn AppendNewColumn(string columnType, bool numberInTheHeader)
{
GridViewDataColumn newColumn = null;
switch (columnType)
{
case "NumericText":
newColumn = new GridViewMaskBoxColumn();
((GridViewMaskBoxColumn)newColumn).Mask = "f";
newColumn.Name = "NumericText";
newColumn.EnableExpressionEditor = true;
break;
case "Decimal":
newColumn = new GridViewDecimalColumn();
newColumn.Name = "Decimal";
newColumn.DataType = typeof(Decimal);
break;
case "DateTime":
newColumn = new GridViewDateTimeColumn();
newColumn.Name = "DateTime";
newColumn.DataType = typeof(DateTime);
break;
case "CheckBox":
newColumn = new GridViewCheckBoxColumn();
newColumn.Name = "CheckBox";
newColumn.EnableExpressionEditor = true;
break;
case "CustomExpression":
newColumn = new GridViewDecimalColumn();
newColumn.EnableExpressionEditor = true;
newColumn.Name = "CustomExpression";
newColumn.HeaderText = "Custom Expression";
newColumn.Width = 80;
break;
}
if (numberInTheHeader)
{
newColumn.HeaderText = (this.columnNum++).ToString() + " - " + columnType;
}
else
{
newColumn.HeaderText = columnType;
}
this.radGridView1.Columns.Add(newColumn);
return(newColumn);
}
private void FormatJobsGrid()
{
grdGroupDetails.ShowGroupPanel = false;
GridViewTextBoxColumn col = new GridViewTextBoxColumn();
col.IsVisible = false;
col.Name = "Id";
grdJobDetails.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.HeaderText = "Passenger";
col.Name = "Passenger";
col.Width = 100;
grdJobDetails.Columns.Add(col);
GridViewDateTimeColumn colD = new GridViewDateTimeColumn();
colD.HeaderText = "Pickup Date Time";
colD.Name = "PickupDateTime";
colD.Width = 130;
grdJobDetails.Columns.Add(colD);
col = new GridViewTextBoxColumn();
col.HeaderText = "Pickup Point";
col.Name = "PickupPoint";
col.Width = 400;
grdJobDetails.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.HeaderText = "No of Pax.";
col.Name = "NoOfPax";
col.Width = 100;
grdJobDetails.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.HeaderText = "Drv";
col.Width = 70;
col.Name = "Drv";
grdJobDetails.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.HeaderText = "Status";
col.Width = 100;
col.Name = "Status";
grdJobDetails.Columns.Add(col);
}
private void ClickSOCTime(object sender, EventArgs e)
{
var commandServer = new CommandServer();
try
{
if (radGridViewSoc.CurrentRow.Cells[0].Value != null)
{
_bindingSource_soc = new BindingSource {
DataSource = commandServer.DataGridSet(@"select key_job_soc_rabotnik, date_start, date_end
from job_soc_rabotnik left join socRabotnik on job_soc_rabotnik.fk_soc_rabotnik = socRabotnik.key_socRabotnik
where fk_soc_rabotnik = " + radGridViewSoc.CurrentRow.Cells[0].Value).Tables[0]
};
radGridViewSocTime.DataSource = _bindingSource_soc;
GridViewDateTimeColumn dateS = new GridViewDateTimeColumn("Дата начала");
radGridViewSocTime.Columns[1] = dateS;
dateS.Name = "date_s";
dateS.FieldName = "date_start";
dateS.FormatString = "{0:dd/MM/yyyy}";
dateS.Format = DateTimePickerFormat.Custom;
dateS.CustomFormat = "dd.MM.yyyy";
GridViewDateTimeColumn dateE = new GridViewDateTimeColumn("Дата конца");
radGridViewSocTime.Columns[2] = dateE;
dateE.Name = "date_e";
dateE.FieldName = "date_end";
dateE.FormatString = "{0:dd/MM/yyyy}";
dateE.Format = DateTimePickerFormat.Custom;
dateE.CustomFormat = "dd.MM.yyyy";
radGridViewSocTime.Columns[0].IsVisible = false;
radGridViewSocTime.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill;
radGridViewSocTime.Columns[1].BestFit();
radGridViewSocTime.Columns[2].BestFit();
if (radGridViewSocTime.Columns.Count > 0)
{
UpdateLoadJobTime();
}
else
{
richTextBox1.Text = "";
}
}
}
catch (Exception ex)
{
CommandClient commandClient = new CommandClient();
commandClient.WriteFileError(ex, null);
}
}
private void radGridView5_Click(object sender, EventArgs e)
{
try
{
if (radGridView5.CurrentRow.Cells[0].Value != null)
{
_bindingSource_personel_time = new BindingSource {
DataSource = new CommandServer().DataGridSet(@"select key_job_spezialist, date_start, date_end
from job_spezialist left join speziolist on job_spezialist.fk_spezialist = speziolist.key_speziolist
where fk_spezialist = " + radGridView5.CurrentRow.Cells[0].Value).Tables[0]
};
radGridView6.DataSource = _bindingSource_personel_time;
GridViewDateTimeColumn dateS = new GridViewDateTimeColumn("Дата начала");
radGridView6.Columns[1] = dateS;
dateS.Name = "date_s";
dateS.FieldName = "date_start";
dateS.FormatString = "{0:dd/MM/yyyy}";
dateS.Format = DateTimePickerFormat.Custom;
dateS.CustomFormat = "dd.MM.yyyy";
GridViewDateTimeColumn dateE = new GridViewDateTimeColumn("Дата конца");
radGridView6.Columns[2] = dateE;
dateE.Name = "date_e";
dateE.FieldName = "date_end";
dateE.FormatString = "{0:dd/MM/yyyy}";
dateE.Format = DateTimePickerFormat.Custom;
dateE.CustomFormat = "d.M.y";
radGridView6.Columns[0].IsVisible = false;
radGridView6.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill;
radGridView6.Columns[1].BestFit();
radGridView6.Columns[2].BestFit();
if (radGridView6.RowCount > 0)
{
UpdateLoadJobTime();
}
else
{
richTextBox1.Text = "";
}
}
}
catch (Exception ex)
{
CommandClient commandClient = new CommandClient();
commandClient.WriteFileError(ex, null);
}
}
private void Grid()
{
var commandServer = new CommandServer();
_bindingSource = new BindingSource {
DataSource = commandServer.DataGridSet(@"select * from Disability_get_table(" + _key + ") order by [Дата инв.]").Tables[0]
};
radGridView1.Refresh();
radGridView1.AutoSizeRows = true;
radGridView1.DataSource = _bindingSource;
radGridView1.Columns[0].IsVisible = false;
GridViewComboBoxColumn comboColumn_powered = new GridViewComboBoxColumn("Степ. утр.");
comboColumn_powered.DataSource = new String[] { "1", "2", "3", "4" };
comboColumn_powered.Name = "_powered";
radGridView1.Columns[1] = comboColumn_powered;
comboColumn_powered.FieldName = "powered";
GridViewDateTimeColumn dat = new GridViewDateTimeColumn("Дата инв.");
dat.Name = "date1";
dat.FormatString = "{0:dd/MM/yyyy}";
dat.Format = DateTimePickerFormat.Custom;
radGridView1.Columns[2] = dat;
dat.CustomFormat = "dd.MM.yyyy";
GridViewDateTimeColumn dat1 = new GridViewDateTimeColumn("Дата переосв.");
dat1.Name = "date2";
dat1.FormatString = "{0:dd/MM/yyyy}";
dat1.Format = DateTimePickerFormat.Custom;
radGridView1.Columns[3] = dat1;
dat1.CustomFormat = "dd.MM.yyyy";
GridViewComboBoxColumn comboColumn_every = new GridViewComboBoxColumn("Диагноз");
comboColumn_every.DataSource = _binding_every;
comboColumn_every.Name = "_every";
radGridView1.Columns[4] = comboColumn_every;
comboColumn_every.FieldName = "name";
radGridView1.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill;
}
private void radGridView2_Click(object sender, EventArgs e)
{
try
{
if (radGridView2.CurrentRow.Cells[0].Value != null)
{
_bindingSource_off_time = new BindingSource {
DataSource = new CommandServer().DataGridSet(@"select key_job_spezialist, date_start, date_end
from job_spezialist left join speziolist on job_spezialist.fk_spezialist = speziolist.key_speziolist
where fk_spezialist = " + radGridView2.CurrentRow.Cells[0].Value).Tables[0]
};
radGridView4.DataSource = _bindingSource_off_time;
GridViewDateTimeColumn dateS_off = new GridViewDateTimeColumn("Дата начала");
radGridView4.Columns[1] = dateS_off;
dateS_off.Name = "date_s_off";
dateS_off.FieldName = "date_start";
dateS_off.FormatString = "{0:dd/MM/yyyy}";
dateS_off.Format = DateTimePickerFormat.Custom;
dateS_off.CustomFormat = "dd.MM.yyyy";
GridViewDateTimeColumn dateE_off = new GridViewDateTimeColumn("Дата конца");
radGridView4.Columns[2] = dateE_off;
dateE_off.Name = "date_e_off";
dateE_off.FieldName = "date_end";
dateE_off.FormatString = "{0:dd/MM/yyyy}";
dateE_off.Format = DateTimePickerFormat.Custom;
dateE_off.CustomFormat = "dd.MM.yyyy";
radGridView4.Columns[0].IsVisible = false;
radGridView4.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill;
radGridView4.Columns[1].BestFit();
radGridView4.Columns[2].BestFit();
}
}
catch (Exception ex)
{
CommandClient commandClient = new CommandClient();
commandClient.WriteFileError(ex, null);
}
}
private void Form1_Load(object sender, EventArgs e)
{
this.radGridView1.TableElement.RowHeight = 50;
this.radGridView1.AllowAddNewRow = false;
this.radGridView1.AllowRowReorder = true;
this.radGridView1.ReadOnly = true;
this.radGridView1.Rows.CollectionChanged += new NotifyCollectionChangedEventHandler(Rows_CollectionChanged);
GridViewImageColumn imageColumn = new GridViewImageColumn("Image", "Image");
imageColumn.Width = 50;
imageColumn.HeaderText = String.Empty;
GridViewDecimalColumn priorityColumn = new GridViewDecimalColumn(typeof(int), "Priority", "Priority");
priorityColumn.HeaderText = "#";
priorityColumn.Width = 50;
priorityColumn.ReadOnly = true;
GridViewTextBoxColumn taskColumn = new GridViewTextBoxColumn("Task", "Task");
taskColumn.Width = 180;
GridViewDateTimeColumn dueDateColumn = new GridViewDateTimeColumn("DueDate", "Due Date");
dueDateColumn.Width = 120;
this.radGridView1.Columns.Add(priorityColumn);
this.radGridView1.Columns.Add(imageColumn);
this.radGridView1.Columns.Add(taskColumn);
this.radGridView1.Columns.Add(dueDateColumn);
this.BindGrid();
this.btnMoveUp.DisplayStyle = Telerik.WinControls.DisplayStyle.ImageAndText;
this.btnMoveUp.TextImageRelation = TextImageRelation.ImageBeforeText;
this.btnMoveDown.DisplayStyle = Telerik.WinControls.DisplayStyle.ImageAndText;
this.btnMoveDown.TextImageRelation = TextImageRelation.ImageBeforeText;
}
public Form1()
{
InitializeComponent();
GridViewDecimalColumn decimalColumn = new GridViewDecimalColumn("Id");
radGridView1.MasterTemplate.Columns.Add(decimalColumn);
GridViewTextBoxColumn textBoxColumn = new GridViewTextBoxColumn("Name");
radGridView1.MasterTemplate.Columns.Add(textBoxColumn);
GridViewDateTimeColumn dateTimeColumn = new GridViewDateTimeColumn("CreatedOn");
radGridView1.MasterTemplate.Columns.Add(dateTimeColumn);
GridViewComboBoxColumn comboColumn = new GridViewComboBoxColumn("Country");
comboColumn.DisplayMember = "Name";
comboColumn.ValueMember = "ID";
comboColumn.DataSource = new List <Country>
{
new Country {
ID = 1, Name = "UK"
},
new Country {
ID = 2, Name = "USA"
}
};
radGridView1.MasterTemplate.Columns.Add(comboColumn);
radGridView1.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill;
for (int i = 0; i < 10; i++)
{
radGridView1.Rows.Add(i, "Name" + i, DateTime.Now.AddDays(i), i % 2 + 1);
}
}
private void SetupMasterForUnbound()
{
this.radGridView1.TableElement.RowHeight = 60;
GridViewImageColumn column = new GridViewImageColumn("Photo");
column.ImageLayout = ImageLayout.Zoom;
column.HeaderText = "Photo";
this.radGridView1.MasterTemplate.Columns.Add(column);
GridViewTextBoxColumn textColumn1 = new GridViewTextBoxColumn("Name");
textColumn1.Width = 150;
textColumn1.HeaderText = "Name";
this.radGridView1.MasterTemplate.Columns.Add(textColumn1);
GridViewDecimalColumn decimalColumn = new GridViewDecimalColumn("Salary");
decimalColumn.HeaderText = "Salary";
decimalColumn.FormatString = "${0:#,###}";
this.radGridView1.MasterTemplate.Columns.Add(decimalColumn);
GridViewDateTimeColumn dateTimeColumn = new GridViewDateTimeColumn("Hire Date");
dateTimeColumn.Width = 100;
dateTimeColumn.TextAlignment = ContentAlignment.MiddleRight;
dateTimeColumn.HeaderText = "Hire Date";
this.radGridView1.MasterTemplate.Columns.Add(dateTimeColumn);
GridViewTextBoxColumn textColumn2 = new GridViewTextBoxColumn("Title");
textColumn2.Width = 150;
textColumn2.HeaderText = "Title";
this.radGridView1.MasterTemplate.Columns.Add(textColumn2);
this.radGridView1.MasterTemplate.Columns.Add(new GridViewCheckBoxColumn("Active"));
}
private void FormatGrid()
{
GridViewTextBoxColumn col = new GridViewTextBoxColumn();
col.HeaderText = "ID";
col.IsVisible = false;
col.Name = "ID";
grdLister.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.HeaderText = "Ref #";
col.Name = "REFNO";
col.IsVisible = false;
col.WrapText = true;
col.ReadOnly = true;
grdLister.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.HeaderText = "Passenger";
col.Name = "PASSENGER";
col.Width = 100;
col.WrapText = true;
col.ReadOnly = true;
grdLister.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.HeaderText = "Contact";
col.Name = "CONTACTNO";
col.Width = 150;
col.ReadOnly = true;
col.WrapText = true;
grdLister.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.IsVisible = false;
col.Name = "EMAIL";
grdLister.Columns.Add(col);
//col = new GridViewTextBoxColumn();
//col.IsVisible = false;
//col.Name = "STATUS";
//grdLister.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.IsVisible = false;
col.Name = "BOOKINGTYPEID";
grdLister.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.IsVisible = false;
col.Name = "JOURNEYTYPEID";
grdLister.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.IsVisible = false;
col.Name = "DEFAULTCLIENTID";
grdLister.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.HeaderText = "Vehicle";
col.Name = "VEHICLE";
col.Width = 70;
col.ReadOnly = true;
col.WrapText = true;
grdLister.Columns.Add(col);
GridViewDateTimeColumn colD = new GridViewDateTimeColumn();
colD.HeaderText = "Pickup Time";
colD.Name = "PICKUPDATETIME";
colD.CustomFormat = "dd/MM/yyyy HH:mm";
colD.FormatString = "{0:dd/MM/yyyy HH:mm}";
colD.ReadOnly = false;
colD.Width = 130;
colD.WrapText = true;
grdLister.Columns.Add(colD);
colD = new GridViewDateTimeColumn();
colD.Name = "OLDPICKUPDATETIME";
colD.CustomFormat = "dd/MM/yyyy HH:mm";
colD.FormatString = "{0:dd/MM/yyyy HH:mm}";
colD.IsVisible = false;
grdLister.Columns.Add(colD);
col = new GridViewTextBoxColumn();
col.HeaderText = "Flight No";
col.Name = "FlightNo";
col.Width = 80;
col.ReadOnly = true;
col.IsVisible = false;
col.WrapText = true;
grdLister.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.HeaderText = "Pickup";
col.Name = "FROMADDRESS";
col.ReadOnly = true;
col.Width = 220;
col.WrapText = true;
grdLister.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.HeaderText = "Via";
col.Name = "VIA";
col.IsVisible = false;
col.Width = 150;
col.WrapText = true;
grdLister.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.HeaderText = "Destination";
col.Name = "TOADDRESS";
col.ReadOnly = true;
col.WrapText = true;
col.Width = 220;
grdLister.Columns.Add(col);
GridViewDecimalColumn colDec = new GridViewDecimalColumn();
colDec.HeaderText = "Fares";
colDec.Name = "FARES";
col.ReadOnly = false;
// colDec.IsVisible = true;
colDec.Width = 70;
grdLister.Columns.Add(colDec);
colDec = new GridViewDecimalColumn();
colDec.Name = "OLDFARES";
colDec.IsVisible = false;
grdLister.Columns.Add(colDec);
col = new GridViewTextBoxColumn();
col.HeaderText = "Payment";
col.Name = "PAYMENTTYPE";
col.Width = 60;
col.IsVisible = false;
col.ReadOnly = true;
col.WrapText = true;
grdLister.Columns.Add(col);
colDec = new GridViewDecimalColumn();
colDec.HeaderText = "Waiting Time(Mins)";
colDec.Name = "WaitingTime";
colDec.IsVisible = false;
colDec.Width = 150;
grdLister.Columns.Add(colDec);
//GridViewCommandColumn commandCol = new GridViewCommandColumn();
//commandCol.UseDefaultText = true;
//commandCol.DefaultText = "Accept";
//commandCol.Name = "ACCEPT";
//commandCol.HeaderText = "";
//commandCol.Width=60;
//commandCol.TextAlignment = ContentAlignment.MiddleCenter;
//grdLister.Columns.Add(commandCol);
//commandCol = new GridViewCommandColumn();
//commandCol.UseDefaultText = true;
//commandCol.DefaultText = "Decline";
//commandCol.Name = "DECLINE";
//commandCol.HeaderText = "";
//commandCol.Width=60;
//commandCol.TextAlignment = ContentAlignment.MiddleCenter;
//grdLister.Columns.Add(commandCol);
//grdLister.CommandCellClick += new CommandCellClickEventHandler(grdLister_CommandCellClick);
grdLister.ShowRowHeaderColumn = false;
grdLister.ShowGroupPanel = false;
grdLister.AllowAddNewRow = false;
grdLister.TableElement.RowHeight = 70;
// grdLister.AllowEditRow = false;
grdLister.AllowDeleteRow = false;
}
private void FormatGrid()
{
grdLister.ShowRowHeaderColumn = false;
grdLister.ShowGroupPanel = false;
GridViewTextBoxColumn col = new GridViewTextBoxColumn();
col.IsVisible = false;
col.Name = "Id";
grdLister.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.HeaderText = "Group No";
col.Name = "GroupName";
col.Width = 100;
grdLister.Columns.Add(col);
GridViewDateTimeColumn colD = new GridViewDateTimeColumn();
colD.IsVisible = this.DestinationLocTypeId == Enums.LOCATION_TYPES.AIRPORT;
colD.CustomFormat = "dd/MM/yyyy HH:mm";
colD.FormatString = "{0:dd/MM/yyyy HH:mm}";
colD.HeaderText = "Departure Date Time";
colD.Name = "FlightDeparture";
colD.Width = 150;
grdLister.Columns.Add(colD);
col = new GridViewTextBoxColumn();
col.HeaderText = "Zone";
col.Name = "Zone";
col.Width = 90;
grdLister.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.HeaderText = "Destination";
col.Name = "Destination";
col.Width = colD.IsVisible? 160:260;
grdLister.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.HeaderText = "Drv";
col.Name = "Drv";
col.Width = 80;
grdLister.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.IsVisible = false;
col.Name = "DestinationId";
grdLister.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.HeaderText = "No of Seats";
col.Name = "TotalSeats";
col.Width = 80;
grdLister.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.HeaderText = "Available Seats";
col.Name = "AvailSeats";
col.Width = 95;
grdLister.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.HeaderText = "Total Jobs";
col.Name = "TotalJobs";
col.Width = 80;
grdLister.Columns.Add(col);
}
private void FormateShiftGride()
{
grdShifts.AllowAutoSizeColumns = true;
grdShifts.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill;
grdShifts.AllowAddNewRow = false;
grdShifts.ShowGroupPanel = false;
grdShifts.AutoCellFormatting = true;
grdShifts.ShowRowHeaderColumn = false;
//grdDocuments.CommandCellClick += new CommandCellClickEventHandler(grdDocuments_CommandCellClick);
GridViewTextBoxColumn col = new GridViewTextBoxColumn();
col.IsVisible = false;
col.Name = COL_SHIFT.ID;
grdShifts.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.IsVisible = false;
col.Name = COL_SHIFT.MASTERID;
grdShifts.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.HeaderText = "Shifts ID";
col.IsVisible = false;
col.Name = COL_SHIFT.SHIFT_ID;
grdShifts.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.HeaderText = "Shifts";
col.IsVisible = true;
col.Name = COL_SHIFT.SHIFT;
col.Width = 200;
grdShifts.Columns.Add(col);
GridViewDateTimeColumn colDate = new GridViewDateTimeColumn();
colDate.HeaderText = "From Time";
colDate.Name = COL_SHIFT.FROMTIME;
colDate.Format = DateTimePickerFormat.Custom;
//colDate.CustomFormat = "dd/MM/yyyy";
//colDate.FormatString = "{0:dd/MM/yyyy}";
colDate.CustomFormat = "HH:mm";
colDate.FormatString = "{0:HH:mm}";
colDate.Width = 80;
col.ReadOnly = false;
grdShifts.Columns.Add(colDate);
colDate = new GridViewDateTimeColumn();
colDate.HeaderText = "To Time";
colDate.Name = COL_SHIFT.TOTIME;
colDate.Format = DateTimePickerFormat.Custom;
//colDate.CustomFormat = "dd/MM/yyyy";
//colDate.FormatString = "{0:dd/MM/yyyy}";
colDate.CustomFormat = "HH:mm";
colDate.FormatString = "{0:HH:mm}";
colDate.Width = 80;
col.ReadOnly = false;
grdShifts.Columns.Add(colDate);
//UI.GridFunctions.AddDeleteColumn(grdShifts);
grdShifts.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill;
grdShifts.AddDeleteColumn();
grdShifts.Columns["btnDelete"].Width = 70;
UI.GridFunctions.SetFilter(grdShifts);
}
private void FormatGrid()
{
GridViewCheckBoxColumn cbcol = new GridViewCheckBoxColumn();
cbcol.Name = COLS.Check;
cbcol.HeaderText = "Active";
cbcol.ReadOnly = false;
cbcol.IsVisible = false;
cbcol.Width = 80;
grdLister.Columns.Add(cbcol);
GridViewImageColumn CImage = new GridViewImageColumn();
CImage.Name = COLS.Image;
CImage.HeaderText = "Active";
CImage.ReadOnly = true;
CImage.Width = 80;
grdLister.Columns.Add(CImage);
GridViewTextBoxColumn col = new GridViewTextBoxColumn();
col.Name = COLS.Id;
col.IsVisible = false;
grdLister.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.Name = COLS.ShiftName;
col.HeaderText = "Shift Name";
col.Width = 190;
col.ReadOnly = true;
grdLister.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.Name = COLS.ShiftStarts;
col.HeaderText = "Shift Starts";
col.Width = 160;
col.ReadOnly = true;
grdLister.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.Name = COLS.ShiftEnds;
col.HeaderText = "Shift Ends";
col.Width = 160;
col.ReadOnly = true;
grdLister.Columns.Add(col);
GridViewDateTimeColumn dcol = new GridViewDateTimeColumn();
dcol.HeaderText = "From Time";
dcol.IsVisible = false;
dcol.Name = COLS.FromTime;
dcol.CustomFormat = "HH:mm";
dcol.FormatString = "{0:HH:mm}";
dcol.Width = 120;
grdLister.Columns.Add(dcol);
dcol = new GridViewDateTimeColumn();
dcol.HeaderText = "Till Time";
dcol.IsVisible = false;
dcol.Name = COLS.TillTime;
dcol.CustomFormat = "HH:mm";
dcol.FormatString = "{0:HH:mm}";
dcol.Width = 120;
grdLister.Columns.Add(dcol);
GridViewCommandColumn cmdcol = new GridViewCommandColumn();
cmdcol.Width = 80;
cmdcol.Name = "btnEdit";
cmdcol.UseDefaultText = true;
cmdcol.ImageLayout = System.Windows.Forms.ImageLayout.Center;
cmdcol.DefaultText = "Edit";
cmdcol.TextAlignment = System.Drawing.ContentAlignment.MiddleCenter;
grdLister.Columns.Add(cmdcol);
cmdcol = new GridViewCommandColumn();
cmdcol.Width = 80;
cmdcol.Name = "btnDelete";
cmdcol.UseDefaultText = true;
cmdcol.ImageLayout = System.Windows.Forms.ImageLayout.Center;
cmdcol.DefaultText = "Delete";
cmdcol.TextAlignment = System.Drawing.ContentAlignment.MiddleCenter;
grdLister.Columns.Add(cmdcol);
grdLister.CommandCellClick += GrdDriverShift_CommandCellClick;
}
private void FormatGrid()
{
GridViewDateTimeColumn dtcol = new GridViewDateTimeColumn();
dtcol.Name = COLS.Date;
dtcol.HeaderText = COLS.Date;
//dtcol.CustomFormat = "{0:dd/MM/yyyy}";
dtcol.FormatString = "{0:dd/MM/yyyy}";
dtcol.Width = 110;
dtcol.ReadOnly = true;
grdPaymentHistory.Columns.Add(dtcol);
GridViewTextBoxColumn col = new GridViewTextBoxColumn();
col.Name = COLS.Id;
col.IsVisible = false;
grdPaymentHistory.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.Name = COLS.CommissionId;
col.IsVisible = false;
grdPaymentHistory.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.Name = COLS.Type;
col.HeaderText = COLS.Type;
col.Width = 100;
col.ReadOnly = true;
grdPaymentHistory.Columns.Add(col);
GridViewDecimalColumn dcol = new GridViewDecimalColumn();
dcol.Name = COLS.Credit;
dcol.IsVisible = false;
grdPaymentHistory.Columns.Add(dcol);
dcol = new GridViewDecimalColumn();
dcol.Name = COLS.Debit;
dcol.IsVisible = false;
grdPaymentHistory.Columns.Add(dcol);
dcol = new GridViewDecimalColumn();
dcol.Name = COLS.Amount;
dcol.HeaderText = COLS.Amount;
dcol.ReadOnly = true;
dcol.Width = 110;
grdPaymentHistory.Columns.Add(dcol);
col = new GridViewTextBoxColumn();
col.Name = COLS.Description;
col.HeaderText = COLS.Description;
col.Width = 140;
col.ReadOnly = true;
grdPaymentHistory.Columns.Add(col);
dcol = new GridViewDecimalColumn();
dcol.Name = COLS.Balance;
dcol.HeaderText = COLS.Balance;
dcol.Width = 100;
dcol.ReadOnly = true;
grdPaymentHistory.Columns.Add(dcol);
GridViewCommandColumn cmd = new GridViewCommandColumn();
cmd.Width = 100;
cmd.Name = "btnDelete";
cmd.UseDefaultText = true;
cmd.ImageLayout = System.Windows.Forms.ImageLayout.Center;
cmd.DefaultText = "Delete";// caption;
cmd.TextAlignment = System.Drawing.ContentAlignment.MiddleCenter;
grdPaymentHistory.Columns.Add(cmd);
}
private void FormatGrid()
{
GridViewCheckBoxColumn colc = new GridViewCheckBoxColumn();
colc.Width = 40;
colc.AutoSizeMode = BestFitColumnMode.None;
colc.HeaderText = "";
colc.Name = "Check";
grdLister.Columns.Add(colc);
GridViewTextBoxColumn col = new GridViewTextBoxColumn();
col.IsVisible = false;
col.Name = COLS.BookingId;
grdLister.Columns.Add(col);
col = new GridViewTextBoxColumn();
// col.IsVisible = false;
col.ReadOnly = true;
col.HeaderText = "Order No";
col.Name = "OrderNo";
col.Width = 90;
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.HeaderText = "Vehicle";
col.Name = "Vehicle";
grdLister.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.Name = COLS.Passenger;
col.HeaderText = "Passenger";
col.ReadOnly = true;
grdLister.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.Name = COLS.Account;
col.HeaderText = "Account";
col.ReadOnly = true;
grdLister.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.Name = COLS.Drv;
col.HeaderText = COLS.Drv;
col.ReadOnly = true;
grdLister.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.IsVisible = false;
col.Name = COLS.AccountTypeId;
grdLister.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.HeaderText = "Pickup Point";
col.Name = "PickupPoint";
col.ReadOnly = true;
grdLister.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.HeaderText = "Destination";
col.Name = "Destination";
col.ReadOnly = true;
grdLister.Columns.Add(col);
GridViewDecimalColumn colD = new GridViewDecimalColumn();
colD.DecimalPlaces = 2;
colD.Minimum = 0;
colD.HeaderText = "D Fares";
colD.Name = "Fares";
colD.Maximum = 9999999;
colD.ReadOnly = true;
colD.FormatString = "{0:#,###0.00}";
grdLister.Columns.Add(colD);
colD = new GridViewDecimalColumn();
colD.DecimalPlaces = 2;
colD.Minimum = 0;
colD.ReadOnly = true;
colD.HeaderText = "D Parking";
colD.Name = COLS.DParking;
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 = "D Waiting";
colD.Name = COLS.DWaiting;
colD.Maximum = 9999999;
colD.FormatString = "{0:#,###0.00}";
grdLister.Columns.Add(colD);
colD = new GridViewDecimalColumn();
colD.DecimalPlaces = 2;
colD.Minimum = 0;
colD.HeaderText = "C Fares";
colD.ReadOnly = true;
colD.Name = COLS.CompanyPrice;
colD.Maximum = 9999999;
// colD.ReadOnly = true;
colD.FormatString = "{0:#,###0.00}";
grdLister.Columns.Add(colD);
colD = new GridViewDecimalColumn();
colD.DecimalPlaces = 2;
colD.Minimum = 0;
colD.HeaderText = "C Parking";
colD.ReadOnly = true;
colD.Name = COLS.CParking;
colD.Maximum = 9999999;
colD.FormatString = "{0:#,###0.00}";
grdLister.Columns.Add(colD);
colD = new GridViewDecimalColumn();
colD.DecimalPlaces = 2;
colD.Minimum = 0;
colD.HeaderText = "C Waiting";
colD.ReadOnly = true;
colD.Name = COLS.CWaiting;
colD.Maximum = 9999999;
colD.FormatString = "{0:#,###0.00}";
grdLister.Columns.Add(colD);
colD = new GridViewDecimalColumn();
colD.DecimalPlaces = 2;
colD.Minimum = 0;
colD.HeaderText = "Escort Price";
colD.Name = COLS.EscortPrice;
colD.Maximum = 9999999;
colD.IsVisible = false;
// colD.ReadOnly = true;
colD.FormatString = "{0:#,###0.00}";
grdLister.Columns.Add(colD);
colD = new GridViewDecimalColumn();
colD.DecimalPlaces = 2;
colD.Minimum = 0;
colD.ReadOnly = true;
colD.HeaderText = "Commission Amount";
colD.Name = COLS.CommissionAmount;
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 = 100;
grdLister.Columns["Account"].Width = 75;
grdLister.Columns[COLS.Drv].Width = 70;
grdLister.Columns["OrderNo"].Width = 70;
grdLister.Columns["Vehicle"].Width = 60;
grdLister.Columns[COLS.Passenger].Width = 60;
grdLister.Columns["PickUpPoint"].Width = 80;
grdLister.Columns["Destination"].Width = 80;
grdLister.Columns["Fares"].Width = 50;
grdLister.Columns[COLS.DParking].Width = 50;
grdLister.Columns[COLS.DWaiting].Width = 50;
grdLister.Columns["CompanyPrice"].Width = 60;
grdLister.Columns[COLS.CParking].Width = 50;
grdLister.Columns[COLS.CWaiting].Width = 50;
grdLister.Columns["CommissionAmount"].Width = 70;
grdLister.Columns["PickUpDate"].HeaderText = "Pickup Date-Time";
grdLister.Columns[COLS.OrderNo].HeaderText = "Ref #";
grdLister.Columns["PickUpPoint"].HeaderText = "Pickup Point";
AddCommandColumn(grdLister, "UnProcess", "UnProcess Job");
// grdLister.CommandCellClick+=new CommandCellClickEventHandler(grdLister_CommandCellClick);
}
public void FormatGrid()
{
grdDriverRentLastStatement.ShowRowHeaderColumn = false;
GridViewCheckBoxColumn col = new GridViewCheckBoxColumn();
col.Width = 70;
col.AutoSizeMode = BestFitColumnMode.None;
col.HeaderText = "";
col.Name = "Check";
// col.ReadOnly = true;
grdDriverRentLastStatement.Columns.Add(col);
GridViewTextBoxColumn colId = new GridViewTextBoxColumn();
colId.Name = COLS.Id;
colId.IsVisible = false;
grdDriverRentLastStatement.Columns.Add(colId);
colId = new GridViewTextBoxColumn();
colId.Name = COLS.DriverId;
colId.IsVisible = false;
grdDriverRentLastStatement.Columns.Add(colId);
colId = new GridViewTextBoxColumn();
colId.Name = COLS.DriverName;
colId.IsVisible = false;
grdDriverRentLastStatement.Columns.Add(colId);
colId = new GridViewTextBoxColumn();
colId.Width = 120;
colId.HeaderText = "Driver No";
colId.Name = COLS.DriverNo;
colId.ReadOnly = true;
grdDriverRentLastStatement.Columns.Add(colId);
colId = new GridViewTextBoxColumn();
colId.Width = 100;
colId.HeaderText = "Trans No";
colId.Name = COLS.TransNo;
colId.ReadOnly = true;
grdDriverRentLastStatement.Columns.Add(colId);
GridViewDateTimeColumn dtcol = new GridViewDateTimeColumn();
dtcol.Name = COLS.TransDate;
dtcol.HeaderText = "Trans Date";
dtcol.FormatString = "{0:dd/MM/yyyy}";
dtcol.Width = 120;
dtcol.ReadOnly = true;
grdDriverRentLastStatement.Columns.Add(dtcol);
dtcol = new GridViewDateTimeColumn();
dtcol.Name = COLS.FromDate;
dtcol.HeaderText = "From Date";
dtcol.FormatString = "{0:dd/MM/yyyy}";
dtcol.ReadOnly = true;
dtcol.Width = 120;
grdDriverRentLastStatement.Columns.Add(dtcol);
dtcol = new GridViewDateTimeColumn();
dtcol.Name = COLS.ToDate;
dtcol.HeaderText = "To Date";
dtcol.FormatString = "{0:dd/MM/yyyy}";
dtcol.ReadOnly = true;
dtcol.Width = 120;
grdDriverRentLastStatement.Columns.Add(dtcol);
GridViewDecimalColumn dcol = new GridViewDecimalColumn();
dcol.Name = COLS.OldBalance;
dcol.HeaderText = "Old Balance";
dcol.Width = 120;
dcol.ReadOnly = true;
grdDriverRentLastStatement.Columns.Add(dcol);
dcol = new GridViewDecimalColumn();
dcol.Name = COLS.Balance;
dcol.HeaderText = "Balance";
dcol.Width = 110;
dcol.ReadOnly = true;
grdDriverRentLastStatement.Columns.Add(dcol);
dcol = new GridViewDecimalColumn();
dcol.Name = COLS.JobsTotal;
dcol.HeaderText = "Jobs Total";
dcol.Width = 120;
dcol.ReadOnly = true;
grdDriverRentLastStatement.Columns.Add(dcol);
grdDriverRentLastStatement.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill;
}
void rptfrmCustomerAppUsers_Load(object sender, EventArgs e)
{
chkAll.Checked = true;
grdLister.AllowEditRow = true;
GridViewCheckBoxColumn cbcol = new GridViewCheckBoxColumn();
cbcol.Name = "Check";
cbcol.Width = 50;
grdLister.Columns.Add(cbcol);
GridViewTextBoxColumn col = new GridViewTextBoxColumn();
col.IsVisible = false;
col.HeaderText = "Id";
col.Name = "Id";
grdLister.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.IsVisible = true;
col.ReadOnly = true;
col.HeaderText = "First Name";
col.Name = COLS.FirstName;
col.Width = 120;
grdLister.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.IsVisible = true;
col.HeaderText = "Surname";
col.ReadOnly = true;
col.Width = 100;
col.Name = COLS.SurName;
grdLister.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.IsVisible = true;
col.ReadOnly = true;
col.HeaderText = "Driver No";
col.Width = 120;
col.Name = COLS.DriverNo;
grdLister.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.IsVisible = true;
col.ReadOnly = true;
col.HeaderText = "PHC Badge";
col.Name = COLS.PHCBadge;
col.Width = 120;
grdLister.Columns.Add(col);
GridViewDateTimeColumn colDate = new GridViewDateTimeColumn();
colDate.IsVisible = true;
colDate.ReadOnly = false;
colDate.HeaderText = "PHC Exp";
colDate.Width = 120;
colDate.Name = COLS.PHCExp;
grdLister.Columns.Add(colDate);
col = new GridViewTextBoxColumn();
col.IsVisible = true;
col.ReadOnly = false;
col.HeaderText = "Address";
col.Width = 170;
col.Name = COLS.Address;
grdLister.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.IsVisible = true;
col.ReadOnly = false;
col.HeaderText = "Mobile No";
col.Width = 120;
col.Name = COLS.MobileNo;
grdLister.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.IsVisible = true;
col.ReadOnly = false;
col.HeaderText = "Licence No";
col.Width = 100;
col.Name = COLS.LicenceNo;
grdLister.Columns.Add(col);
colDate = new GridViewDateTimeColumn();
colDate.IsVisible = true;
colDate.ReadOnly = false;
colDate.HeaderText = "Licence Exp";
colDate.Width = 120;
colDate.Name = COLS.LicenceExp;
grdLister.Columns.Add(colDate);
col = new GridViewTextBoxColumn();
col.IsVisible = true;
col.ReadOnly = false;
col.HeaderText = "NI No";
col.Width = 80;
col.Name = COLS.NINo;
grdLister.Columns.Add(col);
(grdLister.Columns["LicenceExp"] as GridViewDateTimeColumn).FormatString = "{0:dd/MM/yyyy}";
(grdLister.Columns["LicenceExp"] as GridViewDateTimeColumn).CustomFormat = "dd/MM/yyyy";
(grdLister.Columns["PHCExp"] as GridViewDateTimeColumn).FormatString = "{0:dd/MM/yyyy}";
(grdLister.Columns["PHCExp"] as GridViewDateTimeColumn).CustomFormat = "dd/MM/yyyy";
grdLister.EnableFiltering = true;
grdLister.ShowFilteringRow = true;
ViewReport();
}
private void FormatGroupGrid()
{
grdGroupDetails.ShowRowHeaderColumn = false;
grdGroupDetails.ShowGroupPanel = false;
GridViewTextBoxColumn col = new GridViewTextBoxColumn();
col.IsVisible = false;
col.Name = "Id";
grdGroupDetails.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.HeaderText = "Group No";
col.Name = "GroupName";
col.Width = 100;
grdGroupDetails.Columns.Add(col);
GridViewDateTimeColumn colD = new GridViewDateTimeColumn();
colD.HeaderText = "Departure Date Time";
colD.Name = "FlightDeparture";
colD.Width = 150;
colD.CustomFormat = "dd/MM/yyyy HH:mm";
colD.FormatString = "{0:dd/MM/yyyy HH:mm}";
grdGroupDetails.Columns.Add(colD);
col = new GridViewTextBoxColumn();
col.HeaderText = "Zone";
col.Name = "Zone";
col.Width = 90;
grdGroupDetails.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.HeaderText = "Destination";
col.Name = "Destination";
col.Width = 215;
grdGroupDetails.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.IsVisible = false;
col.Name = "DestinationId";
grdGroupDetails.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.HeaderText = "No of Seats";
col.Name = "TotalSeats";
col.Width = 90;
grdGroupDetails.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.HeaderText = "Available Seats";
col.Name = "AvailSeats";
col.Width = 115;
grdGroupDetails.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.HeaderText = "Total Jobs";
col.Name = "TotalJobs";
col.Width = 80;
grdGroupDetails.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.HeaderText = "Status";
col.Name = "Status";
col.Width = 90;
grdGroupDetails.Columns.Add(col);
}
private GridViewDataColumn AppendNewColumn(string columnType, bool numberInTheHeader)
{
GridViewDataColumn newColumn = null;
switch (columnType)
{
case "Text":
newColumn = new GridViewTextBoxColumn();
newColumn.FieldName = "Text";
break;
case "NumericText":
newColumn = new GridViewMaskBoxColumn();
((GridViewMaskBoxColumn)newColumn).Mask = "f";
newColumn.TextAlignment = ContentAlignment.MiddleLeft;
newColumn.FieldName = "NumericText";
break;
case "Decimal":
newColumn = new GridViewDecimalColumn();
newColumn.TextAlignment = ContentAlignment.MiddleRight;
newColumn.FieldName = "Decimal";
break;
case "DateTime":
newColumn = new GridViewDateTimeColumn();
newColumn.FormatString = "{0:MM-dd-yyyy}";
newColumn.TextAlignment = ContentAlignment.MiddleRight;
newColumn.FieldName = "DateTime";
break;
case "Image":
newColumn = new GridViewImageColumn();
((GridViewImageColumn)newColumn).ImageLayout = ImageLayout.Center;
newColumn.Width = 40;
newColumn.FieldName = "Image";
break;
case "ComboBox":
newColumn = new GridViewComboBoxColumn();
((GridViewComboBoxColumn)newColumn).DataSource = this.comboItems;
newColumn.Width = 100;
newColumn.FieldName = "ComboBox";
break;
case "Command":
newColumn = new GridViewCommandColumn();
((GridViewCommandColumn)newColumn).TextAlignment = ContentAlignment.MiddleCenter;
newColumn.FieldName = "Command";
break;
case "CheckBox":
newColumn = new GridViewCheckBoxColumn();
newColumn.Width = 50;
newColumn.FieldName = "CheckBox";
break;
}
if (numberInTheHeader)
{
newColumn.HeaderText = (this.columnNum++).ToString() + " - " + columnType;
}
else
{
newColumn.HeaderText = columnType;
}
this.radGridView1.Columns.Add(newColumn);
return(newColumn);
}
private void rptfrmJobsList_Load(object sender, EventArgs e)
{
dtpFromDate.Value = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1);
dtpToDate.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);
col = new GridViewTextBoxColumn();
// col.IsVisible = false;
col.ReadOnly = true;
col.HeaderText = "Ref #";
col.Name = COLS.RefNumber;
grdLister.Columns.Add(col);
GridViewDateTimeColumn colDt = new GridViewDateTimeColumn();
colDt.Name = COLS.BookingDate;
colDt.ReadOnly = true;
colDt.HeaderText = "Booking Date";
grdLister.Columns.Add(colDt);
colDt = new GridViewDateTimeColumn();
colDt.Name = COLS.PickupDate;
colDt.ReadOnly = true;
colDt.HeaderText = "Pickup Date-Time";
grdLister.Columns.Add(colDt);
col = new GridViewTextBoxColumn();
// col.IsVisible = false;
col.ReadOnly = true;
col.HeaderText = "Passenger";
col.Name = COLS.Passenger;
grdLister.Columns.Add(col);
col = new GridViewTextBoxColumn();
// col.IsVisible = false;
col.ReadOnly = true;
col.HeaderText = "Pickup Point";
col.Name = COLS.PickupPoint;
grdLister.Columns.Add(col);
col = new GridViewTextBoxColumn();
// col.IsVisible = false;
col.ReadOnly = true;
col.HeaderText = "Destination";
col.Name = COLS.Destination;
grdLister.Columns.Add(col);
GridViewDecimalColumn colD = new GridViewDecimalColumn();
colD.DecimalPlaces = 2;
colD.Minimum = 0;
colD.ReadOnly = true;
colD.HeaderText = COLS.Fare;
colD.Name = COLS.Fare;
colD.Maximum = 9999999;
colD.FormatString = "{0:#,###0.00}";
grdLister.Columns.Add(colD);
col = new GridViewTextBoxColumn();
// col.IsVisible = false;
col.ReadOnly = true;
col.Name = COLS.Account;
col.HeaderText = COLS.Account;
grdLister.Columns.Add(col);
col = new GridViewTextBoxColumn();
// col.IsVisible = false;
col.ReadOnly = true;
col.Name = COLS.Driver;
col.HeaderText = COLS.Driver;
grdLister.Columns.Add(col);
col = new GridViewTextBoxColumn();
// col.IsVisible = false;
col.HeaderText = COLS.Vehicle;
col.Name = COLS.Vehicle;
col.ReadOnly = true;
grdLister.Columns.Add(col);
col = new GridViewTextBoxColumn();
// col.IsVisible = false;
col.HeaderText = COLS.Status;
col.Name = COLS.Status;
col.ReadOnly = true;
grdLister.Columns.Add(col);
col = new GridViewTextBoxColumn();
// col.IsVisible = false;
col.HeaderText = COLS.DespatchBy;
col.Name = COLS.DespatchBy;
col.ReadOnly = true;
grdLister.Columns.Add(col);
grdLister.Columns[COLS.RefNumber].HeaderText = "Ref #";
grdLister.Columns[COLS.Fare].HeaderText = "Fare £";
grdLister.Columns[COLS.PickupPoint].HeaderText = "Pickup Point";
grdLister.Columns[COLS.Destination].HeaderText = "Destination";
grdLister.Columns[COLS.BookingDate].HeaderText = "Booking Date";
(grdLister.Columns[COLS.BookingDate] as GridViewDateTimeColumn).CustomFormat = "dd/MM/yyyy HH:mm";
(grdLister.Columns[COLS.BookingDate] as GridViewDateTimeColumn).FormatString = "{0:dd/MM/yyyy HH:mm}";
(grdLister.Columns[COLS.PickupDate] as GridViewDateTimeColumn).CustomFormat = "dd/MM/yyyy HH:mm";
(grdLister.Columns[COLS.PickupDate] as GridViewDateTimeColumn).FormatString = "{0:dd/MM/yyyy HH:mm}";
grdLister.Columns[COLS.PickupDate].HeaderText = "Pickup Date-Time";
grdLister.Columns[COLS.Account].HeaderText = "A/C";
grdLister.Columns[COLS.DespatchBy].HeaderText = "Despatched By";
}
protected void CargaGrillaVenta()
{
RadGridViewVentaDiaria.DataSource = new DataTable();
RadGridViewVentaDiaria.Columns.Clear();
if (dttVentaDia.Rows.Count > 0)
{
RadGridViewVentaDiaria.EnableFiltering = true;
RadGridViewVentaDiaria.AutoGenerateColumns = false;
RadGridViewVentaDiaria.AllowAddNewRow = false;
RadGridViewVentaDiaria.MasterTemplate.ShowHeaderCellButtons = true;
RadGridViewVentaDiaria.MasterTemplate.ShowFilteringRow = false;
RadGridViewVentaDiaria.TableElement.EndUpdate();
RadGridViewVentaDiaria.AllowDeleteRow = false;
RadGridViewVentaDiaria.AllowRowResize = false;
RadGridViewVentaDiaria.AllowEditRow = true;
RadGridViewVentaDiaria.ShowRowHeaderColumn = false;
RadGridViewVentaDiaria.Select();
RadGridViewVentaDiaria.EnableSorting = true;
List <int> data = dttVentaDia.AsEnumerable().Select(Nombre => Nombre.Field <int>("NumeroVentaDia").ToString().Length).ToList();
int WidthText = data.Max();
var col = from dat in dttVentaDia.AsEnumerable()
where dat.Field <int>("NumeroVentaDia").ToString().Length == WidthText
select dat;
GridViewTextBoxColumn colNumeroVentaDia = new GridViewTextBoxColumn();
colNumeroVentaDia.DataType = typeof(decimal);
colNumeroVentaDia.FieldName = "NumeroVentaDia";
colNumeroVentaDia.FormatString = "{0:G}";
colNumeroVentaDia.HeaderText = "Numero de Venta";
colNumeroVentaDia.MinWidth = Consulta.AnchoTexto(col.First().Field <int>("NumeroVentaDia").ToString(), colNumeroVentaDia.HeaderText, RadGridViewVentas.Font);
colNumeroVentaDia.Name = "colNumeroVentaDia";
colNumeroVentaDia.ReadOnly = true;
RadGridViewVentaDiaria.Columns.Add(colNumeroVentaDia);
data = dttVentaDia.AsEnumerable().Select(Servicio => Servicio.Field <int>("ValorVenta").ToString().Length).ToList();
WidthText = data.Max();
col = from dat in dttVentaDia.AsEnumerable()
where dat.Field <int>("ValorVenta").ToString().Length == WidthText
select dat;
GridViewTextBoxColumn colValorVenta = new GridViewTextBoxColumn();
colValorVenta.DataType = typeof(decimal);
colValorVenta.FieldName = "ValorVenta";
colValorVenta.FormatString = "{0:C}";
colValorVenta.HeaderText = "Valor de Factura";
colValorVenta.MinWidth = Consulta.AnchoTexto(col.First().Field <int>("ValorVenta").ToString(), colValorVenta.HeaderText, RadGridViewVentas.Font);
colValorVenta.Name = "colValorVenta";
colValorVenta.ReadOnly = true;
RadGridViewVentaDiaria.Columns.Add(colValorVenta);
data = dttVentaDia.AsEnumerable().Select(Servicio => Servicio.Field <string>("Fecha").ToString().Length).ToList();
WidthText = data.Max();
col = from dat in dttVentaDia.AsEnumerable()
where dat.Field <string>("Fecha").ToString().Length == WidthText
select dat;
GridViewDateTimeColumn colFecha = new GridViewDateTimeColumn();
colFecha.FieldName = "Fecha";
colFecha.HeaderText = "Fecha";
colFecha.MinWidth = Consulta.AnchoTexto(col.First().Field <string>("Fecha").ToString(), colFecha.HeaderText, RadGridViewVentaDiaria.Font);
colFecha.Name = "colFecha";
colFecha.ReadOnly = true;
RadGridViewVentaDiaria.Columns.Add(colFecha);
GridViewImageColumn colEliminar = new GridViewImageColumn();
colEliminar.HeaderText = "Eliminar";
colEliminar.MinWidth = 50;
colEliminar.Name = "colEliminar";
colEliminar.ReadOnly = true;
RadGridViewVentaDiaria.Columns.Add(colEliminar);
RadGridViewVentaDiaria.DataSource = dttVentaDia;
for (int l = 0; l < RadGridViewVentaDiaria.Rows.Count; l++)
{
Bitmap eliminar = new Bitmap(@"Imagenes\shopping-cart-remove-icon (1).png");
RadGridViewVentaDiaria.Rows[l].Cells["colEliminar"].Value = eliminar;
}
}
}
private void FormatShiftGrid()
{
grdShift.EnableFiltering = true;
grdShift.AllowAddNewRow = false;
grdShift.ShowGroupPanel = false;
grdShift.TableElement.RowHeight = 30;
grdShift.MasterTemplate.ShowRowHeaderColumn = false;
//grdDriverShift.EnableHotTracking = false;
grdShift.AllowDeleteRow = false;
GridViewTextBoxColumn col = new GridViewTextBoxColumn();
col.Name = COLS.Id;
col.IsVisible = false;
grdShift.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.Name = COLS.Driver_Shift_ID;
col.IsVisible = false;
grdShift.Columns.Add(col);
GridViewCheckBoxColumn cbcol = new GridViewCheckBoxColumn();
cbcol.Name = COLS.Check;
cbcol.Width = 80;
cbcol.ReadOnly = false;
grdShift.Columns.Add(cbcol);
col = new GridViewTextBoxColumn();
col.Name = COLS.DayValues;
col.IsVisible = false;
grdShift.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.Name = COLS.ShiftName;
col.HeaderText = "Shift Name";
col.Width = 140;
col.ReadOnly = true;
grdShift.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.Name = COLS.ShiftStarts;
col.HeaderText = "Shift Starts";
col.Width = 160;
col.ReadOnly = true;
grdShift.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.Name = COLS.ShiftEnds;
col.HeaderText = "Shift Ends";
col.Width = 160;
col.ReadOnly = true;
grdShift.Columns.Add(col);
GridViewDateTimeColumn dtcol = new GridViewDateTimeColumn();
dtcol.Name = COLS.FromTime;
dtcol.HeaderText = "From Time";
dtcol.Width = 100;
dtcol.CustomFormat = "{0:HH:mm}";
dtcol.FormatString = "{0:HH:mm}";
dtcol.ReadOnly = true;
dtcol.IsVisible = false;
grdShift.Columns.Add(dtcol);
dtcol = new GridViewDateTimeColumn();
dtcol.Name = COLS.TillTime;
dtcol.HeaderText = "Till Time";
dtcol.Width = 100;
dtcol.CustomFormat = "{0:HH:mm}";
dtcol.FormatString = "{0:HH:mm}";
dtcol.ReadOnly = true;
dtcol.IsVisible = false;
grdShift.Columns.Add(dtcol);
grdShift.ViewCellFormatting += GrdShift_ViewCellFormatting;
//GridViewCommandColumn cmdcol = new GridViewCommandColumn();
//cmdcol.Width = 80;
//cmdcol.Name = "btnAdd";
//cmdcol.UseDefaultText = true;
//cmdcol.ImageLayout = System.Windows.Forms.ImageLayout.Center;
//cmdcol.DefaultText = "Add";
//cmdcol.TextAlignment = System.Drawing.ContentAlignment.MiddleCenter;
//grdShift.Columns.Add(cmdcol);
//grdShift.CommandCellClick += GrdShift_CommandCellClick;
// grdDriverShift.CellDoubleClick += GrdDriverShift_CellDoubleClick;
}
private void FormatGrid()
{
GridViewTextBoxColumn col = new GridViewTextBoxColumn();
col.HeaderText = "ID";
col.IsVisible = false;
col.Name = "ID";
grdLister.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.HeaderText = "ONLINEBOOKINGID";
col.IsVisible = false;
col.Name = "ONLINEBOOKINGID";
grdLister.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.HeaderText = "Driver";
col.Name = "Driver";
col.Width = 100;
col.WrapText = true;
col.ReadOnly = true;
grdLister.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.HeaderText = "Ref #";
col.Name = "REFNO";
col.Width = 110;
col.IsVisible = true;
col.WrapText = true;
col.ReadOnly = true;
grdLister.Columns.Add(col);
GridViewDateTimeColumn colD = new GridViewDateTimeColumn();
colD.HeaderText = "Pickup Time";
colD.Name = "PICKUPDATETIME";
colD.CustomFormat = "dd/MM/yyyy HH:mm";
colD.FormatString = "{0:dd/MM/yyyy HH:mm}";
colD.ReadOnly = false;
colD.Width = 160;
colD.WrapText = true;
grdLister.Columns.Add(colD);
col = new GridViewTextBoxColumn();
col.HeaderText = "Pickup";
col.Name = "FROMADDRESS";
col.ReadOnly = true;
col.Width = 330;
col.WrapText = true;
grdLister.Columns.Add(col);
GridViewCommandColumn commandCol = new GridViewCommandColumn();
commandCol.UseDefaultText = true;
commandCol.DefaultText = "Allow";
commandCol.Name = "ACCEPT";
commandCol.HeaderText = "";
commandCol.Width = 80;
commandCol.TextAlignment = ContentAlignment.MiddleCenter;
grdLister.Columns.Add(commandCol);
GridViewCommandColumn commandDenyCol = new GridViewCommandColumn();
commandDenyCol.UseDefaultText = true;
commandDenyCol.DefaultText = "Deny";
commandDenyCol.Name = "DENY";
commandDenyCol.HeaderText = "";
commandDenyCol.Width = 70;
commandDenyCol.TextAlignment = ContentAlignment.MiddleCenter;
grdLister.Columns.Add(commandDenyCol);
grdLister.CommandCellClick += new CommandCellClickEventHandler(grdLister_CommandCellClick);
grdLister.ShowRowHeaderColumn = false;
grdLister.ShowGroupPanel = false;
grdLister.AllowAddNewRow = false;
grdLister.TableElement.RowHeight = 60;
grdLister.AllowDeleteRow = false;
}
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;
}
private void frmCashAccountStatementReport_Load(object sender, EventArgs e)
{
try
{
ComboFunctions.FillCompanyCombo(ddlCompany, c => c.AccountTypeId == Enums.ACCOUNT_TYPE.CASH);
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 = "Driver";
col.HeaderText = "Driver";
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.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.FormatString = "{0:#,###0.00}";
grdLister.Columns.Add(colD);
colD = new GridViewDecimalColumn();
colD.DecimalPlaces = 2;
colD.Minimum = 0;
colD.HeaderText = "Congtion";
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.HeaderText = "DriverCommission";
colD.Name = "DriverCommission";
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+Parking+Waiting+ExtraDrop+MeetAndGreet+CongtionCharge";
grdLister.Columns.Add(colD);
colD = new GridViewDecimalColumn();
colD.DecimalPlaces = 2;
colD.Minimum = 0;
colD.ReadOnly = true;
colD.HeaderText = "Commission";
colD.Name = "Commission";
colD.Maximum = 9999999;
colD.FormatString = "{0:#,###0.00}";
// colD.Expression = "(Total*DriverCommission)/100";
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["Driver"].Width = 60;
grdLister.Columns["PickUpPoint"].Width = 90;
grdLister.Columns["Destination"].Width = 90;
grdLister.Columns["Charges"].Width = 45;
grdLister.Columns["Parking"].Width = 45;
grdLister.Columns["Waiting"].Width = 50;
grdLister.Columns["ExtraDrop"].Width = 55;
grdLister.Columns["MeetAndGreet"].Width = 50;
grdLister.Columns["CongtionCharge"].Width = 55;
grdLister.Columns["Total"].Width = 40;
grdLister.Columns["Commission"].Width = 55;
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";
//grdLister.Columns["MeetAndGreet"].ReadOnly = false;
//grdLister.Columns["CongtionCharge"].ReadOnly = false;
//grdLister.Columns["Charge"].ReadOnly = false;
//grdLister.Columns["Parking"].ReadOnly = false;
//grdLister.Columns["Waiting"].ReadOnly = false;
//grdLister.Columns["ExtraDrop"].ReadOnly = false;
AddUpdateColumn(grdLister);
grdLister.AllowEditRow = true;
}
catch (Exception ex)
{
}
}
private void FormatGrid()
{
GridViewTextBoxColumn col = new GridViewTextBoxColumn();
col.Name = "BookingReference";
col.HeaderText = " Ref #";
col.FieldName = "Booking Reference";
col.WrapText = true;
col.Width = 70;
grdBookings.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.Name = COLS.ID;
col.IsVisible = false;
grdBookings.Columns.Add(col);
GridViewDateTimeColumn colDate = new GridViewDateTimeColumn();
colDate.Name = "PickupDateTime";
colDate.WrapText = true;
colDate.HeaderText = "Pickup Date-Time";
colDate.Width = 140;
colDate.FieldName = "Pickup Time";
colDate.CustomFormat = "dd/MM/yyyy HH:mm";
colDate.FormatString = "{0:dd/MM/yyyy HH:mm}";
grdBookings.Columns.Add(colDate);
GridViewComboBoxColumn colCombo = new GridViewComboBoxColumn();
colCombo.Name = "VehicleType";
colCombo.HeaderText = "Vehicle";
colCombo.FieldName = "Vehicle Class";
colCombo.DataSource = General.GetQueryable <Fleet_VehicleType>(null).OrderBy(c => c.OrderNo).ToList();
colCombo.DisplayMember = "VehicleType";
colCombo.ValueMember = "Id";
colCombo.Width = 80;
col.WrapText = true;
grdBookings.Columns.Add(colCombo);
col = new GridViewTextBoxColumn();
col.Name = "PhoneNo";
col.HeaderText = "Phone No";
col.Width = 120;
col.WrapText = true;
col.FieldName = "Phone";
grdBookings.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.Name = "Passenger";
col.HeaderText = "Passenger";
col.FieldName = "Passenger Name";
col.WrapText = true;
col.Width = 100;
grdBookings.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.Name = "From";
col.HeaderText = "Pickup Point";
col.FieldName = "0";
col.WrapText = true;
col.Width = 130;
grdBookings.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.Name = "To";
col.WrapText = true;
col.HeaderText = "Destination";
col.Width = 130;
col.FieldName = "1";
grdBookings.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.Name = "Notes";
col.WrapText = true;
col.FieldName = "Driver Notes";
col.HeaderText = "Notes";
col.Width = 120;
grdBookings.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.Name = "Account";
col.HeaderText = "Account";
col.FieldName = "Booking Account";
col.WrapText = true;
col.Width = 120;
grdBookings.Columns.Add(col);
//GridViewDecimalColumn colDec = new GridViewDecimalColumn();
//colDec.Name = "Fare";
//colDec.FieldName = "Pricing";
//colDec.DecimalPlaces = 2;
//colDec.Minimum = 0;
//colDec.Maximum = 999999;
//colDec.HeaderText = "Fare";
//colDec.Width = 60;
//grdBookings.Columns.Add(colDec);
//col = new GridViewTextBoxColumn();
//col.Name = "PaymentType";
//col.WrapText = true;
//col.FieldName = "Card";
//col.HeaderText = "Payment";
//col.Width = 100;
//grdBookings.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.Name = "Via";
col.WrapText = true;
col.FieldName = "Via";
col.HeaderText = "Via Point";
col.Width = 100;
grdBookings.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.Name = "FlightNo";
col.WrapText = true;
col.FieldName = "FlightNo";
col.HeaderText = "Flight No";
col.Width = 100;
grdBookings.Columns.Add(col);
ConditionalFormattingObject objSave = new ConditionalFormattingObject();
objSave.ApplyToRow = true;
objSave.RowBackColor = Color.LightGreen;
objSave.ConditionType = ConditionTypes.Greater;
objSave.TValue1 = "0";
grdBookings.Columns[COLS.ID].ConditionalFormattingObjectList.Add(objSave);
ConditionalFormattingObject objError = new ConditionalFormattingObject();
objError.ApplyToRow = true;
objError.RowBackColor = Color.Pink;
objError.ConditionType = ConditionTypes.Equal;
objError.TValue1 = "0";
grdBookings.Columns[COLS.ID].ConditionalFormattingObjectList.Add(objError);
grdBookings.AddDeleteColumn();
grdBookings.Columns["btnDelete"].PinPosition = PinnedColumnPosition.Right;
grdBookings.Columns["btnDelete"].IsPinned = true;
grdBookings.Columns["btnDelete"].Width = 70;
grdBookings.CommandCellClick += new CommandCellClickEventHandler(grdBookings_CommandCellClick);
}
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;
}
private void FormatChargesGrid()
{
GridViewTextBoxColumn col = new GridViewTextBoxColumn();
col.IsVisible = false;
col.Name = "Id";
grdLister.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.IsVisible = false;
col.Name = COLS.InvoiceId;
grdLister.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.IsVisible = false;
col.Name = COLS.PaymentTypeId;
grdLister.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.IsVisible = false;
col.Name = COLS.BookingId;
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 = "Job #";
col.Name = "RefNumber";
grdLister.Columns.Add(col);
//col = new GridViewTextBoxColumn();
// col.IsVisible = false;
//col.HeaderText = "Order No";
//col.Name = "OrderNo";
//grdLister.Columns.Add(col);
//col = new GridViewTextBoxColumn();
//col.IsVisible = false;
//col.HeaderText = "Pupil No";
//col.Name = "PupilNo";
//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 = COLS.Account;
//col.HeaderText = COLS.Account;
//grdLister.Columns.Add(col);
col = new GridViewTextBoxColumn();
// col.IsVisible = false;
col.ReadOnly = false;
col.HeaderText = "Pickup Point";
col.Name = "PickupPoint";
grdLister.Columns.Add(col);
col = new GridViewTextBoxColumn();
// col.IsVisible = false;
col.ReadOnly = false;
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 = "Meet and Greet";
colD.Name = "MeetAndGreet";
colD.IsVisible = false;
colD.Maximum = 9999999;
colD.FormatString = "{0:#,###0.00}";
grdLister.Columns.Add(colD);
colD = new GridViewDecimalColumn();
colD.DecimalPlaces = 2;
colD.Minimum = 0;
colD.HeaderText = "Congestion";
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+Parking+Waiting+ExtraDrop+MeetAndGreet+CongtionCharge";
colD.Expression = "Charges+Parking+Waiting+ExtraDrop";
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 = 105;
grdLister.Columns["RefNumber"].Width = 40;
grdLister.Columns["Vehicle"].Width = 50;
// grdLister.Columns[COLS.Account].Width = 60;
grdLister.Columns["PickUpPoint"].Width = 170;
grdLister.Columns["Destination"].Width = 170;
grdLister.Columns["Charges"].Width = 50;
grdLister.Columns["Parking"].Width = 45;
grdLister.Columns["Waiting"].Width = 50;
grdLister.Columns["ExtraDrop"].Width = 60;
grdLister.Columns["MeetAndGreet"].Width = 50;
grdLister.Columns["CongtionCharge"].Width = 60;
grdLister.Columns["Total"].Width = 45;
// grdLister.Columns["OrderNo"].Width = 55;
grdLister.Columns["PickUpDate"].HeaderText = "Pickup Date-Time";
grdLister.Columns["RefNumber"].HeaderText = "Ref #";
grdLister.Columns["PickUpPoint"].HeaderText = "Pickup Point";
grdLister.Columns["ExtraDrop"].HeaderText = "Congestion";
grdLister.Columns["MeetAndGreet"].HeaderText = "M & G";
grdLister.Columns["CongtionCharge"].HeaderText = "Congestion";
//grdLister.Columns["MeetAndGreet"].ReadOnly = false;
//grdLister.Columns["CongtionCharge"].ReadOnly = false;
//grdLister.Columns["Charge"].ReadOnly = false;
//grdLister.Columns["Parking"].ReadOnly = false;
//grdLister.Columns["Waiting"].ReadOnly = false;
//grdLister.Columns["ExtraDrop"].ReadOnly = false;
AddUpdateColumn(grdLister);
ConditionalFormattingObject objPaid = new ConditionalFormattingObject();
objPaid.ApplyToRow = true;
objPaid.RowBackColor = Color.LightGreen;
objPaid.ConditionType = ConditionTypes.Equal;
objPaid.TValue1 = "6";
objPaid.TValue2 = "2";
grdLister.Columns["PaymentTypeId"].ConditionalFormattingObjectList.Add(objPaid);
}
private void FormatChargesGrid()
{
GridViewTextBoxColumn col = new GridViewTextBoxColumn();
col.IsVisible = false;
col.Name = "Id";
grdLister.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.IsVisible = false;
col.Name = COLS.InvoiceId;
grdLister.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.IsVisible = false;
col.Name = COLS.BookingId;
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 = "Job #";
col.Name = "RefNumber";
grdLister.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.IsVisible = false;
col.HeaderText = "Order No";
col.Name = "OrderNo";
grdLister.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.IsVisible = false;
col.HeaderText = "Booked By";
col.Name = COLS.BookedBy;
grdLister.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.IsVisible = false;
col.HeaderText = "Pupil No";
col.Name = "PupilNo";
grdLister.Columns.Add(col);
col = new GridViewTextBoxColumn();
// col.IsVisible = false;
col.HeaderText = "Vehicle";
col.Name = "Vehicle";
grdLister.Columns.Add(col);
GridViewComboBoxColumn colCombo = new GridViewComboBoxColumn();
colCombo.Name = COLS.VehicleID;
colCombo.IsVisible = false;
colCombo.HeaderText = "Vehicle";
colCombo.DataSource = General.GetQueryable <Fleet_VehicleType>(null).OrderBy(c => c.OrderNo).ToList();
colCombo.DisplayMember = "VehicleType";
colCombo.ValueMember = "Id";
colCombo.DropDownStyle = Telerik.WinControls.RadDropDownStyle.DropDownList;
colCombo.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
grdLister.Columns.Add(colCombo);
colCombo.ReadOnly = false;
col = new GridViewTextBoxColumn();
col.Name = COLS.Passenger;
col.HeaderText = "Passenger";
grdLister.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.Width = 900;
col.IsVisible = false;
col.ReadOnly = true;
col.Name = COLS.RemovalDescription;
col.HeaderText = "Description";
grdLister.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.HeaderText = "Pickup Point";
col.Name = "PickupPoint";
grdLister.Columns.Add(col);
col = new GridViewTextBoxColumn();
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 = "Meet and Greet";
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.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.HeaderText = "Total";
colD.Name = "Total";
colD.Maximum = 9999999;
colD.FormatString = "{0:#,###0.00}";
colD.Expression = "Charges+Parking+Waiting+ExtraDrop+MeetAndGreet+CongtionCharge";
grdLister.Columns.Add(colD);
GridViewComboBoxColumn colPayment = new GridViewComboBoxColumn();
colPayment.IsVisible = false;
colPayment.Name = COLS.Payment_ID;
colPayment.HeaderText = "Status";
colPayment.DataSource = General.GetQueryable <Invoice_PaymentType>(null).Where(c => c.Id == 1 || c.Id == 3).OrderBy(c => c.Id).ToList();
colPayment.DisplayMember = "PaymentType";
colPayment.ValueMember = "Id";
colPayment.DropDownStyle = Telerik.WinControls.RadDropDownStyle.DropDown;
colPayment.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
colPayment.ReadOnly = false;
grdLister.Columns.Add(colPayment);
(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 = 105;
grdLister.Columns["RefNumber"].Width = 40;
grdLister.Columns["Vehicle"].Width = 50;
grdLister.Columns[COLS.Passenger].Width = 60;
grdLister.Columns["PickUpPoint"].Width = 80;
grdLister.Columns["Destination"].Width = 80;
grdLister.Columns["Charges"].Width = 50;
grdLister.Columns["Parking"].Width = 45;
grdLister.Columns["Waiting"].Width = 50;
grdLister.Columns["ExtraDrop"].Width = 60;
grdLister.Columns["MeetAndGreet"].Width = 50;
grdLister.Columns["CongtionCharge"].Width = 60;
grdLister.Columns["Total"].Width = 45;
grdLister.Columns["OrderNo"].Width = 55;
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 = "Congestion";
grdLister.Columns["Payment_ID"].Width = 70;
AddUpdateColumn(grdLister);
}
