package utility
{
	// Import
import mx.controls.Alert;
import mx.rpc.events.FaultEvent;
import mx.rpc.events.ResultEvent;
import mx.rpc.remoting.RemoteObject;
 
	public class DBConnection
	{
	// Create Remote Object for connection to PHP then Postgres for records ArrayCollection
	public var dbConnect:RemoteObject = new RemoteObject;
 
// Data
	//pass in parameters for specific record array request with or without 
	//array of parameters to include in function call to PHP
	public function loadRecords(dest:String, srce:String, phpCall:String, resultFunc:Function, args:Array):void{
		dbConnect.destination = dest;
		dbConnect.source = srce;
		dbConnect.getOperation(phpCall).addEventListener(ResultEvent.RESULT, resultFunc);
		dbConnect.addEventListener(FaultEvent.FAULT, faultHandler);
		if(args.length > 0){
		 dbConnect.getOperation(phpCall).arguments = args;
		}
		dbConnect.getOperation(phpCall).send();
	}
 
	private function faultHandler(event:FaultEvent):void{
			Alert.show(event.fault.faultString, event.fault.faultCode.toString());
		}
 
	}
}

//Load Records - WITH PARAM & VARIABLES	
	public function getPeopleByRef(r_id:uint, r_short:Boolean):void
	{	
		var dbConn:DBConnection = new DBConnection();
		dbConn.loadRecords("zend","People","getPeopleByRef", resultGetPeople,[r_id]);
	}
 
//Load Records - NO PARAMS	
	private function getContracts():void{
		var dbConn:DBConnection = new DBConnection();
		dbConn.loadRecords("zend","Contract","getContracts",resultGetContracts,[]);
	}