public static void DeletePlayer(string Name, string LastName, string City, DateTime DOB)
{
var context = new PokerPlayersContext();
var player = from p in context.Players
where p.PlayerName == (Name ?? p.PlayerName)
where p.Surname == (LastName ?? p.Surname)
where p.City.CityName == (City ?? p.City.CityName)
where p.DOB == (DOB == default(DateTime)?p.DOB:DOB)
select p;
foreach (var p in player)
{
context.Players.Remove(p);
}
context.SaveChanges();
}
public static void SavePlayer(string Name, string LastName, string City, DateTime DOB, List <DataBaseTournament> Tournaments, string Image = "D:\\PhotosPokerPlayer\\noname.png")
{
var pl = DataBase.GetPlayers(Name, LastName, City, DOB, Tournaments);
if (pl.Count != 0)
{
return;
}
var context = new PokerPlayersContext();
var cities = context.Cities.Where(p => p.CityName == City);
City city;
if (cities.Count() == 0)
{
city = context.Cities.Add(new City {
CityName = City
});
}
else
{
city = cities.Single();
}
HashSet <Tournament> tournaments = new HashSet <Tournament>();
int len;
int [] places;
if (Tournaments != null)
{
len = Tournaments.Count;
places = new int[len];
}
else
{
places = null;
}
if (Tournaments == null)
{
tournaments = null;
}
else
{
int i = 0;
foreach (var T in Tournaments)
{
Tournament t = context.Tournaments.Where(p => p.TournamentName == T.TournamentName).Single();
if (T.Place == null)
{
places[i++] = -1;
}
else
{
places[i++] = Int32.Parse(T.Place);
}
tournaments.Add(t);
}
}
Player player = context.Players.Add(new Player {
PlayerName = Name, Surname = LastName, City = city, DOB = DOB, Image = Image, RegistrationDate = DateTime.Now
});
var tournPl = context.TournamentPlayers;
ICollection <TournamentPlayer> TP = new HashSet <TournamentPlayer>();
if (tournaments != null)
{
int i = 0;
foreach (var t in tournaments)
{
TournamentPlayer tp;
if (places[i] != -1)
{
tp = context.TournamentPlayers.Add(new TournamentPlayer {
Player = player, Tournament = t, Place = places[i++]
});
}
else
{
tp = context.TournamentPlayers.Add(new TournamentPlayer {
Player = player, Tournament = t
}); i++;
}
TP.Add(tp);
}
player.TournamentPlayers = TP;
}
context.SaveChanges();
}