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);
}
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 void DownloadRecordingSession(User AccessingUser,RecordingSessions ARS, string sDestination,bool IncludeAttachments, bool ShowProgress,ref OCL.FTPTransfer FT)
{
try
{
FT.ConnectToOysterServer(ServerAddress);
//FT.ConnectToOysterServer("ome-prototype");
}
catch(Exception Err)
{
throw new Exception(Err.Message);
}
int NumberOfDownloadingFiles = 0;
foreach(RecordingSession RS in ARS)
{
foreach(Recording R in RS.CurrentRecordings(AccessingUser))
{
string peek = R.Description;
NumberOfDownloadingFiles++;
}
if(IncludeAttachments)
{
foreach(Note N in RS.AllVisibleNotes(AccessingUser))
{
foreach(Attachment A in N.FileAttachments)
{
string peek = A.mvarStoredName;
NumberOfDownloadingFiles++;
}
}
}
}
string[] sDest = new string[NumberOfDownloadingFiles];
string[] sStoredNames = new string[NumberOfDownloadingFiles];
int i = 0;
foreach(RecordingSession RS in ARS)
{
foreach(Recording R in RS.CurrentRecordings(AccessingUser))
{
//string safeName = RenameFile(R.DisplayName,".wmv",sDestination);
string safeName = RenameFile(RS.Description + "_" + R.DisplayName,".wmv",sDestination);
sDest[i] = sDestination + @"\" + safeName;
// sDest[i] = sDestination + @"\" + R.DisplayName + ".wmv";
sStoredNames[i] = R.Description;
i++;
}
if(IncludeAttachments)
{
foreach(Note N in RS.AllVisibleNotes(AccessingUser))
{
foreach(Attachment A in N.FileAttachments)
{
sDest[i] = sDestination + @"\" + A.StoredName;
sStoredNames[i] = A.StoredName;
i++;
}
}
}
}
FT.DownloadFile(sDest,sStoredNames,ShowProgress);
}