public ActionResult DisplaySchedule(int id = 0, string Month = "0")
{
TeamSchedule ts;
List<TeamSchedule> Model = new List<TeamSchedule>();
List<Schedule> schedules = new List<Schedule>();
if (id == 0)
{
if (Month == "0")
schedules = db.Schedules.ToList();
else
schedules = db.Schedules.ToList().FindAll(o => o.GameDateTime.Month.ToString() == Month);
}
else
{
schedules = db.Schedules.ToList().FindAll(o => (o.HomeTeam == id || o.RoadTeam == id));
}
foreach (Schedule item in schedules)
{
ts = new TeamSchedule();
ts.GameDateTime = item.GameDateTime;
ts.Home_Team = db.Teams.Find(item.HomeTeam);
ts.Road_Team = db.Teams.Find(item.RoadTeam);
ts.HomeScore = item.HomeScore;
ts.RoadScore = item.RoadScore;
Model.Add(ts);
}
return View(Model);
}
public ActionResult UpdateScore(TeamSchedule Model)
{
Schedule schedule = db.Schedules.ToList().FindAll(o => (o.HomeTeam == Model.Home_Team.ID &&
o.RoadTeam == Model.Road_Team.ID &&
o.GameDateTime == Model.GameDateTime)).First();
schedule.HomeScore = Model.HomeScore;
schedule.RoadScore = Model.RoadScore;
db.Entry(schedule).State = EntityState.Modified;
db.SaveChanges();
Record RoadTeamRecord = db.Records.ToList().Find(o => o.TeamID == Model.Road_Team.ID);
Record HomeTeamRecord = db.Records.ToList().Find(o => o.TeamID == Model.Home_Team.ID);
RoadTeamRecord.Win = RoadTeamRecord.Win + Model.RoadScore;
RoadTeamRecord.Lost = RoadTeamRecord.Lost + Model.HomeScore;
HomeTeamRecord.Win = HomeTeamRecord.Win + Model.HomeScore;
HomeTeamRecord.Lost = HomeTeamRecord.Lost + Model.RoadScore;
db.Entry(RoadTeamRecord).State = EntityState.Modified;
db.SaveChanges();
db.Entry(HomeTeamRecord).State = EntityState.Modified;
db.SaveChanges();
return RedirectToAction("Standing","Home");
}
public ActionResult EditScore(TeamSchedule Model)
{
Schedule schedule = db.Schedules.ToList().FindAll(o => (o.HomeTeam == Model.Home_Team.ID &&
o.RoadTeam == Model.Road_Team.ID &&
o.GameDateTime == Model.GameDateTime)).First();
//Take out the previous score from the standing.
Record RoadTeamRecord = db.Records.ToList().Find(o => o.TeamID == Model.Road_Team.ID);
Record HomeTeamRecord = db.Records.ToList().Find(o => o.TeamID == Model.Home_Team.ID);
RoadTeamRecord.Lost = RoadTeamRecord.Lost - schedule.HomeScore;
RoadTeamRecord.Win = RoadTeamRecord.Win - schedule.RoadScore;
HomeTeamRecord.Lost = HomeTeamRecord.Lost - schedule.RoadScore;
HomeTeamRecord.Win = HomeTeamRecord.Win - schedule.HomeScore;
//Now readjust the standing with the latest Score Edit.
schedule.HomeScore = Model.HomeScore;
schedule.RoadScore = Model.RoadScore;
db.Entry(schedule).State = EntityState.Modified;
db.SaveChanges();
RoadTeamRecord.Win = RoadTeamRecord.Win + Model.RoadScore;
RoadTeamRecord.Lost = RoadTeamRecord.Lost + Model.HomeScore;
HomeTeamRecord.Win = HomeTeamRecord.Win + Model.HomeScore;
HomeTeamRecord.Lost = HomeTeamRecord.Lost + Model.RoadScore;
db.Entry(RoadTeamRecord).State = EntityState.Modified;
db.SaveChanges();
db.Entry(HomeTeamRecord).State = EntityState.Modified;
db.SaveChanges();
return RedirectToAction("Standing", "Home");
}
//public ActionResult View(string Month = "0")
//{
// List<TeamSchedule> team_schedules = new List<TeamSchedule>();
// //Find out if the View is for specific month.
// if (Month == "0")
// {
// Month = DateTime.Now.Month.ToString();
// }
// //Grab all the schedule for this team.
// List<Schedule> schedules = db.Schedules.ToList().FindAll(o => o.GameDateTime.Month.ToString() == Month);
// foreach (Schedule item in schedules)
// {
// TeamSchedule ts = new TeamSchedule();
// ts.GameDateTime = item.GameDateTime;
// ts.Home_Team = db.Teams.Find(item.HomeTeam);
// ts.Road_Team = db.Teams.Find(item.RoadTeam);
// ts.HomeScore = item.HomeScore;
// ts.RoadScore = item.RoadScore;
// team_schedules.Add(ts);
// }
// return View(team_schedules);
//}
public ActionResult UpdateScore(int HomeTeamID, int RoadTeamID, DateTime date)
{
TeamSchedule Model = new TeamSchedule();
//QP
Schedule schedule = db.Schedules.ToList().FindAll(o => (o.HomeTeam == HomeTeamID &&
o.RoadTeam == RoadTeamID &&
o.GameDateTime == date)).First();
Model.GameDateTime = schedule.GameDateTime;
Model.Home_Team = db.Teams.Find(schedule.HomeTeam);
Model.Road_Team = db.Teams.Find(schedule.RoadTeam);
Model.HomeScore = schedule.HomeScore;
Model.RoadScore = schedule.RoadScore;
return PartialView(Model);
}
public ActionResult DisplayTeam(int id = 0, string Month = "0")
{
DisplayTeam model = new DisplayTeam();
List<TeamSchedule> team_schedules = new List<TeamSchedule>();
List<Player> Roster = db.Players.ToList();
Team team = db.Teams.Find(id);
//Find out if the View is for specific month.
if (Month == "0")
{
Month = DateTime.Now.Month.ToString();
}
//Grab all the schedule for this team.
List<Schedule> schedules = db.Schedules.ToList().FindAll(o => (o.HomeTeam == id || o.RoadTeam == id) && o.GameDateTime.Month.ToString() == Month);
foreach (Schedule item in schedules)
{
TeamSchedule ts = new TeamSchedule();
ts.GameDateTime = item.GameDateTime;
ts.Home_Team = db.Teams.Find(item.HomeTeam);
ts.Road_Team = db.Teams.Find(item.RoadTeam);
ts.HomeScore = item.HomeScore;
ts.RoadScore = item.RoadScore;
team_schedules.Add(ts);
}
if (team != null)
{
model.ID = id;
model.Name = team.Name;
model.Players = Roster.FindAll(o => o.TeamID == id);
model.Schedules = team_schedules;
model.ShowMonth = CultureInfo.CurrentCulture.DateTimeFormat.GetMonthName(System.Convert.ToInt32(Month));
}
else
return View(team);
return View(model);
}
