Exemplo n.º 1
0
        public static List <DTOUser> SuperUsers(string DefaultConnection)
        {
            List <DTOUser> response = new List <DTOUser>();

            var optionsBuilder = new DbContextOptionsBuilder <ADefHelpDeskContext>();

            optionsBuilder.UseSqlServer(DefaultConnection);

            using (var context = new ADefHelpDeskContext(optionsBuilder.Options))
            {
                // Get the SuperUsers
                var colUsers = (from user in context.AdefHelpDeskUsers
                                where user.IsSuperUser == true
                                select user);

                foreach (var item in colUsers)
                {
                    DTOUser objDTOUser = new DTOUser();

                    objDTOUser.userId      = item.UserId;
                    objDTOUser.userName    = item.Username;
                    objDTOUser.firstName   = item.FirstName;
                    objDTOUser.lastName    = item.LastName;
                    objDTOUser.email       = item.Email;
                    objDTOUser.isSuperUser = item.IsSuperUser;

                    response.Add(objDTOUser);
                }
            }

            return(response);
        }
Exemplo n.º 2
0
        public static DTOUser UserFromUserId(int paramUser, string DefaultConnection)
        {
            DTOUser response = new DTOUser();

            var optionsBuilder = new DbContextOptionsBuilder <ADefHelpDeskContext>();

            optionsBuilder.UseSqlServer(DefaultConnection);

            using (var context = new ADefHelpDeskContext(optionsBuilder.Options))
            {
                // Get the user
                var objUser = (from user in context.AdefHelpDeskUsers
                               where user.UserId == paramUser
                               select user).FirstOrDefault();

                if (objUser != null)
                {
                    response.userId      = objUser.UserId;
                    response.userName    = objUser.Username;
                    response.email       = objUser.Email;
                    response.firstName   = objUser.FirstName;
                    response.lastName    = objUser.LastName;
                    response.isSuperUser = objUser.IsSuperUser;
                    response.riapassword = objUser.Riapassword;
                }
            }

            return(response);
        }
Exemplo n.º 3
0
        public static List <DTOUser> UsersForRoleId(int paramRoleID, string DefaultConnection)
        {
            List <DTOUser> response = new List <DTOUser>();

            var optionsBuilder = new DbContextOptionsBuilder <ADefHelpDeskContext>();

            optionsBuilder.UseSqlServer(DefaultConnection);

            using (var context = new ADefHelpDeskContext(optionsBuilder.Options))
            {
                // Get Users for Role
                var colUsers = (from user in context.AdefHelpDeskUsers
                                from UserRoles in context.AdefHelpDeskUserRoles
                                where UserRoles.User == user
                                where UserRoles.RoleId == paramRoleID
                                select user);

                foreach (var item in colUsers)
                {
                    DTOUser objDTOUser = new DTOUser();

                    objDTOUser.userId      = item.UserId;
                    objDTOUser.userName    = item.Username;
                    objDTOUser.firstName   = item.FirstName;
                    objDTOUser.lastName    = item.LastName;
                    objDTOUser.email       = item.Email;
                    objDTOUser.isSuperUser = item.IsSuperUser;

                    response.Add(objDTOUser);
                }
            }

            return(response);
        }