public void IsUserAuthorizedTest()
{
var dataAccess = new AccessService();
// Make sure that these domains are not there
Assert.IsFalse(dataAccess.IsUserAuthorized("*****@*****.**"));
Assert.IsFalse(dataAccess.IsUserAuthorized("*****@*****.**"));
Assert.IsFalse(dataAccess.IsUserAuthorized("*****@*****.**"));
Guid userId = dataAccess.GetUserID("*****@*****.**");
Assert.IsTrue(userId == Guid.Empty);
// Make sure that you can add users
Assert.IsTrue(dataAccess.AddUser("*****@*****.**", 0));
Assert.IsTrue(dataAccess.AddUser("*****@*****.**", 1));
Assert.IsTrue(dataAccess.AddUser("*****@*****.**", 2));
// Check that the users are actually in the DB
Assert.IsTrue(dataAccess.IsUserAuthorized("*****@*****.**"));
Assert.IsTrue(dataAccess.IsUserAuthorized("*****@*****.**"));
Assert.IsTrue(dataAccess.IsUserAuthorized("*****@*****.**"));
Guid userIdCheck2 = dataAccess.GetUserID("*****@*****.**");
Assert.IsFalse(userIdCheck2 == Guid.Empty);
// Delete users
Assert.IsTrue(dataAccess.DeleteUser("*****@*****.**"));
Assert.IsTrue(dataAccess.DeleteUser("*****@*****.**"));
Assert.IsTrue(dataAccess.DeleteUser("*****@*****.**"));
}
/// <summary>
/// Get function ,to get all the projects for specific vertical from data access layer.
/// It been used in project-list.js to show the project names on a ProjectList.html.
/// </summary>
/// <param name="VerticalId">VerticalId (int)index defined in the Verticals enum</param>
/// <returns>List of Project objects in format of json</returns>
public string GetVerticalProjects(int VerticalId)
{
AccessService DataAccess = new AccessService();
var passProjectList = new List<StatusUpdatesModel.Project>();
try {
if (this.Session["username"].ToString() != null && DataAccess.IsUserAuthorized(this.Session["username"].ToString()))
{
// AccessService DataAccess = new AccessService();
var VerticalProjects = DataAccess.GetAllProjectsForVertical(VerticalId);
foreach (StatusUpdatesModel.Project project in VerticalProjects)
{
StatusUpdatesModel.Project tempProject = new StatusUpdatesModel.Project();
tempProject.LatestUpdate = project.LatestUpdate;
tempProject.ProjectID = project.ProjectID;
tempProject.ProjectName = project.ProjectName;
passProjectList.Add(tempProject);
}
}
}
catch (Exception)
{
// Probably not the best way to handle this
string empty = JsonConvert.SerializeObject(passProjectList);
return empty;
}
string result = JsonConvert.SerializeObject(passProjectList);
return result;
}
public void GetUserIDTest()
{
var dataAccess = new AccessService();
// Add a user
Assert.IsTrue(dataAccess.AddUser("*****@*****.**", 0));
// Check that the users are actually in the DB
Assert.IsTrue(dataAccess.IsUserAuthorized("*****@*****.**"));
// Here's the actual test - the GUID should not be empty
Guid userIdCheck = dataAccess.GetUserID("*****@*****.**");
Assert.IsFalse(userIdCheck == Guid.Empty);
// Now delete and check again - if that was really the user's id, then it should return false after deleting
Assert.IsTrue(dataAccess.DeleteUser("*****@*****.**"));
Guid userIdCheck2 = dataAccess.GetUserID("*****@*****.**");
Assert.IsTrue(userIdCheck2 == Guid.Empty);
}
public void UpdateUserEmailTest2()
{
var dataAccess = new AccessService();
// Make sure that these domains are not there
Assert.IsFalse(dataAccess.IsUserAuthorized("*****@*****.**"));
Assert.IsFalse(dataAccess.IsUserAuthorized("*****@*****.**"));
Assert.IsFalse(dataAccess.IsUserAuthorized("*****@*****.**"));
// Make sure these updated email addresses do not exist
Assert.IsFalse(dataAccess.IsUserAuthorized("*****@*****.**"));
Assert.IsFalse(dataAccess.IsUserAuthorized("*****@*****.**"));
Assert.IsFalse(dataAccess.IsUserAuthorized("*****@*****.**"));
Guid userId = dataAccess.GetUserID("*****@*****.**");
Assert.IsTrue(userId == Guid.Empty);
// Make sure that you can add users
Assert.IsTrue(dataAccess.AddUser("*****@*****.**", 0));
Assert.IsTrue(dataAccess.AddUser("*****@*****.**", 1));
Assert.IsTrue(dataAccess.AddUser("*****@*****.**", 2));
// Check that the users are actually in the DB
Assert.IsTrue(dataAccess.IsUserAuthorized("*****@*****.**"));
Assert.IsTrue(dataAccess.IsUserAuthorized("*****@*****.**"));
Assert.IsTrue(dataAccess.IsUserAuthorized("*****@*****.**"));
Guid userIdCheck2 = dataAccess.GetUserID("*****@*****.**");
Assert.IsFalse(userIdCheck2 == Guid.Empty);
// Make sure these updated email addresses do not exist
Assert.IsFalse(dataAccess.IsUserAuthorized("*****@*****.**"));
Assert.IsFalse(dataAccess.IsUserAuthorized("*****@*****.**"));
Assert.IsFalse(dataAccess.IsUserAuthorized("*****@*****.**"));
// Now we are going to update these users - this is the main part
Assert.IsTrue(dataAccess.UpdateUserEmail("*****@*****.**", "*****@*****.**"));
Assert.IsTrue(dataAccess.UpdateUserEmail("*****@*****.**", "*****@*****.**"));
// Update it in the overloaded way
Guid userId3 = dataAccess.GetUserID("*****@*****.**");
Assert.IsTrue(dataAccess.UpdateUserEmail(userId3, "*****@*****.**"));
// Make sure that these domains are not there anymore
Assert.IsFalse(dataAccess.IsUserAuthorized("*****@*****.**"));
Assert.IsFalse(dataAccess.IsUserAuthorized("*****@*****.**"));
Assert.IsFalse(dataAccess.IsUserAuthorized("*****@*****.**"));
// Make sure these updated email addresses exist
Assert.IsTrue(dataAccess.IsUserAuthorized("*****@*****.**"));
Assert.IsTrue(dataAccess.IsUserAuthorized("*****@*****.**"));
Assert.IsTrue(dataAccess.IsUserAuthorized("*****@*****.**"));
// Clean up users
Assert.IsTrue(dataAccess.DeleteUser("*****@*****.**"));
Assert.IsTrue(dataAccess.DeleteUser("*****@*****.**"));
Assert.IsTrue(dataAccess.DeleteUser("*****@*****.**"));
}
public void GetUserRoleTest()
{//__this covers AddUser, GetUserRole, DeleteUser, UpdateUserRole
string emailAddy = "*****@*****.**";
//string emailAddy2 = "*****@*****.**";
int userRole = 1;
AccessService dataAccess = new AccessService();
try//__make sure we can back out in case of errors
{
bool userAdded = dataAccess.AddUser(emailAddy, userRole);
//__test adding new user
Assert.IsTrue(userAdded, "AddUser returned false for email " + emailAddy + ", UserRole=" + userRole);
int recordedRole = dataAccess.GetUserRole(emailAddy);
Assert.AreEqual(userRole, recordedRole);
int newRole = 0;
dataAccess.UpdateUserRole(emailAddy, newRole);
recordedRole = dataAccess.GetUserRole(emailAddy);
Assert.AreEqual(newRole, recordedRole, "User Role not properly Modified");
bool userRemoved = dataAccess.DeleteUser(emailAddy);
Assert.IsTrue(userRemoved, "userRemoved returned false");
}
finally
{//__make sure to clean out our test data
if (dataAccess.IsUserAuthorized(emailAddy))
{
dataAccess.DeleteUser(emailAddy);
}
}
}