private void FillTrainingTopicDetails()
{
objHRdb = new HRInfo();
DataTable dt = new DataTable();
sDepartments = "";
string DeptName = "";
string Desig = "";
if (cbTopicName.SelectedIndex > 0)
{
try
{
dt = objHRdb.GetTrainingTopicDetails(Convert.ToInt32(cbTopicName.SelectedValue)).Tables[0];
if (dt.Rows.Count > 0)
{
flagUpdate = true;
txtDuration.Text = dt.Rows[0]["TopicDuration"].ToString();
clbDesigs.Items.Clear();
for (int i = 0; i < dt.Rows.Count; i++)
{
if (sDepartments != dt.Rows[i]["DeptId"].ToString())
{
sDepartments = dt.Rows[i]["DeptId"].ToString();
FillDesignationsData(sDepartments);
}
if (DeptName != dt.Rows[i]["DeptName"].ToString())
{
DeptName = dt.Rows[i]["DeptName"].ToString();
for (int j = 0; j < clbDepartments.Items.Count; j++)
{
if (((NewCheckboxListItem)(clbDepartments.Items[j])).Text.Equals(DeptName))
{
clbDepartments.SetSelected(j, true);
clbDepartments.SetItemChecked(j, true);
}
}
}
}
for (int iVar = 0; iVar < dt.Rows.Count; iVar++)
{
Desig = dt.Rows[iVar]["DesigId"].ToString();
for (int k = 0; k < clbDesigs.Items.Count; k++)
{
if (((NewCheckboxListItem)(clbDesigs.Items[k])).Tag.Equals(Desig))
{
clbDesigs.SetSelected(k, true);
clbDesigs.SetItemChecked(k, true);
}
}
}
}
else
{
flagUpdate = false;
for (int i = 0; i < clbDepartments.Items.Count; i++)
{
clbDepartments.SetItemCheckState(i, CheckState.Unchecked);
}
if (clbDesigs.Items.Count > 0)
{
clbDesigs.Items.Clear();
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
objHRdb = null;
dt = null;
}
}
else
{
flagUpdate = false;
for (int i = 0; i < clbDepartments.Items.Count; i++)
{
clbDepartments.SetItemCheckState(i, CheckState.Unchecked);
}
clbDesigs.Items.Clear();
}
}
