public static function editCategory2($category, $eAchievement, $cAchievement)
{
$db = Connection::getInstance();
$mysqli = $db->getConnection();
$mysqli->autocommit(FALSE);
$schoolId = $category->getSchoolId();
$nic = $category->getNIC();
$gradeOfAdmission = $category->getGradeOfAdmission();
$gradeOfLeaving = $category->getGradeOfLeaving();
$pastPupilOrganizationMembership = $category->getPastPupilOrganizationMembership();
$query = "update pastPupil set gradeOfAdmission='{$gradeOfAdmission}',gradeOfLeaving='{$gradeOfLeaving}', pastPupilOrganizationMembership='{$pastPupilOrganizationMembership}' where schoolId='{$schoolId}' and NIC='{$nic}'";
$result1 = $mysqli->query($query);
$result2 = DBPPAchievementController::editPPAchievement($cAchievement);
$result3 = DBPPAchievementController::editPPAchievement($eAchievement);
if ($result1 and $result2 and $result3) {
$mysqli->commit();
return true;
} else {
$mysqli->rollback();
$mysqli->commit();
return false;
}
}
