public PageOfList <PersonDocument> SearchPersonDocuments(int pageNumber, int numRecordsInPage, string sort, SortDirection sortDirection, PersonDocument searchCriteria)
{
// Note the Document Unit of Work will be disposed when out of scope (does not require using statement)
var unitOfWork = new FootlooseFSDocUnitOfWork();
// Search, sort, and page the results
return(unitOfWork.Persons.Search(pageNumber, numRecordsInPage, searchCriteria, sort, sortDirection));
}
static void Main(string[] args)
{
FootlooseFSDocUnitOfWork.Init();
int startRow = 0;
// Remove all record from the Person document
var docUnitOfWork = new FootlooseFSDocUnitOfWork();
docUnitOfWork.Persons.DeleteAll();
while (true)
{
using (var sqlUnitOfWork = new FootlooseFSSqlUnitOfWork())
{
IQueryable <Person> personQueryable = sqlUnitOfWork.Persons.GetQueryable();
// For each person retreived from SQL include the related phones and addresses
personQueryable = personQueryable.Include("Addresses.Address").Include("Phones");
// Always order by person ID so that we can guarantee the order for the persons retrieved from SQL
personQueryable = personQueryable.OrderBy(p => p.PersonID);
// Get throttleRate number of persons from SQL
List <Person> persons = personQueryable.Skip(startRow)
.Take(throttleRate)
.ToList();
IEnumerable <PersonDocument> personDocuments = from p in persons
select new PersonDocument
{
PersonID = p.PersonID,
FirstName = p.FirstName,
LastName = p.LastName,
EmailAddress = p.EmailAddress,
PhoneNumber = p.Phones.First(h => h.PhoneTypeID == 1).Number,
StreetAddress = p.Addresses.First(pa => pa.AddressTypeID == 1).Address.StreetAddress,
City = p.Addresses.First(pa => pa.AddressTypeID == 1).Address.City,
State = p.Addresses.First(pa => pa.AddressTypeID == 1).Address.State,
Zip = p.Addresses.First(pa => pa.AddressTypeID == 1).Address.Zip
};
docUnitOfWork.Persons.AddBatch(personDocuments);
Console.WriteLine(string.Format("Complete {0} - {1}", startRow, startRow + throttleRate));
// If the number of persons retrieved is less than throttleRate then we are finished
if (personDocuments.Count() < throttleRate)
{
break;
}
}
// Otherwise move the starting row by throttleRate number of persons
startRow += throttleRate;
}
}
protected void Application_Start()
{
AreaRegistration.RegisterAllAreas();
FilterConfig.RegisterGlobalFilters(GlobalFilters.Filters);
RouteConfig.RegisterRoutes(RouteTable.Routes);
BundleConfig.RegisterBundles(BundleTable.Bundles);
FootlooseFSDocUnitOfWork.Init();
}
public PageOfList <PersonDocument> SearchPersonDocuments(int pageNumber, PersonSearchColumn personSearchColumn, SortDirection sortDirection, int numRecordsInPage, Dictionary <PersonSearchColumn, string> searchCriteria)
{
// Search for persons using the Document DB repository
// Determine the starting row
int startRow;
int totalItemCount = 0;
if (numRecordsInPage == -1)
{
startRow = 0;
}
else
{
startRow = (pageNumber - 1) * numRecordsInPage;
}
PageOfList <PersonDocument> searchResults = null;
var unitOfWork = new FootlooseFSDocUnitOfWork();
IQueryable <PersonDocument> personsQueryable = unitOfWork.Persons.GetQueryable();
foreach (KeyValuePair <PersonSearchColumn, string> entry in searchCriteria)
{
if (entry.Key == PersonSearchColumn.PersonID)
{
var personID = Int32.Parse(entry.Value);
personsQueryable = personsQueryable.Where(p => p.PersonID == personID);
}
var searchValue = entry.Value.ToLower();
if (entry.Key == PersonSearchColumn.FirstName)
{
personsQueryable = personsQueryable.Where(p => p.FirstName.ToLower().StartsWith(searchValue));
}
if (entry.Key == PersonSearchColumn.LastName)
{
personsQueryable = personsQueryable.Where(p => p.LastName.ToLower().StartsWith(searchValue));
}
if (entry.Key == PersonSearchColumn.EmailAddress)
{
personsQueryable = personsQueryable.Where(p => p.EmailAddress.ToLower().StartsWith(searchValue));
}
if (entry.Key == PersonSearchColumn.Phone)
{
personsQueryable = personsQueryable.Where(p => p.PhoneNumber.ToLower().StartsWith(searchValue));
}
if (entry.Key == PersonSearchColumn.City)
{
personsQueryable = personsQueryable.Where(p => p.City.ToLower().StartsWith(searchValue));
}
if (entry.Key == PersonSearchColumn.State)
{
personsQueryable = personsQueryable.Where(p => p.State.ToLower().StartsWith(searchValue));
}
if (entry.Key == PersonSearchColumn.StreetAddress)
{
personsQueryable = personsQueryable.Where(p => p.StreetAddress.ToLower().StartsWith(searchValue));
}
if (entry.Key == PersonSearchColumn.Zip)
{
personsQueryable = personsQueryable.Where(p => p.Zip.ToLower().StartsWith(searchValue));
}
}
IOrderedQueryable <PersonDocument> personOrderedQueryable = null;
// Apply the sorting using the requested sort column and direction
if (sortDirection == SortDirection.Ascending)
{
if (personSearchColumn == PersonSearchColumn.PersonID)
{
personOrderedQueryable = personsQueryable.OrderBy(p => p.PersonID);
}
else if (personSearchColumn == PersonSearchColumn.FirstName)
{
personOrderedQueryable = personsQueryable.OrderBy(p => p.FirstName);
}
else if (personSearchColumn == PersonSearchColumn.LastName)
{
personOrderedQueryable = personsQueryable.OrderBy(p => p.LastName);
}
else if (personSearchColumn == PersonSearchColumn.EmailAddress)
{
personOrderedQueryable = personsQueryable.OrderBy(p => p.EmailAddress);
}
else if (personSearchColumn == PersonSearchColumn.Phone)
{
personOrderedQueryable = personsQueryable.OrderBy(p => p.PhoneNumber);
}
else if (personSearchColumn == PersonSearchColumn.City)
{
personOrderedQueryable = personsQueryable.OrderBy(p => p.City);
}
else if (personSearchColumn == PersonSearchColumn.State)
{
personOrderedQueryable = personsQueryable.OrderBy(p => p.State);
}
else if (personSearchColumn == PersonSearchColumn.StreetAddress)
{
personOrderedQueryable = personsQueryable.OrderBy(p => p.StreetAddress);
}
else if (personSearchColumn == PersonSearchColumn.Zip)
{
personOrderedQueryable = personsQueryable.OrderBy(p => p.Zip);
}
}
else
{
if (personSearchColumn == PersonSearchColumn.PersonID)
{
personOrderedQueryable = personsQueryable.OrderByDescending(p => p.PersonID);
}
else if (personSearchColumn == PersonSearchColumn.FirstName)
{
personOrderedQueryable = personsQueryable.OrderByDescending(p => p.FirstName);
}
else if (personSearchColumn == PersonSearchColumn.LastName)
{
personOrderedQueryable = personsQueryable.OrderByDescending(p => p.LastName);
}
else if (personSearchColumn == PersonSearchColumn.EmailAddress)
{
personOrderedQueryable = personsQueryable.OrderByDescending(p => p.EmailAddress);
}
else if (personSearchColumn == PersonSearchColumn.Phone)
{
personOrderedQueryable = personsQueryable.OrderByDescending(p => p.PhoneNumber);
}
else if (personSearchColumn == PersonSearchColumn.City)
{
personOrderedQueryable = personsQueryable.OrderByDescending(p => p.City);
}
else if (personSearchColumn == PersonSearchColumn.State)
{
personOrderedQueryable = personsQueryable.OrderByDescending(p => p.State);
}
else if (personSearchColumn == PersonSearchColumn.StreetAddress)
{
personOrderedQueryable = personsQueryable.OrderByDescending(p => p.StreetAddress);
}
else if (personSearchColumn == PersonSearchColumn.Zip)
{
personOrderedQueryable = personsQueryable.OrderByDescending(p => p.Zip);
}
}
// Get the number of records
int recordCount = personOrderedQueryable.Count();
// Apply the paging
List <PersonDocument> persons;
if (numRecordsInPage != -1)
{
persons = personOrderedQueryable.Skip(startRow)
.Take(numRecordsInPage)
.ToList();
}
else
{
persons = personOrderedQueryable.ToList();
}
return(new PageOfList <PersonDocument>(persons, pageNumber, numRecordsInPage, recordCount));
}
