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);
*/
}
