/// <summary>
/// Class constructor
/// </summary>
/// <param name="connection">A connection to the used Sql Server</param>
public SqlSecurityManager(SqlConnection connection)
{
this.connection = connection ?? throw new System.Security.SecurityException("connection connot be null");
userManager = new SqlUserManager(this);
roleManager = new SqlRoleManager(this);
Console.Out.WriteLine("Concrete SecurityManager instanciated");
}
public void GetById()
{
SqlUserManager sqm = new SqlUserManager();
User u = new User();
int id = 9;
u = sqm.GetUserById(id);
Assert.AreEqual(id, u.Id);
}
public void GoodLogin()
{
SqlUserManager sqm = new SqlUserManager();
bool expected = true;
sqm.AddUser("LoginTest", "password");
bool actual = sqm.Login("LoginTest", "password");
sqm.DeleteUserByUsername("LoginTest");
Assert.AreEqual(expected, actual);
}
public void AddUser()
{
SqlUserManager sqm = new SqlUserManager();
int PreCount = sqm.Count();
sqm.AddUser("testUser", "password");
int PostCount = sqm.Count();
Assert.AreEqual((PreCount + 1), PostCount);
}
public void AddInvaliduser()
{
SqlUserManager sqm = new SqlUserManager();
int PreCount = sqm.Count();
sqm.AddUser("", "password");
int PostCount = sqm.Count();
Assert.AreEqual(PreCount, PostCount);
}
public void DeleteUserByUsername()
{
SqlUserManager sqm = new SqlUserManager();
sqm.AddUser("deleteTest", "password");
int PreCount = sqm.Count();
sqm.DeleteUserByUsername("deleteTest");
int PostCount = sqm.Count();
Assert.AreEqual(PreCount-1, PostCount);
}
public void LoginCorrect()
{
SqlUserManager sqm = new SqlUserManager();
string UserName = "******";
string Password = "******";
bool check = sqm.Login(UserName, Password);
Assert.AreEqual(true, check);
}
public void BadLogin()
{
SqlUserManager sqm = new SqlUserManager();
string UserName = "******";
string Password = "******";
bool check = sqm.Login(UserName, Password);
Assert.AreEqual(false, check);
}
public void AddTestUser()
{
SqlUserManager sqm = new SqlUserManager();
User u = new User();
u.Id = 12;
u.Password = "******";
string tempUserName = DateTime.Now.ToString();
u.UserName = tempUserName;
sqm.Add(u);
string found = sqm.GetUserByUserName(tempUserName);
Assert.AreEqual(tempUserName, found);
}
