public function updateCandidateProfile($userID, $updatefiles)
{
$avaiFields = array("firstname", "lastname", "CandidateProfileID", "tagline", "overview", "minimumsalary", "maximumsalary", "CandidateSkillID", "SkillID", "keywords", "servicedescription");
$api = new PR_Api_Core_CandidateClass();
$listskill = $updatefiles["SkillID"];
//echo("tetst:");print_r($listskill);die();
// update table user
$updateFields = array('firstname' => $updatefiles["firstname"], 'lastname' => $updatefiles["lastname"]);
$criteria = "UserID = '{$userID}'";
PR_Database::update('user', $updateFields, $criteria);
//update table candidate
$candidateInfo = $api->getCandidateInfo($userID);
if (count($candidateInfo) == 0) {
return 0;
}
$candidateProfileID = $candidateInfo['CandidateProfileID'];
$updateFields1 = array('tagline' => $updatefiles["tagline"], 'overview' => $updatefiles["overview"], 'minimumsalary' => $updatefiles["minimumsalary"], 'maximumsalary' => $updatefiles["maximumsalary"], 'keywords' => $updatefiles["keywords"], 'servicedescription' => $updatefiles["servicedescription"]);
$criteria1 = "CandidateProfileID = '{$candidateProfileID}'";
PR_Database::update('candidate_profile', $updateFields1, $criteria1);
$db = PR_Database::getInstance();
$select = $db->select();
$select->from('candidate_skill', array('*'));
$select->where("CandidateProfileID = '{$candidateProfileID}'");
$records = PR_Database::fetchAll($select);
if (empty($records) && count($records) > 0) {
return -1;
}
$CandidateSkillID = $records[0]['CandidateProfileID'];
$skillIDs = array();
foreach ($listskill as $Skills) {
$skillIDs[] = $Skills["SkillID"];
}
// echo("tetst:");print_r($skillIDs);die();
$api->saveCandidateSkills($userID, $CandidateSkillID, $skillIDs);
}
