Merged Urgent-Color-Space Branch.

1 files changed, 31 insertions, 0 deletions

diff --git a/Software/Visual_Studio/Tango.BL/Builders/CatalogsCollectionBuilder.cs b/Software/Visual_Studio/Tango.BL/Builders/CatalogsCollectionBuilder.cs
index fb690eb99..dd9e9a54c 100644
--- a/Software/Visual_Studio/Tango.BL/Builders/CatalogsCollectionBuilder.cs
+++ b/Software/Visual_Studio/Tango.BL/Builders/CatalogsCollectionBuilder.cs
@@ -37,5 +37,36 @@ namespace Tango.BL.Builders
                 }
             });
         }
+
+        public virtual CatalogsCollectionBuilder WithGroups()
+        {
+            return AddQueryStep(2, (query) =>
+            {
+                return query.Include(x => x.ColorCatalogsGroups);
+            });
+        }
+
+        public virtual CatalogsCollectionBuilder WithItems()
+        {
+            return AddQueryStep(3, (query) =>
+            {
+                return query.Include(x => x.ColorCatalogsGroups.Select(y => y.ColorCatalogsItems));
+            });
+        }
+
+        public virtual CatalogsCollectionBuilder WithRecipes(Rml rml = null)
+        {
+            return AddQueryStep(4, (query) =>
+            {
+                if (rml != null)
+                {
+                    return query.Include(x => x.ColorCatalogsGroups.Select(y => y.ColorCatalogsItems.Select(z => z.ColorCatalogsItemsRecipes.Where(r => r.RmlGuid == rml.Guid))));
+                }
+                else
+                {
+                    return query.Include(x => x.ColorCatalogsGroups.Select(y => y.ColorCatalogsItems.Select(z => z.ColorCatalogsItemsRecipes)));
+                }
+            });
+        }
     }
 }