public ActionResult Add() { List <SelectListItem> matcheslist = new List <SelectListItem>(); MatchesRepository matchesrep = new MatchesRepository(); var mymatches = matchesrep.GetAllMatches().OrderByDescending(k => k.Timestamp); if (mymatches.Count() > 0) { foreach (Match m in mymatches) { SelectListItem sli = new SelectListItem(); sli.Value = m.Id.ToString(); sli.Text = m.HomeTeamName + " (" + m.HomeGoals + " - " + m.AwayGoals + ") " + m.AwayTeamName; matcheslist.Add(sli); } } ViewData["Matches"] = matcheslist; return(View()); }
// GET: Details/Create public ActionResult Create(int ID) { List <SelectListItem> tlist = new List <SelectListItem>(); List <SelectListItem> matcheslist = new List <SelectListItem>(); PlayerRepository playerList = new PlayerRepository(); MatchesRepository matchrep = new MatchesRepository(); var mymatches = matchrep.GetAllMatches(); var players = playerList.GetAllPlayers(); TeamRepository trep = new TeamRepository(); var teams = trep.GetAllTeams(); foreach (Match m in mymatches.Where(i => i.HomeTeamId == ID && i.Date.Date == DateTime.Today.Date)) { SelectListItem sli2 = new SelectListItem(); SelectListItem sli1 = new SelectListItem(); SelectListItem sli = new SelectListItem(); sli.Value = m.MatchId.ToString(); sli.Text = m.HomeTeam.Name + " " + m.HomeGoals + "-" + m.AwayGoals + " " + m.GuestTeam.Name; sli1.Value = m.HomeTeamId.ToString(); sli1.Text = m.HomeTeam.Name; matcheslist.Add(sli); tlist.Add(sli1); } var pl = db.player.Where(i => i.TeamId == ID).Select(s => new SelectListItem { Value = s.ID.ToString(), Text = s.Name + " " + s.LastName + " " + s.Number }); ViewData["Matches"] = matcheslist; ViewData["Teams"] = tlist; // ViewData["GuestTeams"] = tlist; ViewBag.MatchId = new SelectList(db.matches.Where(i => i.HomeTeamId == ID && i.Date == DateTime.Now), "MatchId", "MatchId"); ViewBag.ID = new SelectList(pl, "Value", "Text"); ViewBag.StatisticId = new SelectList(db.statistic, "StatisticId", "PName"); ViewBag.HomeTeamId = new SelectList(db.team.Where(i => i.TeamId == ID), "TeamId", "Name"); // ViewBag.GuestTeamId = new SelectList(db.team.Where(i => i.TeamId == ID), "TeamId", "Name"); return(View()); }
public ActionResult Add(MatchDetails matchdetails) { List <SelectListItem> matcheslist = new List <SelectListItem>(); MatchesRepository matchrep = new MatchesRepository(); var mymatches = matchrep.GetAllMatches(); foreach (Match m in mymatches) { if (m.Date == DateTime.Now.Date) { SelectListItem sli = new SelectListItem(); sli.Value = m.MatchId.ToString(); sli.Text = m.HomeTeam.Name + "(" + m.HomeGoals + "-" + m.AwayGoals + ")" + m.GuestTeam.Name; matcheslist.Add(sli); } } db.MatchDetails.Add(matchdetails); db.SaveChanges(); ViewData["Matches"] = matcheslist; return(View()); }
public ActionResult Create([Bind(Include = "MatchDetailsId,Content,MatchId,ID,Name,LastName,StatisticId,HomeTeamId,Min")] MatchDetails matchDetails, int ID) { List <SelectListItem> matcheslist = new List <SelectListItem>(); List <SelectListItem> tlist = new List <SelectListItem>(); MatchesRepository matchrep = new MatchesRepository(); var mymatches = matchrep.GetAllMatches(); if (ModelState.IsValid) { foreach (Match m in mymatches.Where(i => i.HomeTeamId == ID)) { SelectListItem sli1 = new SelectListItem(); SelectListItem sli = new SelectListItem(); sli.Value = m.MatchId.ToString(); sli.Text = m.HomeTeam.Name + " " + m.HomeGoals + "-" + m.AwayGoals + " " + m.GuestTeam.Name; sli1.Value = m.HomeTeamId.ToString(); sli1.Text = m.HomeTeam.Name; matcheslist.Add(sli); tlist.Add(sli1); } ViewData["Matches"] = matcheslist; ViewData["Teams"] = tlist; // ViewData["GuestTeams"] = tlist; db.MatchDetails.Add(matchDetails); db.SaveChanges(); return(RedirectToAction("Index", "Match")); } ViewBag.MatchId = new SelectList(db.matches, "MatchId", "MatchId", matchDetails.MatchId); ViewBag.ID = new SelectList(db.player.Where(i => i.TeamId == ID), "ID", "Name", "LastName", matchDetails.ID); ViewBag.StatisticId = new SelectList(db.statistic, "StatisticId", "PName", matchDetails.StatisticId); ViewBag.HomeTeamId = new SelectList(db.team.Where(i => i.TeamId == ID), "TeamId", "Name", matchDetails.HomeTeamId); // ViewBag.GuestTeamId = new SelectList(db.team.Where(i => i.TeamId == ID), "TeamId", "Name", matchDetails.GuestTeamId); return(View()); }
public ActionResult Edit(int?Id) { List <SelectListItem> matchesList = new List <SelectListItem>(); MatchesRepository matchesRep = new MatchesRepository(); var myMatches = matchesRep.GetAllMatches().OrderBy(k => k.TimeStamp); if (myMatches.Count() > 0) { foreach (Match m in myMatches) { SelectListItem sli = new SelectListItem(); sli.Value = m.Id.ToString(); sli.Text = m.HomeTeamName + " ( " + m.HomeGoals + "-" + m.AwayGoals + " ) " + m.AwayTeamName; matchesList.Add(sli); } } ViewData["Matches"] = matchesList; MatchReport model = db.MatchReports.Where(l => l.Id == Id).FirstOrDefault(); return(View(model)); }
public ActionResult GetMatches() { MatchesRepository matchService = new MatchesRepository(); return(PartialView("_MatchesList", matchService.GetAllMatches())); }
// GET: Tables public ActionResult Index() { List <LeagueTableResult> results = new List <LeagueTableResult>(); MatchesRepository matchesrep = new MatchesRepository(); TeamsRepository teamsrep = new TeamsRepository(); var allteams = teamsrep.GetAllTeams(); var allmatches = matchesrep.GetAllMatches(); if (allteams.Count() > 0) { foreach (Team t in allteams) { LeagueTableResult res = new LeagueTableResult(); res.TeamId = t.Id; res.TeamName = t.TeamName; //calc number of wins for team int wins = 0; int losses = 0; int draws = 0; int goalsfor = 0; int goalsagainst = 0; int points = 0; var allteammatches = allmatches.Where(l => l.HomeTeamId == t.Id || l.AwayTeamId == t.Id); var allteamhomematches = allteammatches.Where(l => l.HomeTeamId == t.Id); var allteamawaymatches = allteammatches.Where(l => l.AwayTeamId == t.Id); foreach (Match m in allteamhomematches) { if (m.HomeGoals > m.AwayGoals) { wins++; points += 3; } if (m.HomeGoals == m.AwayGoals) { draws++; points += 1; } if (m.HomeGoals < m.AwayGoals) { losses++; } goalsfor += (int)m.HomeGoals; goalsagainst += (int)m.AwayGoals; } foreach (Match m in allteamawaymatches) { if (m.AwayGoals > m.HomeGoals) { wins++; points += 3; } if (m.AwayGoals == m.HomeGoals) { draws++; points += 1; } if (m.AwayGoals < m.HomeGoals) { losses++; } goalsfor += (int)m.AwayGoals; goalsagainst += (int)m.HomeGoals; } res.GoalsFor = goalsfor; res.GoalsAgainst = goalsagainst; res.GoalDifference = goalsfor - goalsagainst; res.Wins = wins; res.Losses = losses; res.Draws = draws; res.Points = points; results.Add(res); } } ViewData["results"] = results.OrderByDescending(k => k.Points).ThenByDescending(k => k.GoalDifference); return(View()); }
public ActionResult Index() { List <Table> table = new List <Table>(); MatchesRepository matchrep = new MatchesRepository(); var allMatches = matchrep.GetAllMatches(); TeamRepository teamsrep = new TeamRepository(); var allTeams = teamsrep.GetAllTeams(); foreach (Team t in allTeams) { Table result = new Table(); result.Id = t.TeamId; result.TeamName = t.Name; int losses = 0; int draws = 0; int wins = 0; int goalsfor = 0; int goalsAgainst = 0; int points = 0; int Total = 0; var allTeamMAtches = allMatches.Where(k => k.HomeTeamId == t.TeamId || k.GuestTeamId == t.TeamId); var allTeamHomeMatches = allTeamMAtches.Where(k => k.HomeTeamId == t.TeamId); var allTeamAwayMatches = allTeamMAtches.Where(k => k.GuestTeamId == t.TeamId); foreach (Match m in allTeamHomeMatches.Where(i => i.Date <= DateTime.Now)) { if (m.HomeGoals > m.AwayGoals) { wins++; points += 3; } if (m.HomeGoals < m.AwayGoals) { losses++; points += 0; } if (m.HomeGoals == m.AwayGoals) { draws++; points += 1; } Total = wins + draws + losses; goalsfor += m.HomeGoals; goalsAgainst += m.AwayGoals; } foreach (Match m in allTeamAwayMatches.Where(i => i.Date <= DateTime.Now)) { if (m.AwayGoals > m.HomeGoals) { wins++; points += 3; } if (m.AwayGoals < m.HomeGoals) { losses++; points += 0; } if (m.AwayGoals == m.HomeGoals) { draws++; points += 1; } Total = wins + draws + losses; goalsfor += m.AwayGoals; goalsAgainst += m.HomeGoals; } result.Wins = wins; result.Losses = losses; result.Draws = draws; result.GoalsFor = goalsfor; result.GoalsAgains = goalsAgainst; result.Difference = goalsfor - goalsAgainst; result.Points = points; result.totoal = Total; table.Add(result); } ViewData["Result"] = table.OrderByDescending(k => k.Points).ThenByDescending(k => k.Difference); return(View()); }
// GET: Tables public ActionResult Index() { List <LeagueTableResults> results = new List <LeagueTableResults>(); MatchesRepository matchesrep = new MatchesRepository(); var allmatches = matchesrep.GetAllMatches(); TeamsRepository teamsrep = new TeamsRepository(); var allteams = teamsrep.GetAllTeams(); if (allteams.Count() > 0) { foreach (Team t in allteams) { LeagueTableResults res = new LeagueTableResults(); res.TeamId = t.Id; res.TeamName = t.Name; //Calculate number of wins int wins = 0; int lost = 0; int draws = 0; int fgoals = 0; int agoals = 0; int points = 0; var allteammatches = allmatches.Where(m => m.Fixture.HomeTeamId == t.Id || m.Fixture.AwayTeamId == t.Id); var allteamhomematches = allteammatches.Where(m => m.Fixture.HomeTeamId == t.Id); var allteamawaymatches = allteammatches.Where(m => m.Fixture.AwayTeamId == t.Id); var noplayed = 0; noplayed = allmatches.Where(m => m.Fixture.HomeTeamId == t.Id || m.Fixture.AwayTeamId == t.Id).Count(); foreach (Match m in allteamhomematches) { if (m.HomeTeamGoals > m.AwayTeamGoals) { wins++; points = points + 3; } if (m.HomeTeamGoals < m.AwayTeamGoals) { lost++; points = points + 0; } if (m.HomeTeamGoals == m.AwayTeamGoals) { draws++; points = points + 1; } fgoals += (int)m.HomeTeamGoals; agoals += (int)m.AwayTeamGoals; } foreach (Match m in allteamawaymatches) { if (m.AwayTeamGoals > m.HomeTeamGoals) { wins++; points = points + 3; } if (m.AwayTeamGoals < m.HomeTeamGoals) { lost++; points = points + 0; } if (m.AwayTeamGoals == m.HomeTeamGoals) { draws++; points = points + 1; } fgoals += (int)m.AwayTeamGoals; agoals += (int)m.HomeTeamGoals; } res.Win = wins; res.Lost = lost; res.Draw = draws; res.GF = fgoals; res.GA = agoals; res.GD = fgoals - agoals; res.Points = points; res.Played = noplayed; results.Add(res); } } ViewData["Results"] = results.OrderByDescending(r => r.Points).ThenByDescending(r => r.GD); return(View()); }