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; }