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