<?php
class AppProgramStudiToFinansi extends Database{
   protected $mSqlFile= 'module/program_studi/business/appprogramstuditofinansi.sql.php';
   function __construct($connectionNumber=3) {
      parent::__construct($connectionNumber);
      
   }  
   function GetIdJenjangAkademik($jenjangKode){
      $result=$this->Open($this->mSqlQueries['get_id_jenjang'],array($jenjangKode));
      //print($this->GetLastError());
      return $result;
   }
   
   function GetFakultasId($kodeFak){
   	  $result = $this->Open($this->mSqlQueries['get_fakultas_id'],array($kodeFak));
   	  return $result;				
   }
   
   function DoAddProgramStudi($kodeProdi,$namaProdi,$fakultasId,$jenjangAkademik,$model){   	  
      $result=$this->Execute($this->mSqlQueries['do_add_program_studi'],array($kodeProdi,$namaProdi,$fakultasId,$jenjangAkademik,$model));
      //print($this->GetLastError());
      return $result;
   }
   function DoUpdateProgramStudi($kodeProdi,$namaProdi,$fakultasKode,$jenjangAkademik,$model,$oldKode){
      $result=$this->Execute($this->mSqlQueries['do_update_program_studi'],array($kodeProdi,$namaProdi,$fakultasKode,$jenjangAkademik,$model,$oldKode));
      //print($this->GetLastError());
      return $result;
   }
   function DoDeleteProgramStudiById($kodeProdi){
      $result=$this->Execute($this->mSqlQueries['do_delete_program_studi_by_id'],array($kodeProdi));
      return $result;
   }
   function DoDeleteProgramStudiByArrayId($arrKodeProdi){
      $kodeProdi = implode("', '", $arrKodeProdi);
      $result=$this->Execute($this->mSqlQueries['do_delete_program_studi_by_array_id'],array($kodeProdi));
      return $result;
   }
}
?>