//Comparing all registered leagues for each administrator //ID = League ID public List <rep_league> gt_LeaguesStatsForAdmin(string ID) { int id = Convert.ToInt32(ID);//league ID List <rep_league> data = new List <rep_league>(); using (SPORT_LINK_DBDataContext db = new SPORT_LINK_DBDataContext()) { try { //Find User ID int leagueID = (from lg in db.LEAGUEs where lg.League_Id.Equals(id) select lg.USER.UserId).First(); var query = (from log in db.LEAGUEs where log.USER.UserId.Equals(leagueID) select log).ToList(); if (query != null) { foreach (LEAGUE leagues in query) { var res = (from sums in db.LOGs where sums.LEAGUE.League_Id.Equals(leagues.League_Id) select sums).ToList(); int wins = Convert.ToInt32(res.Sum(p => p.Wins)); int looses = Convert.ToInt32(res.Sum(p => p.Loose)); int draws = Convert.ToInt32(res.Sum(p => p.Draws)); rep_league items = new rep_league(); items.LeagueName = leagues.Name; items.Wins = wins; items.Lose = looses; items.Draws = draws; data.Add(items); } return(data); } return(null); } catch (Exception) { return(null); } }; }
//Comparing all registered leagues public List <rep_league> gt_LeaguesStats() { List <rep_league> data = new List <rep_league>(); using (SPORT_LINK_DBDataContext db = new SPORT_LINK_DBDataContext()) { try { var query = (from log in db.LEAGUEs select log).ToList(); if (query != null) { foreach (LEAGUE leagues in query) { var res = (from sums in db.LOGs where sums.LEAGUE.League_Id.Equals(leagues.League_Id) select sums).ToList(); int wins = Convert.ToInt32(res.Sum(p => p.Wins)); int looses = Convert.ToInt32(res.Sum(p => p.Loose)); int draws = Convert.ToInt32(res.Sum(p => p.Draws)); rep_league items = new rep_league(); items.LeagueName = leagues.Name; items.Wins = wins; items.Lose = looses; items.Draws = draws; data.Add(items); } return(data); } return(null); }catch (Exception) { return(null); } }; }