public void FormatGrid()
{
GridViewTextBoxColumn col = new GridViewTextBoxColumn();
col.IsVisible = false;
col.Name = "Id";
grdBookingType.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.Name = COLS.BookingType;
col.ReadOnly = true;
col.Width = 250;
col.HeaderText = "Airport";
grdBookingType.Columns.Add(col);
GridViewDecimalColumn colExpiry = new GridViewDecimalColumn();
colExpiry.Name = "Expiry";
colExpiry.ReadOnly = false;
colExpiry.HeaderText = " ";
colExpiry.Width = 100;
colExpiry.DecimalPlaces = 0;
colExpiry.Minimum = 0;
grdBookingType.Columns.Add(colExpiry);
// grdBookingType.CommandCellClick+=new CommandCellClickEventHandler(grdBookingType_CommandCellClick);
// grdBookingType.ViewCellFormatting += new CellFormattingEventHandler(grdBookingType_ViewCellFormatting);
grdBookingType.TableElement.RowHeight = 35;
}
private void PrepareGrid(RadGridView grid)
{
GridViewImageColumn imageColumn = new GridViewImageColumn("Image", "Image");
imageColumn.Width = 50;
imageColumn.HeaderText = String.Empty;
GridViewTextBoxColumn nameColumn = new GridViewTextBoxColumn("Name", "Name");
nameColumn.Width = 70;
GridViewTextBoxColumn countryColumn = new GridViewTextBoxColumn("Country", "Country");
countryColumn.Width = 90;
GridViewDecimalColumn priceColumn = new GridViewDecimalColumn("Price", "Price");
priceColumn.Width = 90;
priceColumn.FormatString = "{0:c}";
grid.Columns.Add(imageColumn);
grid.Columns.Add(nameColumn);
grid.Columns.Add(countryColumn);
grid.Columns.Add(priceColumn);
grid.TableElement.RowHeight = 50;
grid.MasterTemplate.AllowRowReorder = true;
grid.ReadOnly = true;
grid.MultiSelect = true;
grid.MasterTemplate.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill;
grid.GridBehavior = new CustomGridBehavior();
}
public Form1()
{
InitializeComponent();
//This project demonstrates how to show the summary cells when the groups are collpased
#region Populate with data
for (int i = 0; i < 5; i++)
{
GridViewDecimalColumn col = new GridViewDecimalColumn("Col " + (i + 1));
this.radGridView1.Columns.Add(col);
}
for (int i = 0; i < 20; i++)
{
this.radGridView1.Rows.Add(i % 5, i % 3, i % 2, i, i);
}
#endregion
#region Add summary items
GridViewSummaryItem item1 = new GridViewSummaryItem("Col 1", "Sum = {0}", GridAggregateFunction.Sum);
GridViewSummaryItem item2 = new GridViewSummaryItem("Col 2", "Avg = {0}", GridAggregateFunction.Avg);
GridViewSummaryItem item4 = new GridViewSummaryItem("Col 4", "Max = {0}", GridAggregateFunction.Max);
GridViewSummaryItem item5 = new GridViewSummaryItem("Col 5", "First = {0}", GridAggregateFunction.First);
GridViewSummaryRowItem row = new GridViewSummaryRowItem(new GridViewSummaryItem[] { item1, item2, item4, item5 });
this.radGridView1.SummaryRowsTop.Add(row);
#endregion
this.radGridView1.TableElement.GroupHeaderHeight = 50;
this.radGridView1.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill;
this.radGridView1.CreateCell += new GridViewCreateCellEventHandler(radGridView1_CreateCell);
this.radGridView1.Columns.CollectionChanged += new NotifyCollectionChangedEventHandler(Columns_CollectionChanged);
}
private void FormatServiceChargesGrid()
{
GridViewTextBoxColumn col = new GridViewTextBoxColumn();
col.Name = COLS.Id;
col.IsVisible = false;
grdServiceCharges.Columns.Add(col);
GridViewCheckBoxColumn colcHK = new GridViewCheckBoxColumn();
colcHK.Name = COLS.Account;
colcHK.HeaderText = "Account";
colcHK.Width = 70;
grdServiceCharges.Columns.Add(colcHK);
GridViewDecimalColumn dcol = new GridViewDecimalColumn();
dcol.Name = COLS.FromValue;
dcol.HeaderText = "From";
dcol.Width = 90;
grdServiceCharges.Columns.Add(dcol);
dcol = new GridViewDecimalColumn();
dcol.Name = COLS.ToValue;
dcol.HeaderText = "Till";
dcol.Width = 90;
grdServiceCharges.Columns.Add(dcol);
dcol = new GridViewDecimalColumn();
dcol.Name = COLS.ServiceChargePercent;
dcol.HeaderText = "Service Charge Percent";
dcol.Width = 170;
grdServiceCharges.Columns.Add(dcol);
GridViewCheckBoxColumn cbcol = new GridViewCheckBoxColumn();
cbcol.Name = COLS.AmountWise;
cbcol.HeaderText = "Amount Wise";
cbcol.Width = 120;
grdServiceCharges.Columns.Add(cbcol);
//grdServiceCharges.AddEditColumn();
dcol = new GridViewDecimalColumn();
dcol.Name = COLS.ServiceChargeAmount;
dcol.HeaderText = "Service Charge Amount";
dcol.Width = 170;
grdServiceCharges.Columns.Add(dcol);
grdServiceCharges.AddDeleteColumn();
grdServiceCharges.ShowRowHeaderColumn = false;
//grdServiceCharges.Columns["btnEdit"].Width = 100;
grdServiceCharges.Columns["btnDelete"].Width = 80;
}
private void FormatSurchargeRateGrid()
{
grdSurchargeRates.ShowGroupPanel = false;
GridViewTextBoxColumn col = new GridViewTextBoxColumn();
col.IsVisible = false;
col.Name = COL_SURCHARGERATES.ID;
grdSurchargeRates.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.IsVisible = false;
col.Name = COL_SURCHARGERATES.POLICYID;
grdSurchargeRates.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.HeaderText = COL_SURCHARGERATES.POSTCODE;
col.Width = 100;
col.Name = COL_SURCHARGERATES.POSTCODE;
grdSurchargeRates.Columns.Add(col);
GridViewCheckBoxColumn colChk = new GridViewCheckBoxColumn();
colChk.HeaderText = "Amount Wise";
colChk.Width = 110;
colChk.Name = COL_SURCHARGERATES.AMOUNTWISE;
grdSurchargeRates.Columns.Add(colChk);
GridViewDecimalColumn col2 = new GridViewDecimalColumn();
col2.HeaderText = "Percentage (%)";
col2.Width = 110;
col2.Maximum = 100;
col2.Name = COL_SURCHARGERATES.PERCENTAGE;
grdSurchargeRates.Columns.Add(col2);
col2 = new GridViewDecimalColumn();
col2.HeaderText = "Amount (£)";
col2.Width = 110;
col2.Maximum = 100000;
col2.Name = COL_SURCHARGERATES.AMOUNT;
grdSurchargeRates.Columns.Add(col2);
UI.GridFunctions.AddDeleteColumn(grdSurchargeRates);
grdSurchargeRates.ShowGroupPanel = false;
grdSurchargeRates.AddNewRowPosition = SystemRowPosition.Bottom;
grdSurchargeRates.CellBeginEdit += new GridViewCellCancelEventHandler(grdSurchargeRates_CellBeginEdit);
grdSurchargeRates.CellEndEdit += GrdSurchargeRates_CellEndEdit;
}
private void newGrid_DataBindingComplete(object sender, GridViewBindingCompleteEventArgs e)
{
RadGridView grid = sender as RadGridView;
if (grid.Columns.Count > 0)
{
HideColumns(grid.MasterTemplate);
SetColumnsAsReadOnly(grid.MasterTemplate);
CustomColumnSort(grid.MasterTemplate);
if (grid.Name == "OfficeWorker") // Office workers will be used the most with this form, so these are special changes for them
{
GridViewDataColumn col = grid.Columns.Where(c => c.Name == "InstanceCount").FirstOrDefault();
if (col != null)
{
col.HeaderText = "Total Workers";
}
col = grid.Columns.Where(c => c.Name == "RepeatCount").FirstOrDefault();
if (col != null)
{
col.HeaderText = "Iterations";
}
GridViewDecimalColumn maxWorkersCol = grid.Columns.Where(c => c.Name == "ResourcesPerVM").FirstOrDefault() as GridViewDecimalColumn;
if (maxWorkersCol != null)
{
maxWorkersCol.IsVisible = true;
maxWorkersCol.HeaderText = "Max Workers Per VM";
maxWorkersCol.DecimalPlaces = 0;
grid.Rows.Select(r => r.Cells["ResourcesPerVM"]).ToList().ForEach(c =>
{
if (c.Value == null)
{
c.Value = _context.ResourceTypes.First(n => n.Name == "OfficeWorker").MaxResourcesPerHost;
}
});
}
}
UserInterfaceStyler.Configure(grid, GridViewStyle.Display);
foreach (var c in grid.Columns)
{
c.AutoSizeMode = BestFitColumnMode.AllCells;
c.BestFit();
c.TextAlignment = ContentAlignment.MiddleCenter;
}
}
foreach (var template in grid.Templates) // Accounts for child tables
{
HideColumns(template);
CustomColumnSort(template);
SetColumnsAsReadOnly(template);
}
}
private void InitializeGrid()
{
for (int i = 0; i < this.columnTypes.Length; i++)
{
AppendNewColumn(this.columnTypes[i], false);
}
GridViewDecimalColumn radiusColumn = new GridViewDecimalColumn();
radiusColumn.Name = "Radius";
radiusColumn.HeaderText = "Radius";
this.radGridView1.Columns.Insert(4, radiusColumn);
this.radGridView1.Columns["DateTime"].FormatString = "{0:d}";
this.radGridView1.Columns["DateTime"].TextAlignment = ContentAlignment.MiddleRight;
CreateBitmaps();
GridViewRowInfo rowInfo = this.radGridView1.Rows.AddNew();
rowInfo.Cells[0].Value = "7432";
rowInfo.Cells[1].Value = 23;
rowInfo.Cells[2].Value = DateTime.Now;
rowInfo.Cells[3].Value = true;
rowInfo.Cells[4].Value = 12.37;
rowInfo = this.radGridView1.Rows.AddNew();
rowInfo.Cells[0].Value = "890";
rowInfo.Cells[1].Value = 574;
rowInfo.Cells[2].Value = DateTime.Now.AddMonths(-10);
rowInfo.Cells[3].Value = true;
rowInfo.Cells[4].Value = 5.63;
rowInfo = this.radGridView1.Rows.AddNew();
rowInfo.Cells[0].Value = "5435";
rowInfo.Cells[1].Value = 23444;
rowInfo.Cells[2].Value = DateTime.Now.AddDays(45);
rowInfo.Cells[3].Value = true;
rowInfo.Cells[4].Value = 37.12;
rowInfo = this.radGridView1.Rows.AddNew();
rowInfo.Cells[0].Value = "132323";
rowInfo.Cells[1].Value = 3455;
rowInfo.Cells[2].Value = DateTime.Now.AddMonths(34);
rowInfo.Cells[3].Value = true;
rowInfo.Cells[4].Value = 23.54;
this.radGridView1.RowCount = 4;
this.radGridView1.CurrentRow = this.radGridView1.Rows[0];
this.radGridView1.ShowGroupPanel = false;
this.radGridView1.EnableGrouping = false;
this.radGridView1.MasterTemplate.AllowAddNewRow = false;
this.radGridView1.Columns["CustomExpression"].Expression = "ROUND(PI() * POWER(Radius, 2) + Decimal)";
}
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 FormatGrid()
{
GridViewTextBoxColumn col = new GridViewTextBoxColumn();
col.Name = COLS.ID;
col.IsVisible = false;
grdFixFares.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.Name = COLS.VehicleName;
col.HeaderText = COLS.VehicleName;
col.FieldName = COLS.VehicleName;
col.WrapText = true;
col.Width = 100;
grdFixFares.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.Name = COLS.From;
col.HeaderText = COLS.From;
col.FieldName = COLS.From;
col.WrapText = true;
col.Width = 150;
grdFixFares.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.Name = COLS.To;
col.HeaderText = COLS.To;
col.Width = 150;
col.WrapText = true;
col.FieldName = COLS.To;
grdFixFares.Columns.Add(col);
GridViewDecimalColumn colDec = new GridViewDecimalColumn();
colDec.Name = COLS.Fare;
colDec.FieldName = COLS.Fare;
colDec.DecimalPlaces = 2;
colDec.Minimum = 0;
colDec.Maximum = 999999;
colDec.HeaderText = "Fare";
colDec.Width = 80;
grdFixFares.Columns.Add(colDec);
}
private void BindGrid()
{
GridViewImageColumn imageColumn = new GridViewImageColumn("CarPicture");
imageColumn.ImageLayout = ImageLayout.Zoom;
imageColumn.MaxWidth = 80;
imageColumn.MinWidth = 80;
imageColumn.HeaderTextAlignment = ContentAlignment.MiddleCenter;
imageColumn.HeaderText = "Car Picture";
GridViewTextBoxColumn col1 = new GridViewTextBoxColumn("CarName");
col1.Width = 300;
col1.HeaderText = "Car";
col1.HeaderTextAlignment = ContentAlignment.MiddleCenter;
GridViewDecimalColumn col2 = new GridViewDecimalColumn("Price");
col2.HeaderText = "Price";
col2.Width = 100;
col2.FormatString = "${0:N0}";
col2.TextAlignment = ContentAlignment.MiddleRight;
col2.HeaderTextAlignment = ContentAlignment.MiddleCenter;
GridViewTextBoxColumn dataColumn = new GridViewTextBoxColumn("MaxSpeed");
dataColumn.TextAlignment = ContentAlignment.MiddleRight;
dataColumn.HeaderText = "Max Speed";
dataColumn.FormatString = "{0} mph";
dataColumn.Width = 100;
dataColumn.HeaderTextAlignment = ContentAlignment.MiddleCenter;
GridViewTextBoxColumn companyColumn = new GridViewTextBoxColumn("CompanyName");
companyColumn.HeaderTextAlignment = ContentAlignment.MiddleCenter;
companyColumn.HeaderText = "Manufacturer";
companyColumn.Width = 300;
this.radGridView1.Columns.Add(imageColumn);
this.radGridView1.Columns.Add(col1);
this.radGridView1.Columns.Add(companyColumn);
this.radGridView1.Columns.Add(col2);
this.radGridView1.Columns.Add(dataColumn);
radGridView1.MasterTemplate.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill;
this.radGridView1.DataSource = CreateDataTable();
}
private void InitGrid()
{
this.radGridView1.MasterTemplate.AllowAddNewRow = false;
this.radGridView1.MasterTemplate.AutoGenerateColumns = false;
this.radGridView1.MasterTemplate.EnableFiltering = true;
this.radGridView1.MasterTemplate.EnableSorting = true;
this.radGridView1.MasterTemplate.EnableGrouping = true;
this.radGridView1.DataSource = null;
this.radGridView1.MasterTemplate.Columns.Clear();
var imageColumn = new GridViewImageColumn("image", "image");
imageColumn.HeaderText = "Image";
imageColumn.ImageLayout = ImageLayout.Zoom;
imageColumn.Width = 150;
this.radGridView1.MasterTemplate.Columns.Add(imageColumn);
var asinColumn = new GridViewTextBoxColumn("external_product_id", "external_product_id");
asinColumn.HeaderText = "ASIN";
this.radGridView1.MasterTemplate.Columns.Add(asinColumn);
this.radGridView1.MasterTemplate.Columns.Add("item_name", "Name", "item_name");
this.radGridView1.MasterTemplate.Columns.Add("price", "Price", "price");
var priceColumn = new GridViewDecimalColumn("real_price", "real_price");
priceColumn.HeaderText = "real_price";
this.radGridView1.MasterTemplate.Columns.Add(priceColumn);
this.radGridView1.MasterTemplate.Columns.Add("Dimensions", "Dimensions", "Dimensions");
this.radGridView1.MasterTemplate.Columns.Add("Size", "Size", "Size");
this.radGridView1.MasterTemplate.Columns.Add("brand_name", "Brand", "brand_name");
this.radGridView1.MasterTemplate.Columns.Add("product_type_name", "Type", "product_type_name");
this.radGridView1.MasterTemplate.Columns.Add("department_name", "Department", "department_name");
var urlColumn = new GridViewHyperlinkColumn("Url", "Url");
urlColumn.HeaderText = "Url";
this.radGridView1.MasterTemplate.Columns.Add(urlColumn);
for (int i = 1; i < radGridView1.MasterTemplate.Columns.Count; i++)
{
this.radGridView1.MasterTemplate.Columns[i].Width = 120;
}
this.radGridView1.DataSource = _products;
}
private void frm_cotizador_Load(object sender, EventArgs e)
{
cs_sapbo sapbo = new cs_sapbo();
txt_salas.AutoCompleteDataSource = sapbo.GET_SALAS_DDL(int.Parse(cs_funciones.session_location));
txt_salas.AutoCompleteValueMember = "RoomCode";
txt_salas.AutoCompleteDisplayMember = "RoomName";
txt_instituciones.AutoCompleteDataSource = sapbo.GET_INSTITUCIONES_DDL();
txt_instituciones.AutoCompleteDisplayMember = "CardName";
txt_instituciones.AutoCompleteValueMember = "CardCode";
rgvListado.DataSource = quotingItems;
GridViewDecimalColumn decimalColumn = (GridViewDecimalColumn)rgvListado.Columns["Precio"];
decimalColumn.FormatString = "{0:C}";
quotingItems.ListChanged += QuotingItems_ListChanged;
sapbo = null;
}
private GridViewTemplate SetupChildForUnbound()
{
GridViewTemplate template = new GridViewTemplate();
template.AllowAddNewRow = true;
GridViewTextBoxColumn textBoxColumn = new GridViewTextBoxColumn("Name");
textBoxColumn.HeaderText = "Name";
template.Columns.Add(textBoxColumn);
GridViewDecimalColumn productNumberColumn = new GridViewDecimalColumn("Product Number");
productNumberColumn.HeaderText = "Product Number";
productNumberColumn.DecimalPlaces = 0;
productNumberColumn.FormatString = "#{0}";
template.Columns.Add(productNumberColumn);
GridViewDecimalColumn decimalChildColumn1 = new GridViewDecimalColumn("Quantity");
decimalChildColumn1.HeaderText = "Quantity";
template.Columns.Add(decimalChildColumn1);
GridViewDecimalColumn decimalChildColumn2 = new GridViewDecimalColumn("Discount");
decimalChildColumn2.HeaderText = "Discount";
decimalChildColumn2.FormatString = "{0:F2}%";
template.Columns.Add(decimalChildColumn2);
GridViewDecimalColumn decimalChildColumn3 = new GridViewDecimalColumn("Total");
decimalChildColumn3.HeaderText = "Total";
decimalChildColumn3.FormatString = "${0}";
template.Columns.Add(decimalChildColumn3);
this.radGridView1.Templates.Add(template);
LoadDataForUnbound();
template.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill;
return(template);
}
public RadForm1()
{
InitializeComponent();
DataTable dt = new DataTable();
dt.Columns.Add("Id", typeof(int));
dt.Columns.Add("IssueTitle", typeof(string));
dt.Columns.Add("Priority", typeof(string));
for (int i = 1; i < 20; i++)
{
if (i % 2 == 0)
{
dt.Rows.Add(i, "Issue#" + i, "Low");
}
else
{
dt.Rows.Add(i, "Issue#" + i, "High");
}
}
this.radGridView1.AutoGenerateColumns = false;
GridViewDecimalColumn idColumn = new GridViewDecimalColumn("Id");
this.radGridView1.Columns.Add(idColumn);
GridViewTextBoxColumn titleColumn = new GridViewTextBoxColumn("IssueTitle");
this.radGridView1.Columns.Add(titleColumn);
CustomColumn myColumn = new CustomColumn();
myColumn.FieldName = myColumn.Name = myColumn.HeaderText = "Priority";
this.radGridView1.Columns.Add(myColumn);
this.radGridView1.DataSource = dt;
this.radGridView1.BestFitColumns(BestFitColumnMode.AllCells);
this.radGridView1.EnableFiltering = true;
this.radGridView1.CellBeginEdit += radGridView1_CellBeginEdit;
}
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 FormateGride()
{
try
{
grdLister.ShowGroupPanel = false;
grdLister.ShowGroupedColumns = false;
grdLister.AllowAddNewRow = false;
GridViewTextBoxColumn col = new GridViewTextBoxColumn();
col.HeaderText = "Time";
col.Name = "Miniuts";
col.Width = 130;
grdLister.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.HeaderText = "Miles";
col.Name = "miles";
col.Width = 120;
grdLister.Columns.Add(col);
GridViewDecimalColumn col2 = new GridViewDecimalColumn();
col2.HeaderText = "Price";
col2.Name = "Fares";
col2.DecimalPlaces = 2;
col2.FormatString = "{0:#,###0.00}";
col2.Maximum = 10000;
col2.Minimum = 0;
col2.Width = 120;
grdLister.Columns.Add(col2);
grdLister.ShowRowHeaderColumn = false;
}
catch (Exception ex)
{
}
}
public void FormatGrid()
{
GridViewTextBoxColumn col = new GridViewTextBoxColumn();
col.IsVisible = false;
col.Name = "Id";
grdSinBin.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.IsVisible = false;
col.Name = "SinBinTypeId";
grdSinBin.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.Name = COLS.SinBinType;
col.ReadOnly = true;
col.Width = 150;
col.HeaderText = "Sin Bin Type";
grdSinBin.Columns.Add(col);
GridViewDecimalColumn col1 = new GridViewDecimalColumn();
col1.Name = COLS.Minutes;
// col1.ReadOnly = true;
col1.HeaderText = "Minutes";
col1.DecimalPlaces = 0;
col1.Width = 80;
grdSinBin.Columns.Add(col1);
grdSinBin.CommandCellClick += new CommandCellClickEventHandler(grdBookingType_CommandCellClick);
grdSinBin.ViewCellFormatting += new CellFormattingEventHandler(grdBookingType_ViewCellFormatting);
grdSinBin.TableElement.RowHeight = 30;
}
private void FormatFaresDetailGrid()
{
grdDetails.AllowAddNewRow = false;
// grdDetails.AllowEditRow = false;
grdDetails.AutoCellFormatting = true;
grdDetails.ShowGroupPanel = false;
GridViewTextBoxColumn col = new GridViewTextBoxColumn();
col.Name = COLS_DETAILS.ID;
col.IsVisible = false;
grdDetails.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.Name = COLS_DETAILS.FAREID;
col.IsVisible = false;
grdDetails.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.Name = COLS_DETAILS.FROMLOCTYPEID;
col.IsVisible = false;
grdDetails.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.Name = COLS_DETAILS.TOLOCTYPEID;
col.IsVisible = false;
grdDetails.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.Name = COLS_DETAILS.FROMLOCATIONID;
col.IsVisible = false;
grdDetails.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.Name = COLS_DETAILS.TOLOCATIONID;
col.IsVisible = false;
grdDetails.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.HeaderText = "From Location";
col.Name = COLS_DETAILS.FROMLOCATION;
col.Width = 260;
col.ReadOnly = true;
grdDetails.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.HeaderText = "To Location";
col.ReadOnly = true;
col.Name = COLS_DETAILS.TOLOCATION;
col.Width = 260;
grdDetails.Columns.Add(col);
GridViewDecimalColumn colDec = new GridViewDecimalColumn();
colDec.HeaderText = "Fare (£)";
colDec.Width = 130;
colDec.ReadOnly = false;
colDec.DecimalPlaces = 2;
colDec.ThousandsSeparator = true;
colDec.Name = COLS_DETAILS.FARE;
grdDetails.Columns.Add(colDec);
grdDetails.MasterTemplate.ShowRowHeaderColumn = false;
//UI.GridFunctions.AddDeleteColumn(grdDetails);
//grdDetails.Columns["ColDelete"].Width = 80;
DetailGridButton();
}
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 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;
}
public PWTIMETEMP()
{
InitializeComponent();
#region <Window Form>
this.Text = string.Format(@"Usr:{0}; {1}", System.Security.Principal.WindowsIdentity.GetCurrent().Name, "พฤติกรรมการรูดบัตร");
this.KeyPreview = true;
this.ShowIcon = true;
this.StartPosition = FormStartPosition.CenterParent;
this.Load += new EventHandler(PWTIMETEMP_Load);
#endregion
#region <layout>
this.toolStrip1.Dock = DockStyle.Top;
this.panelContainer.Dock = DockStyle.Fill;
#endregion
#region <RadGridView>
this.radGridTimeTemp.Dock = DockStyle.Fill;
this.radGridTimeTemp.AutoGenerateColumns = true;
this.radGridTimeTemp.EnableFiltering = true;
this.radGridTimeTemp.AllowAddNewRow = false;
this.radGridTimeTemp.ReadOnly = true;
this.radGridTimeTemp.BestFitColumns(Telerik.WinControls.UI.BestFitColumnMode.HeaderCells);
this.radGridTimeTemp.MasterTemplate.ShowHeaderCellButtons = true;
this.radGridTimeTemp.MasterTemplate.ShowFilteringRow = false;
this.radGridTimeTemp.MasterTemplate.AutoGenerateColumns = false;
GridViewTextBoxColumn txtCol0 = new GridViewTextBoxColumn();
txtCol0.FieldName = "PWDATE";
txtCol0.Name = "PWDATE";
txtCol0.HeaderText = "วันที่";
txtCol0.FormatString = "{0:dd/MM/yyyy}";
txtCol0.IsVisible = true;
this.radGridTimeTemp.Columns.Add(txtCol0);
GridViewTextBoxColumn txtCol1 = new GridViewTextBoxColumn();
txtCol1.FieldName = "PWRDATE";
txtCol1.Name = "PWRDATE";
txtCol1.HeaderText = "วันที่(2)";
txtCol1.FormatString = "{0:dd/MM/yyyy}";
txtCol1.IsVisible = true;
this.radGridTimeTemp.Columns.Add(txtCol1);
GridViewTextBoxColumn txtCol2 = new GridViewTextBoxColumn();
txtCol2.FieldName = "PWEMPLOYEE";
txtCol2.Name = "PWEMPLOYEE";
txtCol2.HeaderText = "พนักงาน";
txtCol2.IsVisible = true;
this.radGridTimeTemp.Columns.Add(txtCol2);
GridViewTextBoxColumn txtCol3 = new GridViewTextBoxColumn();
txtCol3.FieldName = "PWSOURCE";
txtCol3.Name = "PWSOURCE";
txtCol3.HeaderText = "PWSOURCE";
txtCol3.IsVisible = true;
this.radGridTimeTemp.Columns.Add(txtCol3);
GridViewDecimalColumn txtCol4 = new GridViewDecimalColumn();
txtCol4.FieldName = "PWTIME";
txtCol4.Name = "PWTIME";
txtCol4.HeaderText = "เวลา";
txtCol4.IsVisible = true;
this.radGridTimeTemp.Columns.Add(txtCol4);
GridViewTextBoxColumn txtCol5 = new GridViewTextBoxColumn();
txtCol5.FieldName = "PWTRANTYPE";
txtCol5.Name = "PWTRANTYPE";
txtCol5.HeaderText = "ประเภท";
txtCol5.IsVisible = true;
this.radGridTimeTemp.Columns.Add(txtCol5);
GridViewTextBoxColumn txtCol6 = new GridViewTextBoxColumn();
txtCol6.FieldName = "PWEVENT";
txtCol6.Name = "PWEVENT";
txtCol6.HeaderText = "เหตุการณ์";
txtCol6.IsVisible = true;
this.radGridTimeTemp.Columns.Add(txtCol6);
#endregion
#region <MenuItem>
toolStripBtnExportExcel.Click += new EventHandler(toolStripBtnExportExcel_Click);
#endregion
}
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 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";
}
private void FormateGrid()
{
try
{
grdAcceptorPooljobs.ShowGroupPanel = false;
grdAcceptorPooljobs.ShowGroupedColumns = false;
grdAcceptorPooljobs.AllowAddNewRow = false;
GridViewTextBoxColumn col = new GridViewTextBoxColumn();
col.HeaderText = "Ref #";
col.Name = "RefNumber";
col.Width = 70;
col.ReadOnly = true;
grdAcceptorPooljobs.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.HeaderText = "PickupDateTime";
col.Name = "PickupDateTime";
col.IsVisible = false;
col.Width = 140;
col.ReadOnly = true;
grdAcceptorPooljobs.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.HeaderText = "Date/Time";
col.Name = "PickUpDate";
col.Width = 140;
col.ReadOnly = true;
grdAcceptorPooljobs.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.HeaderText = "Time";
col.Name = "Time";
col.ReadOnly = true;
col.IsVisible = false;
col.Width = 45;
grdAcceptorPooljobs.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.HeaderText = "Passenger";
col.Name = "Passenger";
col.ReadOnly = true;
col.Width = 90;
grdAcceptorPooljobs.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.HeaderText = "From";
col.ReadOnly = true;
col.Name = "From";
col.Width = 160;
grdAcceptorPooljobs.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.HeaderText = "To";
col.ReadOnly = true;
col.Name = "To";
col.Width = 160;
grdAcceptorPooljobs.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.HeaderText = "Vehicle";
col.ReadOnly = true;
col.Name = "Vehicle";
col.Width = 90;
grdAcceptorPooljobs.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.HeaderText = "Account";
col.Name = "Account";
col.ReadOnly = true;
col.Width = 65;
col.IsVisible = true;
grdAcceptorPooljobs.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.HeaderText = "Notes";
col.Name = "Notes";
col.Width = 90;
grdAcceptorPooljobs.Columns.Add(col);
GridViewDecimalColumn col2 = new GridViewDecimalColumn();
col2.HeaderText = "Offer Price";
col2.Name = "OfferPrice";
col2.DecimalPlaces = 2;
col2.FormatString = "{0:#,###0.00}";
col2.Maximum = 10000;
col2.Minimum = 0;
col2.Width = 80;
col2.ReadOnly = true;
grdAcceptorPooljobs.Columns.Add(col2);
col2 = new GridViewDecimalColumn();
col2.HeaderText = "Bid";
col2.Name = "Bid";
col2.DecimalPlaces = 2;
col2.ReadOnly = false;
col2.FormatString = "{0:#,###0.00}";
col2.Maximum = 10000;
col2.Minimum = 0;
col2.Width = 63;
col2.ReadOnly = false;
grdAcceptorPooljobs.Columns.Add(col2);
col = new GridViewTextBoxColumn();
col.HeaderText = "Provider";
col.Name = "Provider";
col.Width = 80;
col.IsVisible = false;
grdAcceptorPooljobs.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.HeaderText = "Status";
col.Name = "Status";
col.Width = 70;
col.IsVisible = false;
grdAcceptorPooljobs.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.HeaderText = "Driver No";
col.Name = "DriverNo";
col.Width = 65;
col.IsVisible = false;
grdAcceptorPooljobs.Columns.Add(col);
//col = new GridViewTextBoxColumn();
//col.HeaderText = "Accept";
//col.Name = "Accept";
//col.Width = 55;
//grdAcceptorPooljobs.Columns.Add(col);
grdAcceptorPooljobs.ShowRowHeaderColumn = false;
}
catch (Exception ex)
{
}
}
private void FormatFaresGrid()
{
grdFares.AllowAddNewRow = false;
grdFares.AllowEditRow = true;
GridViewCheckBoxColumn cbcol = new GridViewCheckBoxColumn();
cbcol.HeaderText = "";
cbcol.Name = COLS.CheckBox;
//cbcol.AutoSizeMode = BestFitColumnMode.None;
cbcol.Width = 40;
cbcol.ReadOnly = false;
grdFares.Columns.Add(cbcol);
GridViewTextBoxColumn col = new GridViewTextBoxColumn();
col.Name = COLS.Id;
col.IsVisible = false;
col.ReadOnly = true;
grdFares.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.Name = COLS.RowNo;
col.IsVisible = false;
col.ReadOnly = true;
grdFares.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.HeaderText = "Pickup";
col.Name = COLS.Pickup;
col.Width = 240;
col.IsVisible = true;
col.ReadOnly = true;
grdFares.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.HeaderText = "Destination";
col.Name = COLS.Destination;
col.Width = 240;
col.IsVisible = true;
col.ReadOnly = true;
grdFares.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.HeaderText = "ViaPoints";
col.Name = COLS.ViaPoints;
col.Width = 150;
col.IsVisible = true;
col.ReadOnly = true;
grdFares.Columns.Add(col);
col = new GridViewTextBoxColumn();
col.HeaderText = "A/C";
col.Name = COLS.CompanyName;
col.Width = 100;
col.IsVisible = true;
col.ReadOnly = true;
grdFares.Columns.Add(col);
GridViewDecimalColumn colDec = new GridViewDecimalColumn();
colDec.HeaderText = "Drv Fares";
colDec.Name = COLS.DriverFares;
colDec.Width = 70;
col.IsVisible = true;
col.ReadOnly = false;
colDec.ThousandsSeparator = true;
grdFares.Columns.Add(colDec);
colDec = new GridViewDecimalColumn();
colDec.HeaderText = "Drv R/Fares";
colDec.Name = COLS.DriverRtnFares;
colDec.Width = 85;
col.IsVisible = true;
col.ReadOnly = false;
colDec.ThousandsSeparator = true;
grdFares.Columns.Add(colDec);
colDec = new GridViewDecimalColumn();
colDec.HeaderText = "Cust Fares";
colDec.Name = COLS.CustomerFares;
colDec.Width = 80;
colDec.DecimalPlaces = 2;
col.ReadOnly = false;
colDec.ThousandsSeparator = true;
grdFares.Columns.Add(colDec);
//grdFares.MasterTemplate.ShowRowHeaderColumn = false;
colDec = new GridViewDecimalColumn();
colDec.HeaderText = "Cust R/Fares";
colDec.Name = COLS.CustomerRtnFares;
colDec.Width = 95;
colDec.IsVisible = true;
col.ReadOnly = false;
colDec.ThousandsSeparator = true;
grdFares.Columns.Add(colDec);
colDec = new GridViewDecimalColumn();
colDec.HeaderText = "A/C Fares";
colDec.Name = COLS.CompanyFares;
colDec.Width = 80;
colDec.IsVisible = true;
col.ReadOnly = false;
colDec.ThousandsSeparator = true;
grdFares.Columns.Add(colDec);
colDec = new GridViewDecimalColumn();
colDec.HeaderText = "A/C RtnFares";
colDec.Name = COLS.CompanyRtnFares;
colDec.Width = 95;
colDec.IsVisible = true;
col.ReadOnly = false;
colDec.ThousandsSeparator = true;
grdFares.Columns.Add(colDec);
col = new GridViewTextBoxColumn();
col.HeaderText = "CompanyId";
col.Name = COLS.CompanyId;
col.Width = 70;
col.IsVisible = false;
col.ReadOnly = true;
grdFares.Columns.Add(col);
GridViewCommandColumn colbtn = new GridViewCommandColumn();
colbtn.Width = 70;
colbtn.UseDefaultText = true;
colbtn.DefaultText = "Update";
colbtn.Name = "Update";
colbtn.IsVisible = true;
grdFares.Columns.Add(colbtn);
colbtn = new GridViewCommandColumn();
colbtn.Width = 60;
colbtn.UseDefaultText = true;
colbtn.DefaultText = "Delete";
colbtn.Name = "Delete";
colbtn.IsVisible = true;
grdFares.Columns.Add(colbtn);
UI.GridFunctions.SetFilter(grdFares);
}
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 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;
}
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 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);
}
