public static void Remove(Core core, ListItem item) { core.Db.BeginTransaction(); item.Delete(); UpdateQuery uQuery = new UpdateQuery(GetTable(typeof(List))); uQuery.AddField("list_items", new QueryOperation("list_items", QueryOperations.Subtraction, 1)); uQuery.AddCondition("list_id", item.ListId); core.Db.Query(uQuery); }
public void Remove(long listItemId) { ListItem item = new ListItem(core, listItemId); db.BeginTransaction(); item.Delete(); UpdateQuery uQuery = new UpdateQuery(GetTable(typeof(List))); uQuery.AddField("list_items", new QueryOperation("list_items", QueryOperations.Subtraction, 1)); uQuery.AddCondition("list_id", listId); db.Query(uQuery); }
/// <summary> /// Remove an item from a list /// </summary> void AccountListsManage_Remove(object sender, EventArgs e) { AuthoriseRequestSid(); long itemId = core.Functions.RequestLong("id", 0); try { ListItem item = new ListItem(core, itemId); List list = new List(core, LoggedInMember, item.ListId); List.Remove(core, item); SetRedirectUri(list.Uri); core.Display.ShowMessage("List Updated", "You have successfully removed an item from your list."); } catch (InvalidListItemException) { DisplayGenericError(); return; } catch (UnauthorisedToDeleteItemException) { DisplayGenericError(); return; } }