private void grdBlockView_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e) { //bool bAns = false; int iBlockId = Convert.ToInt32(CommFun.IsNullCheck(grdBlockView.GetRowCellValue(grdBlockView.FocusedRowHandle, "BlockId").ToString(), CommFun.datatypes.vartypenumeric)); BOStageDetails.s_BlockName = grdBlockView.GetRowCellValue(grdBlockView.FocusedRowHandle, "BlockName").ToString(); BOStageDetails.i_SortOrderBlock = grdBlockView.RowCount; BOStageDetails.i_CostCentreId = m_icostCentreId; if (CommFun.IsNullCheck(grdBlockView.GetFocusedRowCellValue(grdBlockView.Columns[1].FieldName).ToString(), CommFun.datatypes.vartypestring).ToString().Trim() == "") { grdBlockView.CancelUpdateCurrentRow(); return; } //bAns = StageDetDL.CheckBlockFound(BOStageDetails); //if (bAns == true) { MessageBox.Show("Block Name Already Exist"); grdBlockView.CancelUpdateCurrentRow(); return; } if (iBlockId == 0) { iBlockId = StageDetBL.InsertBlock(BOStageDetails); grdBlockView.SetRowCellValue(grdBlockView.FocusedRowHandle, "BlockId", iBlockId); grdBlockView.SetRowCellValue(grdBlockView.FocusedRowHandle, "SortOrder", BOStageDetails.i_SortOrderBlock); } else { StageDetBL.UpdateBlock(BOStageDetails, iBlockId); } }
private void grdLevelBlockView_Click(object sender, EventArgs e) { if (selection.SelectedCount == 0) { for (int j = 0; j < grdLevelBlockView.RowCount; j++) { BOStageDetails.i_LevelBlockId = Convert.ToInt32(CommFun.IsNullCheck(grdLevelBlockView.GetRowCellValue(j, "LevelId"), CommFun.datatypes.vartypenumeric)); BOStageDetails.i_BlockId = Convert.ToInt32(CommFun.IsNullCheck(grdBlockView.GetRowCellValue(grdBlockView.FocusedRowHandle, "BlockId"), CommFun.datatypes.vartypenumeric)); StageDetBL.DeleteLevelBlock(BOStageDetails); } } else { for (int i = 0; i < selection.SelectedCount; i++) { BOStageDetails.i_LevelBlockId = Convert.ToInt32(CommFun.IsNullCheck(grdLevelBlockView.GetRowCellValue(i, "LevelId"), CommFun.datatypes.vartypenumeric)); BOStageDetails.i_BlockId = Convert.ToInt32(CommFun.IsNullCheck(grdBlockView.GetRowCellValue(grdBlockView.FocusedRowHandle, "BlockId"), CommFun.datatypes.vartypenumeric)); if (BOStageDetails.i_LevelBlockId != 0 || BOStageDetails.i_BlockId != 0) { StageDetBL.DeleteLevelBlock(BOStageDetails); StageDetBL.InsertLevelBlock(BOStageDetails); } else { MessageBox.Show("Please Select Block Name", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } } } }
private void FillLevel() { dtLevel = new DataTable(); dtLevel = StageDetBL.PopulateLevel(m_icostCentreId); grdLevel.DataSource = dtLevel; grdLevel.ForceInitialize(); grdLevelView.PopulateColumns(); grdLevelView.Columns["LevelId"].Visible = false; grdLevelView.Appearance.HeaderPanel.Font = new Font(grdLevelView.Appearance.HeaderPanel.Font, FontStyle.Bold); grdLevelView.Appearance.FocusedCell.BackColor = Color.Teal; grdLevelView.Appearance.FocusedCell.ForeColor = Color.White; grdLevelView.Appearance.FocusedRow.ForeColor = Color.Teal; grdLevelView.Appearance.FocusedRow.BackColor = Color.White; grdLevelView.OptionsSelection.EnableAppearanceHideSelection = false; }
private void btnDelStageLevel_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { int i_dStageLevelId = 0; int i_LevelId = 0; if (grdStagesLevelView.FocusedRowHandle >= 0 && grdLevelView.FocusedRowHandle >= 0) { i_LevelId = Convert.ToInt32(grdLevelView.GetFocusedRowCellValue("LevelId")); i_dStageLevelId = Convert.ToInt32(CommFun.IsNullCheck(grdStagesLevelView.GetRowCellValue(grdStagesLevelView.FocusedRowHandle, "StageId"), CommFun.datatypes.vartypenumeric)); if (MessageBox.Show("Do You want to Delete Row?", "Information", MessageBoxButtons.YesNo, MessageBoxIcon.Stop) == DialogResult.Yes) { StageDetBL.DeleteStageLevel(i_dStageLevelId, i_LevelId); grdStagesLevelView.DeleteRow(grdStagesLevelView.FocusedRowHandle); FillStages(); } } }
private void EditSetUp() { DataTable dt = new DataTable(); dt = StageDetBL.EditCarParkCodeSetup(m_iCCId, m_iBlockId); if (dt == null) { return; } if (dt.Rows.Count == 0) { return; } RGType.SelectedIndex = Convert.ToInt32(CommFun.IsNullCheck(dt.Rows[0]["Type"], CommFun.datatypes.vartypenumeric)); txtPrefix.Text = CommFun.IsNullCheck(dt.Rows[0]["Prefix"], CommFun.datatypes.vartypestring).ToString(); txtSuffix.Text = CommFun.IsNullCheck(dt.Rows[0]["Suffix"], CommFun.datatypes.vartypestring).ToString(); txtStartNo.Text = Convert.ToInt32(CommFun.IsNullCheck(dt.Rows[0]["StartNo"], CommFun.datatypes.vartypenumeric)).ToString(); txtWidth.Text = Convert.ToInt32(CommFun.IsNullCheck(dt.Rows[0]["Width"], CommFun.datatypes.vartypenumeric)).ToString(); }
private void FillLevelBlock() { grdLevelBlock.DataSource = null; if (i_BlockId != 0) { dtLevel = new DataTable(); dtLevel = StageDetBL.PopulateLevelBlock(i_BlockId, m_icostCentreId); grdLevelBlock.DataSource = dtLevel; grdLevelBlock.ForceInitialize(); grdLevelBlockView.PopulateColumns(); grdLevelBlockView.Columns["LevelId"].Visible = false; grdLevelBlockView.Columns["LevelName"].OptionsColumn.AllowEdit = false; selection = new GridSelectAll(grdLevelBlockView); selection.CheckMarkColumn.VisibleIndex = 2; } DataTable dt = new DataTable(); dt = StageDetBL.PopulateBlockLevel(i_BlockId, m_icostCentreId); if (dt != null && dtLevel != null) { for (int c = 0; c < dtLevel.Rows.Count; c++) { for (int c1 = 0; c1 < dt.Rows.Count; c1++) { if (Convert.ToInt32(dtLevel.Rows[c]["LevelId"]) == Convert.ToInt32(dt.Rows[c1]["LevelId"])) { grdLevelBlockView.SetRowCellValue(c, selection.CheckMarkColumn, true); } } } } grdLevelBlockView.Appearance.HeaderPanel.Font = new Font(grdLevelBlockView.Appearance.HeaderPanel.Font, FontStyle.Bold); grdLevelBlockView.Appearance.FocusedCell.BackColor = Color.Teal; grdLevelBlockView.Appearance.FocusedCell.ForeColor = Color.White; grdLevelBlockView.Appearance.FocusedRow.ForeColor = Color.Teal; grdLevelBlockView.Appearance.FocusedRow.BackColor = Color.White; grdLevelBlockView.OptionsSelection.EnableAppearanceHideSelection = false; }
private void btnOk_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { string sType = ""; if (RGType.SelectedIndex == 0) { sType = "M"; } else { sType = "A"; } string sPrefix = CommFun.IsNullCheck(txtPrefix.Text, CommFun.datatypes.vartypestring).ToString(); string sSuffix = CommFun.IsNullCheck(txtSuffix.Text, CommFun.datatypes.vartypestring).ToString(); int iStartNo = Convert.ToInt32(CommFun.IsNullCheck(txtStartNo.Text, CommFun.datatypes.vartypenumeric)); int iWidth = Convert.ToInt32(CommFun.IsNullCheck(txtWidth.Text, CommFun.datatypes.vartypenumeric)); StageDetBL.InsertCarParkCodeSetUp(m_iCCId, m_iBlockId, sType, sPrefix, sSuffix, iStartNo, iWidth); Close(); }
private void FillStageBlock() { grdStagesBlock.DataSource = null; if (i_BlockId != 0) { dtStages = new DataTable(); dtStages = StageDetBL.PopulateStageBlock(i_BlockId, m_icostCentreId); grdStagesBlock.DataSource = dtStages; grdStagesBlock.ForceInitialize(); grdStagesBlockView.PopulateColumns(); grdStagesBlockView.Columns["StageId"].Visible = false; } grdStagesBlockView.Appearance.HeaderPanel.Font = new Font(grdStagesBlockView.Appearance.HeaderPanel.Font, FontStyle.Bold); grdStagesBlockView.Appearance.FocusedCell.BackColor = Color.Teal; grdStagesBlockView.Appearance.FocusedCell.ForeColor = Color.White; grdStagesBlockView.Appearance.FocusedRow.ForeColor = Color.Teal; grdStagesBlockView.Appearance.FocusedRow.BackColor = Color.White; grdStagesBlockView.OptionsSelection.EnableAppearanceHideSelection = false; }
private void grdLevelBlockView_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e) { BOStageDetails.i_LevelBlockId = Convert.ToInt32(CommFun.IsNullCheck(grdLevelBlockView.GetRowCellValue(grdLevelBlockView.FocusedRowHandle, "LevelId"), CommFun.datatypes.vartypenumeric)); BOStageDetails.i_BlockId = Convert.ToInt32(CommFun.IsNullCheck(grdBlockView.GetRowCellValue(grdBlockView.FocusedRowHandle, "BlockId"), CommFun.datatypes.vartypenumeric)); if (selection.IsRowSelected(grdLevelBlockView.FocusedRowHandle) == true) { if (BOStageDetails.i_LevelBlockId != 0 || BOStageDetails.i_BlockId != 0) { StageDetBL.DeleteLevelBlock(BOStageDetails); StageDetBL.InsertLevelBlock(BOStageDetails); } else { MessageBox.Show("Please Select Block Name", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } } else { StageDetBL.DeleteLevelBlock(BOStageDetails); } }
private void grdLevelView_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e) { int iLevelId = Convert.ToInt32(CommFun.IsNullCheck(grdLevelView.GetRowCellValue(grdLevelView.FocusedRowHandle, "LevelId").ToString(), CommFun.datatypes.vartypenumeric)); BOStageDetails.s_LevelName = grdLevelView.GetRowCellValue(grdLevelView.FocusedRowHandle, "LevelName").ToString(); BOStageDetails.i_SortOrderLevel = grdLevelView.RowCount; BOStageDetails.i_CostCentreId = m_icostCentreId; if (CommFun.IsNullCheck(grdLevelView.GetFocusedRowCellValue(grdLevelView.Columns[1].FieldName).ToString(), CommFun.datatypes.vartypestring).ToString().Trim() == "") { grdLevelView.CancelUpdateCurrentRow(); return; } if (iLevelId == 0) { iLevelId = StageDetBL.InsertLevel(BOStageDetails); grdLevelView.SetRowCellValue(grdLevelView.FocusedRowHandle, "LevelId", iLevelId); grdLevelView.SetRowCellValue(grdLevelView.FocusedRowHandle, "SortOrder", BOStageDetails.i_SortOrderLevel); } else { StageDetBL.UpdateLevel(BOStageDetails, iLevelId); } }
private void btnDelete_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { int i_dBlockId = 0, i_dStageId = 0, i_dLevelId = 0; if (grdBlock.ContainsFocus == true) { if (grdBlockView.FocusedRowHandle >= 0) { i_dBlockId = Convert.ToInt32(CommFun.IsNullCheck(grdBlockView.GetRowCellValue(grdBlockView.FocusedRowHandle, "BlockId"), CommFun.datatypes.vartypenumeric)); if (i_dBlockId != 0) { if (MessageBox.Show("Do You want to Delete Row?", "Information", MessageBoxButtons.YesNo, MessageBoxIcon.Stop) == DialogResult.Yes) { StageDetBL.DeletBlock(i_dBlockId, m_icostCentreId); grdBlockView.DeleteRow(grdBlockView.FocusedRowHandle); DataTable dt = new DataTable(); dt = grdBlock.DataSource as DataTable; UpdateSortOrder(dt, "Block", m_icostCentreId); int iOrder = 0; for (int i = 0; i < grdBlockView.RowCount; i++) { iOrder = i + 1; grdBlockView.SetRowCellValue(i, "SortOrder", iOrder); } } } } } if (grdLevel.ContainsFocus == true) { if (grdLevelView.FocusedRowHandle >= 0) { i_dLevelId = Convert.ToInt32(CommFun.IsNullCheck(grdLevelView.GetRowCellValue(grdLevelView.FocusedRowHandle, "LevelId"), CommFun.datatypes.vartypenumeric)); if (i_dLevelId != 0) { if (MessageBox.Show("Do You want to Delete Row?", "Information", MessageBoxButtons.YesNo, MessageBoxIcon.Stop) == DialogResult.Yes) { StageDetBL.DeletLevel(i_dLevelId, m_icostCentreId); grdLevelView.DeleteRow(grdLevelView.FocusedRowHandle); DataTable dt = new DataTable(); dt = grdLevel.DataSource as DataTable; UpdateSortOrder(dt, "Level", m_icostCentreId); int iOrder = 0; for (int i = 0; i < grdLevelView.RowCount; i++) { iOrder = i + 1; grdLevelView.SetRowCellValue(i, "SortOrder", iOrder); } } } } } if (grdStages.ContainsFocus == true) { if (grdStagesView.FocusedRowHandle >= 0) { i_dStageId = Convert.ToInt32(CommFun.IsNullCheck(grdStagesView.GetRowCellValue(grdStagesView.FocusedRowHandle, "StageId"), CommFun.datatypes.vartypenumeric)); if (i_dStageId != 0) { if (MessageBox.Show("Do You want to Delete Row?", "Information", MessageBoxButtons.YesNo, MessageBoxIcon.Stop) == DialogResult.Yes) { StageDetBL.DeletStage(i_dStageId); grdStagesView.DeleteRow(grdStagesView.FocusedRowHandle); DataTable dt = new DataTable(); dt = grdStages.DataSource as DataTable; UpdateSortOrder(dt, "Stage", m_icostCentreId); int iOrder = 0; for (int i = 0; i < grdStagesView.RowCount; i++) { iOrder = i + 1; grdStagesView.SetRowCellValue(i, "SortOrder", iOrder); } } } } } }
private void UpdateSortOrder(DataTable dt, string argType, int argCCId) { StageDetBL.UpdateBlockSort(dt, argType, m_icostCentreId); }