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