コード例 #1
0
        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";
            }
        }
コード例 #2
0
        public string DeleteUser(iMentorUserInfo user)
        {
            if (user != null)
            {
                using (iMAST_dbEntities db = new iMAST_dbEntities())
                {
                    var u = db.iMentorUsers.Where(x => x.Email.Equals(user.Email)).FirstOrDefault();

                    if (u != null)
                    {
                        db.iMentorUsers.Remove(u);
                        db.SaveChanges();

                        DeleteAspUser(user);

                        return "User Deleted";
                    }
                    else
                    {
                        return "Invalid User";
                    }

                }
            }
            else
            {
                return "Invalid User";
            }
        }
コード例 #3
0
        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";
            }
        }
コード例 #4
0
ファイル: RoleServiceMstr.cs プロジェクト: SCCapstone/imentor
        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";
            }
        }
コード例 #5
0
        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;
        }
コード例 #6
0
        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;
            }
        }
コード例 #7
0
        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";
            }
        }
コード例 #8
0
        public string UpdateAspUser(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)
                    {
                        aspUser.UserName = user.UserName;
                        aspUser.Email = user.Email;

                        db.SaveChanges();

                        return "Asp User Updated";
                    }
                    else
                    {
                        return "Invalid Asp User";
                    }

                }
            }
            else
            {
                return "Invalid Asp User";
            }
        }
コード例 #9
0
        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;
            }
        }
コード例 #10
0
        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;
        }
コード例 #11
0
        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);
        }
コード例 #12
0
        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);
        }
コード例 #13
0
        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);
        }
コード例 #14
0
 public string UpdateUser(iMentorUserInfo user)
 {
     return iMentorUserService.UpdateUser(user);
 }