internal OCL.Attachments SetNoteAttachments(int NotedId, string[] sfile,ref OCL.FTPTransfer FTP)
{
OCL.Attachments AS = new Attachments();
try
{
FTP.ConnectToOysterServer(ServerAddress);
//FT.ConnectToOysterServer("ome-prototype");
}
catch(Exception Err)
{
throw new Exception(Err.Message);
}
System.IO.FileInfo[] FI = new System.IO.FileInfo[sfile.Length];
int i = 0;
foreach(string CFile in sfile)
{
FI[i] = new System.IO.FileInfo(CFile);
i++;
}
string[] EncodedFileNames = FTP.UploadFile(FI,false,true);
i = 0;
foreach(string EFN in EncodedFileNames)
{
string sSQL = "INSERT INTO tblAttachments(OriginalName,StoredName,NoteId, FileSize) VALUES(" +
" '" + FI[i].Name + "','" + EFN +
"'," + NotedId.ToString() +
"," + FI[i].Length +
"); SELECT IDENT_CURRENT('tblAttachments')";
int AttachmentID = Convert.ToInt32(RF.ExecuteCommandWithQuery(sSQL));
OCL.Attachment A = this.GetAttachment(AttachmentID);
AS.Add(A);
i++;
}
return AS;
}
internal string[] UploadFiles(string[] sourcefiles,bool ShowProgress,bool EncryptFileNames,ref OCL.FTPTransfer FT)
{
OCL.Attachments AS = new Attachments();
try
{
FT.ConnectToOysterServer(ServerAddress);
//FT.ConnectToOysterServer("ome-prototype");
}
catch(Exception Err)
{
throw new Exception(Err.Message);
}
System.IO.FileInfo[] FI = new System.IO.FileInfo[sourcefiles.Length];
int i = 0;
foreach(string CFile in sourcefiles)
{
FI[i] = new System.IO.FileInfo(CFile);
i++;
}
string[] EncodedFileNames = new string[1];
try
{
EncodedFileNames = FT.UploadFile(FI,ShowProgress,EncryptFileNames);
}
catch(Exception Err)
{
throw new Exception(Err.Message);
}
try
{
FT.DisconnectFromOysterServer();
}
catch(Exception Err)
{
string peekError = Err.Message;
}
return EncodedFileNames;
}
internal OCL.Attachment SetNoteAttachment(int NoteId, string sfile,ref OCL.FTPTransfer FTP)
{
//FTPTransfer FT = new FTPTransfer();
try
{
FTP.ConnectToOysterServer(ServerAddress);
//FT.ConnectToOysterServer("ome-prototype");
}
catch(Exception Err)
{
throw new Exception(Err.Message);
}
System.IO.FileInfo[] AFI = new System.IO.FileInfo[1];
System.IO.FileInfo FI = new System.IO.FileInfo(sfile);
AFI[0] = FI;
string[] EncodedFileName = FTP.UploadFile(AFI,false,true);
OCL.Note N = GetNote(NoteId);
string sSQL = "INSERT INTO tblAttachments(OriginalName,StoredName,NoteId,FileSize) VALUES(" +
" '" + FI.Name + "','" + EncodedFileName[0] +
"'," + N.ID.ToString() +
"," + FI.Length +
"); SELECT IDENT_CURRENT('tblAttachments')";
int AttachmentID = Convert.ToInt32(RF.ExecuteCommandWithQuery(sSQL));
return this.GetAttachment(AttachmentID);
//int numrecs = RF.ExecuteCommand(sSQL);
}