public PurchaseOrderHeader CreateNewPurchaseOrder(Vendor vendor)
{
var _PurchaseOrderHeader = NewTransientInstance<PurchaseOrderHeader>();
_PurchaseOrderHeader.Vendor = vendor;
//MakePersistent(_PurchaseOrderHeader);
return _PurchaseOrderHeader;
}
public IQueryable<PurchaseOrderHeader> ListPurchaseOrders(Vendor vendor, DateTime? fromDate, DateTime? toDate)
{
IQueryable<PurchaseOrderHeader> query = from obj in Instances<PurchaseOrderHeader>()
where obj.Vendor.VendorID == vendor.VendorID &&
(fromDate == null || obj.OrderDate >= fromDate) &&
(toDate == null || obj.OrderDate <= toDate)
orderby obj.OrderDate
select obj;
return query;
}
public IQueryable<PurchaseOrderHeader> OpenPurchaseOrdersForVendor(Vendor vendor)
{
return from obj in Instances<PurchaseOrderHeader>()
where obj.Vendor.VendorID == vendor.VendorID && obj.Status <= 2
select obj;
}
public string ValidateListPurchaseOrders(Vendor vendor, DateTime? fromDate, DateTime? toDate)
{
return toDate.IsAtLeastOneDayBefore(fromDate) ? "To Date cannot be before From Date" : null;
}
public static (Person, IContext) CreateNewContact(this Vendor vendor, IContext context) =>
// for autoautocomplete testing
public IQueryable<PurchaseOrderHeader> OpenPurchaseOrdersForVendorAndProduct(Vendor vendor, Product product)
{
return from obj in Instances<PurchaseOrderDetail>()
where obj.Product.ProductID == product.ProductID &&
obj.PurchaseOrderHeader.Status <= 2 &&
obj.PurchaseOrderHeader.Vendor.BusinessEntityID == vendor.BusinessEntityID
select obj.PurchaseOrderHeader;
}
public static List <Product> ShowAllProducts(this Vendor vendor)
{
return(vendor.Products.Select(vp => vp.Product).ToList());
}
public IQueryable <PurchaseOrderHeader> OpenPurchaseOrdersForVendor([ContributedAction("Purchase Orders")] Vendor vendor)
{
return(from obj in Instances <PurchaseOrderHeader>()
where obj.Vendor.VendorID == vendor.VendorID && obj.Status <= 2
select obj);
}
/// <summary>
/// Create a new Vendor object.
/// </summary>
/// <param name="vendorID">Initial value of the VendorID property.</param>
/// <param name="accountNumber">Initial value of the AccountNumber property.</param>
/// <param name="name">Initial value of the Name property.</param>
/// <param name="creditRating">Initial value of the CreditRating property.</param>
/// <param name="preferredVendorStatus">Initial value of the PreferredVendorStatus property.</param>
/// <param name="activeFlag">Initial value of the ActiveFlag property.</param>
/// <param name="modifiedDate">Initial value of the ModifiedDate property.</param>
public static Vendor CreateVendor(global::System.Int32 vendorID, global::System.String accountNumber, global::System.String name, global::System.Byte creditRating, global::System.Boolean preferredVendorStatus, global::System.Boolean activeFlag, global::System.DateTime modifiedDate)
{
Vendor vendor = new Vendor();
vendor.VendorID = vendorID;
vendor.AccountNumber = accountNumber;
vendor.Name = name;
vendor.CreditRating = creditRating;
vendor.PreferredVendorStatus = preferredVendorStatus;
vendor.ActiveFlag = activeFlag;
vendor.ModifiedDate = modifiedDate;
return vendor;
}
/// <summary>
/// Deprecated Method for adding a new object to the Vendors EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead.
/// </summary>
public void AddToVendors(Vendor vendor)
{
base.AddObject("Vendors", vendor);
}
// for autoautocomplete testing
public IQueryable <PurchaseOrderHeader> OpenPurchaseOrdersForVendorAndProduct(Vendor vendor, Product product)
{
return(from obj in Instances <PurchaseOrderDetail>()
where obj.Product.ProductID == product.ProductID &&
obj.PurchaseOrderHeader.Status <= 2 &&
obj.PurchaseOrderHeader.Vendor.VendorID == vendor.VendorID
select obj.PurchaseOrderHeader);
}
