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