public async Task <IActionResult> AddAthleteAsync([FromForm] AthleteViewModel athlete) { UserTestMapper UserTest = new UserTestMapper(); var UserExist = (from user in _context.UserTestMappers.Where(t => t.TestID == TestID) select user.User.Name).ToList(); var Tests = await _context.Tests.FirstOrDefaultAsync(t => t.ID == TestID); var Users = _context.Users.Where(u => u.Name == athlete.Name); if (!UserExist.Contains(athlete.Name)) { UserTest.TestID = Tests.ID; foreach (User user in Users) { UserTest.UserID = user.ID; } if (athlete.Distance != 0) { UserTest.CooperTestDistance = athlete.Distance; UserTest.FitnessRating = CalculateFitness(athlete.Distance); } else { UserTest.SprintTestTime = athlete.Time; } _context.UserTestMappers.Add(UserTest); } else { var UpdateUser = _context.UserTestMappers.Where(u => u.User.Name == athlete.Name).Where(u => u.TestID == TestID).FirstOrDefault(); if (athlete.Distance != 0) { UpdateUser.CooperTestDistance = athlete.Distance; UpdateUser.FitnessRating = CalculateFitness(athlete.Distance); } else { UpdateUser.SprintTestTime = athlete.Time; } _context.UserTestMappers.Update(UpdateUser); } await _context.SaveChangesAsync(); return(RedirectToAction("TestDetails", new { id = TestID })); }
public async Task <IActionResult> AddAthleteAsync([FromRoute] int id, [FromBody] AthleteAddViewModel athlete) { UserTestMapper UserTest = new UserTestMapper(); var UserExist = (from user in context.UserTestMappers.Where(t => t.TestID == id) select user.User.Name).ToList(); var Tests = await context.Tests.FirstOrDefaultAsync(t => t.ID == id); var Users = context.Users.Where(u => u.Name == athlete.Name); if (!UserExist.Contains(athlete.Name)) { UserTest.TestID = Tests.ID; foreach (User user in Users) { UserTest.UserID = user.ID; } if (athlete.Distance != 0) { UserTest.CooperTestDistance = athlete.Distance; UserTest.FitnessRating = CalculateFitness(athlete.Distance); } else { UserTest.SprintTestTime = athlete.Time; } context.UserTestMappers.Add(UserTest); } else { var UpdateUser = context.UserTestMappers.Where(u => u.User.Name == athlete.Name).Where(u => u.TestID == id).FirstOrDefault(); if (athlete.Distance != 0) { UpdateUser.CooperTestDistance = athlete.Distance; UpdateUser.FitnessRating = CalculateFitness(athlete.Distance); } else { UpdateUser.SprintTestTime = athlete.Time; } context.UserTestMappers.Update(UpdateUser); } await context.SaveChangesAsync(); return(Ok(athlete)); }
public void AddAthlete(UserTestViewModel user) { UserTestMapper UserTest = new UserTestMapper(); var UserExist = context.UserTestMappers.Where(t => t.TestID == TestId).Select(u => u.User.Name).ToList(); int User = context.Users.Where(u => u.Name == user.Name).Select(u => u.ID).FirstOrDefault(); if (!UserExist.Contains(user.Name)) { UserTest.TestID = TestId; UserTest.UserID = User; if (user.Distance != null) { UserTest.CooperTestDistance = user.Distance; UserTest.FitnessRating = CalculateFitness(user.Distance); } else { UserTest.SprintTestTime = user.Time; } context.UserTestMappers.Add(UserTest); } else { var UpdateUser = context.UserTestMappers.Where(u => u.User.Name == user.Name).Where(u => u.TestID == TestId).FirstOrDefault(); if (user.Distance != null) { UpdateUser.CooperTestDistance = user.Distance; UpdateUser.FitnessRating = CalculateFitness(user.Distance); } else { UpdateUser.SprintTestTime = user.Time; } context.UserTestMappers.Update(UpdateUser); } }