Exemple #1
0
        public IDocumentQuery <Package> CreateCurrentInventoryQuery(IDocumentSession session,
                                                                    string communityCode,
                                                                    string sortBy,
                                                                    bool sortDescending,
                                                                    bool viewIsDeleted,
                                                                    DefconFilter defconFilter,
                                                                    string unitResidentFilter,
                                                                    int?take)
        {
            IDocumentQuery <Package> query = session.Advanced.LuceneQuery <Package>("Package/CurrentInventory").Take(take.Value);

            query.WhereEquals("CommunityCode", communityCode);
            query.AndAlso().Not.WhereEquals("Status", PackageStatusCodes.Released);

            if (!viewIsDeleted)
            {
                query.AndAlso();
                query.WhereEquals("IsDeleted", false);
            }

            DefConFilterQuery(query, defconFilter);

            if (!string.IsNullOrEmpty(unitResidentFilter))
            {
                query.AndAlso();
                query.WhereEquals("AddressName", unitResidentFilter);
            }

            if (!string.IsNullOrEmpty((sortBy)))
            {
                query.AddOrder(sortBy, sortDescending);
            }
            return(query);
        }
Exemple #2
0
        private static void DefConFilterQuery <T>(IDocumentQuery <T> query, DefconFilter defconFilter)
        {
            if (defconFilter == null || (defconFilter.Start == null && defconFilter.End == null))
            {
                return;
            }

            DateTime?startDate = null;
            DateTime?endDate   = null;

            if (defconFilter.Start.HasValue)
            {
                startDate = DateTime.Today.Date.AddDays(-(defconFilter.Start.Value));
            }

            if (defconFilter.End.HasValue)
            {
                endDate = DateTime.Today.Date.AddDays(-(defconFilter.End.Value));
            }

            query.AndAlso();
            if (startDate.HasValue && endDate.HasValue)
            {
                query.WhereBetweenOrEqual("ReceiveDate", startDate.Value, endDate.Value.AddDays(1));
            }
            else if (!startDate.HasValue)
            {
                query.WhereLessThanOrEqual("ReceiveDate", endDate.Value.AddDays(1));
            }
        }
Exemple #3
0
        public List <PackageWithCustomers> GetPackageInventory(
            string communityCode,
            string sortBy,
            bool sortDescending,
            bool viewIsDeleted,
            DefconFilter defconFilter,
            string unitResidentFilter,
            int?take)
        {
            IDocumentSession currentSession = GetCurrentDocumentSession();
            var query = CreateCurrentInventoryQuery(currentSession, communityCode, sortBy, sortDescending, viewIsDeleted,
                                                    defconFilter, unitResidentFilter, take);

            query.Include("CustomerIds");

            var packages = query.ToList();

            var results = new List <PackageWithCustomers>();

            foreach (Package package in packages)
            {
                var packageWithCustomers = new PackageWithCustomers
                {
                    Package = package, Customers = new List <Customer>()
                };

                //Note:have to loop each customerId. If we load them as a list then that causes a hit to the server :(
                foreach (string customerId in package.CustomerIds)
                {
                    packageWithCustomers.Customers.Add(currentSession.Load <Customer>(customerId));
                }

                results.Add(packageWithCustomers);
            }
            return(results);
        }