private void FillTrainingProgramDetl(Int32 iEcode, string sTrainerName)
{
objHRdb = new HRInfo();
DataTable dt = new DataTable();
gvTrainingPrgDetl.Rows.Clear();
if (cbTrainerNames.SelectedIndex > 0)
{
try
{
if (cbPrgType.SelectedIndex == 0)
{
dt = objHRdb.GetTrainingProgramsByTrainer(iEcode, sTrainerName, Convert.ToDateTime(dtpFromdate.Value).ToString("dd/MMM/yyyy"), Convert.ToDateTime(dtpToDate.Value).ToString("dd/MMM/yyyy"), "ACTUAL").Tables[0];
}
else
{
dt = objHRdb.GetTrainingProgramsByTrainer(iEcode, sTrainerName, Convert.ToDateTime(dtpFromdate.Value).ToString("dd/MMM/yyyy"), Convert.ToDateTime(dtpToDate.Value).ToString("dd/MMM/yyyy"), "PLAN").Tables[0];
}
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
gvTrainingPrgDetl.Rows.Add();
gvTrainingPrgDetl.Rows[i].Cells["SLNO"].Value = (i + 1).ToString();
gvTrainingPrgDetl.Rows[i].Cells["PrgNo"].Value = dt.Rows[i]["PrgNo"].ToString();
gvTrainingPrgDetl.Rows[i].Cells["PrgName"].Value = dt.Rows[i]["PrgName"].ToString();
gvTrainingPrgDetl.Rows[i].Cells["Location"].Value = dt.Rows[i]["Prglocation"].ToString();
gvTrainingPrgDetl.Rows[i].Cells["EmpCnt"].Value = dt.Rows[i]["EmpCnt"].ToString();
gvTrainingPrgDetl.Rows[i].Cells["TopicsCnt"].Value = dt.Rows[i]["TopicsCnt"].ToString();
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
}
private void FillTrainingProgramDetl(Int32 iEcode)
{
objHRdb = new HRInfo();
DataTable dt = new DataTable();
clbPrograms.Items.Clear();
if (cbTrainerNames.SelectedIndex > 0)
{
try
{
dt = objHRdb.GetTrainingProgramsByTrainer(iEcode, "", Convert.ToDateTime(dtpFromdate.Value).ToString("dd/MMM/yyyy"), Convert.ToDateTime(dtpToDate.Value).ToString("dd/MMM/yyyy"), "ACTUAL").Tables[0];
if (dt.Rows.Count > 0)
{
//chkAllPrgs.Visible = true;
btnReport.Enabled = true;
foreach (DataRow dataRow in dt.Rows)
{
NewCheckboxListItem oclBox = new NewCheckboxListItem();
oclBox.Text = dataRow["PrgNo"].ToString() + '-' + dataRow["PrgName"].ToString() + '(' + dataRow["Prglocation"].ToString() + ')';
oclBox.Tag = dataRow["PrgNo"].ToString();
clbPrograms.Items.Add(oclBox);
oclBox = null;
}
}
else
{
btnReport.Enabled = false;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
}
