//Get Statistics of players
public List <dynamic> GetPlayerStatistics(string playerName)
{
List <dynamic> playerStats = new List <dynamic>();
int winPercent = 0;
using (var cdb = new minesweeper_RonOzeritskyEntities())
{
try
{
var player = (from c in cdb.Clients
where c.Name == playerName
select c).SingleOrDefault();
if ((player.GamesPlayed != 0))
{
winPercent = ((player.GamesWon * 100) / player.GamesPlayed);
}
playerStats.Add(player.Name);
playerStats.Add(player.GamesPlayed);
playerStats.Add(player.Points);
playerStats.Add(player.GamesWon);
playerStats.Add(player.GamesLost);
playerStats.Add(player.GamesTie);
playerStats.Add(winPercent);
}
catch
{
UserFaultException fault = new UserFaultException()
{
Message = "Error in showing player statistics"
};
throw new FaultException <UserFaultException>(fault);
}
}
return(playerStats);
}
//Refresh the live game table
private void RefreshLiveGameTable(string Player1, string Player2)
{
using (var cdb = new minesweeper_RonOzeritskyEntities())
{
try
{
LiveGame liveGame = new LiveGame
{
Serial = LiveGamesCounterAdd(),
Player1Name = Player1,
Player2Name = Player2,
GameStarted = GetCurrentDateTime()
};
cdb.LiveGames.Add(liveGame);
cdb.Entry(liveGame).State = System.Data.Entity.EntityState.Added;
cdb.SaveChanges();
}
catch (Exception)
{
UserFaultException fault = new UserFaultException()
{
Message = "Server error."
};
throw new FaultException <UserFaultException>(fault);
}
}
}
//Delete client from the DB
public void DeleteClient(string userName, string password)
{
Boolean userPassFlag = false;
Client remClient = new Client
{
Name = userName,
Password = password
};
using (var cdb = new minesweeper_RonOzeritskyEntities())
{
try
{
var remFriend = cdb.Clients.Where(o => o.Name == remClient.Name &&
o.Password == remClient.Password).FirstOrDefault();
if (remFriend != null)
{
userPassFlag = true;
cdb.Clients.Remove(remFriend);
cdb.SaveChanges();
}
else
{
throw new Exception();
}
}
catch (Exception)
{
UserFaultException fault = new UserFaultException()
{
Message = "Password is incorrect"
};
throw new FaultException <UserFaultException>(fault);
}
try
{
if (userPassFlag)
{
clients.Remove(remClient.Name);
Thread updateThread = new Thread(UpdateClientsLists);
updateThread.Start();
}
else
{
throw new Exception(); //Unknown error reached.
}
}
catch (Exception)
{
UserFaultException fault = new UserFaultException()
{
Message = "Something went wrong, try again."
};
throw new FaultException <UserFaultException>(fault);
}
}
}
//Client connected event
public void ClientConnected(string username, string password)
{
Boolean userExistFlag = false;
Client newClient = new Client
{
Name = username,
Password = password
};
using (var cdb = new minesweeper_RonOzeritskyEntities())
{
try
{
if (cdb.Clients.Any(o => o.Name == newClient.Name && o.Password == newClient.Password))
{
userExistFlag = true;
}
else
{
throw new Exception();
}
}
catch (Exception)
{
UserFaultException fault = new UserFaultException()
{
Message = "Usernamme or Password are incorrect"
};
throw new FaultException <UserFaultException>(fault, new FaultReason(fault.Message));
}
}
try
{
if (userExistFlag)
{
IMineServiceCallback callback = OperationContext.Current.GetCallbackChannel <IMineServiceCallback>();
clients.Add(newClient.Name, callback);
Thread updateThread = new Thread(UpdateClientsLists);
updateThread.Start();
}
else
{
throw new Exception(); //Unknown error reached.
}
}
catch (Exception)
{
//user name is already in clients dictionary => already connected.
UserFaultException fault = new UserFaultException()
{
Message = "You are already connected"
};
throw new FaultException <UserFaultException>(fault, new FaultReason(fault.Message));
}
}
// MineService C'tor.
public MineService()
{
liveGames = new List <GameMatch>();
clients = new SortedDictionary <string, IMineServiceCallback>();
playingClients = new List <string>();
liveGamesCounter = 0;
//set gamesCounter.
using (var cdb = new minesweeper_RonOzeritskyEntities())
{
try
{
var gameCount = (from g in cdb.Games
select g).Count();
gamesCounter = gameCount;
}
catch
{
UserFaultException fault = new UserFaultException()
{
Message = "Some error in DataBase while openning server."
};
throw new FaultException <UserFaultException>(fault, new FaultReason(fault.Message));
}
}
//Clean LiveGames table.
using (var cdb = new minesweeper_RonOzeritskyEntities())
{
try
{
var liveGame = (from g in cdb.LiveGames
select g);
cdb.LiveGames.RemoveRange(liveGame);
cdb.SaveChanges();
}
catch
{
UserFaultException fault = new UserFaultException()
{
Message = "Some error in DataBase while openning server."
};
throw new FaultException <UserFaultException>(fault);
}
}
}
// The player has finished playing
public void PlayerFinishedPlaying(string playerName, string opponent)
{
using (var cdb = new minesweeper_RonOzeritskyEntities())
{
try
{
LiveGame endedGame = (from g in cdb.LiveGames
where g.Player1Name == playerName || g.Player2Name == playerName
select g).SingleOrDefault();
if (endedGame != null)
{
cdb.LiveGames.Remove(endedGame);
cdb.Entry(endedGame).State = System.Data.Entity.EntityState.Deleted;
cdb.SaveChanges();
}
}
catch (Exception)
{
UserFaultException fault = new UserFaultException()
{
Message = "Server error."
};
throw new FaultException <UserFaultException>(fault);
}
}
if (playingClients.Contains(playerName))
{
playingClients.Remove(playerName);
playingClients.Remove(opponent);
UpdateClientsLists();
GameMatch match = liveGames.Find(g => g.playerYellow == playerName);
if (match == null)
{
match = liveGames.Find(g => g.playerBlue == playerName);
}
LiveGamesCounterReduce();
if (match != null)
{
liveGames.Remove(match);
}
Thread gameExit = new Thread(() => clients[opponent].GameExit(playerName));
gameExit.Start();
}
}
//Check if the client is exist in DB and not connected
public Boolean ClientExist(string username, string password)
{
using (var cdb = new minesweeper_RonOzeritskyEntities())
{
try
{
if (clients.ContainsKey(username))
{
throw new Exception();
}
}
catch (Exception)
{
UserFaultException fault = new UserFaultException()
{
Message = "You are already connected"
};
throw new FaultException <UserFaultException>(fault, new FaultReason(fault.Message));
}
try
{
if (cdb.Clients.Any(o => o.Name == username && o.Password == password))
{
return(true);
}
else
{
throw new Exception();
}
}
catch (Exception)
{
UserFaultException fault = new UserFaultException()
{
Message = "Usernamme or Password are incorrect"
};
throw new FaultException <UserFaultException>(fault, new FaultReason(fault.Message));
}
}
}
//change the clients password
public void ChangeClientPassword(string userName, string oldPassword, string newPassword)
{
Client passClient = new Client
{
Name = userName,
Password = oldPassword
};
using (var cdb = new minesweeper_RonOzeritskyEntities())
{
try
{
if (!IsValidPassword(newPassword))
{
throw new Exception();
}
var passChange = (from c in cdb.Clients
where c.Name == passClient.Name && c.Password == passClient.Password
select c).FirstOrDefault();
if (passChange == null)
{
throw new Exception();
}
else
{
passChange.Password = newPassword;
}
cdb.SaveChanges();
}
catch (Exception)
{
UserFaultException fault = new UserFaultException()
{
Message = "Password change failed"
};
throw new FaultException <UserFaultException>(fault);
}
}
}
//get the statistics of Games
public List <dynamic> GetGameStatistics(string getFactor)
{
List <dynamic> wantedStats = new List <dynamic>();
List <dynamic> allWantedStats = new List <dynamic>();
switch (getFactor)
{
case "Players":
{
try
{
using (var cdb = new minesweeper_RonOzeritskyEntities())
{
foreach (var player in cdb.Clients)
{
wantedStats = GetPlayerStatistics(player.Name);
allWantedStats.AddRange(wantedStats);
}
return(allWantedStats);
}
}
catch (Exception)
{
UserFaultException fault = new UserFaultException()
{
Message = "Database fail."
};
throw new FaultException <UserFaultException>(fault);
}
}
case "Games":
{
try
{
using (var cdb = new minesweeper_RonOzeritskyEntities())
{
foreach (var game in cdb.Games)
{
if (game.Tie)
{
allWantedStats.Add("Tie");
allWantedStats.Add("Tie");
}
else
{
allWantedStats.Add(game.Winner);
allWantedStats.Add(game.Loser);
}
allWantedStats.Add(String.Format("{0:g}", game.GameEnded));
}
return(allWantedStats);
}
}
catch (Exception)
{
UserFaultException fault = new UserFaultException()
{
Message = "Database fail."
};
throw new FaultException <UserFaultException>(fault);
}
}
case "LiveGames":
{
try
{
using (var cdb = new minesweeper_RonOzeritskyEntities())
{
foreach (var game in cdb.LiveGames)
{
allWantedStats.Add(game.Player1Name);
allWantedStats.Add(game.Player2Name);
allWantedStats.Add(String.Format("{0:g}", game.GameStarted));
}
return(allWantedStats);
}
}
catch (Exception)
{
UserFaultException fault = new UserFaultException()
{
Message = "Database fail."
};
throw new FaultException <UserFaultException>(fault);
}
}
default:
{
return(null);
}
}
}
//Registration
public void Register(string userName, string password)
{
Boolean userExistFlag = true;
Client newClient = new Client
{
Name = userName,
Password = password
};
try
{
if (!IsValidName(newClient.Name))
{
throw new Exception();
}
}
catch
{
UserFaultException fault = new UserFaultException()
{
Message = "Usernamme should be at least 3 charecters long and contain only numbers and digits"
};
throw new FaultException <UserFaultException>(fault, new FaultReason(fault.Message));;
}
try
{
if (!IsValidPassword(newClient.Password))
{
throw new Exception();
}
}
catch
{
UserFaultException fault = new UserFaultException()
{
Message = "Password should be at least 6 charecters long and contain only numbers and digits"
};
throw new FaultException <UserFaultException>(fault);
}
using (var cdb = new minesweeper_RonOzeritskyEntities())
{
try
{
if (cdb.Clients.Any(o => o.Name == newClient.Name))
{
throw new Exception();
}
else
{
userExistFlag = false;
}
}
catch (Exception)
{
UserFaultException fault = new UserFaultException()
{
Message = "Usernamme is taken"
};
throw new FaultException <UserFaultException>(fault, new FaultReason(fault.Message));
}
try
{
if (!userExistFlag)
{
cdb.Clients.Add(newClient);
cdb.SaveChanges();
}
else
{
throw new Exception(); //Unknown error reached.
}
}
catch (Exception)
{
//error adding new user to database.
UserFaultException fault = new UserFaultException()
{
Message = "Something went wrong, try again."
};
throw new FaultException <UserFaultException>(fault, new FaultReason(fault.Message));
}
}
}
//Update the DB after game ends
private void EndGameDBUpdate(string winner, string loser, bool isTie)
{
//Remove game from Livegames table.
using (var cdb = new minesweeper_RonOzeritskyEntities())
{
try
{
LiveGame endedGame = (from g in cdb.LiveGames
where g.Player1Name == winner || g.Player2Name == winner
select g).SingleOrDefault();
if (endedGame != null)
{
cdb.LiveGames.Remove(endedGame);
cdb.Entry(endedGame).State = System.Data.Entity.EntityState.Deleted;
cdb.SaveChanges();
}
}
catch (Exception)
{
UserFaultException fault = new UserFaultException()
{
Message = "Server error."
};
throw new FaultException <UserFaultException>(fault);
}
}
//Add game to Games table.
using (var cdb = new minesweeper_RonOzeritskyEntities())
{
try
{
Game game = new Game
{
Serial = gamesCounter,
Winner = winner,
Loser = loser,
Tie = isTie,
GameEnded = GetCurrentDateTime()
};
cdb.Games.Add(game);
cdb.Entry(game).State = System.Data.Entity.EntityState.Added;
cdb.SaveChanges();
}
catch (Exception)
{
UserFaultException fault = new UserFaultException()
{
Message = "Server error."
};
throw new FaultException <UserFaultException>(fault);
}
}
//Update Clients table properties.
using (var cdb = new minesweeper_RonOzeritskyEntities())
{
try
{
if (!isTie)
{
Client Winner = (from w in cdb.Clients
where w.Name == winner
select w).SingleOrDefault();
Winner.GamesPlayed++;
Winner.Points++;
Winner.GamesWon++;
Client Loser = (from l in cdb.Clients
where l.Name == loser
select l).SingleOrDefault();
Loser.GamesPlayed++;
Loser.GamesLost++;
cdb.Entry(Winner).State = System.Data.Entity.EntityState.Modified;
cdb.Entry(Loser).State = System.Data.Entity.EntityState.Modified;
cdb.SaveChanges();
}
else //its Tie
{
Client Winner = (from w in cdb.Clients
where w.Name == winner
select w).SingleOrDefault();
Winner.GamesPlayed++;
Winner.GamesTie++;
Client Loser = (from l in cdb.Clients
where l.Name == loser
select l).SingleOrDefault();
Loser.GamesPlayed++;
Loser.GamesTie++;
cdb.Entry(Winner).State = System.Data.Entity.EntityState.Modified;
cdb.Entry(Loser).State = System.Data.Entity.EntityState.Modified;
cdb.SaveChanges();
}
}
catch (Exception)
{
UserFaultException fault = new UserFaultException()
{
Message = "Server error."
};
throw new FaultException <UserFaultException>(fault);
}
}
}