public candidate_display balcrud2_getcanlist(int candidateid)
{
BgcScheduleDAL dc = new BgcScheduleDAL();
candidate_display cd = dc.dalcrud2_getcanlist(candidateid);
return(cd);
}
public candidate_display dalcrud2_getcanlist(int candidateid)
{
candidate_display cd = new candidate_display();
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString());
try
{
con.Open();
SqlCommand cmd = new SqlCommand("select Can_CandidateID,Can_CandidateName,Can_VacancyID,Can_TestID,Can_BGCTestID,Can_BCGTestStatus from E_Data_Candidate_Profile where Can_CandidateID=" + candidateid, con);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
cd.candidateid = dr.GetInt32(0);
if (dr.IsDBNull(1))
{
cd.candidatename = "No value found";
}
else
{
cd.candidatename = dr.GetString(1);
}
if (dr.IsDBNull(2))
{
cd.vacancyid = -1;
}
else
{
cd.vacancyid = dr.GetInt32(2);
}
if (dr.IsDBNull(3))
{
cd.testid = -1;
}
else
{
cd.testid = dr.GetInt32(3);
}
if (dr.IsDBNull(4))
{
cd.bgctestid = -1;
}
else
{
cd.bgctestid = dr.GetInt32(4);
}
cd.bgcteststatus = (bool)dr[5];
}
}
catch (Exception ex)
{
Console.WriteLine(ex);
}
return(cd);
}
public List <candidate_display> dalcrud2_getbgclist(int bgcadminid)
{
List <candidate_display> li = new List <candidate_display>();
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString());
try
{
con.Open();
SqlCommand cmd = new SqlCommand("select Can_CandidateID,Can_CandidateName,Can_VacancyID,Can_TestID,Can_BGCTestID,Can_BCGTestStatus from E_Data_Candidate_Profile where Can_BGCTestID in (select BgcCheck_BGCTestID from E_Data_Candidate_BGC_Check where BgcCheck_AdministratorID in (select BgcAdmin_AdministratorID from E_Data_BGC_Administrator where BgcAdmin_EmployeeID=" + bgcadminid + "))", con);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
candidate_display cd = new candidate_display();
cd.candidateid = dr.GetInt32(0);
if (dr.IsDBNull(1))
{
cd.candidatename = "No value found";
}
else
{
cd.candidatename = dr.GetString(1);
}
if (dr.IsDBNull(2))
{
cd.vacancyid = -1;
}
else
{
cd.vacancyid = dr.GetInt32(2);
}
if (dr.IsDBNull(3))
{
cd.testid = -1;
}
else
{
cd.testid = dr.GetInt32(3);
}
if (dr.IsDBNull(4))
{
cd.bgctestid = -1;
}
else
{
cd.bgctestid = dr.GetInt32(4);
}
cd.bgcteststatus = (bool)dr[5];
li.Add(cd);
}
}
catch (Exception ex)
{
Console.WriteLine(ex);
}
return(li);
}
