public EntitySparePart GetByRefManID(int OrderID, string RefManID, string Estatus)
        {
            var data = base.DataContext.SpareParts.Where(p => p.FK_OrderID == OrderID && p.RefManID == RefManID && p.SparePartStatus == Estatus);

            if (data.Count() == 1)
            {
                return(FactorySparePart.Get(data.Single()));
            }
            else
            {
                return(null);
            }
        }
        public EntitySparePart Get(int Id)
        {
            var data = base.DataContext.SpareParts.Where(p => p.PK_SparePartsID == Id);

            if (data.Count() == 1)
            {
                return(FactorySparePart.Get(data.Single()));
            }
            else
            {
                return(null);
            }
        }
 public List <EntitySparePart> GetAllByOrderID(int OrderID)
 {
     return(FactorySparePart.GetList(base.DataContext.SpareParts.Where(p => p.FK_OrderID == OrderID).ToList()));
 }
 public List <EntitySparePart> GetAll()
 {
     return(FactorySparePart.GetList(base.DataContext.SpareParts.ToList()));
 }
 public List <EntitySparePart> GetActives()
 {
     return(FactorySparePart.GetList(base.DataContext.SpareParts.Where(p => p.Status == true).ToList()));
 }
 public List <EntitySparePart> GetByOrder(string OrderID)
 {
     return(FactorySparePart.GetList(base.DataContext.SpareParts.Where(p => p.Orders.OrderID == OrderID).OrderBy(p => p.CreateDate).ToList()));
 }
 public List <EntitySparePart> Get(int OrderID, string SparePartsID)
 {
     return(FactorySparePart.GetList(base.DataContext.SpareParts.Where(p => p.FK_OrderID == OrderID && p.BuildOfMaterials.SparePartsID == SparePartsID).ToList()));
 }
 public List <EntitySparePart> GetListByRefManID(int OrderID, string RefManID)
 {
     return(FactorySparePart.GetList(base.DataContext.SpareParts.Where(p => p.FK_OrderID == OrderID && p.RefManID == RefManID).ToList()));
 }