public void addEventDetailsInEventProfile(int eventId) { int theUserId = UIs.anna.LogInPage.userId; var v = Db_connector.ExecuteQuery(@"SELECT us.id, ev.id, ev.title, ve.name, cat.color, ev.image, us.name, us.surname, ev.startingDate, ev.ticketprice, ev.description " + "FROM event ev " + "JOIN venues ve ON ev.venueID = ve.id " + "JOIN area ar ON ar.id = ve.areaID " + "JOIN users us ON us.id = ev.ownerID " + "JOIN categories cat ON ev.categoryID = cat.id " + "WHERE ev.id = @eventId ", new MySqlParameter("@eventId", eventId)); try { v.Read(); Image img = v.IsDBNull(5) ? null : Classes.Utility.DownloadImage(v.GetString(5)); theEventProfilePage = new UIs.andrea.EventProfilePage( v.GetInt32(0), v.GetInt32(1), v.GetString(2), v.GetString(3), v.GetString(4), img, v.GetString(6), v.GetString(7), v.GetDateTime(8), v.GetDouble(9), v.GetString(10)); } catch (Exception e) { Console.WriteLine(e.Message); theEventProfilePage = new UIs.andrea.EventProfilePage(-1, -1, "NoEventFound", "", "", null, "", "", DateTime.Now, 1.00, ""); } //bool userLoggedIn = false; if (UIs.anna.LogInPage.loggedInUser == true) { var z = Db_connector.ExecuteQuery(@"SELECT us.name, us.surname, evL.title FROM following fol JOIN users us ON fol.followed_user_id = us.id JOIN event_list evL ON fol.followed_user_id = evL.creatorID JOIN attendants att ON evL.id = att.eventListID JOIN event ev ON att.eventID = ev.id WHERE ev.id = @eventId AND fol.following_user_id = @theUserId ", new[] { new MySqlParameter("@eventId", eventId), new MySqlParameter("@theUserId", theUserId) }); try { while (z.Read()) { theEventProfilePage.friendsWhoWillAttend(null, z.GetString(0), z.GetString(1), z.GetString(2)); } //userLoggedIn = true; } catch (Exception e) { Console.WriteLine(e.Message); //userLoggedIn = false; } } //if (!userLoggedIn) //theEventProfilePage.friendsWhoWillAttend(null, "No", "User", ""); }
public void eventsProfileToolStripMenuItem() { Controllers.UIController.Instance.MainSplitForm.middlePanel.Controls.Clear(); theEventProfilePage = new UIs.andrea.EventProfilePage(); Controllers.UIController.Instance.MainSplitForm.middlePanel.Controls.Add(theEventProfilePage); designEditOfPanels(theEventProfilePage); }