public string GetVisaEntity(Guid sysAdminUnitId, Guid visaId)
{
var helper = GetVisaHelper(sysAdminUnitId);
SelectQueryResponse result = helper.GetEntity(visaId);
return(ServiceStackTextHelper.Serialize(result));
}
public string GetVisaEntities(Guid sysAdminUnitId, RequestOptions requestOptions)
{
var helper = GetVisaHelper(sysAdminUnitId);
SelectQueryResponse result = helper.GetEntities(requestOptions);
return(ServiceStackTextHelper.Serialize(result));
}
private SelectQueryResponse GetVisaData(Select entitiesSelect)
{
Dictionary <string, string> serverToClientColumnNameMap = GetColumnNameMap(entitiesSelect);
var collection = new EntityCollection(_userConnection, _baseVisaSchema);
using (DBExecutor dbExecutor = _userConnection.EnsureDBConnection()) {
using (IDataReader dataReader = entitiesSelect.ExecuteReader(dbExecutor)) {
collection.Load(dataReader);
}
}
var convertedEntities = QueryExtension.GetEntityCollection(collection, serverToClientColumnNameMap);
Dictionary <string, object> config = QueryExtension.GetColumnConfig(_baseVisaESQ, serverToClientColumnNameMap);
SelectQueryResponse response = new SelectQueryResponse {
Rows = convertedEntities,
RowsAffected = convertedEntities.Count,
RowConfig = config
};
return(response);
}
public SelectQueryResponse GetEntities(RequestOptions requestOptions)
{
Select selectFromProviders = GetSelectFromProviders();
if (selectFromProviders == null)
{
return(new SelectQueryResponse {
Rows = null,
RowsAffected = 0,
RowConfig = null
});
}
Select entitiesSelect = WrapSelect(selectFromProviders);
ApplyOptions(ref entitiesSelect, requestOptions);
Dictionary <string, string> serverToClientColumnNameMap = GetColumnNameMap(entitiesSelect);
CoreEntitySchema baseVisaSchema = GetExtendedBaseVisaEntitySchema();
EntitySchemaQuery baseVisaESQ = GetExtendedBaseVisaESQ(baseVisaSchema);
Terrasoft.Core.Entities.EntityCollection collection =
new Terrasoft.Core.Entities.EntityCollection(_userConnection, baseVisaSchema);
using (DBExecutor dbExecutor = _userConnection.EnsureDBConnection()) {
using (IDataReader dataReader = entitiesSelect.ExecuteReader(dbExecutor)) {
collection.Load(dataReader);
}
}
var convertedEntities = QueryExtension.GetEntityCollection(collection, serverToClientColumnNameMap);
Dictionary <string, object> config = QueryExtension.GetColumnConfig(baseVisaESQ, serverToClientColumnNameMap);
SelectQueryResponse response = new SelectQueryResponse {
Rows = convertedEntities,
RowsAffected = convertedEntities.Count,
RowConfig = config
};
return(response);
}
