public void PopulateLevel() { DataTable dtLevel = new DataTable(); dtLevel = FlatUnitBL.GetSOLevel(m_iCCId); Level.DataSource = dtLevel; Level.PopulateColumns(); Level.DisplayMember = "LevelName"; Level.ValueMember = "LevelId"; Level.Columns["LevelId"].Visible = false; Level.ShowFooter = false; Level.ShowHeader = false; }
public void PopulateBlock() { DataTable dtBlock = new DataTable(); dtBlock = FlatUnitBL.GetSOBlock(m_iCCId); Block.DataSource = dtBlock; Block.PopulateColumns(); Block.DisplayMember = "BlockName"; Block.ValueMember = "BlockId"; Block.Columns["BlockId"].Visible = false; Block.ShowFooter = false; Block.ShowHeader = false; }
private void PopulateData() { DataTable dtB = new DataTable(); DataTable dtL = new DataTable(); DataTable dtT = new DataTable(); dtB = FlatUnitBL.GetBlock(m_iCCId); if (dtB.Rows.Count > 0) { cboBlock.Properties.DataSource = dtB; cboBlock.Properties.PopulateColumns(); cboBlock.Properties.DisplayMember = "BlockName"; cboBlock.Properties.ValueMember = "BlockId"; cboBlock.Properties.Columns["BlockId"].Visible = false; cboBlock.Properties.ShowFooter = false; cboBlock.Properties.ShowHeader = false; } dtL = FlatUnitBL.GetLevel(m_iCCId); if (dtL.Rows.Count > 0) { cboLevel.Properties.DataSource = dtL; cboLevel.Properties.PopulateColumns(); cboLevel.Properties.DisplayMember = "LevelName"; cboLevel.Properties.ValueMember = "LevelId"; cboLevel.Properties.Columns["LevelId"].Visible = false; cboLevel.Properties.ShowFooter = false; cboLevel.Properties.ShowHeader = false; } dtT = FlatUnitBL.GetFlatType(m_iCCId); if (dtT.Rows.Count > 0) { cboFlatType.Properties.DataSource = dtT; cboFlatType.Properties.PopulateColumns(); cboFlatType.Properties.DisplayMember = "TypeName"; cboFlatType.Properties.ValueMember = "FlatTypeId"; cboFlatType.Properties.Columns["FlatTypeId"].Visible = false; cboFlatType.Properties.ShowFooter = false; cboFlatType.Properties.ShowHeader = false; } }
private void PopulateFlat() { grdSort.DataSource = null; DataTable dt = new DataTable(); dt = FlatUnitBL.GetSOFlat(m_iCCId, m_iBlockId, m_iLevelId); grdSort.DataSource = dt; grdViewSort.PopulateColumns(); grdViewSort.Columns["FlatId"].Visible = false; grdViewSort.Appearance.HeaderPanel.Font = new Font(grdViewSort.Appearance.HeaderPanel.Font, FontStyle.Bold); grdViewSort.Appearance.FocusedCell.BackColor = Color.Teal; grdViewSort.Appearance.FocusedCell.ForeColor = Color.White; grdViewSort.Appearance.FocusedRow.ForeColor = Color.Teal; grdViewSort.Appearance.FocusedRow.BackColor = Color.White; grdViewSort.OptionsSelection.EnableAppearanceHideSelection = false; }
private void btnOK_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { if (cboBlock.EditValue == DBNull.Value || cboBlock.EditValue == null) { MessageBox.Show("Select Block"); cboBlock.Focus(); return; } if (cboLevel.EditValue == DBNull.Value || cboLevel.EditValue == null) { MessageBox.Show("Select Level"); cboLevel.Focus(); return; } if (cboFlatType.EditValue == DBNull.Value || cboFlatType.EditValue == null) { MessageBox.Show("Select FlatType"); cboFlatType.Focus(); return; } if (CommFun.IsNullCheck(txtFlatNo.EditValue, CommFun.datatypes.vartypestring).ToString() == "") { MessageBox.Show("Enter Flat No"); txtFlatNo.Focus(); return; } bool bAns = FlatUnitBL.GetFlatNoFound(m_iCCId, txtFlatNo.EditValue.ToString()); if (bAns == true) { MessageBox.Show("Flat No Already Exist"); txtFlatNo.Text = ""; txtFlatNo.Focus(); return; } int iBlockId = Convert.ToInt32(cboBlock.EditValue); int ilevelId = Convert.ToInt32(cboLevel.EditValue); int iFlatTypeId = Convert.ToInt32(cboFlatType.EditValue); FlatUnitBL.InsertFlatUnit(m_iCCId, iBlockId, ilevelId, iFlatTypeId, txtFlatNo.EditValue.ToString()); Close(); }
private void UpdateSortOrder(DataTable argdt) { FlatUnitBL.UpdateSortOrder(argdt); }