private void ListsContentPage_Load(object sender, EventArgs e) { if (UIs.anna.LogInPage.loggedInUser == true) { Console.WriteLine("UserID: " + UIs.anna.LogInPage.userId); } else { var eventminiview = new UIs.Common.EventMiniView(); // eventminiview.Scale(0.55F); EventHolderFlowLayoutPanel.Controls.Add(eventminiview); } }
public void MyEventsListsContentPageLoad(int userId, UIs.valentina.ListsContentPage theListContentPage) { int EventNum = Classes.DatabaseGeneralMethods.ReturnNumberOfUserEvents(userId); Classes.DatabaseGeneralMethods.GetUserEventCategoryIds(userId); Classes.DatabaseGeneralMethods.GetUserEventIds(userId); for (int i = 0; i < EventNum; i++) { var eventImagePath = Classes.DatabaseGeneralMethods.returnImageOfEvent(Convert.ToInt32(eventIDList[i])); var eventImage = eventImagePath == "" ? null : Classes.Utility.DownloadImage(eventImagePath); var eventTitle = Classes.DatabaseGeneralMethods.returnTitleOfEvent(Convert.ToInt32(eventIDList[i])); var catColor = Classes.DatabaseGeneralMethods.GetCategoryColorOfEvent(Convert.ToInt32(eventCategoryIDList[i])); var eventminiview = new UIs.Common.EventMiniView(catColor, Convert.ToInt32(eventIDList[i]), eventTitle, eventImage); // eventminiview.Scale(0.55F); theListContentPage.EventHolderFlowLayoutPanel.Controls.Add(eventminiview); } }
public void showMatches() { matchesFlowLayoutPanel.Controls.Clear(); List <string> selectedCategoryIds = new List <string>(); foreach (CategoryMiniBox box in allcategoriesFlowLayoutPanel2.Controls) { if (box.IsSelected) { selectedCategoryIds.Add(box.ID.ToString()); } } foreach (CategoryMiniBox box in allcategoriesFlowLayoutPanel3.Controls) { if (box.IsSelected) { selectedCategoryIds.Add(box.ID.ToString()); } } var ids = String.Join(",", selectedCategoryIds); MySqlConnection con; try { con = new MySqlConnection(conStr); con.Open(); MySqlCommand command; MySqlDataReader dataReader; String queryString = "SELECT ev.title, cat.color, ev.id, ev.image " + // When Images get inserted to database, there will be a -- event.image -- added, and the -- event.title -- will be removed. "FROM event ev JOIN categories cat " + "ON cat.id = ev.categoryID " + "WHERE cat.id IN (" + ids + ") " + "LIMIT 50"; command = new MySqlCommand(queryString, con); dataReader = command.ExecuteReader(); while (dataReader.Read()) { var imUrl = dataReader.IsDBNull(3) ? "" : dataReader.GetString(3); Image img = imUrl == "" ? null : Classes.Utility.DownloadImage(imUrl); var eventminiview = new UIs.Common.EventMiniView(dataReader.GetString(1), Convert.ToInt32(dataReader.GetString(2)), dataReader.GetString(0), img); eventminiview.Scale(0.90F); matchesFlowLayoutPanel.Controls.Add(eventminiview); } con.Close(); } catch (Exception e) { Console.WriteLine(e.Message); } /* * var eventminiview = new UIs.Common.EventMiniView(); * eventminiview.Scale(0.55F); * matchesFlowLayoutPanel.Controls.Add(eventminiview); */ }