public bool EnterClientToDB(Clients client) { bool value; using (MineSweeperDB1Entities ctx = new MineSweeperDB1Entities()) { var cli = from c in ctx.Clients where c.UserName == client.UserName select c.UserName; if (cli.ToList().Count == 0) { //enter username+password to the db as a new client ctx.Clients.Add(client); ctx.SaveChanges(); value = true; } //if the username already exists, put a message else { value = false; } } return(value); }
public string[][] ShowAllGames() { string[][] GList = null; using (MineSweeperDB1Entities ctx = new MineSweeperDB1Entities()) { GList = new string[ctx.Games.Count()][]; for (int i = 0; i < ctx.Games.Count(); i++) { GList[i] = new string[4]; for (int j = 0; j < 4; j++) { string isTie = ctx.Games.ToArray()[i].tie ? "yes" : "no"; if (j == 0) { GList[i][j] = ctx.Games.ToArray()[i].EndingDate.ToString(); } if (j == 1) { GList[i][j] = ctx.Games.ToArray()[i].Winner; } if (j == 2) { GList[i][j] = ctx.Games.ToArray()[i].Loser; } if (j == 3) { GList[i][j] = isTie; } } } } return(GList); }
public void EnterGameToDB(Games game) { using (MineSweeperDB1Entities ctx = new MineSweeperDB1Entities()) { var query = (from g in ctx.Games select g.Id).Max(); game.Id = query + 1; ctx.Games.Add(game); num_of_games = game.Id; ctx.SaveChanges(); } GameDisconnect(game); }
public bool SearchUsernamePasswordInDB(Clients client) { using (MineSweeperDB1Entities ctx = new MineSweeperDB1Entities()) { var cli = from c in ctx.Clients where c.UserName == client.UserName && c.Password == client.Password select c.UserName; //if the client exists in the database if (cli.ToList().Count != 0) { return(true); } else { return(false); } } }
public string[][] ShowAllPlayers() { string[][] clients = null; using (MineSweeperDB1Entities ctx = new MineSweeperDB1Entities()) { clients = new string[ctx.Clients.Count()][]; for (int i = 0; i < ctx.Clients.Count(); i++) { Clients c = ctx.Clients.ToArray()[i]; //the games c won var gamesCWon = (from g in ctx.Games where g.Winner == c.UserName select g).ToArray(); //the games c lost var gamesCLost = (from g in ctx.Games where g.Loser == c.UserName select g).ToArray(); //the games where there was a tie and c participated var gamesTie = from g in ctx.Games where g.tie == true && (g.Loser == c.UserName || g.Winner == c.UserName) select g; double gamesPlayed = gamesCWon.Count() + gamesCLost.Count(); double percent; if (gamesPlayed == 0) { percent = 0; } else { percent = (gamesCWon.Count() / gamesPlayed) * 100; } clients[i] = new string[6]; for (int j = 0; j < 6; j++) { if (j == 0) { clients[i][j] = ctx.Clients.ToArray()[i].UserName; } if (j == 1) { clients[i][j] = gamesPlayed.ToString(); } if (j == 2) { clients[i][j] = gamesCWon.Count().ToString(); } if (j == 3) { clients[i][j] = gamesCLost.Count().ToString(); } if (j == 4) { clients[i][j] = gamesTie.Count().ToString(); } if (j == 5) { clients[i][j] = percent.ToString(); } } } } return(clients); }