예제 #1
0
        internal bool DeleteSession(OCL.User AccessingUser,OCL.RecordingSession RS)
        {
            if(!RS.CanDeleteSession(AccessingUser))
            {
                return false;
            }
            try
            {
                string sSQL = "SELECT tblAttachments.StoredName FROM tblAttachments left outer join tblNotes ON tblNotes.Id = tblAttachments.NoteId" +
                    " left outer join tblSession ON tblNotes.SessionId = tblSession.Id WHERE tblSession.Id = " + RS.ID;

                DataSet DS = RF.GetDataSet(sSQL);
                FTPTransfer FT = new FTPTransfer();
                try
                {
                    FT.ConnectToOysterServer(ServerAddress);
                    //FT.ConnectToOysterServer("ome-prototype");
                }
                catch(Exception Err)
                {
                    throw new Exception(Err.Message);
                }
                if(DS.Tables[0].Rows.Count > 0)
                {
                    foreach(DataRow r in DS.Tables[0].Rows)
                    {
                        FT.RemoveFile(Convert.ToString(r[0]));
                    }
                }
                sSQL = "DELETE FROM tblAttachments FROM tblSession,tblNotes WHERE tblNotes.SessionId = tblSession.Id " +
                    "AND tblAttachments.NoteId = tblNotes.Id AND tblSession.Id = " + RS.ID;
                int numrecs = RF.ExecuteCommandNonQuery(sSQL);

                //Remove Recordings
                sSQL = "SELECT tblRecording.Name FROM tblRecording WHERE SessionId = " + RS.ID;
                DS = RF.GetDataSet(sSQL);
                if(DS.Tables[0].Rows.Count > 0)
                {
                    foreach(DataRow r in DS.Tables[0].Rows)
                    {
                        FT.RemoveFile(Convert.ToString(r[0]));
                    }
                }

                //DELETE EVERYTHING!!!
                sSQL = "DELETE FROM tblNotes WHERE tblNotes.SessionId = " + RS.mvarID +
                    "; DELETE FROM tblRecording WHERE tblRecording.SessionId = " + RS.mvarID +
                    "; DELETE FROM tblSession WHERE tblSession.Id = " + RS.mvarID;

                numrecs = RF.ExecuteCommandNonQuery(sSQL);

                if(numrecs > 0)
                    return true;
                else
                    return false;
            }
            catch(Exception Err)
            {
                throw new Exception(Err.Message);
            }
        }
예제 #2
0
        internal void RemoveNoteAttachment(int NoteId, int AttachmentId)
        {
            FTPTransfer FT = new FTPTransfer();
            try
            {
                FT.ConnectToOysterServer(ServerAddress);
            }
            catch(Exception Err)
            {
                throw new Exception(Err.Message);
            }
            Attachment FA = GetAttachment(AttachmentId);

            try
            {
                FT.RemoveFile(FA.StoredName);
            }
            catch(Exception Err)
            {
                throw new Exception(Err.Message);
            }
            string sSQL = "DELETE FROM tblAttachments WHERE Id = " + AttachmentId;

            int records = RF.ExecuteCommand(sSQL);
            records = records;
        }
예제 #3
0
        internal bool DeleteRecording(OCL.User AccessingUser,OCL.Recording R)
        {
            if(!R.CanDelete(AccessingUser))
            {
                return false;
            }
            try
            {
                FTPTransfer FT = new FTPTransfer();
                try
                {
                    FT.ConnectToOysterServer(ServerAddress);
                    //FT.ConnectToOysterServer("ome-prototype");
                }
                catch(Exception Err)
                {
                    throw new Exception(Err.Message);
                }
                FT.RemoveFile(R.Description);

                string sSQL = "DELETE FROM tblRecording WHERE ID = " + R.ID;
                int numrecs = RF.ExecuteCommandNonQuery(sSQL);
                if(numrecs > 0)
                    return true;
                else
                    return false;
            }
            catch(Exception Err)
            {
                throw new Exception(Err.Message);
            }
        }