private bool CheckNewName(String newName) { using (var context = new TournamentDBContext()) { return(context.Team.Any(Team => Team.Name == newName)); } }
public void ModifyTeam(String oldName, String newName) { using (var context = new TournamentDBContext()) { Constants constants = new Constants(); if (CheckOldNAme(oldName)) { if (!CheckNewName(newName)) { var team = context.Team.First(Team => Team.Name == oldName); team.Name = newName; team.ModifiedTime = DateTime.Now; context.SaveChanges(); } else { constants.NameExists(); } } else { constants.NameDoNotExists(); } } }
private bool CheckOldName(String oldname) { using (var context = new TournamentDBContext()) { return(context.Couch.Any(Couch => Couch.Name == oldname)); } }
public void ModifyPlayer(String oldName, String newName) { Constants constants = new Constants(); if (CheckOldName(oldName)) { if (!CheckNewName(newName)) { using (var context = new TournamentDBContext()) { var player = context.Player.First(Player => Player.Name == oldName); player.Name = newName; player.ModifiedTime = DateTime.Now; constants.FinishModification(newName, oldName); context.SaveChanges(); } } else { constants.NameExists(); } } else { constants.NameDoNotExists(); } }
private List <Player> OrderBy(List <Player> players, int choice) { using (var context = new TournamentDBContext()) { switch (choice) { case 1: players = context.Player.OrderBy(Player => Player.Name).ToList(); break; case 2: players = context.Player.OrderBy(Player => Player.BirthDate).ToList(); break; case 3: players = context.Player.OrderBy(player => player.Sallary).ToList(); break; case 4: players = context.Player.OrderBy(player => player.Position).ToList(); break; } } return(players); }
private bool ValidateTitle(string name, DateTime year) { using (var context = new TournamentDBContext()) { return(context.Title.Any(Title => Title.Name == name && Title.Year == year)); } }
public void CreatePlayer(String Name, DateTime birthDate, int sallary, String position, string teamName) { if (!CreateValidation(Name) && CheckPlayerTeam(teamName)) { using (var context = new TournamentDBContext()) { var team = context.Team.First(Team => Team.Name == teamName); var player = new Player { Id = Guid.NewGuid(), CreatedTime = DateTime.Now, Name = Name, BirthDate = birthDate, Sallary = sallary, Position = position, Team = team, TeamId = team.Id, }; context.Player.Add(player); context.SaveChanges(); } } else { Constants constants = new Constants(); constants.NameExists(); } }
private bool CheckOldName(string oldname) { using (var context = new TournamentDBContext()) { return(context.Player.Any(Player => Player.Name == oldname)); } }
private bool CheckPlayerTeam(String teamName) { using (var context = new TournamentDBContext()) { return(context.Team.Any(Team => Team.Name == teamName)); } }
private bool CreateValidation(String Name) { using (var context = new TournamentDBContext()) { return(context.Player.Any(Player => Player.Name == Name)); } }
public void CreateTitle(String name, DateTime year) { Constants constants = new Constants(); if (!ValidateTitle(name, year)) { using (var context = new TournamentDBContext()) { var title = new Title { Id = Guid.NewGuid(), CreatedTime = DateTime.Now, Name = name, Year = year, }; context.Title.Add(title); context.SaveChanges(); } } else { constants.NameExists(); } }
private bool CreateValidation(String name) { using (var context = new TournamentDBContext()) { return(context.Team.Any(Team => Team.Name == name)); } }
public void CreateCouch(String Name, DateTime BirthDate, int Sallary, string teamName) { if (!CreateValidation(Name) && CheckTeamName(teamName)) { using (var context = new TournamentDBContext()) { var team = context.Team.First(Team => Team.Name == teamName); var couch = new Couch { Id = Guid.NewGuid(), CreatedTime = DateTime.Now, Name = Name, BirthDate = BirthDate, Sallary = Sallary, Team = team, TeamId = team.Id, }; context.Couch.Add(couch); context.SaveChanges(); } } else { Constants constants = new Constants(); constants.NameExists(); } }
public void ModifyCouch(string oldName, string newName) { using (var context = new TournamentDBContext()) { Constants constants = new Constants(); if (CheckOldName(oldName)) { if (!CheckNewName(newName)) { Couch couch = context.Couch.First(Couch => Couch.Name == oldName); couch.Name = newName; couch.ModifiedTime = DateTime.Now; context.SaveChanges(); constants.FinishModification(newName, oldName); } else { constants.NameExists(); } } else { constants.NameDoNotExists(); } } }
private bool CreateValidation(String name) { using (var context = new TournamentDBContext()) { return(context.Couch.Any(Couch => Couch.Name == name)); } }
private bool CheckNewName(String newname) { using (var context = new TournamentDBContext()) { return(context.Player.Any(Player => Player.Name == newname)); } }
public void DeletePlayer(string name) { using (var context = new TournamentDBContext()) { var player = context.Player.First(Player => Player.Name == name); player.DeletedTime = DateTime.Now; Constants constants = new Constants(); constants.Deleted(); context.SaveChanges(); } }
public void DeleteTeam(string name) { using (var context = new TournamentDBContext()) { var team = context.Team.First(Team => Team.Name == name); team.DeletedTime = DateTime.Now; Constants constants = new Constants(); constants.Deleted(); context.SaveChanges(); } }
public void DeleteCouch(string name) { using (var context = new TournamentDBContext()) { var couch = context.Couch.First(Couch => Couch.Name == name); couch.DeletedTime = DateTime.Now; Constants constants = new Constants(); constants.Deleted(); context.SaveChanges(); } }
public void DeleteTitle(string name) { using (var context = new TournamentDBContext()) { var title = context.Title.First(Title => Title.Name == name); title.DeletedTime = DateTime.Now; Constants constants = new Constants(); constants.Deleted(); context.SaveChanges(); } }
public void RenderAllTeams(int choice) { Constants constants = new Constants(); Console.Clear(); constants.HereAreAll(); using (var context = new TournamentDBContext()) { int count = 1; var teams = context.Team.ToList(); teams = OrderBy(teams, choice); Pagination pagination = new Pagination(); pagination.TeamsToPage(teams, 0); } }
public void renderAllPlayers(int choice) { Console.Clear(); Constants constants = new Constants(); constants.HereAreAll(); using (var context = new TournamentDBContext()) { int count = 1; var players = context.Player.ToList(); players = OrderBy(players, choice); Pagination pagination = new Pagination(); pagination.PlayersToPage(players, 0); } }
public void RenderAllCouches(int choice) { Console.Clear(); Constants constants = new Constants(); constants.HereAreAll(); using (var context = new TournamentDBContext()) { int count = 1; var coaches = context.Couch.ToList(); coaches = OrderBy(coaches, choice); Pagination pagination = new Pagination(); pagination.CouchToPage(coaches, 0); } }
public void renderPlayerByLetter(string letter) { Constants constants = new Constants(); constants.HereAreAll(); using (var context = new TournamentDBContext()) { int count = 1; var players = context.Player.Where(Player => Player.Name.Contains(letter) && Player.DeletedTime == null).ToList(); foreach (var player in players) { Console.WriteLine(count + ": " + player.Name); count++; } } }
public void RenderTeamsByLetter(string letter) { Constants constants = new Constants(); Console.Clear(); constants.HereAreAll(); using (var context = new TournamentDBContext()) { int count = 1; var teams = context.Team.Where(Team => Team.Name.Contains(letter) && Team.DeletedTime == null).ToList(); foreach (var team in teams) { Console.WriteLine(count + ": " + team.Name); count++; } } }
private List <Team> OrderBy(List <Team> teams, int choice) { using (var context = new TournamentDBContext()) { switch (choice) { case 1: teams = context.Team.OrderBy(Team => Team.Name).ToList(); break; case 2: teams = context.Team.OrderBy(Team => Team.FoundationYear).ToList(); break; } } return(teams); }
public void RenderCouchesByLetter(string letter) { Console.Clear(); Constants constants = new Constants(); constants.HereAreAll(); using (var context = new TournamentDBContext()) { int count = 1; var coaches = context.Couch.Where(Couch => Couch.Name.Contains(letter) && Couch.DeletedTime == null) .ToList(); foreach (var coach in coaches) { Console.WriteLine(count + ": " + coach.Name); count++; } } }
public void RenderAllTitle() { Console.Clear(); Constants constants = new Constants(); constants.HereAreAll(); using (var context = new TournamentDBContext()) { int count = 1; var titles = context.Title; foreach (var title in titles) { if (title.DeletedTime == null) { Console.WriteLine(count + ": " + title.Name); count++; } } } }
public void RenderTitlesByLetter(string letter) { Console.Clear(); Constants constants = new Constants(); constants.HereAreAll(); using (var context = new TournamentDBContext()) { int count = 1; var titles = context.Title.Where(title => title.Name.Contains(letter) && title.DeletedTime == null).ToList(); foreach (var title in titles) { if (title.DeletedTime == null) { Console.WriteLine(count + ": " + title.Name); count++; } } } }
private List <Couch> OrderBy(List <Couch> couches, int choice) { using (var context = new TournamentDBContext()) { switch (choice) { case 1: couches = context.Couch.OrderBy(Couch => Couch.Name).ToList(); break; case 2: couches = context.Couch.OrderBy(Couch => Couch.BirthDate).ToList(); break; case 3: couches = context.Couch.OrderBy(Couch => Couch.Sallary).ToList(); break; } } return(couches); }