public IQueryable <Person> AutoComplete0CreateNewEmployeeFromContact([MinLength(2)] string name)
{
return(Container.Instances <Person>().Where(p => p.LastName.ToUpper().StartsWith(name.ToUpper())));
}
public IQueryable <SpecialOffer> AllSpecialOffers()
{
return(Container.Instances <SpecialOffer>().OrderByDescending(so => so.ModifiedDate));
}
public IQueryable <Shift> Shifts()
{
return(Container.Instances <Shift>());
}
public IQueryable <Location> AllLocations()
{
return(Container.Instances <Location>());
}
public IQueryable <Customer> AutoComplete0FindCustomer([MinLength(3)] string matching)
{
return(Container.Instances <Customer>().Where(c => c.AccountNumber.Contains(matching)));
}
public ShipMethod DefaultShipMethod()
{
return(Container.Instances <ShipMethod>().First());
}
public IQueryable <Product> AutoComplete0OpenPurchaseOrdersForProduct([MinLength(2)] string name)
{
return(Container.Instances <Product>().Where(product => product.Name.ToUpper().StartsWith(name.ToUpper())));
}
public IQueryable <PurchaseOrderHeader> AllOpenPurchaseOrders()
{
return(Container.Instances <PurchaseOrderHeader>().Where(poh => poh.Status <= 2));
}
public IList <CreditCard> ListCreditCards()
{
int id = this.BusinessEntityID;
return(Container.Instances <PersonCreditCard>().Where(pcc => pcc.PersonID == id).Select(pcc => pcc.CreditCard).ToList());
}
public IQueryable <CreditCard> RecentCreditCards()
{
int id = this.BusinessEntityID;
return(Container.Instances <PersonCreditCard>().Where(pcc => pcc.PersonID == id).Select(pcc => pcc.CreditCard).OrderByDescending(cc => cc.ModifiedDate));
}
public IQueryable <PurchaseOrderHeader> AllPurchaseOrders()
{
return(Container.Instances <PurchaseOrderHeader>().OrderByDescending(poh => poh.ModifiedDate));
}
public void PopulateUsingKeys(string[] keys)
{
int customerId = int.Parse(keys[0]);
Root = Container.Instances <Customer>().Single(c => c.CustomerId == customerId);
}
public IQueryable <SalesTaxRate> SalesTaxRates()
{
return(Container.Instances <SalesTaxRate>());
}
public IQueryable <SalesPerson> AutoComplete0ListAccountsForSalesPerson([MinLength(2)] string name)
{
return(Container.Instances <SalesPerson>().Where(sp => sp.EmployeeDetails.PersonDetails.LastName.ToUpper().StartsWith(name.ToUpper())));
}
public IQueryable <Department> ListAllDepartments()
{
return(Container.Instances <Department>());
}
public IQueryable <AddressType> AllAddressTypes()
{
return(Container.Instances <AddressType>());
}
public CurrencyRate FindRate(string currency, string currency1)
{
return(Container.Instances <CurrencyRate>().FirstOrDefault(cr => cr.Currency.Name == currency && cr.Currency1.Name == currency1));
}
public IList <BusinessEntityAddress> RecentAddressLinks()
{
return(Container.Instances <BusinessEntityAddress>().OrderByDescending(a => a.ModifiedDate).Take(10).ToList());
}
public IQueryable <Vendor> AutoComplete0ListPurchaseOrders([MinLength(2)] string name)
{
return(Container.Instances <Vendor>().Where(v => v.Name.ToUpper().StartsWith(name.ToUpper())));
}
public IQueryable <SpecialOffer> AutoComplete0AssociateSpecialOfferWithProduct([MinLength(2)] string name)
{
return(Container.Instances <SpecialOffer>().Where(specialOffer => specialOffer.Description.ToUpper().StartsWith(name.ToUpper())));
}
public virtual IQueryable <ProductModel> AutoCompleteProductModel(string match)
{
return(Container.Instances <ProductModel>().Where(pm => pm.Name.ToUpper().Contains(match.ToUpper())));
}
public IQueryable <Product> AutoComplete1AssociateSpecialOfferWithProduct([MinLength(2)] string name)
{
return(Container.Instances <Product>().Where(product => product.Name.ToUpper().StartsWith(name.ToUpper())));
}
public IQueryable <Product> AutoComplete0WorkOrders([MinLength(2)] string name)
{
return(Container.Instances <Product>().Where(p => p.Name.Contains(name)));
}
public IQueryable <Vendor> FindVendorByName(string name)
{
return(Container.Instances <Vendor>().Where(v => v.Name == name).OrderBy(v => v.Name));
}