public static QueryBuilderServiceModel Select(this QueryBuilderServiceModel queryBuilderModel, IEnumerable <ISelectColumnTableModel> columnNamesWithAliasAndTable)
{
if (queryBuilderModel.SelectedColumns == null)
{
queryBuilderModel.SelectedColumns = new List <SelectBuilderModel>();
}
queryBuilderModel.SelectedColumns.AddRange(columnNamesWithAliasAndTable?.Select(s => new SelectBuilderModel(s)));
return(queryBuilderModel);
}
public static QueryBuilderServiceModel Select(this QueryBuilderServiceModel queryBuilderModel, IEnumerable <string> columnNames)
{
if (queryBuilderModel.SelectedColumns == null)
{
queryBuilderModel.SelectedColumns = new List <SelectBuilderModel>();
}
queryBuilderModel.SelectedColumns.AddRange(columnNames?.Select(s => new SelectBuilderModel(s, queryBuilderModel.FromTableName)));
return(queryBuilderModel);
}
public static QueryBuilderServiceModel Select(this QueryBuilderServiceModel queryBuilderModel, string columnName)
{
if (queryBuilderModel.SelectedColumns == null)
{
queryBuilderModel.SelectedColumns = new List <SelectBuilderModel>();
}
queryBuilderModel.SelectedColumns.Add(new SelectBuilderModel(columnName, queryBuilderModel.FromTableName));
return(queryBuilderModel);
}
public static QueryBuilderServiceModel Where(this QueryBuilderServiceModel queryBuilder, string sourceTableName, string sourceColumnName, ComparerOperator comparerOperator, object destinationValue, bool isNotComparision, ChainLogic outwardConditionLogic)
{
if (queryBuilder.WhereFilters == null)
{
queryBuilder.WhereFilters = new List <FilterBuilderModel>();
}
queryBuilder.WhereFilters.Add(new FilterBuilderModel
{
SourceTableName = sourceTableName,
SourceColumnName = sourceColumnName,
ComparerOperator = comparerOperator,
DestinationColumnValue = destinationValue,
OutwardConditionLogic = outwardConditionLogic,
IsNotComparision = isNotComparision,
IsComparedToDestinationValue = true
});
return(queryBuilder);
}
public static QueryBuilderServiceModel Where(this QueryBuilderServiceModel queryBuilder, string sourceTableName, string sourceColumnName, ComparerOperator comparerOperator, object destinationValue, bool isNotComparision)
{
return(Where(queryBuilder, sourceTableName, sourceColumnName, comparerOperator, destinationValue, isNotComparision, ChainLogic.AND));
}
public static QueryBuilderServiceModel Where(this QueryBuilderServiceModel queryBuilder, string sourceTableName, string sourceColumnName, ComparerOperator comparerOperator, object destinationValue)
{
return(Where(queryBuilder, sourceTableName, sourceColumnName, comparerOperator, destinationValue, false));
}
