private void barbtnDelete_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { if (BsfGlobal.FindPermission("Executive Target-Delete") == false) { MessageBox.Show("You don't have Rights to Executive Target-Delete"); return; } if (grdTargetRegView.FocusedRowHandle >= 0) { if (MessageBox.Show("Do You Want Delete?", "Delete", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1) == DialogResult.Yes) { i_RegModeId = Convert.ToInt32(grdTargetRegView.GetFocusedRowCellValue("TargetId")); TargetRegBL.DeleteReg(i_RegModeId); grdTargetRegView.DeleteRow(grdTargetRegView.FocusedRowHandle); PopulateTargetReg(); } } }
private void PopulateTargetReg() { fromDate = Convert.ToDateTime(deFrom.EditValue); toDate = Convert.ToDateTime(deTo.EditValue); string fdate = string.Format("{0:dd MMM yyyy}", fromDate); string tdate = string.Format("{0:dd MMM yyyy}", toDate); DataTable dt = new DataTable(); dt = TargetRegBL.getTargetReg(fdate, tdate); grdTargetRegister.DataSource = null; grdTargetRegister.DataSource = dt; grdTargetRegView.PopulateColumns(); if (grdTargetRegView.FocusedRowHandle >= 0) { for (int i = 0; i <= dt.Rows.Count - 1; i++) { if (dt.Rows[i]["PeriodType"].ToString() == "M") { grdTargetRegView.SetRowCellValue(i, "PeriodType", "Month"); } else if (dt.Rows[i]["PeriodType"].ToString() == "Q") { grdTargetRegView.SetRowCellValue(i, "PeriodType", "Quarter"); } else if (dt.Rows[i]["PeriodType"].ToString() == "H") { grdTargetRegView.SetRowCellValue(i, "PeriodType", "Half-Year"); } else if (dt.Rows[i]["PeriodType"].ToString() == "Y") { grdTargetRegView.SetRowCellValue(i, "PeriodType", "Year"); } if (dt.Rows[i]["TargetType"].ToString() == "U") { grdTargetRegView.SetRowCellValue(i, "TargetType", "Units"); } else if (dt.Rows[i]["TargetType"].ToString() == "A") { grdTargetRegView.SetRowCellValue(i, "TargetType", "Amounts"); } } grdTargetRegView.Columns["TargetId"].Visible = false; grdTargetRegView.Columns["TargetType"].Visible = false; grdTargetRegView.Columns["NoofPeriods"].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Far; grdTargetRegView.OptionsCustomization.AllowFilter = false; grdTargetRegView.OptionsBehavior.AllowIncrementalSearch = true; grdTargetRegView.OptionsView.ShowAutoFilterRow = false; grdTargetRegView.OptionsView.ShowViewCaption = false; grdTargetRegView.OptionsView.ShowFooter = false; grdTargetRegView.OptionsSelection.MultiSelectMode = GridMultiSelectMode.CellSelect; grdTargetRegView.OptionsSelection.InvertSelection = false; grdTargetRegView.OptionsView.ColumnAutoWidth = true; grdTargetRegView.Appearance.HeaderPanel.Font = new Font(grdTargetRegView.Appearance.HeaderPanel.Font, FontStyle.Bold); grdTargetRegView.Appearance.FocusedCell.BackColor = Color.Teal; grdTargetRegView.Appearance.FocusedCell.ForeColor = Color.White; grdTargetRegView.Appearance.FocusedRow.ForeColor = Color.White; grdTargetRegView.Appearance.FocusedRow.BackColor = Color.Teal; grdTargetRegView.OptionsSelection.EnableAppearanceHideSelection = false; } }