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