/*@Author: quocvuongdn
*@Twitter: quocvuongdn
*@Site: quocvuongdn.com
*/
class DBMSSQL{
	//Default CardAssociation
	 protected $server= 'ip:port'; 
	 protected $account= ''; 
	 protected $password= '';
	 protected $database_name= '';
	 protected $conn;

	function __construct(){
		$this->connect();
	}
	 
	//connect to db
	public function connect(){
		//connect to server
		$this->conn = mssql_connect($this->server,$this->account,$this->password) or die(mssql_get_last_message());
		mssql_select_db($this->database_name) or die(mssql_get_last_message());
	}
	public function call_prcNoParam($spName){
		$stmt = mssql_init($spName);
		$prc_results = mssql_execute($stmt) or die(mssql_get_last_message());
		mssql_free_statement($stmt);
		return $this->processRowSet($prc_results, true);
	}

	public function processRowSet($prc_results, $singleRow = false){
		$resultArray = array();
		while($row = mssql_fetch_assoc($prc_results)){
			array_push($resultArray, $row);
		}
		if($singleRow){
			return $resultArray[0];
		}
		return $resultArray;
	}


	//demo call sp on mssql
	public function call_prcByDate($spName, $fromDate = null, $endDate = null, $flag = 1){
		$stmt = mssql_init($spName);
		if(isset($fromDate) && isset($endDate)){
			mssql_bind($stmt, '@Flag', $flag, SQLINT1);
			mssql_bind($stmt, '@FromDate', $fromDate, SQLVARCHAR);
			mssql_bind($stmt, '@EndDate', $endDate, SQLVARCHAR);
		}
		$prc_results = mssql_execute($stmt) or die(mssql_get_last_message());
		mssql_free_statement($stmt);
		return $this->processRowSet($prc_results, false);
	}
}