private void InitializeConstructor() { ComboFunctions.FillCompanyCombo(ddlCompany); ComboFunctions.FillBookingTypeCombo(ddlBookingType); ddlBookingType.SelectedValue = Enums.BOOKING_TYPES.LOCAL; dtpInvoiceDate.Value = DateTime.Now.ToDate(); dtpDueDate.Value = DateTime.Now.ToDate().AddMonths(1); FormatChargesGrid(); grdLister.ShowGroupPanel = false; grdLister.AutoCellFormatting = true; grdLister.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill; grdLister.ShowRowHeaderColumn = false; objMaster = new InvoiceBO(); this.SetProperties((INavigation)objMaster); grdLister.AllowAddNewRow = false; dtpFromDate.Value = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1); dtpTillDate.Value = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.LastDayOfMonthValue()); grdLister.CommandCellClick += new CommandCellClickEventHandler(grdLister_CommandCellClick); }
public override void OnNew() { txtInvoiceNo.Text = string.Empty; ComboFunctions.FillCompanyCombo(ddlCompany); chkDepartmentWise.Checked = false; chkCostCenterWise.Checked = false; grdLister.Rows.Clear(); txtInvoiceAmount.Text = string.Empty; }
public rptfrmJobActivity() { InitializeComponent(); ComboFunctions.FillCompanyCombo(ddlCompany); dtpFromDate.Value = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1); dtpTillDate.Value = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.LastDayOfMonthValue()); }
private void rptfrmAccountInvoiceSummary_Load(object sender, System.EventArgs e) { this.FormTitle = "Account Invoice Summary"; dtpTillDate.Value = DateTime.Now.ToDate(); dtpFromDate.Value = DateTime.Now.ToDate().AddMonths(-1); ComboFunctions.FillCompanyCombo(ddlCompany); ddlCompany.Enabled = false; chkAll.Checked = true; }
void frmDriverReport_Load(object sender, EventArgs e) { ComboFunctions.FillCompanyCombo(ddlCompany); ComboFunctions.FillDriverNoComboSorted(ddlDriver); dtpFromDate.Value = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1); dtpTillDate.Value = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.LastDayOfMonthValue()); IsLoaded = true; }
public frmCompanyCostCenter(int companyId) { InitializeComponent(); ComboFunctions.FillCompanyCombo(ddlCompany); this.Shown += new EventHandler(frmCompanyDepartments_Shown); objMaster = new CompanyCostCenterBO(); this.SetProperties((INavigation)objMaster); ddlCompany.SelectedValue = companyId; this.CompanyId = companyId; }
public frmPreAccInvoiceReport() { InitializeComponent(); this.Load += new EventHandler(frmInvoiceReport_Load); ComboFunctions.FillCompanyCombo(ddlCompany); dtpFromDate.Value = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1); dtpTillDate.Value = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.LastDayOfMonthValue()); }
private void rptfrmDriverLoginHistory_Load(object sender, EventArgs e) { try { ComboFunctions.FillCompanyCombo(ddl_Company, 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()); } catch (Exception ex) { } }
public frmCompanyWebLogin(int companyId) { InitializeComponent(); ComboFunctions.FillCompanyCombo(ddlCompany); this.Shown += new EventHandler(frmCompanyDepartments_Shown); objMaster = new CompanyWebLoginBO(); this.SetProperties((INavigation)objMaster); ddlCompany.SelectedValue = companyId; this.CompanyId = companyId; chkActivateLogin.Checked = true; }
private void FillCombos() { ComboFunctions.FillVehicleTypeCombo(ddlVehicleType); ComboFunctions.FillCompanyCombo(ddlCompany); ComboFunctions.FillSubCompanyCombo(ddlSubCompanyId); if (ddlSubCompanyId.Items.Count == 0) { ddlSubCompanyId.SelectedIndex = 0; } }
public frmComplaint(int Id, List <Complaint> listofComplaints, long jobId, string jobRefNo, string customerName, string customerPhoneNo, string customerAddress, bool IsHide) { try { InitializeComponent(); InitializeConstructor(); grdLister.ShowRowHeaderColumn = false; ComboFunctions.FillCompanyCombo(ddlAccount); IsHidePopulateDate = IsHide; txtJobRef.Text = jobRefNo; txtJobRef.Tag = jobId; txtJobRef.Enabled = false; if (Id != 0) { this.listOfBookingComplaints = listofComplaints; objMaster.GetByPrimaryKey(Id); DisplayRecord(); } else { grdLister.Enabled = false; radPanel2.Enabled = false; btnOnNew.Enabled = false; txtCustomerName.Text = customerName.ToStr(); txtAddressDetail.Text = customerAddress.ToStr(); txtPhoneNo.Text = customerPhoneNo.ToStr(); } } catch (Exception ex) { } }
void chkAllCompany_ToggleStateChanged(object sender, StateChangedEventArgs args) { if (args.ToggleState == ToggleState.On) { ddlCompany.SelectedValue = null; ddlCompany.Enabled = false; } else { if (ddlCompany.DataSource == null) { ComboFunctions.FillCompanyCombo(ddlCompany); } ddlCompany.Enabled = true; } }
private void chkAllAcc_ToggleStateChanged(object sender, StateChangedEventArgs args) { if (args.ToggleState == Telerik.WinControls.Enumerations.ToggleState.On) { if (ddlCompany.DataSource == null) { ComboFunctions.FillCompanyCombo(ddlCompany); } ddlCompany.Enabled = true; } else { ddlCompany.Enabled = false; ddlCompany.SelectedValue = null; } }
private void InitializeConstructor() { var obj = General.GetObject <Gen_SysPolicy_DocumentNumberSetup>(c => c.DocumentId == Enums.GEN_DOCUMENTS.INVOICENO && (c.AutoIncrement == null || c.AutoIncrement == false)); if (obj != null) { txtInvoiceNo.ReadOnly = false; txtInvoiceNo.Enabled = true; this.AutoInc = false; } ComboFunctions.FillCompanyCombo(ddlCompany); ComboFunctions.FillBookingTypeCombo(ddlBookingType); ddlBookingType.SelectedValue = Enums.BOOKING_TYPES.LOCAL; dtpInvoiceDate.Value = DateTime.Now.ToDate(); dtpDueDate.Value = DateTime.Now.ToDate().AddMonths(1); FormatChargesGrid(); grdLister.ShowGroupPanel = false; // grdLister.AutoCellFormatting = true; grdLister.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill; grdLister.ShowRowHeaderColumn = false; objMaster = new InvoiceBO(); this.SetProperties((INavigation)objMaster); grdLister.AllowAddNewRow = false; dtpFromDate.Value = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1); dtpTillDate.Value = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.LastDayOfMonthValue()); grdLister.CommandCellClick += new CommandCellClickEventHandler(grdLister_CommandCellClick); grdLister.ContextMenuOpening += new ContextMenuOpeningEventHandler(grdLister_ContextMenuOpening); }
void frmDriverReport_Load(object sender, EventArgs e) { ComboFunctions.FillCompanyCombo(ddlCompany, c => c.IsAgent != null && c.IsAgent == true); ComboFunctions.FillCompanyGroupCombo(ddlGroup); ComboFunctions.FillSubCompanyCombo(ddlSubCompany); dtpFromDate.Value = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1); dtpTillDate.Value = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.LastDayOfMonthValue()); IsLoaded = true; // this.TemplatePath = General.GetObject<UM_Form_Template>(c => c.UM_Form.FormName == this.Name && c.IsDefault == true).DefaultIfEmpty().TemplateName.ToStr().Trim(); //if (this.TemplatePath.ToStr().ToLower() == "template3" || this.TemplatePath.ToStr().ToLower() == "template4") //{ // chkShowCharges.Visible = true; //} // chkShowCharges.Visible = true; ddlSubCompany.SelectedValue = AppVars.objSubCompany.Id; ddlSubCompany.SelectedValueChanged += new EventHandler(ddlSubCompany_SelectedValueChanged); }
void frmCompanyIncomeReport_Load(object sender, EventArgs e) { // ViewReport(); // ComboFunctions.FillDriverNoCombo(ddlDriver); TimeSpan tillTime = TimeSpan.Zero; TimeSpan.TryParse("23:59:59", out tillTime); dtpTillDate.Value = (new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.LastDayOfMonthValue()).Date); dtptilltime.Value = dtpTillDate.Value.Value.Date + tillTime; ComboFunctions.FillCompanyCombo(ddlCompany); ComboFunctions.FillSubCompanyCombo(ddlSubCompany); ddlCompany.Enabled = 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 = "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 = COLS.Driver; col.Name = COLS.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); 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 = COLS.Driver; //col.Name = COLS.Driver; //grdLister.Columns.Add(col); GridViewDecimalColumn colD = new GridViewDecimalColumn(); colD.DecimalPlaces = 2; colD.Minimum = 0; colD.ReadOnly = true; colD.HeaderText = "Charges"; colD.Name = "Charges"; colD.Maximum = 9999999; colD.FormatString = "{0:#,###0.00}"; grdLister.Columns.Add(colD); colD = new GridViewDecimalColumn(); colD.DecimalPlaces = 2; colD.Minimum = 0; colD.ReadOnly = true; colD.HeaderText = "Parking"; colD.Name = "Parking"; colD.Maximum = 9999999; colD.FormatString = "{0:#,###0.00}"; grdLister.Columns.Add(colD); colD = new GridViewDecimalColumn(); colD.DecimalPlaces = 2; colD.Minimum = 0; colD.ReadOnly = true; colD.HeaderText = "Waiting"; colD.Name = "Waiting"; colD.Maximum = 9999999; colD.FormatString = "{0:#,###0.00}"; grdLister.Columns.Add(colD); colD = new GridViewDecimalColumn(); colD.DecimalPlaces = 2; colD.Minimum = 0; colD.ReadOnly = true; colD.HeaderText = "Extra Drop"; colD.Name = "ExtraDrop"; colD.Maximum = 9999999; colD.FormatString = "{0:#,###0.00}"; grdLister.Columns.Add(colD); //colD = new GridViewDecimalColumn(); //colD.DecimalPlaces = 2; //colD.Minimum = 0; //colD.HeaderText = "M & G"; //colD.ReadOnly = true; //colD.Name = "MeetAndGreet"; //colD.Maximum = 9999999; //colD.FormatString = "{0:#,###0.00}"; //grdLister.Columns.Add(colD); //colD = new GridViewDecimalColumn(); //colD.DecimalPlaces = 2; //colD.Minimum = 0; //colD.ReadOnly = true; //colD.HeaderText = "Congestion"; //colD.Name = "CongtionCharge"; //colD.Maximum = 9999999; //colD.FormatString = "{0:#,###0.00}"; //grdLister.Columns.Add(colD); colD = new GridViewDecimalColumn(); colD.DecimalPlaces = 2; colD.Minimum = 0; colD.ReadOnly = true; colD.ReadOnly = true; colD.HeaderText = "Total"; colD.Name = "Total"; colD.Maximum = 9999999; colD.FormatString = "{0:#,###0.00}"; colD.Expression = "Charges+Parking+Waiting+ExtraDrop"; grdLister.Columns.Add(colD); // grdLister.Columns["Id"].IsVisible = false; (grdLister.Columns["PickUpDate"] as GridViewDateTimeColumn).CustomFormat = "dd/MM/yyyy HH:mm"; (grdLister.Columns["PickUpDate"] as GridViewDateTimeColumn).FormatString = "{0:dd/MM/yyyy HH:mm}"; grdLister.Columns["PickUpDate"].Width = 90; grdLister.Columns["RefNumber"].Width = 40; grdLister.Columns["Vehicle"].Width = 50; //grdLister.Columns["Account"].Width = 60; grdLister.Columns[COLS.Driver].Width = 40; grdLister.Columns["PickUpPoint"].Width = 110; grdLister.Columns["Destination"].Width = 110; // grdLister.Columns[COLS.Driver].Width = 40; grdLister.Columns["Account"].Width = 60; grdLister.Columns["Charges"].Width = 45; grdLister.Columns["Parking"].Width = 45; grdLister.Columns["Waiting"].Width = 50; grdLister.Columns["ExtraDrop"].Width = 60; //grdLister.Columns["MeetAndGreet"].Width = 60; //grdLister.Columns["CongtionCharge"].Width = 70; grdLister.Columns["Total"].Width = 40; grdLister.Columns["PickUpDate"].HeaderText = "Pickup Date-Time"; grdLister.Columns["RefNumber"].HeaderText = "Ref #"; grdLister.Columns["PickUpPoint"].HeaderText = "Pickup Point"; grdLister.Columns["ExtraDrop"].HeaderText = "Extra Drop"; }
private void FillCombo() { ComboFunctions.FillCompanyCombo(ddlCompany); ComboFunctions.FillSubCompanyCombo(ddlSubCompany); }
public override void DisplayRecord() { if (objMaster.Current == null) { return; } btnExportPDF.Enabled = true; btnPrint.Enabled = true; btnSendEmail.Enabled = true; ddlBookingType.SelectedValue = objMaster.Current.BookingTypeId; txtInvoiceNo.Text = objMaster.Current.InvoiceNo.ToStr(); dtpInvoiceDate.Value = objMaster.Current.InvoiceDate.ToDate(); if (objMaster.Current.CompanyId != null && objMaster.Current.Gen_Company.IsClosed.ToBool()) { var data = (List <Gen_Company>)ddlCompany.DataSource; data.Add(objMaster.Current.Gen_Company); ComboFunctions.FillCompanyCombo(ddlCompany, data); } ddlCompany.SelectedValue = objMaster.Current.CompanyId; dtpDueDate.Value = objMaster.Current.DueDate.ToDate(); ddlDepartment.SelectedValue = objMaster.Current.DepartmentId; chkDepartmentWise.Checked = objMaster.Current.DepartmentWise.ToBool(); ddlCostCenter.SelectedValue = objMaster.Current.CostCenterId; chkCostCenterWise.Checked = objMaster.Current.CostCenterWise.ToBool(); int cnt = objMaster.Current.Invoice_Charges.Count; var list = objMaster.Current.Invoice_Charges; grdLister.RowCount = cnt; Booking objBooking = null; for (int i = 0; i < cnt; i++) { grdLister.Rows[i].Cells[COLS.ID].Value = list[i].Id; grdLister.Rows[i].Cells[COLS.InvoiceId].Value = list[i].InvoiceId; grdLister.Rows[i].Cells[COLS.BookingId].Value = list[i].BookingId; objBooking = list[i].Booking; if (objBooking != null) { grdLister.Rows[i].Cells[COLS.Payment_ID].Value = objBooking.InvoicePaymentTypeId; grdLister.Rows[i].Cells[COLS.PickupDate].Value = objBooking.PickupDateTime; grdLister.Rows[i].Cells[COLS.OrderNo].Value = objBooking.OrderNo; grdLister.Rows[i].Cells[COLS.PupilNo].Value = objBooking.PupilNo; grdLister.Rows[i].Cells[COLS.BookedBy].Value = objBooking.Gen_Company_Department.DefaultIfEmpty().DepartmentName.ToStr(); grdLister.Rows[i].Cells[COLS.Vehicle].Value = objBooking.Fleet_VehicleType.VehicleType; grdLister.Rows[i].Cells[COLS.VehicleID].Value = objBooking.VehicleTypeId; grdLister.Rows[i].Cells[COLS.RefNumber].Value = objBooking.BookingNo; //grdLister.Rows[i].Cells[COLS.Charges].Value = objBooking.FareRate.ToDecimal(); grdLister.Rows[i].Cells[COLS.Charges].Value = objBooking.CompanyPrice.ToDecimal(); grdLister.Rows[i].Cells[COLS.Parking].Value = objBooking.ParkingCharges.ToDecimal(); grdLister.Rows[i].Cells[COLS.PickupPoint].Value = !string.IsNullOrEmpty(objBooking.FromDoorNo) ? objBooking.FromDoorNo + " - " + objBooking.FromAddress.ToStr():objBooking.FromAddress.ToStr(); grdLister.Rows[i].Cells[COLS.Destination].Value = !string.IsNullOrEmpty(objBooking.ToDoorNo) ? objBooking.ToDoorNo + " - " + objBooking.ToAddress.ToStr() : objBooking.ToAddress.ToStr(); grdLister.Rows[i].Cells[COLS.Waiting].Value = objBooking.WaitingCharges.ToDecimal(); grdLister.Rows[i].Cells[COLS.ExtraDrop].Value = objBooking.ExtraDropCharges.ToDecimal(); grdLister.Rows[i].Cells[COLS.MeetAndGreet].Value = objBooking.MeetAndGreetCharges.ToDecimal(); grdLister.Rows[i].Cells[COLS.CongtionCharge].Value = objBooking.CongtionCharges.ToDecimal(); grdLister.Rows[i].Cells[COLS.Total].Value = objBooking.TotalCharges.ToDecimal(); grdLister.Rows[i].Cells[COLS.Passenger].Value = objBooking.CustomerName.ToStr().Trim(); } } grdLister.CurrentRow = null; txtInvoiceAmount.Text = objMaster.Current.InvoiceTotal.ToDecimal().ToStr(); }
private void FillCombo() { ComboFunctions.FillCompanyCombo(ddlAccount); }
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) { } }