public List <ICandidateBO> viewCandidateGrid()
{
try
{
SqlConnection conn = new SqlConnection();
string str = ConfigurationManager.ConnectionStrings["conn"].ConnectionString;
conn.ConnectionString = str;
conn.Open();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "sp_Candidategridview1";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = conn;
SqlDataReader reader = cmd.ExecuteReader();
List <ICandidateBO> objCandidateBOList = new List <ICandidateBO>();
while (reader.Read())
{
{
ICandidateBO objCandidateBO = new CandidateBO(Convert.ToInt32(reader["Candidate_profile_ID"]), Convert.ToInt32(reader["Vacancy_ID"]), reader["Candidate_Name"].ToString(), Convert.ToDateTime(reader["DOB"]), reader["Location"].ToString(), reader["Gender"].ToString());
objCandidateBOList.Add(objCandidateBO);
}
}
conn.Close();
return(objCandidateBOList);
}
catch (Exception)
{
throw;
}
}
public static ICandidateBO createEmployeeBO(int id)
{
ICandidateBO objCandidateBO = new CandidateBO(id);
return(objCandidateBO);
}
public static ICandidateBO createCandBO()
{
ICandidateBO objCandidateBO = new CandidateBO();
return(objCandidateBO);
}
