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 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)
{
}
}
