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);
}
