public async Task <List <JObject> > Post([FromBody] object record)
{
try
{
JObject jobj = (JObject)record;
string procName = "GetTablesAndColumns";
var procParams = new Dictionary <string, string>();
procParams["@tableGuid"] = (string)jobj.SelectToken(Configurations.ProtectedPropertyTableName);
List <Column> columns = await _dal.GetData <Column>(procParams, procName, ConnectionSettings.ExploreConnString);
Query query = QueryHelpers.BuildQuery(jobj, columns);
Dictionary <string, string> colNameToPsedonym = columns.ToDictionary(x => x.ColumnName, x => x.Pseudonym);
List <JObject> records = await _dal.GetDataWithParameters(query, ConnectionSettings.ExploreConnString, jobj, colNameToPsedonym);
return(records);
}
catch (Exception ex)
{
//todo logging
throw;
}
}
public IEnumerable <T> Retrieve(int pageSize, int pageIndex, out int virtualCount, TCriteria criteria = null,
params Order <T>[] orderBy)
{
return(QueryHelpers <T> .Page(
QueryHelpers <T> .BuildQuery(_dbSet, _expressionBuilder(criteria), orderBy), pageSize, pageIndex,
out virtualCount));
}
public IEnumerable <T> Retrieve(TCriteria criteria = null, params Order <T>[] orderBy)
{
return(QueryHelpers <T> .BuildQuery(_dbSet, _expressionBuilder(criteria), orderBy));
}
public IEnumerable <T> RetrieveAll(params Order <T>[] @orderby)
{
return(QueryHelpers <T> .BuildQuery(_dbSet, orderby));
}
