public DTO.Player JoinLobby(DTO.Lobby lobby, DTO.Player player)
{
DTO.Player returnplay = new DTO.Player();
try
{
if (player.IsHost == true)
{
StopHost(player);
}
var join = (from l in db.Players
where l.PlayerId == player.PlayerId
select l).First();
var isthere = (from l in db.Lobbis
where l.HostID == lobby.HostID
select l);
if (isthere != null)
{
join.Lobby = lobby.HostPlayer;
join.HostID = lobby.HostID;
db.SubmitChanges();
updatelobby(lobby.HostID);
}
returnplay = player;
returnplay.HostID = lobby.HostID;
returnplay.Lobby = lobby.HostPlayer;
return returnplay;
}
catch (Exception)
{
throw;
}
}
public DTO.Player Inloggen(string naam, string wachtwoord)
{
try
{
// List<DTO.Player> playerList = new List<DTO.Player>();
DTO.Player player = new DTO.Player();
// look for player
//var usercontrol = from u in db.Players
// where u.PlayerNaam == naam && u.Wachtwoord == wachtwoord
// select new { u.PlayerNaam, u.Gewonnen, u.Verloren, u.Wachtwoord, u.PlayerId, u.Lobby, u.IsHost };
var user = (from u in db.Players
where u.PlayerNaam == naam && u.Wachtwoord == wachtwoord
select u).First();
player.PlayerId = user.PlayerId;
player.PlayerNaam = user.PlayerNaam;
player.Lobby = user.Lobby;
if (user.Locatie.HasValue)
player.Locatie = user.Locatie.Value;
if (user.IsHost.HasValue)
player.IsHost = user.IsHost.Value;
if (user.HostID.HasValue)
player.HostID = user.HostID.Value;
if (user.Gewonnen.HasValue)
player.Gewonnen = user.Gewonnen.Value;
if (user.Verloren.HasValue)
player.Verloren = user.Verloren.Value;
// add players attributes
//foreach (var item in user)
//{
// playerList.Add(new DTO.Player() { PlayerNaam = item.PlayerNaam, Wachtwoord = item.Wachtwoord, PlayerId = item.PlayerId, Lobby = item.Lobby, IsHost=item.IsHost.Value, Gewonnen=item.Gewonnen.Value, Verloren=item.Verloren.Value });
//}
return player;
}
catch (Exception)
{
throw;
}
}