internal Attachments GetAttachments(int NoteId)
{
string sSQL = "SELECT * FROM tblAttachments WHERE NoteId = " + NoteId +
" And IsDefault = 0";
DataSet DS = RF.GetDataSet(sSQL);
DataTable DT = DS.Tables[0];
Attachments AS = new Attachments();
if(DT.Rows.Count == 0)
return AS;
foreach(DataRow r in DT.Rows)
{
Attachment X = new Attachment();
X.mvarID = Convert.ToInt32(r[0]);
X.mvarOriginalName = Convert.ToString(r[1]);
X.mvarStoredName = Convert.ToString(r[2]);
X.mvarNoteId = Convert.ToInt32(r[3]);
X.mvarCreated = Convert.ToDateTime(r[4]);
X.mvarFileSize = Convert.ToInt32(r[6]);
AS.Add(X);
}
return AS;
}
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 OCL.Attachments AllVisibleAttachments(OCL.User AccessingUser,OCL.Group TargetGroup, OCL.Note TargetNote)
{
string sSQL = "SELECT DISTINCT tblGroupTokens.ObjectId, tblAttachments.OriginalName FROM tblGroupTokens LEFT OUTER JOIN tblAttachments ON tblGroupTokens.ObjectId = tblAttachments.Id" +
" AND tblGroupTokens.ObjectTypeId = " + Convert.ToInt32(OCL.OysterObjectType.Attachment) +
" AND tblGroupTokens.GroupId = " + TargetGroup.mvarID +
" AND tblAttachments.IsDefault = 0" +
" AND tblAttachments.NoteId = " + TargetNote.mvarID +
" ORDER BY tblAttachments.OriginalName";
if(!AccessingUser.mvarIsSuperUser)
{
sSQL = "SELECT DISTINCT tblGroupTokens.ObjectId, tblAttachments.OriginalName FROM tblGroupTokens LEFT OUTER JOIN tblAttachments ON tblGroupTokens.ObjectId = tblAttachments.Id WHERE UserId = " + AccessingUser.ID +
" AND tblGroupTokens.ObjectTypeId = " + Convert.ToInt32(OCL.OysterObjectType.Attachment) +
" AND tblGroupTokens.GroupId = " + TargetGroup.mvarID +
" AND tblGroupTokens.IsVisible <> 0" +
" AND tblAttachments.IsDefault = 0" +
" AND tblAttachments.NoteId = " + TargetNote.mvarID +
" ORDER BY tblAttachments.OriginalName";
}
DataSet DS = RF.GetDataSet(sSQL);
DataTable DT = DS.Tables[0];
Attachments AS = new Attachments();
if(DT.Rows.Count == 0)
return AS;
foreach(DataRow r in DT.Rows)
{
Attachment X = GetAttachment(Convert.ToInt32(r[0]));
AS.Add(X);
}
return AS;
}
