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