public void addVenueDetailsToVenueProfile()
{
int venueId = -1;
int theUserId = UIs.anna.LogInPage.userId;
var v = Db_connector.ExecuteQuery(@"SELECT ve.id, ve.name, ar.country FROM venues ve JOIN area ar
ON ve.areaID = ar.id WHERE ve.id = venueId ",
new MySqlParameter("@venueId", venueId));
try
{
v.Read();
theSVenueProfilePage = new UIs.andrea.VenueProfilePage(v.GetInt32(0), v.GetString(1), null, null);
}
catch
{
theSVenueProfilePage = new UIs.andrea.VenueProfilePage(-1, "No Venue", null, null);
}
var z = Db_connector.ExecuteQuery(@"SELECT DISTINCT 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 evL.title='HISTORY' AND fol.following_user_id = @theUserId AND ev.id = @venueId ",
new[] { new MySqlParameter("@theUserId", theUserId), new MySqlParameter("@venueId", venueId) });
try
{
z.Read();
UIs.andrea.VenueProfilePage.Instance.friendsWhoHaveVisited(z.GetString(0), z.GetString(1));
}
catch
{
UIs.andrea.VenueProfilePage.Instance.friendsWhoHaveVisited("No", "User");
}
}
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", "");
}
private void LoggedOutUser(int size)
{
var query = Db_connector.Categories(size);
List <List <string> > Categories = Db_connector.Readrows(query, new int[] { 0, 1 });
for (int i = 0; i < size; i++)
{
GroupBox.Add(new CategoryGroupBox(Categories [i] [0], Categories[i][1]));
}
}
private void LoggedInUser(int size)
{
//den exw tropo na parw ton loged in user
List <List <string> > Categories = Db_connector.Readrows(Db_connector.Categories(size), new int[] { 2, 3 });
for (int i = 0; i < size; i++)
{
GroupBox.Add(new CategoryGroupBox(Categories[i][0], Categories[i][1]));
}
}
public todayEventsCarousel()
{
MySqlDataReader reader = Db_connector.ActiveEvents();
List <List <string> > Events = Db_connector.Readrows(reader, new int[] { 0, 1, 2, 3 });
for (int i = 0; i < Events.Count; i++)
{
var imgPath = Events[i][3];
Image img = imgPath == "" ? null : Classes.Utility.DownloadImage(imgPath);
EventMiniView obj = new EventMiniView(Events[i][2], Int32.Parse(Events[i][0]), Events[i][1], img);
TodaysEvents.Add(obj);
}
}
private void addUsersDetailsInUserProfile()
{
int theUserId = UIs.anna.LogInPage.userId;
var z = Db_connector.ExecuteQuery(@"SELECT users.id, users.name, surname FROM users WHERE users.id = @theUserId",
new MySqlParameter("@theUserId", theUserId));
try
{
z.Read();
theUserProfilePage = new UIs.andrea.UserProfilePage(z.GetInt32(0), z.GetString(1), z.GetString(2), null);
}
catch
{
theUserProfilePage = new UIs.andrea.UserProfilePage(-1, "No", "User", null);
}
}
