/// <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); } }