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