public static EntityList <PurchaseOrder> GetPurchaseOrdersBySuppliers(int supplierID)
{
List <SqlParameter> parameters = new List <SqlParameter>();
parameters.Add(new SqlParameter("@supplier_id", supplierID));
string where = "where supplier_id = @supplier_id";
EntityList <PurchaseOrder> orders = PurchaseOrder.GetPurchaseOrders(where, parameters);
return(orders);
}
public static EntityList <PurchaseOrder> GetPurchaseOrdersByCustomerLocalCode(int customerID, string localCode)
{
List <SqlParameter> parameters = new List <SqlParameter>();
parameters.Add(new SqlParameter("@customer_id", customerID));
parameters.Add(new SqlParameter("@localCode", localCode));
string where = "where customer_id = @customer_id and local_code = @localCode";
EntityList <PurchaseOrder> orders = PurchaseOrder.GetPurchaseOrders(where, parameters);
return(orders);
}
