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