public void TestUsersMethods()
{
using (DataContextDataContext dc = new DataContextDataContext())
{
User usr1 = DBDataManager.GetUserByLogin("testuser1");
User usr2 = DBDataManager.GetUserByLogin("testuser2");
if (usr1 != null) dc.Users.DeleteOnSubmit(dc.Users.First(u => u.Id == usr1.Id));
if (usr2 != null) dc.Users.DeleteOnSubmit(dc.Users.First(u => u.Id == usr2.Id));
dc.SubmitChanges();
Assert.IsTrue(DBDataManager.CreateUser("testuser1", "123", "name1", "*****@*****.**"));
Assert.IsFalse(DBDataManager.CreateUser("testuser1", "123", "name1", "*****@*****.**"));
Assert.IsTrue(DBDataManager.CreateUser("testuser2", "123", "name2", "*****@*****.**"));
usr1 = DBDataManager.GetUserByLogin("testuser1");
usr2 = DBDataManager.GetUserByLogin("testuser2");
Assert.IsTrue(usr1 != null && usr2 != null);
}
}
public static int CreateGame(int bId, int wId)
{
try
{
using (DataContextDataContext dc = new DataContextDataContext())
{
Game dbGame = new Game();
dbGame.BlackUserId = bId;
dbGame.WhiteUserId = wId;
GameObject cGameObject = new GameObject();
dbGame.GameData = Serialize(cGameObject.GetState());
dc.Games.InsertOnSubmit(dbGame);
dc.SubmitChanges();
return dbGame.Id;
}
}
catch (Exception)
{
return 0;
}
}
public static bool CreateUser(string login, string pass, string name, string email)
{
try
{
using (DataContextDataContext dc = new DataContextDataContext())
{
User u = new User()
{
Email = email,
Login = login,
Name = login,
Password = ChessCore.Utils.CalculateMD5Hash(pass)
};
dc.Users.InsertOnSubmit(u);
dc.SubmitChanges();
}
return true;
}
catch (Exception)
{
return false;
}
}
public static User GetUserById(int id)
{
try
{
using (DataContextDataContext dc = new DataContextDataContext())
{
User user = dc.Users.Where(u => u.Id == id).FirstOrDefault();
return user;
}
}
catch (Exception)
{
return null;
}
}
public static User GetUserByEmail(string email)
{
try
{
using (DataContextDataContext dc = new DataContextDataContext())
{
User user = dc.Users.Where(u => u.Email == email).FirstOrDefault();
return user;
}
}
catch (Exception)
{
return null;
}
}
public static bool UpdateGame(ChessCore.GameObject gs)
{
try
{
using (DataContextDataContext dc = new DataContextDataContext())
{
var data = (from G in dc.Games
where G.Id == gs.gameId
select G).FirstOrDefault();
if (data == null) return false;
data.GameData = Serialize(gs);
data.GameStatus = (int) gs.status;
dc.SubmitChanges();
}
return true;
}
catch (Exception)
{
return false;
}
}
public static void RemoveUser(User usr)
{
try
{
using (DataContextDataContext dc = new DataContextDataContext())
{
dc.Users.DeleteOnSubmit(usr);
dc.SubmitChanges();
}
}
catch (Exception)
{
}
}
public static GameObject LoadGameById(int gId)
{
try
{
GameState GameState;
using (DataContextDataContext dc = new DataContextDataContext())
{
Game dbGame = dc.Games.FirstOrDefault(g => g.Id == gId);
if (dbGame == null)
return null;
GameState = (GameState)Deserialize(dbGame);
}
GameObject GameObject = null;
return GameObject;
}
catch (Exception)
{
return null;
}
}
public static User GetUserByLogin(string login)
{
try
{
using (DataContextDataContext dc = new DataContextDataContext())
{
User user = dc.Users.Where(u => u.Login == login).FirstOrDefault();
return user;
}
}
catch (Exception)
{
return null;
}
}
public void TestLoadGame()
{
using (DataContextDataContext dc = new DataContextDataContext())
{
int gameID = DBDataManager.CreateGame(7, 9);
GameObject gameObject = DBDataManager.LoadGameById(gameID);
}
}
public void TestCreateGame()
{
using (DataContextDataContext dc = new DataContextDataContext())
{
User usr1 = DBDataManager.GetUserByLogin("testuser1");
User usr2 = DBDataManager.GetUserByLogin("testuser2");
if (usr1 == null || usr2 == null)
{
Assert.IsTrue(DBDataManager.CreateUser("testuser1", "123", "name1", "*****@*****.**"));
Assert.IsTrue(DBDataManager.CreateUser("testuser2", "123", "name2", "*****@*****.**"));
usr1 = DBDataManager.GetUserByLogin("testuser1");
usr2 = DBDataManager.GetUserByLogin("testuser2");
}
Assert.IsTrue(DBDataManager.CreateGame(usr1.Id, usr2.Id) != 0);
}
}