private void FillCheck()
{
grdCheck.DataSource = null;
DataTable dt = new DataTable();
if (m_sType == "FlatType")
{
if (m_sCType == "")
{
return;
}
dt = UnitDirBL.FlatTypeCheckList(m_iId, m_sCType, m_icostCentreId);
grdCheck.DataSource = dt;
grdCheckView.PopulateColumns();
grdCheckView.Columns["CheckListId"].Visible = false;
grdCheckView.Columns["Status"].Visible = false;
grdCheckView.Columns["CheckListName"].OptionsColumn.AllowEdit = false;
RepositoryItemDateEdit expDate = new RepositoryItemDateEdit();
grdCheckView.Columns["ExpCompletionDate"].ColumnEdit = expDate;
//grdCheckView.Columns["Status"].Width = 50;
//grdCheckView.Columns["Status"].Caption = "Select";
//grdCheckView.Columns["Status"].AppearanceHeader.Options.UseTextOptions = true;
//grdCheckView.Columns["Status"].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
selection = new GridSelectAll(grdCheckView);
selection.CheckMarkColumn.VisibleIndex = 2;
for (int i = 0; i < dt.Rows.Count; i++)
{
bool b_Status = Convert.ToBoolean(CommFun.IsNullCheck(dt.Rows[i]["Status"], CommFun.datatypes.varTypeBoolean));
grdCheckView.SetRowCellValue(i, selection.CheckMarkColumn, b_Status);
}
grdCheckView.OptionsBehavior.Editable = true;
}
else if (m_sType == "Flat")
{
if (m_sCType == "")
{
return;
}
dt = UnitDirBL.FlatCheckList(m_iId, m_sCType);
grdCheck.DataSource = dt;
if (dt != null)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
if (Convert.ToBoolean(CommFun.IsNullCheck(dt.Rows[i]["Status"], CommFun.datatypes.varTypeBoolean)) == true)
{
}
else
{
bChkAlertSend = true;
}
}
}
grdCheckView.PopulateColumns();
grdCheckView.Columns["CheckListId"].Visible = false;
grdCheckView.Columns["Status"].Visible = false;
grdCheckView.Columns["CheckListName"].OptionsColumn.AllowEdit = false;
grdCheckView.Columns["ExecutiveId"].Caption = "Executive";
RepositoryItemDateEdit expDate = new RepositoryItemDateEdit();
grdCheckView.Columns["ExpCompletionDate"].ColumnEdit = expDate;
DataTable dtExe = new DataTable();
RepositoryItemLookUpEdit cboExecutive = new RepositoryItemLookUpEdit();
dtExe = UnitDirBL.Executive();
cboExecutive.DataSource = dtExe;
cboExecutive.ForceInitialize();
cboExecutive.PopulateColumns();
cboExecutive.DisplayMember = "ExecName";
cboExecutive.ValueMember = "ExecId";
cboExecutive.ShowHeader = false;
cboExecutive.ShowFooter = false;
cboExecutive.Columns["ExecId"].Visible = false;
cboExecutive.NullText = "None";
grdCheckView.Columns["ExecutiveId"].ColumnEdit = cboExecutive;
//grdCheckView.Columns["Status"].Width = 50;
//grdCheckView.Columns["Status"].Caption = "Select";
//grdCheckView.Columns["Status"].AppearanceHeader.Options.UseTextOptions = true;
//grdCheckView.Columns["Status"].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
selection = new GridSelectAll(grdCheckView);
selection.CheckMarkColumn.VisibleIndex = 2;
for (int i = 0; i < dt.Rows.Count; i++)
{
bool b_Status = Convert.ToBoolean(CommFun.IsNullCheck(dt.Rows[i]["Status"], CommFun.datatypes.varTypeBoolean));
grdCheckView.SetRowCellValue(i, selection.CheckMarkColumn, b_Status);
}
grdCheckView.OptionsBehavior.Editable = true;
}
else if (m_sType == "ProjectInfo")
{
dt = UnitDirBL.ProjectCheckList(m_iId);
grdCheck.DataSource = dt;
grdCheckView.PopulateColumns();
grdCheckView.Columns["CheckListId"].Visible = false;
grdCheckView.Columns["Status"].Visible = false;
grdCheckView.Columns["CheckListName"].OptionsColumn.AllowEdit = false;
RepositoryItemDateEdit Date = new RepositoryItemDateEdit();
grdCheckView.Columns["CompletionDate"].ColumnEdit = Date;
//grdCheckView.Columns["Status"].Width = 50;
//grdCheckView.Columns["Status"].Caption = "Select";
//grdCheckView.Columns["Status"].AppearanceHeader.Options.UseTextOptions = true;
//grdCheckView.Columns["Status"].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
selection = new GridSelectAll(grdCheckView);
selection.CheckMarkColumn.VisibleIndex = 2;
for (int i = 0; i < dt.Rows.Count; i++)
{
bool b_Status = Convert.ToBoolean(CommFun.IsNullCheck(dt.Rows[i]["Status"], CommFun.datatypes.varTypeBoolean));
grdCheckView.SetRowCellValue(i, selection.CheckMarkColumn, b_Status);
}
grdCheckView.OptionsBehavior.Editable = true;
}
else if (m_sType == "Final")
{
//if (m_iId == 0) { MessageBox.Show("Select Flat"); return; }
if (dtFinal != null && dtFinal.Rows.Count > 0)
{
dt = dtFinal; grdCheck.DataSource = dt;
} //dtLand = dt;
else
{
if (m_sBussinessType == "L")
{
dt = UnitDirBL.FinalCheckListPlot(m_iId);
dtLand = UnitDirBL.FinalPlot(m_iId);
grdCheck.DataSource = dt;
if (dt != null)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
for (int j = 0; j < dtLand.Rows.Count; j++)
{
if (Convert.ToInt32(dtLand.Rows[j]["CheckListId"]) == Convert.ToInt32(dt.Rows[i]["CheckListId"]))
{
}
else
{
bChkAlertSend = true;
}
}
}
}
}
else
{
dt = UnitDirBL.FinalCheckListFlat(m_iId);
grdCheck.DataSource = dt;
if (dt != null)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
if (Convert.ToBoolean(CommFun.IsNullCheck(dt.Rows[i]["Status"], CommFun.datatypes.varTypeBoolean)) == true)
{
}
else
{
bChkAlertSend = true;
}
}
}
}
}
grdCheckView.PopulateColumns();
grdCheckView.Columns["CheckListId"].Visible = false;
grdCheckView.Columns["CheckListName"].OptionsColumn.AllowEdit = false;
grdCheckView.Columns["ExecutiveId"].Caption = "Executive";
RepositoryItemDateEdit expDate = new RepositoryItemDateEdit();
grdCheckView.Columns["ExpCompletionDate"].ColumnEdit = expDate;
DataTable dtExe = new DataTable();
dtExe = UnitDirBL.Executive();
RepositoryItemLookUpEdit cboExecutive = new RepositoryItemLookUpEdit();
cboExecutive.DataSource = dtExe;
cboExecutive.ForceInitialize();
cboExecutive.PopulateColumns();
cboExecutive.DisplayMember = "ExecName";
cboExecutive.ValueMember = "ExecId";
cboExecutive.ShowHeader = false;
cboExecutive.ShowFooter = false;
cboExecutive.Columns["ExecId"].Visible = false;
cboExecutive.NullText = "None";
grdCheckView.Columns["ExecutiveId"].ColumnEdit = cboExecutive;
if (m_sBussinessType == "B")
{
grdCheckView.Columns["Status"].Visible = false;
selection = new GridSelectAll(grdCheckView);
selection.CheckMarkColumn.VisibleIndex = 2;
for (int i = 0; i < dt.Rows.Count; i++)
{
bool b_Status = Convert.ToBoolean(CommFun.IsNullCheck(dt.Rows[i]["Status"], CommFun.datatypes.varTypeBoolean));
grdCheckView.SetRowCellValue(i, selection.CheckMarkColumn, b_Status);
}
}
else
{
selection = new GridSelectAll(grdCheckView);
selection.CheckMarkColumn.VisibleIndex = 2;
for (int i = 0; i < dt.Rows.Count; i++)
{
for (int j = 0; j < dtLand.Rows.Count; j++)
{
if (Convert.ToInt32(dt.Rows[i]["CheckListId"]) == Convert.ToInt32(dtLand.Rows[j]["CheckListId"]))
{
grdCheckView.SetRowCellValue(i, selection.CheckMarkColumn, true);
}
}
}
}
grdCheckView.OptionsBehavior.Editable = true;
}
else if (m_sType == "Cancel")
{
if (dtCancel != null && dtCancel.Rows.Count > 0)
{
dt = dtCancel;
}
else
{
dt = UnitDirBL.CancelCheckListFlat(m_iId);
}
if (dt != null)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
if (Convert.ToBoolean(CommFun.IsNullCheck(dt.Rows[i]["Status"], CommFun.datatypes.varTypeBoolean)) == true)
{
}
else
{
bChkAlertSend = true;
}
}
}
grdCheck.DataSource = dt;
grdCheckView.PopulateColumns();
grdCheckView.Columns["CheckListId"].Visible = false;
grdCheckView.Columns["Status"].Visible = false;
grdCheckView.Columns["CheckListName"].OptionsColumn.AllowEdit = false;
grdCheckView.Columns["ExecutiveId"].Caption = "Executive";
RepositoryItemDateEdit expDate = new RepositoryItemDateEdit();
grdCheckView.Columns["ExpCompletionDate"].ColumnEdit = expDate;
DataTable dtExe = new DataTable();
dtExe = UnitDirBL.Executive();
RepositoryItemLookUpEdit cboExecutive = new RepositoryItemLookUpEdit();
cboExecutive.DataSource = dtExe;
cboExecutive.DisplayMember = "ExecName";
cboExecutive.ValueMember = "ExecId";
cboExecutive.ForceInitialize();
cboExecutive.PopulateColumns();
cboExecutive.ShowHeader = false;
cboExecutive.ShowFooter = false;
cboExecutive.Columns["ExecId"].Visible = false;
cboExecutive.NullText = "None";
grdCheckView.Columns["ExecutiveId"].ColumnEdit = cboExecutive;
selection = new GridSelectAll(grdCheckView);
selection.CheckMarkColumn.VisibleIndex = 2;
for (int i = 0; i < dt.Rows.Count; i++)
{
bool b_Status = Convert.ToBoolean(CommFun.IsNullCheck(dt.Rows[i]["Status"], CommFun.datatypes.varTypeBoolean));
grdCheckView.SetRowCellValue(i, selection.CheckMarkColumn, b_Status);
}
grdCheckView.OptionsBehavior.Editable = true;
}
else if (m_sType == "Project")
{
if (m_sCType == "")
{
return;
}
dt = UnitDirBL.ProjectCheckListFlat(m_iId, m_sCType);
grdCheck.DataSource = dt;
grdCheckView.PopulateColumns();
grdCheckView.Columns["CheckListId"].Visible = false;
grdCheckView.Columns["Status"].Visible = false;
grdCheckView.Columns["CheckListName"].OptionsColumn.AllowEdit = false;
grdCheckView.Columns["CheckListName"].Width = 200;
//grdCheckView.Columns["Status"].Width = 50;
//grdCheckView.Columns["Status"].Caption = "Select";
//grdCheckView.Columns["Status"].AppearanceHeader.Options.UseTextOptions = true;
//grdCheckView.Columns["Status"].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
selection = new GridSelectAll(grdCheckView);
selection.CheckMarkColumn.VisibleIndex = 2;
for (int i = 0; i < dt.Rows.Count; i++)
{
bool b_Status = Convert.ToBoolean(CommFun.IsNullCheck(dt.Rows[i]["Status"], CommFun.datatypes.varTypeBoolean));
grdCheckView.SetRowCellValue(i, selection.CheckMarkColumn, b_Status);
}
grdCheckView.OptionsBehavior.Editable = true;
}
grdCheckView.Appearance.HeaderPanel.Font = new Font(grdCheckView.Appearance.HeaderPanel.Font, FontStyle.Bold);
grdCheckView.OptionsSelection.InvertSelection = true;
grdCheckView.OptionsSelection.EnableAppearanceHideSelection = false;
grdCheckView.Appearance.FocusedRow.BackColor = Color.Teal;
grdCheckView.Appearance.FocusedRow.ForeColor = Color.White;
grdCheckView.BestFitColumns();
}