public void UpdateTeamTest()
{
Data.Entities.HLContext _db = new Data.Entities.HLContext();
Data.TeamRepository test = new Data.TeamRepository(_db);
Data.UserRepository usertest = new Data.UserRepository(_db);
//preliminary stuff to clean database in case this stuff is already in there
//first see if the team used in this test is in the DB
Data.Entities.Team isthisteamhere = _db.Team.Where(o => o.Teamname.Equals("testteamname")).FirstOrDefault();
if (isthisteamhere != null)
{
//obtain the primary key for this team
int primarykey = isthisteamhere.Id;
//remove the userteam(s) associated with this team
IEnumerable <UserTeam> ww = _db.UserTeam.Where(mm => mm.Teamid == primarykey);
foreach (var item in ww)
{
_db.UserTeam.Remove(item);
}
_db.SaveChanges();
//now we can remove the team
_db.Team.Remove(isthisteamhere);
_db.SaveChanges();
}
//now we can remove our user1 and 2 if they exist
Data.Entities.User isthisuserhere = _db.User.Where(p => p.Username.Equals("username1")).FirstOrDefault();
if (isthisuserhere != null)
{
_db.User.Remove(isthisuserhere);
_db.SaveChanges();
}
Data.Entities.User isthisuserhere2 = _db.User.Where(p => p.Username.Equals("username2")).FirstOrDefault();
if (isthisuserhere2 != null)
{
_db.User.Remove(isthisuserhere2);
_db.SaveChanges();
}
bool what; //random bool to hold data about success of methods.
bool success; //initialize boolean for asserts
//first case, we pass the method a faulty team check for null case and count case.
Domain.Team team = new Domain.Team();
success = test.UpdateTeam(team);
Assert.AreEqual(success, false);
//second test case for we have an empty team in the database and it is updated to contain a team.
team.teamname = "testteamname";
Domain.User user = new Domain.User("username1", "password1");
//need to add user to db and pull it to get a stupid id
success = usertest.DeleteUser(user);
usertest.Save();
//add user to the database;
success = usertest.AddUser(user);
usertest.Save();
if (!success)
{
Assert.Fail();
}
_db.SaveChanges();
//obtain the user from the database so it has the userID
var x = _db.User.Where(a => a.Username.Equals(user.username)).FirstOrDefault();
Domain.User user1withID = Mapper.Map(x);
team.Roles.Add(true);
team.Userlist.Add(user1withID);
what = test.DeleteTeam(team);
what = test.AddTeam(team);
//now I will add another user to the team and see if it updates.
Domain.User user2 = new Domain.User("username2", "password2");
usertest.AddUser(user2);
usertest.Save();
var xx = _db.User.Where(a => a.Username.Equals(user2.username)).FirstOrDefault();
Domain.User user2withID = Mapper.Map(xx);
team.AddMember(user2withID);
success = test.UpdateTeam(team);
Assert.AreEqual(success, true);
//keep database clean and undo the things i put in it
//first remove the userteams
//preliminary stuff to clean database in case this stuff is already in there
//first see if the team used in this test is in the DB
Data.Entities.Team isthisteamhere3 = _db.Team.Where(o => o.Teamname.Equals("testteamname")).FirstOrDefault();
if (isthisteamhere3 != null)
{
//obtain the primary key for this team
int primarykey = isthisteamhere3.Id;
//remove the userteam(s) associated with this team
IEnumerable <UserTeam> ww = _db.UserTeam.Where(mm => mm.Teamid == primarykey);
foreach (var item in ww)
{
_db.UserTeam.Remove(item);
}
_db.SaveChanges();
//now we can remove the team
_db.Team.Remove(isthisteamhere3);
_db.SaveChanges();
}
//now we can remove our user1 and 2 if they exist
Data.Entities.User isthisuserhere3 = _db.User.Where(p => p.Username.Equals("username1")).FirstOrDefault();
if (isthisuserhere3 != null)
{
_db.User.Remove(isthisuserhere3);
_db.SaveChanges();
}
Data.Entities.User isthisuserhere4 = _db.User.Where(p => p.Username.Equals("username2")).FirstOrDefault();
if (isthisuserhere4 != null)
{
_db.User.Remove(isthisuserhere4);
_db.SaveChanges();
}
}
public void AddAndRemoveTeamTest()
{
Data.Entities.HLContext _db = new Data.Entities.HLContext();
Data.TeamRepository test = new Data.TeamRepository(_db);
Data.UserRepository usertest = new Data.UserRepository(_db);
bool success; //variable to determine if a team was added or removed successfully.
Domain.Team x = new Domain.Team();
x.teamname = "XXstarstrikersXX1113452435x4";
success = test.DeleteTeam(x);
_db.SaveChanges();
success = test.AddTeam(x);
_db.SaveChanges();
//assert that the team was added to the database
Assert.AreEqual(success, true);
success = test.AddTeam(x);
_db.SaveChanges();
//assert that the team was not added to the database because it already exists
Assert.AreEqual(success, false);
//assert that the team was successfuly deleted from the database
success = test.DeleteTeam(x);
_db.SaveChanges();
Assert.AreEqual(success, true);
//assert that the team was not deleted from the database because it did not exist
success = test.DeleteTeam(x);
_db.SaveChanges();
Assert.AreEqual(success, false);
//assert that the propery userteam table was added to the database
Domain.User anewuser = new Domain.User("newuser89", "newpassword89");
//delete the user from DB incase it exist
success = usertest.DeleteUser(anewuser);
if (success)
{
usertest.Save();
}
//add the user to the DB
success = usertest.AddUser(anewuser);
if (success)
{
usertest.Save();
}
//pull the user from the database
Domain.User anewuserwithID = usertest.GetUserByUsername("newuser89");
//add the user to the team
x.AddMember(anewuserwithID);
//add the team to the DB
success = test.DeleteTeam(x);
_db.SaveChanges();
success = test.AddTeam(x);
_db.SaveChanges();
//now check that a usertable was created properly for the team
Data.Entities.UserTeam userteam = _db.UserTeam.Where(jj => jj.Userid == anewuserwithID.id).FirstOrDefault();
Assert.AreEqual(userteam.Userid, anewuserwithID.id);
//now remove the team from the db
success = test.DeleteTeam(x);
Data.Entities.UserTeam deleted = _db.UserTeam.Where(jj => jj.Userid == anewuserwithID.id).FirstOrDefault();
//check that the userteam was deleted
Assert.AreEqual(deleted, null);
//delete the user from the DB to keep it clean
usertest.DeleteUser(anewuserwithID);
usertest.Save();
}
