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