// To retrieve all the candidates along with their test status public List <ICandidate_Test> getCandidates_Test() { List <ICandidate_Test> lstCandidateTest = new List <ICandidate_Test>(); SqlCommand myCommand; SqlConnection myConnection = DBUtility.getConnection(); try { using (myConnection) { myCommand = new SqlCommand("SP_getCandidates_Test", myConnection); myCommand.CommandType = CommandType.StoredProcedure; myConnection.Open(); SqlDataReader objSqlDataReader = myCommand.ExecuteReader(); while (objSqlDataReader.Read()) { int get_CandidateProfileID = Convert.ToInt32(objSqlDataReader["CandidateProfileID"]); int get_VacancyID = Convert.ToInt32(objSqlDataReader["VacancyID"]); DateTime get_DOB = Convert.ToDateTime(objSqlDataReader["DOB"]); string get_Gender = Convert.ToString(objSqlDataReader["Gender"]); int get_TestID = Convert.ToInt32(objSqlDataReader["TestID"]); int get_TestStatus = Convert.ToInt32(objSqlDataReader["TestStatus"]); DateTime get_HRInterviewDate = Convert.ToDateTime(objSqlDataReader["HRInterviewDate"]); DateTime get_TechnicalInterviewDate = Convert.ToDateTime(objSqlDataReader["TechnicalInterviewDate"]); DateTime get_WrittenTestDate = Convert.ToDateTime(objSqlDataReader["WrittenTestDate"]); ICandidate_Test objCandidateTest = Candidate_TestFactory.create_Candidate_Test(get_VacancyID, get_CandidateProfileID, get_DOB, get_Gender, get_TestID, get_TestStatus, get_WrittenTestDate, get_TechnicalInterviewDate, get_HRInterviewDate); lstCandidateTest.Add(objCandidateTest); } objSqlDataReader.Close(); } return(lstCandidateTest); } catch (Exception EE) { Console.WriteLine(EE); Console.Read(); return(null); } finally { myConnection.Close(); } }
public static ICandidate_Test create_Candidate_Test(int VacancyID, int CandidateProfileID, DateTime DOB, String Gender, int TestID, int TestStatus, DateTime WrittenTestDate, DateTime TechnicalInterviewDate, DateTime HRInterviewDate) { objCandidateTest = new Candidate_Test(VacancyID, CandidateProfileID, DOB, Gender, TestID, TestStatus, WrittenTestDate, TechnicalInterviewDate, HRInterviewDate); return(objCandidateTest); }