private List <Member> SearchMembersByDetails(string firstName, string lastName, string city, bool recentTransactions)
{
using (var db = new TigerTreeFoodsContext())
{
List <Member> members = db.Members
.Where(m =>
(m.FirstName == firstName || firstName == null || firstName == String.Empty) &&
(m.LastName == lastName || lastName == null || lastName == String.Empty) &&
(m.City == city || city == null || city == String.Empty)
)
.OrderBy(m => m.LastName)
.ToList();
if (recentTransactions)
{
DateTime oneWeekAgo = DateTime.UtcNow.AddDays(-7);
members = members
.Where(m => m.Transactions
.Count(t => t.PurchaseDate > oneWeekAgo) > 0)
.ToList();
}
return(members);
}
}
private List <Member> SearchMembersByMembershipCode(string membershipCode)
{
using (var db = new TigerTreeFoodsContext())
{
IEnumerable <Member> membersByMembershipCode = db.Members.Where(m => m.MembershipCode == membershipCode);
return(membersByMembershipCode.ToList());
}
}
public List <Product> SearchProducts(string barcode, string category, string description)
{
using (var db = new TigerTreeFoodsContext())
{
if (!String.IsNullOrWhiteSpace(barcode))
{
return(db.Products.Where(p => p.Barcode == barcode).ToList());
}
if (!String.IsNullOrWhiteSpace(category))
{
return(db.Products.Where(p => p.Category == category).ToList());
}
if (!String.IsNullOrWhiteSpace(description))
{
return(db.Products.Where(p => p.TillDescription.Contains(description)).Take(10).ToList());
}
return(new List <Product>());
}
}
