public List <BOCandidateOfferStatus> getBOCandidateOfferStatusDAL() { List <BOCandidateOfferStatus> candidatestatus = new List <BOCandidateOfferStatus>(); try { conOpen.Open(); SqlCommand cmd = new SqlCommand("select Can_CandidateID,Can_TestStatus,Can_BCGTestStatus from E_Data_Candidate_Profile where Can_BCGTestStatus=1 and Can_TestStatus=6 and Offer_Letter_Status is null", conOpen); var dr = cmd.ExecuteReader(); while (dr.Read()) { BOCandidateOfferStatus bo = new BOCandidateOfferStatus(); bo.candidateid = dr.GetInt32(0); bo.interviewstatus = Convert.ToString(dr.GetInt32(1)); if (bo.interviewstatus.Equals("6")) { bo.interviewstatus = "Approved"; } bo.bgcstatus = Convert.ToString(dr.GetBoolean(2)); if (bo.bgcstatus.Equals("1")) { bo.bgcstatus = "Cleared"; } candidatestatus.Add(bo); } } catch (Exception ex) { Console.WriteLine(ex); } return(candidatestatus); }
public List <BOCandidateOfferStatus> waitingApprovalCandidate() { conOpen.Open(); List <BOCandidateOfferStatus> candidatestatus = new List <BOCandidateOfferStatus>(); SqlCommand cmd = new SqlCommand("select Can_CandidateID,Can_TestStatus,Can_BCGTestStatus,Offer_Letter_Status from E_Data_Candidate_Profile where Can_BCGTestStatus=1 and Can_TestStatus=6 and Offer_Letter_Status='Awaiting Approal'", conOpen); var dr = cmd.ExecuteReader(); while (dr.Read()) { BOCandidateOfferStatus bo = new BOCandidateOfferStatus(); bo.candidateid = dr.GetInt32(0); bo.interviewstatus = Convert.ToString(dr.GetInt32(1)); if (bo.interviewstatus.Equals("6")) { bo.interviewstatus = "Approved"; } bo.bgcstatus = Convert.ToString(dr.GetBoolean(2)); if (bo.bgcstatus.Equals("1")) { bo.bgcstatus = "Cleared"; } candidatestatus.Add(bo); } return(candidatestatus); }