Beispiel #1
0
        public List <Role> SelectAllRoles(bool pSelectDeletedRoles)
        {
            string q = @"SELECT [Roles].[id], [code], [deleted], [description]
                               FROM [Roles] WHERE 1 = 1 ";

            if (!pSelectDeletedRoles)
            {
                q += " AND [deleted] = 0";
            }

            List <Role> Roles = new List <Role>();

            using (SqlConnection conn = GetConnection())
            {
                using (OpenCbsCommand c = new OpenCbsCommand(q, conn))
                {
                    using (OpenCbsReader r = c.ExecuteReader())
                    {
                        if (r != null)
                        {
                            if (!r.Empty)
                            {
                                while (r.Read())
                                {
                                    Roles.Add(GetRole(r));
                                }
                            }
                        }
                    }
                }
            }
            foreach (Role r in Roles)
            {
                r.SetMenuItems(GetAllowedMenuList(r.Id));
                r.SetActionItems(GetAllowedActionList(r.Id));
            }
            return(Roles);
        }