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