public IEnumerable<DataSetAdventureWorks.SalesOrderDetailRow> GetOrderLines(int orderId)
{
var builder = new ConditionsBuilder();
builder.Add(string.Format("OrderId = {0}", orderId));
using (var adapter = new SqlDataAdapter(SelectOrderLineCommandText, Connection as SqlConnection))
{
adapter.SelectCommand.CommandText = string.Format("{0} {1}", SelectOrderLineCommandText, builder.Build());
OrderLines.Clear();
adapter.Fill(OrderLines);
}
return OrderLines;
}
public string BuildWhereClause(string selectCommandText)
{
ConditionsBuilder conditions = new ConditionsBuilder();
if (OrderId.HasValue)
{
conditions.Add(string.Format("OrderId = {0}", OrderId.Value));
}
if (MinCreatedAt.HasValue)
{
conditions.Add(string.Format("CreatedAt >= {0}", MinCreatedAt.Value));
}
if (MaxCreatedAt.HasValue)
{
conditions.Add(string.Format("CreatedAt <= {0}", MaxCreatedAt.Value));
}
if (Status.HasValue)
{
conditions.Add(string.Format("Status = {0}", Status.Value));
}
return string.Format("{0} {1}", selectCommandText, conditions.Build());
}
