internal bool RemoveNote(OCL.User AccessingUser, OCL.Note CurrentNote) { try { if(CurrentNote.CanDelete(AccessingUser)) { //Remove any attached files if(CurrentNote.HasAttachment) { foreach(OCL.Attachment NA in CurrentNote.FileAttachments) { this.RemoveNoteAttachment(CurrentNote.mvarID, NA.ID); } } string sSQL = "DELETE FROM tblNotes WHERE Id = " + CurrentNote.ID; int numrecs = RF.ExecuteCommandNonQuery(sSQL); if(numrecs < 1) throw new Exception("Failed to delete Note " + CurrentNote.ID + " for unknown reason"); else return true; } return false; } catch(Exception Err) { throw new ApplicationException(Err.Message); } }
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); } }
public bool DeleteGroup(OCL.Group TargetGroup, OCL.User AccessingUser, out string ErrorString) { ErrorString = ""; try { if(TargetGroup.CanDelete(AccessingUser)) { Functions F = new Functions(); F.DeleteGroup(TargetGroup,AccessingUser); return true; } else { ErrorString = "User does not have access to delete group."; return false; } } catch(Exception Err) { ErrorString = Err.Message; return false; } }
internal bool DeleteGroup(OCL.Group TargetGroup,OCL.User AccessingUser) { try { if(TargetGroup.CanDelete(AccessingUser)) { //Delete all references to items in this group string sSQL = "DELETE FROM tblGroupTokens WHERE GroupID = " + TargetGroup.ID; if(this.ExecuteNonQuery(sSQL) == 0) throw new Exception("Unknown error attempting to remove all items from " + TargetGroup.Description); //Just in case nested groups have been implemented. Delete this group from all other group entries. sSQL = "DELETE FROM tblGroupTokens WHERE ObjectID = " + TargetGroup.ID + " AND ObjectTypeId = " + Convert.ToInt32(OysterObjectType.Group).ToString(); this.ExecuteNonQuery(sSQL); sSQL = "Delete FROM tblGroup WHERE ID = " + TargetGroup.ID; if(this.ExecuteNonQuery(sSQL) == 0) throw new Exception("Unknown error attempting to remove group " + TargetGroup.Description); return true; } else { throw new Exception("User does not have access to delete group."); } } catch(Exception Err) { throw new ApplicationException(Err.Message,Err.InnerException); } }
/// <summary> /// /// </summary> /// <param name="AccessingUser"></param> /// <param name="CurrentNote"></param> /// <returns></returns> public bool RemoveNote(OCL.User AccessingUser, OCL.Note CurrentNote) { if((AccessingUser.mvarIsSuperUser)||(CurrentNote.CanDelete(AccessingUser))) { Functions F = new Functions(); F.RemoveNote(CurrentNote.ID); return true; } else return false; }