public IActionResult TeamAddView() { using (var db = new Context()) { var newTeam = new Team(); newTeam.city = Request.Form["city"]; newTeam.name = Request.Form["name"]; newTeam.Clubid = int.Parse(Request.Form["idClub"]); db.Team.Add(newTeam); db.SaveChanges(); var model = new ModelForClubView(); db.Club.Load(); db.SportCategory.Load(); db.SportRang.Load(); db.Sportsmen.Load(); db.Team.Load(); db.Trainer.Load(); model.allClubs = db.Club.ToList(); model.selectClub = newTeam.Clubid; model.sportsmenOnClub = db.Sportsmen.Where(x => x.Clubid == model.selectClub).ToList(); model.teamOnClub = db.Team.Where(x => x.Clubid == model.selectClub).ToList(); model.trainerOnClub = db.Trainer.Where(x => x.Clubid == model.selectClub).ToList(); return(View("ClubView", model)); } }
public IActionResult TrainerAddView() { using (var db = new Context()) { var newTrainer = new Trainer(); newTrainer.job = Request.Form["job"]; newTrainer.name = Request.Form["name"]; newTrainer.surname = Request.Form["surname"]; newTrainer.patronymic = Request.Form["patronymic"]; newTrainer.phone = Request.Form["phone"].ToString(); newTrainer.photo = ""; newTrainer.dateBirth = Convert.ToDateTime(Request.Form["dateBirth"]); newTrainer.Clubid = int.Parse(Request.Form["idClub"]); db.Trainer.Add(newTrainer); db.SaveChanges(); var model = new ModelForClubView(); db.Club.Load(); db.SportCategory.Load(); db.SportRang.Load(); db.Sportsmen.Load(); db.Team.Load(); db.Trainer.Load(); model.allClubs = db.Club.ToList(); model.selectClub = newTrainer.Clubid; model.sportsmenOnClub = db.Sportsmen.Where(x => x.Clubid == model.selectClub).ToList(); model.teamOnClub = db.Team.Where(x => x.Clubid == model.selectClub).ToList(); model.trainerOnClub = db.Trainer.Where(x => x.Clubid == model.selectClub).ToList(); return(View("ClubView", model)); } }
public IActionResult ClubInfoView(int id) { using (var db = new Context()) { var model = new ModelForClubView(); db.Club.Load(); db.SportCategory.Load(); db.SportRang.Load(); db.Sportsmen.Load(); db.Team.Load(); db.Trainer.Load(); model.allClubs = db.Club.ToList(); model.selectClub = id; model.sportsmenOnClub = db.Sportsmen.Where(x => x.Clubid == model.selectClub).ToList(); model.teamOnClub = db.Team.Where(x => x.Clubid == model.selectClub).ToList(); model.trainerOnClub = db.Trainer.Where(x => x.Clubid == model.selectClub).ToList(); return(View("ClubView", model)); } }
public IActionResult ClubView(int id) { using (var db = new Context()) { var model = new ModelForClubView(); //db.Category.Load(); db.Club.Load(); //db.Competition.Load(); //db.Judge.Load(); //db.JudgeCategory.Load(); //db.JudgeCompetition.Load(); // db.JudgePosition.Load(); db.SportCategory.Load(); db.SportRang.Load(); db.Sportsmen.Load(); db.Team.Load(); db.Trainer.Load(); //db.UnionRK.Load(); model.allClubs = db.Club.ToList(); if (id == -1) { model.selectClub = db.Club.ToList()[0].id; model.sportsmenOnClub = db.Sportsmen.Where(x => x.Clubid == model.selectClub).ToList(); model.teamOnClub = db.Team.Where(x => x.Clubid == model.selectClub).ToList(); model.trainerOnClub = db.Trainer.Where(x => x.Clubid == model.selectClub).ToList(); return(View(model)); } else { model.selectClub = id; model.sportsmenOnClub = db.Sportsmen.Where(x => x.Clubid == model.selectClub).ToList(); model.teamOnClub = db.Team.Where(x => x.Clubid == model.selectClub).ToList(); model.trainerOnClub = db.Trainer.Where(x => x.Clubid == model.selectClub).ToList(); return(View(model)); } } }
public IActionResult TeamDelete(int id) { Team team = new Team(); using (var db = new Context()) { team = db.Team.FirstOrDefault(x => x.id == id); db.Team.Remove(team); db.SaveChanges(); var model = new ModelForClubView(); db.Club.Load(); db.SportCategory.Load(); db.SportRang.Load(); db.Sportsmen.Load(); db.Team.Load(); db.Trainer.Load(); model.allClubs = db.Club.ToList(); model.selectClub = team.Clubid; model.sportsmenOnClub = db.Sportsmen.Where(x => x.Clubid == model.selectClub).ToList(); model.teamOnClub = db.Team.Where(x => x.Clubid == model.selectClub).ToList(); model.trainerOnClub = db.Trainer.Where(x => x.Clubid == model.selectClub).ToList(); return(View("ClubView", model)); } }