/// <summary>
/// Get all the Employeeses by PostalCode.
/// </summary>
/// <param name="postalCode">PostalCode of the Employees</param>
/// <returns></returns>
public List <EmployeesView> GetAllByPostalCode(string postalCode)
{
return(ObjectViewDAO.Search(new SimpleCondition(EmployeesView.Properties.PostalCode, postalCode)));
}
/// <summary>
/// Get all the Employeeses of the ReportsToEmployee.
/// </summary>
/// <param name="reportsToEmployeeID">ID of ReportsToEmployee</param>
/// <returns></returns>
public List <EmployeesView> GetAllWithReportsToEmployee(int reportsToEmployeeID)
{
return(ObjectViewDAO.Search(new SimpleCondition(EmployeesView.Properties.ReportsTo, reportsToEmployeeID)));
}
public virtual List <TView> Search(Condition condition)
{
return(ObjectViewDAO.Search(condition));
}
/// <summary>
/// Get all the Employeeses by LastName.
/// </summary>
/// <param name="lastName">LastName of the Employees</param>
/// <returns></returns>
public List <EmployeesView> GetAllByLastName(string lastName)
{
return(ObjectViewDAO.Search(new SimpleCondition(EmployeesView.Properties.LastName, lastName)));
}
/// <summary>
/// Get all the Orderses by ShipPostalCode.
/// </summary>
/// <param name="shipPostalCode">ShipPostalCode of the Orders</param>
/// <returns></returns>
public List <OrdersView> GetAllByShipPostalCode(string shipPostalCode)
{
return(ObjectViewDAO.Search(new SimpleCondition(OrdersView.Properties.ShipPostalCode, shipPostalCode)));
}
/// <summary>
/// Get all the Orderses of the Employee.
/// </summary>
/// <param name="employeeID">ID of Employee</param>
/// <returns></returns>
public List <OrdersView> GetAllWithEmployee(int employeeID)
{
return(ObjectViewDAO.Search(new SimpleCondition(OrdersView.Properties.EmployeeID, employeeID)));
}
/// <summary>
/// Get all the Productses by ProductName.
/// </summary>
/// <param name="productName">ProductName of the Products</param>
/// <returns></returns>
public List <ProductsView> GetAllByProductName(string productName)
{
return(ObjectViewDAO.Search(new SimpleCondition(ProductsView.Properties.ProductName, productName)));
}
/// <summary>
/// Get all the Orderses by OrderDate.
/// </summary>
/// <param name="orderDate">OrderDate of the Orders</param>
/// <returns></returns>
public List <OrdersView> GetAllByOrderDate(DateTime orderDate)
{
return(ObjectViewDAO.Search(new SimpleCondition(OrdersView.Properties.OrderDate, orderDate)));
}
/// <summary>
/// Get all the Supplierses by CompanyName.
/// </summary>
/// <param name="companyName">CompanyName of the Suppliers</param>
/// <returns></returns>
public List <Suppliers> GetAllByCompanyName(string companyName)
{
return(ObjectViewDAO.Search(new SimpleCondition(Suppliers.Properties.CompanyName, companyName)));
}
/// <summary>
/// Get all the Supplierses by PostalCode.
/// </summary>
/// <param name="postalCode">PostalCode of the Suppliers</param>
/// <returns></returns>
public List <Suppliers> GetAllByPostalCode(string postalCode)
{
return(ObjectViewDAO.Search(new SimpleCondition(Suppliers.Properties.PostalCode, postalCode)));
}
/// <summary>
/// Get all the Customerses by Region.
/// </summary>
/// <param name="region">Region of the Customers</param>
/// <returns></returns>
public List <Customers> GetAllByRegion(string region)
{
return(ObjectViewDAO.Search(new SimpleCondition(Customers.Properties.Region, region)));
}
/// <summary>
/// Get all the Customerses by City.
/// </summary>
/// <param name="city">City of the Customers</param>
/// <returns></returns>
public List <Customers> GetAllByCity(string city)
{
return(ObjectViewDAO.Search(new SimpleCondition(Customers.Properties.City, city)));
}
/// <summary>
/// Get all the Territorieses of the Region.
/// </summary>
/// <param name="regionID">ID of Region</param>
/// <returns></returns>
public List <TerritoriesView> GetAllWithRegion(int regionID)
{
return(ObjectViewDAO.Search(new SimpleCondition(TerritoriesView.Properties.RegionID, regionID)));
}
/// <summary>
/// Get all the Categorieses by CategoryName.
/// </summary>
/// <param name="categoryName">CategoryName of the Categories</param>
/// <returns></returns>
public List <Categories> GetAllByCategoryName(string categoryName)
{
return(ObjectViewDAO.Search(new SimpleCondition(Categories.Properties.CategoryName, categoryName)));
}
/// <summary>
/// Get all the Productses of the Category.
/// </summary>
/// <param name="categoryID">ID of Category</param>
/// <returns></returns>
public List <ProductsView> GetAllWithCategory(int categoryID)
{
return(ObjectViewDAO.Search(new SimpleCondition(ProductsView.Properties.CategoryID, categoryID)));
}
/// <summary>
/// Get all the EmployeeTerritorieses of the Territory.
/// </summary>
/// <param name="territoryID">ID of Territory</param>
/// <returns></returns>
public List <EmployeeTerritoriesView> GetAllWithTerritory(string territoryID)
{
return(ObjectViewDAO.Search(new SimpleCondition(EmployeeTerritoriesView.Properties.TerritoryID, territoryID)));
}
/// <summary>
/// Get all the Productses of the Supplier.
/// </summary>
/// <param name="supplierID">ID of Supplier</param>
/// <returns></returns>
public List <ProductsView> GetAllWithSupplier(int supplierID)
{
return(ObjectViewDAO.Search(new SimpleCondition(ProductsView.Properties.SupplierID, supplierID)));
}
/// <summary>
/// Get all the Orderses by ShippedDate.
/// </summary>
/// <param name="shippedDate">ShippedDate of the Orders</param>
/// <returns></returns>
public List <OrdersView> GetAllByShippedDate(DateTime shippedDate)
{
return(ObjectViewDAO.Search(new SimpleCondition(OrdersView.Properties.ShippedDate, shippedDate)));
}
/// <summary>
/// Get all the OrderDetailses of the Order.
/// </summary>
/// <param name="orderID">ID of Order</param>
/// <returns></returns>
public List <OrderDetailsView> GetAllWithOrder(int orderID)
{
return(ObjectViewDAO.Search(new SimpleCondition(OrderDetailsView.Properties.OrderID, orderID)));
}
/// <summary>
/// Get all the Orderses of the Customer.
/// </summary>
/// <param name="customerID">ID of Customer</param>
/// <returns></returns>
public List <OrdersView> GetAllWithCustomer(string customerID)
{
return(ObjectViewDAO.Search(new SimpleCondition(OrdersView.Properties.CustomerID, customerID)));
}
/// <summary>
/// Get all the OrderDetailses of the Product.
/// </summary>
/// <param name="productID">ID of Product</param>
/// <returns></returns>
public List <OrderDetailsView> GetAllWithProduct(int productID)
{
return(ObjectViewDAO.Search(new SimpleCondition(OrderDetailsView.Properties.ProductID, productID)));
}
/// <summary>
/// Get all the Orderses of the Shipper.
/// </summary>
/// <param name="shipperID">ID of Shipper</param>
/// <returns></returns>
public List <OrdersView> GetAllWithShipper(int shipperID)
{
return(ObjectViewDAO.Search(new SimpleCondition(OrdersView.Properties.ShipVia, shipperID)));
}
/// <summary>
/// Get all the CustomerCustomerDemos of the CustomerDemographic.
/// </summary>
/// <param name="customerDemographicID">ID of CustomerDemographic</param>
/// <returns></returns>
public List <CustomerCustomerDemoView> GetAllWithCustomerDemographic(string customerDemographicID)
{
return(ObjectViewDAO.Search(new SimpleCondition(CustomerCustomerDemoView.Properties.CustomerTypeID, customerDemographicID)));
}