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());
}
