Index: branches/Emisje/BazaReklam/OrderDetails.cs
===================================================================
--- branches/Emisje/BazaReklam/OrderDetails.cs (revision 778)
+++ branches/Emisje/BazaReklam/OrderDetails.cs (revision 779)
@@ -19,4 +19,6 @@
 
         private readonly List<Title> _titles = new List<Title>();
+        public readonly List<NavigationColumn> _dzialy = new List<NavigationColumn>();
+        public readonly List<NavigationSubColumn> _rozdzialy = new List<NavigationSubColumn>();
         //numery reklam dla nowych zamówieñ       
         readonly StringDictionary numeryReklam = new StringDictionary();
@@ -130,4 +132,10 @@
             TitleRepository titleRepository = new TitleRepository(ConnString.getConnString().Value);
             _titles = titleRepository.FindAllActive();
+
+            NavigationColumnRepository navigationColumnRepository = new NavigationColumnRepository(ConnString.getConnString().Value);
+            _dzialy = navigationColumnRepository.FindAll();
+
+            NavigationSubColumnRepository navigationSubColumnRepository = new NavigationSubColumnRepository(ConnString.getConnString().Value);
+            _rozdzialy = navigationSubColumnRepository.FindAll();
 
             AdLocationRepository adPlacementRepository = new AdLocationRepository(ConnString.getConnString().Value);
Index: branches/Emisje/BazaReklam/Classes/Repositories/NavigationColumnRepository.cs
===================================================================
--- branches/Emisje/BazaReklam/Classes/Repositories/NavigationColumnRepository.cs (revision 732)
+++ branches/Emisje/BazaReklam/Classes/Repositories/NavigationColumnRepository.cs (revision 779)
@@ -13,4 +13,42 @@
         {
             _connectionString = connectionString;
+        }
+
+        public override List<NavigationColumn> FindAll()
+        {
+            const string query = "SELECT Id, Name FROM dbo.Dzial ORDER BY SortOrder";
+
+            List<NavigationColumn> navigationColumns = new List<NavigationColumn>();
+
+            SqlConnection conn = null;
+            SqlCommand cmd = null;
+            SqlDataReader reader = null;
+            try
+            {
+                conn = new SqlConnection(_connectionString);
+                conn.Open();
+                cmd = new SqlCommand(query, conn);
+                reader = cmd.ExecuteReader();
+                if (reader != null)
+                {
+                    while (reader.Read())
+                        navigationColumns.Add(new NavigationColumn(reader.GetInt32(0), reader.GetString(1)));
+                }
+            }
+            finally
+            {
+                if (reader != null)
+                {
+                    reader.Close();
+                    reader.Dispose();
+                }
+                if (cmd != null) cmd.Dispose();
+                if (conn != null)
+                {
+                    conn.Close();
+                    conn.Dispose();
+                }
+            }
+            return navigationColumns;
         }
 
Index: branches/Emisje/BazaReklam/Classes/Repositories/NavigationSubColumnRepository.cs
===================================================================
--- branches/Emisje/BazaReklam/Classes/Repositories/NavigationSubColumnRepository.cs (revision 732)
+++ branches/Emisje/BazaReklam/Classes/Repositories/NavigationSubColumnRepository.cs (revision 779)
@@ -14,7 +14,49 @@
         }
 
+        public override List<NavigationSubColumn> FindAll()
+        {
+            const string query = "SELECT Id, Name FROM Rozdzial ORDER BY SortOrder";
+
+            List<NavigationSubColumn> navigationSubColumns = new List<NavigationSubColumn>();
+
+            SqlConnection conn = null;
+            SqlCommand cmd = null;
+            SqlDataReader reader = null;
+            try
+            {
+                conn = new SqlConnection(_connectionString);
+                conn.Open();
+                cmd = new SqlCommand(query, conn);
+                reader = cmd.ExecuteReader();
+                if (reader != null)
+                {
+                    while (reader.Read())
+                    {
+                        NavigationSubColumn navigationSubColumn = new NavigationSubColumn(reader.GetInt32(0), reader.GetString(1));
+                        navigationSubColumns.Add(navigationSubColumn);
+                    }
+                }
+            }
+            finally
+            {
+                if (reader != null)
+                {
+                    reader.Close();
+                    reader.Dispose();
+                }
+                if (cmd != null) cmd.Dispose();
+                if (conn != null)
+                {
+                    conn.Close();
+                    conn.Dispose();
+                }
+
+            }
+            return navigationSubColumns;
+        }
+
         public List<NavigationSubColumn> FindAllActiveByNavigationColumn(NavigationColumn navigationColumn)
         {
-            string query = "SELECT Id, Name FROM Rozdzial WHERE  Active=1 AND DzialId={0}";
+            string query = "SELECT Id, Name FROM Rozdzial WHERE Active=1 AND DzialId={0} ORDER BY SortOrder";
             query = string.Format(query, navigationColumn.Id);