public EntityPrice GetPrice(int FK_BuildOfMaterialsID, int FK_ProductID) { var data = base.DataContext.Prices.Where(p => p.FK_BuildOfMaterialsID == FK_BuildOfMaterialsID && p.FK_ProductID == FK_ProductID); if (data.Count() == 1) { return(FactoryPrice.Get(data.Single())); } else { return(null); } }
public EntityPrice Get(int Id) { var data = base.DataContext.Prices.Where(p => p.PK_PriceID == Id); if (data.Count() == 1) { return(FactoryPrice.Get(data.Single())); } else { return(null); } }
public List <EntityPrice> GetAllPriceByModel(List <int> models) { this.DataContext.Database.CommandTimeout = 180; return(FactoryPrice.GetList(base.DataContext.Prices.Where(p => models.Contains(p.FK_ProductID.Value)).ToList())); }
public List <EntityPrice> GetAll() { var a = FactoryPrice.GetList(base.DataContext.Prices.ToList()); return(a); }
public List <EntityPrice> GetActives() { return(FactoryPrice.GetList(base.DataContext.Prices.Where(p => p.Status == true).ToList())); }