public IList <Food> GetFoods(FoodCriteria criteria) { IList <BreederStationDataLayer.Orm.Dto.Food> dtoFoods = foodGateway.Select(new BreederStationDataLayer.Orm.SelectCriteria.FoodCriteria { MinimumCarbohydrates = criteria.MinimumCarbohydrates, MinimumFat = criteria.MinimumFat, MinimunProteins = criteria.MinimunProteins }); IList <Food> foods = new List <Food>(); foreach (BreederStationDataLayer.Orm.Dto.Food dtoFood in dtoFoods) { foods.Add(mapDtoToDomainObject(dtoFood)); } return(foods); }
public IList <Food> Select(FoodCriteria criteria) { db.Connect(); DbCommand command = db.CreateCommand(GetSelectSql()); ApplyCriteria(command, criteria); DbDataReader reader = db.Select(command); IList <Food> foods = Read(reader); reader.Close(); db.Close(); return(foods); }
protected override void ApplyCriteria(DbCommand command, FoodCriteria criteria) { SqlCommand sqlCommand = (SqlCommand)command; if (criteria.MinimunProteins != null) { sqlCommand.CommandText += " WHERE PROTEINS>=@c_proteins"; sqlCommand.Parameters.Add("@c_proteins", SqlDbType.Int).Value = criteria.MinimunProteins; } if (criteria.MinimumFat != null) { sqlCommand.CommandText += " AND FAT>=@c_fat"; sqlCommand.Parameters.Add("c_fat", SqlDbType.Int).Value = criteria.MinimumFat; } if (criteria.MinimumCarbohydrates != null) { sqlCommand.CommandText += " AND CARBOHYDRATES>=@c_carbohydrates"; sqlCommand.Parameters.Add("c_carbohydrates", SqlDbType.Int).Value = criteria.MinimumCarbohydrates; } }
protected override void ApplyCriteria(DbCommand command, FoodCriteria criteria) { OracleCommand oracleCommand = (OracleCommand)command; oracleCommand.BindByName = true; if (criteria.MinimunProteins != null) { oracleCommand.CommandText += " WHERE PROTEINS>=:c_proteins"; oracleCommand.Parameters.Add("c_proteins", OracleDbType.Int32).Value = criteria.MinimunProteins; } if (criteria.MinimumFat != null) { oracleCommand.CommandText += " AND FAT>=:c_fat"; oracleCommand.Parameters.Add("c_fat", OracleDbType.Int32).Value = criteria.MinimumFat; } if (criteria.MinimumCarbohydrates != null) { oracleCommand.CommandText += " AND CARBOHYDRATES>=:c_carbohydrates"; oracleCommand.Parameters.Add("c_carbohydrates", OracleDbType.Int32).Value = criteria.MinimumCarbohydrates; } }
protected abstract void ApplyCriteria(DbCommand command, FoodCriteria criteria);