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