private void PopulateTargetReg()
{
fromDate = Convert.ToDateTime(deFrom.EditValue);
if (deTo.EditValue == null)
{
deTo.EditValue = Convert.ToDateTime(DateTime.Now.ToShortDateString());
}
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 = ExecTargetBL.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", "Monthly");
}
else if (dt.Rows[i]["PeriodType"].ToString() == "Q")
{
grdTargetRegView.SetRowCellValue(i, "PeriodType", "Quarterly");
}
else if (dt.Rows[i]["PeriodType"].ToString() == "H")
{
grdTargetRegView.SetRowCellValue(i, "PeriodType", "Half yearly");
}
else if (dt.Rows[i]["PeriodType"].ToString() == "Y")
{
grdTargetRegView.SetRowCellValue(i, "PeriodType", "Yearly");
}
}
grdTargetRegView.Columns["TargetId"].Visible = false;
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;
}
}
private void btnDelete_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)
{
int iTargetId = Convert.ToInt32(grdTargetRegView.GetFocusedRowCellValue("TargetId"));
ExecTargetBL.DeleteReg(iTargetId);
grdTargetRegView.DeleteRow(grdTargetRegView.FocusedRowHandle);
PopulateTargetReg();
}
}
}
