<fx:Script>
<![CDATA[
import flash.filesystem.File;
import flash.system.Capabilities;
import flash.utils.ByteArray;
import mx.utils.Base64Decoder;
import mx.utils.Base64Encoder;
public var fnamearr:Array=new Array();
private var loadedFile:ByteArray;
public var byte:String;
public var bytesarr:Array=new Array();
public var p:int;
public function browse_file(eve:MouseEvent):void{
file1 = File.documentsDirectory;
file1.addEventListener(Event.SELECT, handleSelectFile);
file1.browseForOpen("Select Picture");
}
public function handleSelectFile(event:Event):void
{
if(os=="Win" ){
file_name.text = event.target.nativePath;
}
else if(os=="Mac"|| os=="Lin"){
file_name.text = event.target.url;
}
fnamearr.push(event.target.name);
Alert.show(event.target.name);
var request:URLRequest = new URLRequest(file_name.text);
var urlLoader:URLLoader = new URLLoader(request);
urlLoader.addEventListener(Event.COMPLETE,onURLLoaderComplete);
urlLoader.dataFormat = URLLoaderDataFormat.BINARY;
urlLoader.load(request);
}
private function onURLLoaderComplete(event:Event):void
{
loadedFile = event.target.data;
var encoder:Base64Encoder=new Base64Encoder();
encoder.encodeBytes(loadedFile);
byte=encoder.toString();
bytesarr.push(byte);
Alert.show('==>'+file_name.text);
}
public function saveLoadedFile():void
{
for(var j:int=0;j<bytesarr.length;j++){
if(bytesarr[j].length!=0 && bytesarr[j]!='' ){
dbStatement=new SQLStatement();
dbStatement.sqlConnection=exampleDB;
dbStatement.text="INSERT INTO cmr_patient_files (patient_id,file,filename) VALUES (:recordId,:byteArray,:recordNote)";
dbStatement.parameters[":recordNote"] = fnamearr[j];
dbStatement.parameters[":byteArray"] = bytesarr[j];
dbStatement.parameters[":recordId"] = spat_id;
dbStatement.execute();
}
}}