public async Task <IActionResult> Edit(int id, [Bind("TeamId,SchoolName,Player1,Player2,Player3,Player4," + "Player5,Player6,Player7,Wins,Games")] TeamDataModel teamDataModel) { if (id != teamDataModel.TeamId) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(teamDataModel); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!TeamDataModelExists(teamDataModel.TeamId)) { return(NotFound()); } else { throw; } } return(RedirectToAction("Index", "Home")); } return(View(teamDataModel)); }
public void UpdateScoresheet() { List <TeamDataModel> TeamDataModels = new List <TeamDataModel>(); foreach (var t in db.StudentTeams.Where(a => a.CompID == 1).OrderByDescending(a => a.RoundEntries.Where(b => b.Usable == true).Average(b => b.Score)).ThenBy(a => a.TeamNumberBranch).ThenBy(a => a.TeamNumberSpecific)) { TeamDataModel Data = new TeamDataModel(); Data.TeamID = t.TeamID; Data.TeamName = t.TeamName; Data.TeamNumberBranch = t.TeamNumberBranch; Data.TeamNumberSpecific = t.TeamNumberSpecific; var Round1 = (from a in db.RoundEntries where a.TeamID == t.TeamID && a.Usable == true && a.Round == 1 select a).FirstOrDefault(); if (Round1 != null) { Data.Round1Score = Round1.Score; Data.Round1Time = Round1.Time; } var Round2 = (from a in db.RoundEntries where a.TeamID == t.TeamID && a.Usable == true && a.Round == 2 select a).FirstOrDefault(); if (Round2 != null) { Data.Round2Score = Round2.Score; Data.Round2Time = Round2.Time; } Data.RoundAverage = Data.Round1Score + Data.Round2Score; Data.RoundAverage = Data.RoundAverage / 2; Data.ReadyR1 = true; Data.ReadyR2 = true; TeamDataModels.Add(Data); } TeamDataModels = TeamDataModels.OrderByDescending(p => p.RoundAverage).ThenBy(p => p.TeamID).ToList(); this._hubContext.Clients.All.SendAsync("changeScoreboard", TeamDataModels); }
public TeamModel Create(TeamColorDOM model) { var team = new TeamDataModel() { Color = model.Color }; return(new TeamModel(repository.Save(team))); }
public void InsertTeam(CreateTeamViewModel team) { var teamDataModel = new TeamDataModel { Name = team.Name }; teamRepository.InsertTeam(teamDataModel); teamRepository.Save(); }
public async Task <IActionResult> Create([Bind("TeamId,SchoolName,Player1,Player2,Player3,Player4," + "Player5,Player6,Player7")] TeamDataModel teamDataModel) { if (ModelState.IsValid) { _context.Add(teamDataModel); await _context.SaveChangesAsync(); return(RedirectToAction("Index", "Home")); } return(View(teamDataModel)); }
public TeamDataModel Save(TeamDataModel teamModel) { using (var session = helper.OpenSession()) { using (var transaction = session.BeginTransaction()) { session.Save(teamModel); transaction.Commit(); return(teamModel); } } }
public ActionResult Index() { var TeamDataModelList = new List <TeamDataModel>(); int i = 0; foreach (var s in db.StudentTeams.ToList()) { i++; var TeamData = db.StudentTeams.Find(s.TeamID); var Round1 = (from a in db.RoundEntries where a.TeamID == s.TeamID && a.Round == 1 select a).FirstOrDefault(); var Round2 = (from a in db.RoundEntries where a.TeamID == s.TeamID && a.Round == 2 select a).FirstOrDefault(); var TeamDataModel = new TeamDataModel(); TeamDataModel.TeamName = TeamData.TeamName; TeamDataModel.TeamID = TeamData.TeamID; TeamDataModel.TeamNumberBranch = TeamData.TeamNumberBranch; TeamDataModel.TeamNumberSpecific = TeamData.TeamNumberSpecific; if (Round2 != null && Round1 != null) { TeamDataModel.Round1Score = Round1.Score; TeamDataModel.Round2Score = Round2.Score; TeamDataModel.RoundAverage = (Round1.Score + Round2.Score) / 2; } else if (Round2 != null && Round1 == null) { //Round 1 is null TeamDataModel.Round1Score = 0; TeamDataModel.Round2Score = Round2.Score; TeamDataModel.RoundAverage = Round2.Score / 2; } else if (Round2 == null && Round1 != null) { //Round 2 is null TeamDataModel.Round1Score = Round1.Score; TeamDataModel.Round2Score = 0; TeamDataModel.RoundAverage = Round1.Score / 2; } else if (Round2 == null && Round1 == null) { //Round 2 is null TeamDataModel.Round1Score = 0; TeamDataModel.Round2Score = 0; TeamDataModel.RoundAverage = 0; } TeamDataModelList.Add(TeamDataModel); } return(View(TeamDataModelList.OrderByDescending(a => a.RoundAverage))); }
public ActionResult Competition(int id) { if (id == 0) { //return new HttpStatusCodeResult(HttpStatusCode.BadRequest); } var CompetitionPageModel = new CompetitionPageModel(); int i = 0; //COMPETITION ID CHANGES BASED ON WHATEVER IS PASSED THROUGH CONTROLLER //1 IS A TEST VALUE var Competition = (from a in db.Competitions where a.CompID == id select a).FirstOrDefault(); CompetitionPageModel.CompID = Competition.CompID; CompetitionPageModel.Date = Competition.Date; CompetitionPageModel.Location = Competition.Location; CompetitionPageModel.ExtraData = Competition.ExtraData; CompetitionPageModel.GameID = Competition.GameID; CompetitionPageModel.FieldPreferred.Add(Competition.field1preferred); CompetitionPageModel.FieldPreferred.Add(Competition.field2preferred); CompetitionPageModel.FieldPreferred.Add(Competition.field3preferred); CompetitionPageModel.FieldPreferred.Add(Competition.field4preferred); CompetitionPageModel.FieldPreferred.Add(Competition.field5preferred); CompetitionPageModel.FieldPreferred.Add(Competition.field6preferred); CompetitionPageModel.validmatches[0] = Competition.validmatch1; CompetitionPageModel.validmatches[1] = Competition.validmatch2; CompetitionPageModel.validmatches[2] = Competition.validmatch3; CompetitionPageModel.validmatches[3] = Competition.validmatch4; CompetitionPageModel.validmatches[4] = Competition.validmatch5; CompetitionPageModel.validmatches[5] = Competition.validmatch6; int sitem = 0; foreach (var s in db.StudentTeams.ToList()) { var TeamData = db.StudentTeams.Find(s.TeamID); var Round1 = (from a in db.RoundEntries where a.TeamID == s.TeamID && a.Round == 1 && a.Usable == true select a).FirstOrDefault(); var Round2 = (from a in db.RoundEntries where a.TeamID == s.TeamID && a.Round == 2 && a.Usable == true select a).FirstOrDefault(); i++; var TeamDataModel = new TeamDataModel(); TeamDataModel.TeamName = TeamData.TeamName; TeamDataModel.TeamID = TeamData.TeamID; TeamDataModel.TeamNumberBranch = TeamData.TeamNumberBranch; TeamDataModel.TeamNumberSpecific = TeamData.TeamNumberSpecific; TeamDataModel.Round1Score = 0; TeamDataModel.Round2Score = 0; if (Round2 != null) { TeamDataModel.Round2Score = Round2.Score; } if (Round1 != null) { TeamDataModel.Round1Score = Round1.Score; } TeamDataModel.RoundAverage = TeamDataModel.Round1Score + TeamDataModel.Round2Score; TeamDataModel.RoundAverage = TeamDataModel.RoundAverage / 2; CompetitionPageModel.Teams.Add(TeamDataModel); } return(View(CompetitionPageModel)); }
public TeamModel(TeamDataModel model) { Id = model.Id; Color = model.Color; }
public void UpdateTeam(TeamDataModel team) { dataContext.Entry(team).State = EntityState.Modified; }
public void DeleteTeam(int teamID) { TeamDataModel teamDataModel = dataContext.Teams.Find(teamID); dataContext.Teams.Remove(teamDataModel); }
public void InsertTeam(TeamDataModel team) { dataContext.Teams.Add(team); }