public static void DeletePolicy(Group g, Policy pol) { if (!DoesUserHavePolicy(WindchimeSession.Current.User, Policy.DeletePolicy)) { throw new NoPolicyException(Policy.DeletePolicy); } using (WindchimeEntities wce = new WindchimeEntities()) { var deletePol = (from PolicyEntry pe in wce.PolicyEntries where pe.GroupID == g.GroupID && pe.Policy == pol select pe); foreach (var p in deletePol) { wce.DeleteObject(p); } wce.SaveChanges(); } }
public static void DeletePermissionEntry(Group g, PermissionableEntity ent, Permission perm) { if (!DoesUserHavePerm(WindchimeSession.Current.User, ent, Permission.EditPermissions)) { throw new NoPermissionException(Permission.EditPermissions); } if (g == null || ent == null) { return; } using (WindchimeEntities wce = new WindchimeEntities()) { var deletePerm = (from PermissionEntry pe in wce.PermissionEntrySet where pe.GroupID == g.GroupID && pe.EntityID == ent.EntityID && pe.Permission == (int)perm select pe); foreach (var pe in deletePerm) { wce.DeleteObject(pe); } } }
protected void ClearDBButton_Click(object sender, EventArgs e) { using (WindchimeEntities wce = new WindchimeEntities()) { var deleteAssetTypes = (from x in wce.AssetTypeSet select x); var deleteComments = (from x in wce.CommentSet select x); var deleteCreators = (from x in wce.CreatorSet select x); var deleteGroups = (from x in wce.Groups select x); var deleteEnts = (from x in wce.PermissionableEntities select x); var deletePerms = (from x in wce.PermissionEntrySet select x); var deletePols = (from x in wce.PolicyEntries select x); var deleteVers = (from x in wce.VersionSet select x); var deleteAssets = (from x in wce.Assets select x); var deleteColls = (from x in wce.Collections select x); foreach (Group go in wce.Groups) { go.Parents.Load(); var Parents = go.Parents.ToList(); foreach (Group gi in Parents) { go.Parents.Remove(gi); } } wce.SaveChanges(); foreach (Collection co in wce.Collections) { co.Parents.Load(); var Parents = co.Parents.ToList(); foreach (Collection ci in Parents) { co.Parents.Remove(ci); } } wce.SaveChanges(); foreach (Asset ao in wce.Assets) { ao.Collections.Load(); var Parents = ao.Collections.ToList(); foreach (Collection ci in Parents) { ao.Collections.Remove(ci); } } wce.SaveChanges(); foreach (Group go in wce.Groups) { go.Users.Load(); var Parents = go.Users.ToList(); foreach (User ui in Parents) { go.Users.Remove(ui); } } wce.SaveChanges(); foreach (var a in deleteAssetTypes) { wce.DeleteObject(a); } foreach (var c in deleteComments) { wce.DeleteObject(c); } foreach (var c in deleteCreators) { wce.DeleteObject(c); } foreach (var g in deleteGroups) { wce.DeleteObject(g); } foreach (var d in deleteEnts) { wce.DeleteObject(d); } foreach (var p in deletePerms) { wce.DeleteObject(p); } foreach (var p in deletePols) { wce.DeleteObject(p); } foreach (var v in deleteVers) { wce.DeleteObject(v); } foreach (var a in deleteAssets) { wce.DeleteObject(a); } foreach (var c in deleteColls) { wce.DeleteObject(c); } wce.SaveChanges(); } LoadTestDataButton.Enabled = true; }
public static void DeletePolicy(Group g, Policy pol) { if (!DoesUserHavePolicy(WindchimeSession.Current.User, Policy.DeletePolicy)) throw new NoPolicyException(Policy.DeletePolicy); using (WindchimeEntities wce = new WindchimeEntities()) { var deletePol = (from PolicyEntry pe in wce.PolicyEntries where pe.GroupID == g.GroupID && pe.Policy == pol select pe); foreach (var p in deletePol) wce.DeleteObject(p); wce.SaveChanges(); } }
public static void DeletePermissionEntry(Group g, PermissionableEntity ent, Permission perm) { if (!DoesUserHavePerm(WindchimeSession.Current.User, ent, Permission.EditPermissions)) throw new NoPermissionException(Permission.EditPermissions); if (g == null || ent == null) return; using (WindchimeEntities wce = new WindchimeEntities()) { var deletePerm = (from PermissionEntry pe in wce.PermissionEntrySet where pe.GroupID == g.GroupID && pe.EntityID == ent.EntityID && pe.Permission == (int)perm select pe); foreach (var pe in deletePerm) wce.DeleteObject(pe); } }
protected void ClearDBButton_Click(object sender, EventArgs e) { using (WindchimeEntities wce = new WindchimeEntities()) { var deleteAssetTypes = (from x in wce.AssetTypeSet select x); var deleteComments = (from x in wce.CommentSet select x); var deleteCreators = (from x in wce.CreatorSet select x); var deleteGroups = (from x in wce.Groups select x); var deleteEnts = (from x in wce.PermissionableEntities select x); var deletePerms = (from x in wce.PermissionEntrySet select x); var deletePols = (from x in wce.PolicyEntries select x); var deleteVers = (from x in wce.VersionSet select x); var deleteAssets = (from x in wce.Assets select x); var deleteColls = (from x in wce.Collections select x); foreach (Group go in wce.Groups) { go.Parents.Load(); var Parents = go.Parents.ToList(); foreach (Group gi in Parents) go.Parents.Remove(gi); } wce.SaveChanges(); foreach (Collection co in wce.Collections) { co.Parents.Load(); var Parents = co.Parents.ToList(); foreach (Collection ci in Parents) co.Parents.Remove(ci); } wce.SaveChanges(); foreach (Asset ao in wce.Assets) { ao.Collections.Load(); var Parents = ao.Collections.ToList(); foreach (Collection ci in Parents) ao.Collections.Remove(ci); } wce.SaveChanges(); foreach (Group go in wce.Groups) { go.Users.Load(); var Parents = go.Users.ToList(); foreach (User ui in Parents) go.Users.Remove(ui); } wce.SaveChanges(); foreach (var a in deleteAssetTypes) wce.DeleteObject(a); foreach (var c in deleteComments) wce.DeleteObject(c); foreach (var c in deleteCreators) wce.DeleteObject(c); foreach (var g in deleteGroups) wce.DeleteObject(g); foreach (var d in deleteEnts) wce.DeleteObject(d); foreach (var p in deletePerms) wce.DeleteObject(p); foreach (var p in deletePols) wce.DeleteObject(p); foreach (var v in deleteVers) wce.DeleteObject(v); foreach (var a in deleteAssets) wce.DeleteObject(a); foreach (var c in deleteColls) wce.DeleteObject(c); wce.SaveChanges(); } LoadTestDataButton.Enabled = true; }