<?php
//--Class StudentBio--------------------------

include_once "clsbase_StudentBio.php";

class StudentBio extends base_StudentBio {

function Save2(){
    if($this->status==1) {
        $sql = "insert into StudentBio(studentId, studentSex, parentName, parentRelation, parentAddress, parentDistrictId, parentAmphurId, parentProvinceId, parentZipcode, parentPhoneNo, parentMobile, parentOcc, parentIncome, parentEmail, canRefund, healthPrivId) values('$this->studentId', '$this->studentSex', '$this->parentName', '$this->parentRelation', '$this->parentAddress', $this->parentDistrictId, $this->parentAmphurId, $this->parentProvinceId, '$this->parentZipcode', '$this->parentPhoneNo', $this->parentMobile, '$this->parentOcc', '$this->parentIncome', '$this->parentEmail', '$this->canRefund', $this->healthPrivId)";
    }else {
        $sql = "update StudentBio set studentSex='$this->studentSex', parentName='$this->parentName', parentRelation='$this->parentRelation', parentAddress='$this->parentAddress', parentDistrictId=$this->parentDistrictId, parentAmphurId=$this->parentAmphurId, parentProvinceId=$this->parentProvinceId, parentZipcode='$this->parentZipcode', parentPhoneNo='$this->parentPhoneNo', parentMobile=$this->parentMobile, parentOcc='$this->parentOcc', parentIncome='$this->parentIncome', parentEmail='$this->parentEmail', canRefund='$this->canRefund', healthPrivId=$this->healthPrivId where studentId='$this->studentId'";
    }
    $this->SetQuery($sql);
}

// Use on page addResultExamOcc.php
function RSStudentBioByStudIdAndNonAdd($xKey){
    $this->SetQuery("select * from StudentBio where studentId='$xKey' ");
//    $this->SetQuery("select * from StudentBio where studentId='$xKey' and occExamResult='' ");    
}
//-- The End --

function RSStudentBioByDate($date){
    $this->SetQuery("select * from StudentBio where birthDate = '$date' ");    
}

function RSStudentBioByDayAndMonth($day,$month){
    $this->SetQuery("select * from StudentBio where DAYOFMONTH(birthDate) = '$day' AND MONTH(birthDate) = '$month'");    
}

} //--End class StudentBio--
?>