public ActionResult MatchKeeper(int id)
{
var MatchDataModel = new MatchDataModel();
MatchDataModel.Competition = (from c in db.Competitions where c.CompID == id select c).FirstOrDefault();
MatchDataModel.RunningFields = MatchDataModel.Competition.RunningFields;
foreach (var s in db.StudentTeams.ToList())
{
var StudentTeam = new StudentTeam();
var TeamData = db.StudentTeams.Find(s.TeamID);
StudentTeam.TeamName = TeamData.TeamName;
StudentTeam.TeamNumberBranch = TeamData.TeamNumberBranch;
StudentTeam.TeamNumberSpecific = TeamData.TeamNumberSpecific;
StudentTeam.TeamID = TeamData.TeamID;
StudentTeam.FieldR1 = TeamData.FieldR1;
StudentTeam.FieldR2 = TeamData.FieldR2;
MatchDataModel.R1List.Add(StudentTeam);
MatchDataModel.R2List.Add(StudentTeam);
}
var GetMatches = (from m in db.TeamMatches where m.CompID == id select m).ToList();
foreach (var item in GetMatches)
{
MatchDataModel.Matches++;
}
float numofmatches = (float)MatchDataModel.Matches / (float)MatchDataModel.RunningFields;
MatchDataModel.Matches = (int)Math.Ceiling(numofmatches);
return(View(MatchDataModel));
}
public void TeamSelected(int TeamID, int field, int round)
{
var studentTeam = (from r in db.StudentTeams where r.TeamID == TeamID select r).FirstOrDefault();
if (round == 1)
{
studentTeam.FieldR1 = field;
}
else if (round == 2)
{
studentTeam.FieldR2 = field;
}
db.StudentTeams.Update(studentTeam);
db.SaveChanges();
var MatchDataModelSent = new MatchDataModel();
foreach (var s in db.StudentTeams.ToList())
{
var StudentTeam = new StudentTeam();
var TeamData = db.StudentTeams.Find(s.TeamID);
StudentTeam.TeamName = TeamData.TeamName;
StudentTeam.TeamNumberBranch = TeamData.TeamNumberBranch;
StudentTeam.TeamNumberSpecific = TeamData.TeamNumberSpecific;
StudentTeam.TeamID = TeamData.TeamID;
StudentTeam.FieldR1 = TeamData.FieldR1;
StudentTeam.FieldR2 = TeamData.FieldR2;
MatchDataModelSent.R1List.Add(StudentTeam);
MatchDataModelSent.R2List.Add(StudentTeam);
}
MatchDataModelSent.R1List = MatchDataModelSent.R1List.Where(a => a.FieldR1 == 0).OrderBy(a => a.TeamNumberBranch).ThenBy(a => a.TeamNumberSpecific).ToList();
MatchDataModelSent.R2List = MatchDataModelSent.R2List.Where(a => a.FieldR2 == 0).OrderByDescending(a => a.TeamNumberBranch).ThenByDescending(a => a.TeamNumberSpecific).ToList();
Clients.All.SendAsync("changeList", MatchDataModelSent);
}
public ActionResult MatchManager(int id)
{
var MatchDataModel = new MatchDataModel();
var Competition = (from a in db.Competitions where a.CompID == id select a).FirstOrDefault();
MatchDataModel.RunningFields = Competition.RunningFields;
int i = 0;
foreach (var s in db.StudentTeams.ToList())
{
var StudentTeam = new StudentTeam();
i++;
var TeamData = db.StudentTeams.Find(s.TeamID);
StudentTeam.TeamName = TeamData.TeamName;
StudentTeam.TeamNumberBranch = TeamData.TeamNumberBranch;
StudentTeam.TeamNumberSpecific = TeamData.TeamNumberSpecific;
StudentTeam.TeamID = TeamData.TeamID;
StudentTeam.FieldR1 = TeamData.FieldR1;
StudentTeam.FieldR2 = TeamData.FieldR2;
MatchDataModel.R1List.Add(StudentTeam);
MatchDataModel.R2List.Add(StudentTeam);
}
return(View(MatchDataModel));
}
public void DeleteItem(int id)
{
StudentTeam itemToDelete = new StudentTeam()
{
StudentTeamID = id
};
_database.StudentTeams.Delete(itemToDelete.StudentTeamID);
_database.Save();
}
public StudentTeamResponseDTO AddStudentIntoTeam(AddStudentIntoTeamDTO requestDTO)
{
if (this._teamService.GetOneByUuid(requestDTO.teamUUID) == null)
{
throw new EntityAlreadyExistsException($"Team with uuid {requestDTO.teamUUID} doesn't exist!", GeneralConsts.MICROSERVICE_NAME);
}
List <StudentCourseDTO> studentCourse = this._httpClientService.SendRequest <List <StudentCourseDTO> >(HttpMethod.Get, "http://localhost:40005/api/courses/students/" + requestDTO.courseUUID, new UserPrincipal(_httpContextAccessor.HttpContext).token).Result;
bool flag = false;
foreach (var sc in studentCourse)
{
if (sc.studentUUID == requestDTO.studentUUID)
{
flag = true;
}
}
if (!flag)
{
throw new EntityAlreadyExistsException($"Student with uuid {requestDTO.studentUUID} is not on Course with uuid {requestDTO.courseUUID}!", GeneralConsts.MICROSERVICE_NAME);
}
StudentDTO student = this._httpClientService.SendRequest <StudentDTO>(HttpMethod.Get, "http://localhost:40001/api/users/students/" + requestDTO.studentUUID, new UserPrincipal(_httpContextAccessor.HttpContext).token).Result;
if (student == null)
{
throw new EntityAlreadyExistsException($"Student with uuid {requestDTO.studentUUID} doesn't exist!", GeneralConsts.MICROSERVICE_NAME);
}
StudentTeam studentTeam = new StudentTeam()
{
team = new Team()
{
uuid = requestDTO.teamUUID,
course = new Course()
{
uuid = requestDTO.courseUUID
}
},
student = new Student()
{
uuid = requestDTO.studentUUID
}
};
studentTeam = this._queryExecutor.Execute <StudentTeam>(DatabaseConsts.USER_SCHEMA, this._sqlCommands.ADD_STUDENT_INTO_TEAM(studentTeam), this._modelMapper.MapToStudentTeam);
StudentTeamResponseDTO response = this._autoMapper.Map <StudentTeamResponseDTO>(studentTeam);
response.team = this._teamService.GetOneByUuid(requestDTO.teamUUID);
response.student = student;
return(response);
}
public StudentTeamDTO GetItem(int?id)
{
StudentTeam studentTeam = _database.StudentTeams.Get(id);
return(new StudentTeamDTO
{
StudentID = studentTeam.StudentID,
TeamID = studentTeam.TeamID,
StudentTeamID = studentTeam.StudentTeamID
});
}
public ActionResult TeamCreate([Bind("TeamID,CompID,TeamName,TeamNumberBranch,TeamNumberSpecific,Location,Coach,ReadyR1,ReadyR2")] StudentTeam studentTeam)
{
Random random = new Random();
studentTeam.TeamID = random.Next(1, 100000);
db.StudentTeams.Add(studentTeam);
db.SaveChanges();
string page = studentTeam.CompID.ToString();
page = "Competition/" + page;
return(RedirectToAction(page));
}
public ActionResult TeamEdit([Bind("TeamID,CompID,TeamName,TeamNumberBranch,TeamNumberSpecific,Location,Coach,ReadyR1,ReadyR2")] StudentTeam studentTeam)
{
if (ModelState.IsValid)
{
db.Entry(studentTeam).State = EntityState.Modified;
db.SaveChanges();
string page = studentTeam.CompID.ToString();
page = "Competition/" + page;
return(RedirectToAction(page));
}
return(View(studentTeam));
}
public void UpdateItem(StudentTeamDTO item)
{
StudentTeam studentTeam = new StudentTeam
{
StudentTeamID = item.StudentTeamID,
StudentID = item.StudentID,
TeamID = item.TeamID
};
_database.StudentTeams.Update(studentTeam);
_database.Save();
}
public ActionResult TeamEdit(int id)
{
if (id == null)
{
//return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
}
StudentTeam score = db.StudentTeams.Find(id);
if (score == null)
{
//return HttpNotFound();
}
return(View(score));
}
public string ADD_STUDENT_INTO_TEAM(StudentTeam studentTeam)
{
return($"insert into {GeneralConsts.SCHEMA_NAME}.StudentCourseTeam (teamUUID, courseUUID, studentUUID) output inserted.* " +
$"values ('{studentTeam.team.uuid}', '{studentTeam.team.course.uuid}', '{studentTeam.student.uuid}');");
}
