/**
* @user admin
* @param CandidateAction object
* @return true if candidate information added in database else false Generates a unique candidate
* id for each candidate and fills the candidate information into the database
*/
public boolean addCandidate(CandidateAction ca) {
conn = Connect.createConn();
try {
int j = genCandidateid();
query = "insert into its_candidateinformation_tbl values(?,?,?,?,?,?,?,?,?,?,?, default)";
pstmt = conn.prepareStatement(query);
pstmt.setInt(1, j);
pstmt.setString(2, ca.getFname());
pstmt.setString(3, ca.getLname());
pstmt.setString(4, ca.getDegree());
pstmt.setString(5, ca.getStream());
pstmt.setString(6, ca.getPskillset());
pstmt.setString(7, ca.getSskillset());
pstmt.setInt(8, ca.getExperience());
pstmt.setString(9, ca.getDesignation());
pstmt.setString(10, ca.getJoining());
pstmt.setString(11, ca.getLocation());
int i = pstmt.executeUpdate();
if (i == 1) {
message = "Candidate successfully added. Candidate ID is:" + j;
return true;
}
if (i == 0) {
message = "Candidate could not be added";
return false;
}
} catch (SQLException e) {
message = "exception occured ";
System.out.println("Cannot add data into candidate table " + e);
return false;
} finally {
closeConn();
}
return false;
}
