public DataSet ExecuteQuerySearchSchema(string connectionString, IList <FilterCriteria> filter, DataSetSchema schema, int currentPage,
int pageSize, string orderByColumn, string orderDirection)
{
var query = BuildSqlQuery(filter, schema, orderByColumn, orderDirection, currentPage, pageSize);
return(SqlExtensions.ExecuteQuery(connectionString, query.Sql, query.Params));
}
public DataSet ExecuteQueryDatasetDetailId(string connectionString, DataSetSchemaDefinition dataSetSchemaDefinition, int datasetdetailId)
{
var sql = String.Format("SELECT {0} FROM {1} WHERE DatasetDetailId = @datasetDetailId",
dataSetSchemaDefinition.ColumnSelectList,
dataSetSchemaDefinition.TableName);
var parameters = new List <SqlParameter>
{
new SqlParameter
{
ParameterName = "@datasetDetailId",
SqlDbType = SqlDbType.Int,
Direction = ParameterDirection.Input,
Value = datasetdetailId
}
};
var data = SqlExtensions.ExecuteQuery(connectionString, sql, parameters.ToArray());
return(data);
}
public DataSet ExecuteQueryVisualiseSchema(VisualSchemaCriteria criteria)
{
var queryExecute = BuildVisualiseSqlQuery(criteria.Filters, criteria.Schema, criteria.ChartType, criteria.XAxisColumn, criteria.XAxisType, criteria.XAxisDateFormat, criteria.YAxisColumn, criteria.YAxisAggregate, criteria.PageNum, criteria.PageSize);
return(SqlExtensions.ExecuteQuery(criteria.DbConnectionString, queryExecute.Sql, queryExecute.Params));
}
public DataSet ExecuteQueryVisualiseSchemaMap(string connectionString, IEnumerable <FilterCriteria> filters, DataSetSchema schema)
{
var queryExecute = BuildVisualiseMapSqlQuery(filters, schema);
return(SqlExtensions.ExecuteQuery(connectionString, queryExecute.Sql, queryExecute.Params));
}
public DataSet ExecuteQuery(string connectionString, string sql, Array parameters)
{
return(SqlExtensions.ExecuteQuery(connectionString, sql, parameters));
}