public IList <Product> SearchByText(string text) { string query = string.Format( @"select p.id Id,p.price Price,pc.name classifier_name from Product p inner join Classifier pc on pc.id = p.classifier_id where exists(select ps.product_id from productonstore ps where ps.product_id = p.id and ps.amount > 1) and exists(select id from Classifier c where ( c.Name like '%{0}%' or (exists(select * from BarCode b where b.classifier_id=c.id and b.code = '{0}') ) ) and p.classifier_id = c.id)", text); return(DbORM.GetEntities <Product>(this.GetDbConnection(), query, (product, column, value) => { if ("classifier_name".Equals(column.ToLower())) { product.Classifier = product.Classifier ?? new Classifier() { Name = value as string }; } }, (typeDst, src) => typeDst.Equals(typeof(decimal)) && (src is long || src is int) ? ((long)src) / 10000m : src )); }
public override Classifier Find(int id) { return (DbORM.GetEntities <Classifier>(this.GetDbConnection(), string.Format(@"select * from Classifier where Id={0}", id) ).FirstOrDefault()); }
public decimal GetAmountOnStore(Product product) { return (DbORM.GetEntities <Product>( this.GetDbConnection(), string.Format(@"select sum(amount) Price from productonstore where product_id = {0}", product.Id) ) .Select <Product, decimal>(p => p.Price).FirstOrDefault()); }
public override Defectura Find(int id) { return (DbORM.GetEntities <Defectura>(_dbConnection).FirstOrDefault()); }
System.Collections.IEnumerator System.Collections.IEnumerable.GetEnumerator() { return(DbORM.GetEntities <T>(this.GetDbConnection()).AsEnumerable().GetEnumerator()); }
public IEnumerator <T> GetEnumerator() { return(DbORM.GetEntities <T>(this.GetDbConnection()).AsEnumerable().GetEnumerator()); }
public virtual T Find(int id) { return(DbORM.GetEntities <T>(this.GetDbConnection()).FirstOrDefault()); }
public override Sale Find(int id) { return (DbORM.GetEntities <Sale>(this.GetDbConnection()).FirstOrDefault()); }
public override Product Find(int id) { return (DbORM.GetEntities <Product>(this.GetDbConnection()).FirstOrDefault()); }
public override BarCode Find(int id) { return (DbORM.GetEntities <BarCode>(_dbConnection).FirstOrDefault()); }