/// <summary>
/// Gets all vendor contact.
/// </summary>
/// <returns> All Vendor Contact</returns>
public List <VendorContact> GetAllVendorContact()
{
using (IllusionPurchasingDBEntities entites = new IllusionPurchasingDBEntities())
{
ObjectQuery <VendorContact> vendorContacts = entites.VendorContacts;
vendorContacts.MergeOption = MergeOption.NoTracking;
IQueryable <VendorContact> query = from contact in vendorContacts select contact;
List <VendorContact> result = query.ToList();
return(result);
}
}
/// <summary>
/// Gets all purchase order.
/// </summary>
/// <returns>All Purchase Order</returns>
public List <PurchaseOrder> GetAllPurchaseOrder()
{
using (IllusionPurchasingDBEntities entites = new IllusionPurchasingDBEntities())
{
ObjectQuery <PurchaseOrder> purchaseOrders = entites.PurchaseOrders;
purchaseOrders.MergeOption = MergeOption.NoTracking;
IQueryable <PurchaseOrder> query = from orders in purchaseOrders select orders;
List <PurchaseOrder> result = query.ToList();
return(result);
}
}
/// <summary>
/// Gets all product vendor.
/// </summary>
/// <returns>All Product Vendor</returns>
public List <ProductVendor> GetAllProductVendor()
{
using (IllusionPurchasingDBEntities entites = new IllusionPurchasingDBEntities())
{
ObjectQuery <ProductVendor> productvendors = entites.ProductVendors;
productvendors.MergeOption = MergeOption.NoTracking;
IQueryable <ProductVendor> query = from vendor in productvendors select vendor;
List <ProductVendor> result = query.ToList();
return(result);
}
}
