private void CreateClauses(List <Tuple <string, List <SqlParameter> > > whereClauses, HashSet <string> innerJoins, List <IOrderByClause> orderByClauses, List <IEntitySearch <Car> > search, List <IEntityOrderBy <Car> > order)
{
if (search != null)
{
foreach (var item in search)
{
var res = WhereFactory.CreateWhereClause(item);
var join = res.GenerateJoin();
if (!string.IsNullOrEmpty(join))
{
innerJoins.Add(join);
}
whereClauses.Add(res.GenerateWhereClause());
}
}
if (order != null)
{
foreach (var item in order)
{
var res = OrderByFactory.CreateOrderByClause(item);
var join = res.GenerateInnerJoin();
orderByClauses.Add(res);
if (!string.IsNullOrEmpty(join))
{
innerJoins.Add(join);
}
}
}
}
private void ApplyWhere(StringBuilder builder, List <IEntitySearch <T> > search, SqlCommand command, List <IEntityOrderBy <T> > order)
{
var whereClauses = new List <Tuple <string, List <SqlParameter> > >();
var innerJoins = new HashSet <string>();
if (search != null)
{
foreach (var item in search)
{
var res = WhereFactory.CreateWhereClause(item);
var join = res.GenerateJoin();
innerJoins.Add(join);
whereClauses.Add(res.GenerateWhereClause());
}
}
if (order != null)
{
foreach (var item in order)
{
var res = OrderByFactory.CreateOrderByClause(item);
var join = res.GenerateInnerJoin();
innerJoins.Add(join);
}
}
foreach (var item in innerJoins)
{
builder.Append(item);
}
if (whereClauses.Count > 0)
{
builder.Append(" WHERE ");
for (int i = 0; i < whereClauses.Count; i++)
{
builder.Append(whereClauses[i].Item1);
command.Parameters.AddRange(whereClauses[i].Item2.ToArray());
if (i < whereClauses.Count - 1)
{
builder.Append(" AND ");
}
}
}
}