protected List <Event_count> count_joined_user()
{
db = new SQLDatabase();
db.Connect();
list_events = db.ListEvents();
List <Event_count> ranking_amount_events2 = new List <Event_count>();
for (int i = 0; i < list_events.Count; i++)
{
ranking_amount_events2.Add(new Event_count(list_events.ElementAt(i).id, db.Count_Events(list_event_ranking, list_events.ElementAt(i).id)));
}
ranking_amount_events2.Sort((Event_count x, Event_count y) => y.amount.CompareTo(x.amount));
/* for (int i = 0; i < ranking_amount_events2.Count; i++)
* {
* for (int j = i; j < ranking_amount_events2.Count; j++)
* {
* if (ranking_amount_events2.ElementAt(j).amount > ranking_amount_events2.ElementAt(i).amount)
* {
* Event_count temp = ranking_amount_events2.ElementAt(i);
* ranking_amount_events2.Insert(i, ranking_amount_events2.ElementAt(j));
* ranking_amount_events2.Insert(j, temp);
* }
* }
* } */
// db.Disconnect();
return(ranking_amount_events2);
}
