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);
}
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));
}
}
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);
}