public bool Create(TeamSchedule teamSchedule)
{
bool created;
try
{
using (var scope = new TransactionScope())
{
//Mapper.CreateMap<UserInfoEntity, UserInfo>();
//var userInfo = Mapper.Map<UserInfoEntity, UserInfo>(userInfoEntity);
_unitOfWork.TeamScheduleRepository.Insert(teamSchedule);
_unitOfWork.Save();
scope.Complete();
created = true;
}
}
catch (TransactionAbortedException ex)
{
created = false;
LogError.Write(ex, "TransactionAbortedException");
}
catch (ApplicationException ex)
{
created = false;
LogError.Write(ex, "ApplicationException");
}
catch (Exception ex)
{
created = false;
LogError.Write(ex, "Exception");
}
return(created);
}
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(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));
}
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 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));
}
