public string DeleteAspUser(iMentorUserInfo user)
{
if (user != null)
{
using (iMAST_dbEntities db = new iMAST_dbEntities())
{
var aspUser = db.AspNetUsers.Where(x => x.Email.Equals(user.Email)).FirstOrDefault();
if (aspUser != null)
{
db.AspNetUsers.Remove(aspUser);
db.SaveChanges();
return("Asp User Deleted");
}
else
{
return("Invalid Asp User");
}
}
}
else
{
return("Invalid Asp User");
}
}
public void UpdateUserTest()
{
ManageController controller = new ManageController();
iMentorUser user = controller.ReturnLastAddedUser();
iMentorUserInfo userInfo = new iMentorUserInfo();
userInfo.Id = user.Id;
userInfo.UserName = "******";
userInfo.Email = user.Email;
userInfo.RoleId = user.RoleId;
userInfo.Role = userInfo.GetRoleByUser(user);
//Check that the UpdateUser function completed successfully
Assert.AreEqual(controller.UpdateUser(userInfo), "User Updated");
//Check that the user was actually updated in the database
iMentorUser userUpdated = controller.ReturnLastAddedUser();
Assert.IsTrue(userUpdated.Id == userInfo.Id &&
userUpdated.UserName == userInfo.UserName &&
userUpdated.Email == userInfo.Email &&
userUpdated.RoleId == userInfo.RoleId);
//Clean up
userInfo.UserName = user.UserName;
controller.UpdateUser(userInfo);
}
public List <iMentorUserInfo> GetAllUsers()
{
using (iMAST_dbEntities db = new iMAST_dbEntities())
{
var iMentorUsers = db.iMentorUsers.ToList();
List <iMentorUserInfo> users = new List <iMentorUserInfo>();
foreach (iMentorUser user in iMentorUsers)
{
var u = new iMentorUserInfo();
u.Id = user.Id;
u.UrlId = user.UrlId;
u.UserName = user.UserName;
u.FirstName = user.FirstName;
u.LastName = user.LastName;
u.Email = user.Email;
u.RoleId = u.GetRoleIdByUser(user);
u.Role = u.GetRoleName(user);
u.ShowOnlyAssignedListings = user.ShowOnlyAssignedListings;
u.IconIndex = user.IconIndex;
users.Add(u);
}
return(users);
}
}
public string RemoveUserAssignments(iMentorUserInfo user)
{
if (user != null)
{
using (iMAST_dbEntities db = new iMAST_dbEntities())
{
var assignments = db.AssignedListings.Where(x => x.UserId == user.Id).ToList();
if (assignments != null || assignments.Count == 0)
{
foreach (AssignedListing assignment in assignments)
{
db.AssignedListings.Remove(assignment);
db.SaveChanges();
}
return("Assignment Removed");
}
else
{
return("No assignment found");
}
}
}
else
{
return("Invalid Assignment");
}
}
public iMentorUserInfo GetCurrentUser(string userName)
{
var currentUserName = userName;
var user = new iMentorUserInfo();
if (!currentUserName.Equals(""))
{
using (iMAST_dbEntities db = new iMAST_dbEntities())
{
var iMentorUser = db.iMentorUsers.Where(x => x.UserName.Equals(currentUserName)).FirstOrDefault();
if (iMentorUser != null)
{
user.Id = iMentorUser.Id;
user.UrlId = iMentorUser.UrlId;
user.UserName = iMentorUser.UserName;
user.FirstName = iMentorUser.FirstName;
user.LastName = iMentorUser.LastName;
user.Email = iMentorUser.Email;
user.RoleId = user.GetRoleIdByUser(iMentorUser);
user.Role = user.GetRoleName(iMentorUser);
user.ShowOnlyAssignedListings = iMentorUser.ShowOnlyAssignedListings;
user.IconIndex = iMentorUser.IconIndex;
}
}
}
return(user);
}
public string RemoveUserApplications(iMentorUserInfo user)
{
if (user != null)
{
using (iMAST_dbEntities db = new iMAST_dbEntities())
{
var applications = db.Applicants.Where(x => x.UserId == user.Id).ToList();
if (applications != null || applications.Count == 0)
{
foreach (Applicant applicant in applications)
{
db.Applicants.Remove(applicant);
db.SaveChanges();
}
return("Applicant Removed");
}
else
{
return("No application found");
}
}
}
else
{
return("Invalid Applicant");
}
}
public string RemoveUserRole(iMentorUserInfo user)
{
if (user != null)
{
using (iMAST_dbEntities db = new iMAST_dbEntities())
{
var u = db.iMentorUserRoles.Where(x => x.UserId == user.Id).FirstOrDefault();
if (u != null)
{
db.iMentorUserRoles.Remove(u);
db.SaveChanges();
return("User Role Removed");
}
else
{
return("No user role found");
}
}
}
else
{
return("Invalid User Role");
}
}
public string DeleteUser(iMentorUserInfo user)
{
string applicantResponse = applicantService.RemoveUserApplications(user);
string particpantResponse = participantService.RemoveUserAssignments(user);
string roleResponse = roleService.RemoveUserRole(user);
string iMentorUserResponse = iMentorUserService.DeleteUser(user);
return(applicantResponse + " " + particpantResponse + " " + roleResponse + " " + iMentorUserResponse);
}
public void GetTeachersTest()
{
ManageController controller = new ManageController();
var JSONTeachers = controller.GetTeachers();
string stringTeachers = JsonConvert.SerializeObject(JSONTeachers.Data);
List <iMentorUserInfo> ListTeachers = JsonConvert.DeserializeObject <List <iMentorUserInfo> >(stringTeachers);
//This should return the first teacher created "*****@*****.**"
iMentorUserInfo test1 = ListTeachers.First();
Assert.IsTrue(test1.UserName == "*****@*****.**" &&
test1.Email == "*****@*****.**" &&
test1.RoleId == 3);
}
public void GetStudentsTest()
{
ManageController controller = new ManageController();
var JSONStudents = controller.GetStudents();
string stringStudents = JsonConvert.SerializeObject(JSONStudents.Data);
List <iMentorUserInfo> ListStudents = JsonConvert.DeserializeObject <List <iMentorUserInfo> >(stringStudents);
//This should return the first student created "StudentOne"
iMentorUserInfo test1 = ListStudents.First();
Assert.IsTrue(test1.UserName == "StudentOne" &&
test1.Email == "*****@*****.**" &&
test1.RoleId == 1);
}
public void GetUserByIdTest()
{
ManageController controller = new ManageController();
var JSONUser = controller.GetUserById("5");
string stringUser = JsonConvert.SerializeObject(JSONUser.Data);
iMentorUserInfo test = JsonConvert.DeserializeObject <iMentorUserInfo>(stringUser);
iMentorUserInfo user = new iMentorUserInfo();
user.UserName = "******";
user.Email = "*****@*****.**";
Assert.IsTrue(test.UserName == user.UserName &&
test.Email == user.Email);
}
public List <iMentorUserInfo> GetUsersByListing(string data)
{
using (iMAST_dbEntities db = new iMAST_dbEntities())
{
var users = new List <iMentorUserInfo>();
if (data != null)
{
var userIds = new List <int>();
int id = Convert.ToInt32(data);
if (id > 0)
{
var listing = db.ListingModels.Where(x => x.Id == id).FirstOrDefault();
var assignments = db.AssignedListings.Where(x => x.ListingId == listing.Id).ToList();
foreach (AssignedListing assignment in assignments)
{
var user = db.iMentorUsers.Where(x => x.Id == assignment.UserId).FirstOrDefault();
var u = new iMentorUserInfo();
u.Id = user.Id;
u.UrlId = user.UrlId;
u.UserName = user.UserName;
u.FirstName = user.FirstName;
u.LastName = user.LastName;
u.Email = user.Email;
u.RoleId = u.GetRoleIdByUser(user);
u.Role = u.GetRoleName(user);
u.ShowOnlyAssignedListings = user.ShowOnlyAssignedListings;
u.IconIndex = user.IconIndex;
users.Add(u);
}
}
}
return(users);
}
}
public void GetUsersTest()
{
ManageController controller = new ManageController();
var JSONUsers = controller.GetUsers();
string stringUsers = JsonConvert.SerializeObject(JSONUsers.Data);
List <iMentorUserInfo> ListUsers = JsonConvert.DeserializeObject <List <iMentorUserInfo> >(stringUsers);
iMentorUserInfo test = ListUsers.First();
iMentorUserInfo user = new iMentorUserInfo();
user.UserName = "******";
user.Email = "*****@*****.**";
//Check that all users were returned by checking for a specific user
Assert.IsTrue(test.UserName == user.UserName &&
test.Email == user.Email);
}
public string UpdateUser(iMentorUserInfo user)
{
if (user != null)
{
UpdateAspUser(user);
using (iMAST_dbEntities db = new iMAST_dbEntities())
{
int no = Convert.ToInt32(user.Id);
var u = db.iMentorUsers.Where(x => x.Id == no).FirstOrDefault();
if (u != null)
{
u.Id = user.Id;
u.UrlId = user.UrlId;
u.UserName = user.UserName;
u.FirstName = user.FirstName;
u.LastName = user.LastName;
u.Email = user.Email;
u.ShowOnlyAssignedListings = user.ShowOnlyAssignedListings;
u.IconIndex = user.IconIndex;
var role = db.iMentorRoles.Where(x => x.RoleName.Equals(user.Role)).FirstOrDefault();
var userRole = db.iMentorUserRoles.Where(x => x.UserId == user.Id).FirstOrDefault();
userRole.RoleId = role.Id;
db.SaveChanges();
return("User Updated");
}
else
{
return("Invalid User");
}
}
}
else
{
return("Invalid User");
}
}
public string UpdateUser(iMentorUserInfo user)
{
return(iMentorUserService.UpdateUser(user));
}
