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); }