private void WriteUsernameToDb(ClientObject client)
{
try
{
if (client == null)
{
return;
}
using (var db = new ChessDataBaseDataContext())
{
if (client.Username.Length > 21 || client.Username.Length == 0)
{
return;
}
var newPlayer = new T_User
{
Nickname = client.Username
};
db.T_Users.InsertOnSubmit(newPlayer);
db.SubmitChanges();
}
}
catch (Exception ex)
{
Console.Write("WriteUsernameToDb(): ");
Console.WriteLine(ex.Message);
Console.ReadKey();
}
}
private T_Game NewGameToDb()
{
if (server.clients.Count != 2)
{
return(null);
}
T_Game _game = new T_Game();
try
{
using (var db = new ChessDataBaseDataContext())
{
var user = db.T_Users.Select(q => q).ToArray();
foreach (var u in user)
{
_game =
db.T_Games.FirstOrDefault(q => q.Black == u.Id && u.Nickname == server.clients[1].Username);
}
if (_game != null)
{
return(_game);
}
var newGame = new T_Game();
foreach (var cl in server.clients)
{
foreach (var u in user)
{
if (cl.Username == u.Nickname && cl.WhoIam == "w")
{
newGame.White = u.Id;
}
if (cl.Username == u.Nickname && cl.WhoIam == "b")
{
newGame.Black = u.Id;
}
}
}
db.T_Games.InsertOnSubmit(newGame);
db.SubmitChanges();
_game = newGame;
return(_game);
}
}
catch (Exception ex)
{
Console.Write("NewGameToDb(): ");
Console.WriteLine(ex.Message);
Console.ReadKey();
}
return(null);
}
private void AddStepGame(string step, T_Game game)
{
try
{
if (game == null)
{
return;
}
using (var db = new ChessDataBaseDataContext())
{
var stepArray = step.ToCharArray();
var count = db.T_Courses.Count(q => q.GameID == game.Id) + 1;
var newStep = new T_Course
{
Course = step,
GameID = game.Id,
Number = count
};
if (stepArray[0] == 'w')
{
newStep.WhoGone = game.White;
}
if (stepArray[0] == 'b')
{
newStep.WhoGone = game.Black;
}
db.T_Courses.InsertOnSubmit(newStep);
db.SubmitChanges();
}
}
catch (Exception ex)
{
Console.Write("AddStepGame(): ");
Console.WriteLine(ex.Message);
Console.ReadKey();
}
}