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