private void PopulateBroker() { dtB = new DataTable(); dtB = BrokerBL.getVendor(m_iBrokerId); cboBroker.Properties.DataSource = dtB; cboBroker.Properties.DisplayMember = "BrokerName"; cboBroker.Properties.ValueMember = "VendorId"; cboBroker.Properties.PopulateColumns(); cboBroker.Properties.Columns["VendorId"].Visible = false; cboBroker.Properties.ShowHeader = false; cboBroker.Properties.ShowFooter = false; }
private void cboBroker_EditValueChanged(object sender, EventArgs e) { DGVTrans.DataSource = null; try { int i_BrokerId = Convert.ToInt32(CommFun.IsNullCheck(cboBroker.EditValue, CommFun.datatypes.vartypenumeric)); if (i_BrokerId == 0) { return; } dtCC = new DataTable(); dtCC = BrokerBL.getCostCentre(i_BrokerId); DGVTrans.DataSource = dtCC; dgvTransView.PopulateColumns(); dgvTransView.Columns["CostCentreId"].Visible = false; dgvTransView.Columns["BrokerType"].Visible = false; dgvTransView.Columns["CostCentreName"].OptionsColumn.AllowEdit = false; dgvTransView.Columns["PerBased"].OptionsColumn.AllowEdit = true; dgvTransView.Columns["CommType"].OptionsColumn.AllowEdit = true; dgvTransView.Columns["CommPer"].OptionsColumn.AllowEdit = true; dgvTransView.Columns["Amount"].OptionsColumn.AllowEdit = true; dgvTransView.Columns["PerBased"].Caption = "Commission Based"; dgvTransView.Columns["CommType"].Caption = "Commission Type"; dgvTransView.Columns["CommPer"].Caption = "Commission %"; dgvTransView.Columns["PerBased"].ColumnEdit = repositoryItemComboBox1; dgvTransView.Columns["CommType"].ColumnEdit = repositoryItemComboBox2; dgvTransView.Columns["CommPer"].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Far; dgvTransView.Columns["Sel"].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center; dgvTransView.OptionsView.NewItemRowPosition = DevExpress.XtraGrid.Views.Grid.NewItemRowPosition.None; dgvTransView.Appearance.HeaderPanel.Font = new Font(dgvTransView.Appearance.HeaderPanel.Font, FontStyle.Bold); dgvTransView.OptionsSelection.InvertSelection = true; dgvTransView.OptionsSelection.EnableAppearanceHideSelection = false; dgvTransView.Appearance.FocusedRow.ForeColor = Color.White; dgvTransView.Appearance.FocusedRow.BackColor = Color.Teal; } catch (Exception ex) { throw ex; } }
public void FillCC() { try { dtCC = new DataTable(); if (m_iBrokerId != 0) { dtCC = BrokerBL.getBrokerCostCentre(m_iBrokerId, m_iVendorId); } else { dtCC = BrokerBL.getCostCentre(0); } DGVTrans.DataSource = dtCC; dgvTransView.PopulateColumns(); dgvTransView.Columns["CostCentreId"].Visible = false; dgvTransView.Columns["BrokerType"].Visible = false; dgvTransView.Columns["CostCentreName"].OptionsColumn.AllowEdit = false; dgvTransView.Columns["PerBased"].OptionsColumn.AllowEdit = true; dgvTransView.Columns["CommType"].OptionsColumn.AllowEdit = true; dgvTransView.Columns["CommPer"].OptionsColumn.AllowEdit = true; dgvTransView.Columns["Amount"].OptionsColumn.AllowEdit = true; dgvTransView.Columns["PerBased"].Caption = "Commission Based"; dgvTransView.Columns["CommType"].Caption = "Commission Type"; dgvTransView.Columns["CommPer"].Caption = "Commission %"; dgvTransView.Columns["PerBased"].ColumnEdit = repositoryItemComboBox1; dgvTransView.Columns["CommType"].ColumnEdit = repositoryItemComboBox2; dgvTransView.Columns["CommPer"].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Far; dgvTransView.Columns["Sel"].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center; dgvTransView.OptionsView.NewItemRowPosition = DevExpress.XtraGrid.Views.Grid.NewItemRowPosition.None; dgvTransView.Appearance.HeaderPanel.Font = new Font(dgvTransView.Appearance.HeaderPanel.Font, FontStyle.Bold); dgvTransView.OptionsSelection.InvertSelection = true; dgvTransView.OptionsSelection.EnableAppearanceHideSelection = false; dgvTransView.Appearance.FocusedRow.ForeColor = Color.White; dgvTransView.Appearance.FocusedRow.BackColor = Color.Teal; } catch (Exception e) { throw e; } }
public void FillData() { try { DataTable dt = new DataTable(); dt = BrokerBL.getVendorDetails(m_iBrokerId); if (dt.Rows.Count > 0) { cboBroker.EditValue = Convert.ToInt32(CommFun.IsNullCheck(dt.Rows[0]["VendorId"].ToString(), CommFun.datatypes.vartypenumeric)); } } catch (Exception e) { throw e; } }
public void f_Update() { BrokerBL.UpdateBroker(m_iBrokerId, Convert.ToInt32(cboBroker.EditValue), dtCC); }