public void DeleteGameResults(int GameResultsId) { AgileMindEntities db = new DAL.Data.AgileMindEntities(); List<t_GameResults> resultList = (from data in db.t_GameResults where data.GameScoreId == GameResultsId select data).ToList(); foreach (t_GameResults item in resultList) { db.DeleteObject(item); } db.SaveChanges(); }
public static void DeleteLoginsFromDB(String LoginName) { AgileMind.DAL.Data.AgileMindEntities agileMindDB = new DAL.Data.AgileMindEntities(); List<AgileMind.DAL.Data.Login> loginList = (from p in agileMindDB.Logins where p.LoginName == LoginName select p).ToList(); foreach (AgileMind.DAL.Data.Login loginToDelete in loginList) { agileMindDB.DeleteObject(loginToDelete); } agileMindDB.SaveChanges(); }
public void CallingCreateLoginInfoAddsTheLoginPersonIntoTheDatabase() { String loginName = "TestName"; String password = "******"; String email = "Email"; DeleteLoginsFromDB(loginName); LoginResult loginInfo = LoginResult.CreateLogin(loginName, password, email); AgileMind.DAL.Data.AgileMindEntities agileMind = new DAL.Data.AgileMindEntities(); List<AgileMind.DAL.Data.Login> loginList = agileMind.Logins_CheckLogin(loginName, password, String.Empty).ToList(); Assert.AreEqual(1, loginList.Count, "After insertion of new login there should be one login"); Assert.AreEqual(loginName, loginList[0].LoginName, "Login Name should be set equal"); Assert.AreEqual(password, loginList[0].Password, "Password should be equal"); Assert.AreEqual(email, loginList[0].EmailAddress); DeleteLoginsFromDB(loginName); }
public void CallingValidateLoginReturnsFalseIfTheLoginNameAndPasswordAreCorrectButActiveIsFalse() { String loginName = "TestAccount"; String password = "******"; String email = "*****@*****.**"; DeleteLoginsFromDB(loginName); LoginResult loginResult = LoginResult.CreateLogin(loginName, password, email); AgileMind.DAL.Data.AgileMindEntities agileMindDB = new DAL.Data.AgileMindEntities(); List<AgileMind.DAL.Data.Login> loginList = (from data in agileMindDB.Logins where data.LoginName == loginName select data).ToList(); foreach (AgileMind.DAL.Data.Login login in loginList) { login.Active = false; } agileMindDB.SaveChanges(); LoginResult validateResult = LoginResult.ValidateLogin(loginName, password, String.Empty); Assert.IsFalse(validateResult.Success); DeleteLoginsFromDB(loginName); }
public static int GetFirstGameID() { AgileMind.DAL.Data.AgileMindEntities db = new DAL.Data.AgileMindEntities(); AgileMind.DAL.Data.t_Game tGame = (from data in db.t_Game select data).First(); return tGame.GameId; }