public QvDataContractResponse getFields(IQlikConnector driver, string database, string table, Dictionary <string, string> userParameters) { QvxLog.Log(QvxLogFacility.Application, QvxLogSeverity.Debug, "+ getFields()"); QvDataContractResponse retVal; try { Database db = driver.getDatabases(userParameters).Find(x => x.qName == database); QvxTable tb = driver.getTables(db, userParameters).Find(x => x.TableName == table); retVal = new QvDataContractFieldListResponse { qFields = driver.getFields(db, tb, userParameters).ToArray() }; } catch (Exception e) { QvxLog.Log(QvxLogFacility.Application, QvxLogSeverity.Error, "getFields() : " + e.Message); throw e; } QvxLog.Log(QvxLogFacility.Application, QvxLogSeverity.Debug, "- getFields()"); return(retVal); }
public QvDataContractResponse getPreview(IQlikConnector driver, string database, string table, Dictionary <string, string> userParameters) { QvxLog.Log(QvxLogFacility.Application, QvxLogSeverity.Debug, "+ getPreview()"); QvDataContractPreviewResponse retVal; try { Database db = driver.getDatabases(userParameters).Find(x => x.qName == database); QvxTable tb = driver.getTables(db, userParameters).Find(x => x.TableName == table); retVal = new QvDataContractPreviewResponse() { qPreview = new List <MyQvxDataRow>() { new MyQvxDataRow() { qValues = driver.getFields(db, tb, userParameters).Select(a => a.FieldName).ToList() } } }; retVal.qPreview.AddRange( driver.getPreview(db, tb, userParameters).Select( a => new MyQvxDataRow() { qValues = a } ).ToList() ); } catch (Exception e) { QvxLog.Log(QvxLogFacility.Application, QvxLogSeverity.Error, "getPreview() : " + e.Message); throw e; } QvxLog.Log(QvxLogFacility.Application, QvxLogSeverity.Debug, "- getPreview()"); return(retVal); }