AbleCommerce Shopping Cart Software

Code: Select all

        public IList<Product> GetNewProducts(bool useDays, int numberOfDays, string sortExpression = "LastModifiedDate DESC", int maximumRows = 0, int startRowIndex = 0)
        {
            DateTime date = new DateTime();
            if (useDays && numberOfDays > 0)
            {
                date = LocaleHelper.LocalNow.AddDays(-1 * numberOfDays);
            }

            ICriteria criteria = NHibernateHelper.CreateCriteria<Product>("P", maximumRows, startRowIndex, sortExpression)
                .Add(Restrictions.Eq("P.DisablePurchase", false))
                .Add(Restrictions.Eq("P.VisibilityId", (byte)CatalogVisibility.Public));

            if (useDays)
            {
                Disjunction firstCriteria = new Disjunction();
                firstCriteria.Add(Restrictions.Ge("P.CreatedDate", date))
                    .Add(Restrictions.Ge("P.LastModifiedDate", date));

                criteria.Add(firstCriteria);
            }

            // LIMIT PRODUCTS BY USER GROUP RESTRICTIONS            
            var user = AbleContext.Current.User;
            int[] groupIds = null;
            if (user != null) groupIds = (from ug in user.UserGroups select ug.GroupId).ToList<int>().ToArray();
            else groupIds = new int[0];
            if (!user.IsAdmin)
            {
                if (groupIds.Length > 0)
                {
                    Disjunction disjunction = new Disjunction();
                    DetachedCriteria secondCriteria = DetachedCriteria.For<ProductGroup>("PG")
                        .Add(Restrictions.EqProperty("PG.Product.Id", "P.Id"))
                        .Add(Restrictions.In("PG.Group.Id", groupIds))
                        .SetProjection(Projections.Property("PG.Group.Id"));

                    disjunction.Add(Restrictions.Eq("P.EnableGroups", false));
                    disjunction.Add(Subqueries.Exists(secondCriteria));
                    criteria.Add(disjunction);
                }
                else
                {
                    criteria.Add(Restrictions.Eq("P.EnableGroups", false));
                }
            }

            return criteria.List<Product>();
        }