/// <summary> /// Gets all product inventory. /// </summary> /// <returns>Get All ProductInventory</returns> public List <ProductInventory> GetAllProductInventory() { using (IllusionManufacturingDBEntities entites = new IllusionManufacturingDBEntities()) { ObjectQuery <ProductInventory> productInventories = entites.ProductInventories; productInventories.MergeOption = MergeOption.NoTracking; IQueryable <ProductInventory> query = from inventory in productInventories select inventory; List <ProductInventory> result = query.ToList(); return(result); } }
/// <summary> /// Gets all work order. /// </summary> /// <returns>Get All WorkOrder</returns> public List <WorkOrder> GetAllWorkOrder() { using (IllusionManufacturingDBEntities entites = new IllusionManufacturingDBEntities()) { ObjectQuery <WorkOrder> workOrders = entites.WorkOrders; workOrders.MergeOption = MergeOption.NoTracking; IQueryable <WorkOrder> query = from orders in workOrders select orders; List <WorkOrder> result = query.ToList(); return(result); } }
/// <summary> /// Gets all bill of material. /// </summary> /// <returns>Get All BillOfMaterial</returns> public List <BillOfMaterial> GetAllBillOfMaterial() { using (IllusionManufacturingDBEntities entites = new IllusionManufacturingDBEntities()) { ObjectQuery <BillOfMaterial> billOfMaterials = entites.BillOfMaterials; billOfMaterials.MergeOption = MergeOption.NoTracking; IQueryable <BillOfMaterial> query = from bill in billOfMaterials select bill; List <BillOfMaterial> result = query.ToList(); return(result); } }