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