protected void Delete_Account(object sender, EventArgs e) { List <int> list_announcement_id = ListAnnouncements_User(); List <int> list_events_id = ListEventsFromAnnouncement_User(); List <int> list_invitations_id = ListInvitations_User(); db = new SQLDatabase(); db.Connect(); db.Delete_Users_Assigned_Announcement_id_user(id); for (int i = 0; i < list_announcement_id.Count; i++) { db.Delete_Users_Assigned_Announcement(list_announcement_id.ElementAt(i)); } for (int i = 0; i < list_events_id.Count; i++) { db.Delete_Users_Joined_Event(list_events_id.ElementAt(i)); } db.Delete_Users_Joined_Event_id_user(id); for (int i = 0; i < list_events_id.Count; i++) { db.Delete_Users_Joined_Event(list_events_id.ElementAt(i)); } for (int i = 0; i < list_invitations_id.Count; i++) { db.DeleteInvitation_id(list_invitations_id.ElementAt(i)); } for (int i = 0; i < list_events_id.Count; i++) { db.DeleteEvent(list_events_id.ElementAt(i)); } for (int i = 0; i < list_announcement_id.Count; i++) { db.DeleteAnnouncement(list_announcement_id.ElementAt(i)); } db.DeleteUser(id); Session.RemoveAll(); Response.Redirect("Home.aspx"); db.Disconnect(); }