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