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();
}
/// <summary>
/// The method that supports the possibility of resignation from the performance of the announcement
/// or from taking part in the event.
/// It also supports deleting announcements or events that the logged-in user has created.
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Page_Load(object sender, EventArgs e)
{
db = new SQLDatabase();
db.Connect();
if (Request.QueryString["id_a"] != null)
{
id_a = int.Parse(Request.QueryString["id_a"]);
}
if (Request.QueryString["id_e"] != null)
{
id_e = int.Parse(Request.QueryString["id_e"]);
}
if (Request.QueryString["id_u"] != null)
{
id_u = int.Parse(Request.QueryString["id_u"]);
}
opcja = 0;
if (Request.QueryString["r"] != null)
{
if (Request.QueryString["r"].Equals("z"))
{
opcja = 1;
}
if (Request.QueryString["r"].Equals("u"))
{
opcja = 2;
}
}
if (opcja == 1)
{
if (Request.QueryString["id_a"] != null)
{
db.DeclineFromAnnouncement(id_a, db.getId((string)Session["id"]));
}
if (Request.QueryString["id_e"] != null)
{
db.DeclineFromEvent(id_e, db.getId((string)Session["id"]));
}
Response.Redirect("MyActivities.aspx");
}
if (opcja == 2)
{
if (Request.QueryString["id_e"] != null)
{
if (Request.QueryString["id_u"] != null)
{
Send_Email(db.getEmail(id_u), db.getNickname_id(id_u), true, db.getTitleEvent(id_e));
}
db.Delete_Users_Joined_Event(id_e);
db.DeleteInvitation(id_e);
db.DeleteEvent(id_e);
}
if (Request.QueryString["id_a"] != null)
{
if (Request.QueryString["id_u"] != null)
{
Send_Email(db.getEmail(id_u), db.getNickname_id(id_u), false, db.getTitleAnnouncement(id_a));
}
List <int?> list_events_id = db.getIdEvents(id_a);
for (int i = 0; i < list_events_id.Count; i++)
{
db.Delete_Users_Joined_Event((int)list_events_id.ElementAt(i));
db.DeleteInvitation((int)list_events_id.ElementAt(i));
}
db.DeleteEvent_id_a(id_a);
db.Delete_Users_Assigned_Announcement(id_a);
db.DeleteAnnouncement(id_a);
}
if (Request.QueryString["id_u"] == null)
{
Response.Redirect("MyActivities.aspx");
}
}
db.Disconnect();
}