public List <QvxTable> GetTables() { List <QvxTable> tables = new List <QvxTable>(); string folder_name; try { this.MParameters.TryGetValue("folder_name", out folder_name); } catch { return(tables); } if (string.IsNullOrEmpty(folder_name)) { return(tables); } IDictionary <string, string> tableDictionary = EndpointCalls.GetTableNameList(this, folder_name); List <QvxTable> newTables = BuildTablesAsync(this, tableDictionary); //List<QvxTable> newTables = BuildTablesSync(this, tableDictionary); return(newTables); }
private IEnumerable <QvxDataRow> GetData(QvxConnection connection, QvxFieldsWrapper fields, string reportID) { IEnumerable <QvxDataRow> rows = EndpointCalls.GetReportData(connection, fields, reportID); if (rows.Count() == 0) { QvxLog.Log(QvxLogFacility.Application, QvxLogSeverity.Notice, "No rows were returned for report ID: '" + reportID + "'."); } return(rows); }
public QvDataContractResponse getDatabases(QvxConnection connection) { IEnumerable <string> databases = EndpointCalls.GetReportFoldersList(connection); return(new QvDataContractDatabaseListResponse { qDatabases = databases.Select(name => new Database() { qName = name }).ToArray() }); }
private string HandleAPIRequests(string method, string[] userParameters, QvxConnection connection) { QvDataContractResponse response; switch (method) { case "API-getSalesforcePath": Uri baseUri = new Uri(userParameters[0]); string url = new Uri(baseUri, string.Format("services/oauth2/authorize?response_type=token&client_id={0}&redirect_uri=https%3A%2F%2Flogin.salesforce.com%2Fservices%2Foauth2%2Fsuccess", QvxSalesforceConnectionInfo.CLIENT_ID)).AbsoluteUri; response = new Info { qMessage = url }; break; case "API-BuildConnectionString": string connectionString = String.Format("{0}={1};{2}={3};{4}={5};{6}={7};", QvxSalesforceConnectionInfo.CONNECTION_HOST, userParameters[0], QvxSalesforceConnectionInfo.CONNECTION_AUTHHOST, userParameters[1], QvxSalesforceConnectionInfo.CONNECTION_ACCESS_TOKEN, userParameters[2], QvxSalesforceConnectionInfo.CONNECTION_REFRESH_TOKEN, userParameters[3]); response = new Info { qMessage = connectionString }; break; case "API-getUsername": string username = EndpointCalls.GetUsername(connection, userParameters[0], userParameters[1], userParameters[2], Uri.UnescapeDataString(userParameters[3]), Uri.UnescapeDataString(userParameters[4])); response = new Info { qMessage = string.Format("{{\"username\": \"{0}\", \"host\": \"{1}\" }}", username, Uri.UnescapeDataString(userParameters[3])) }; break; default: response = new Info { qMessage = "Unknown command" }; break; } return(ToJson(response)); }
private QvxFieldsWrapper GetFields(QvxConnection connection, string tableID) { IDictionary <string, SalesforceDataType> fields = EndpointCalls.GetFieldsFromReport(connection, tableID); if (fields == default(IDictionary <string, Type>)) { return(new QvxFieldsWrapper(0)); } QvxFieldsWrapper qvxFields = new QvxFieldsWrapper(fields.Count); for (int i = 0; i < fields.Count; i++) { if (fields.ElementAt(i).Value == SalesforceDataType.String) { qvxFields.SetFieldValue(i, new QvxField(fields.ElementAt(i).Key, QvxFieldType.QVX_TEXT, QvxNullRepresentation.QVX_NULL_FLAG_SUPPRESS_DATA, FieldAttrType.ASCII), fields.ElementAt(i).Value); } else if (fields.ElementAt(i).Value == SalesforceDataType.Integer || fields.ElementAt(i).Value == SalesforceDataType.Boolean) { qvxFields.SetFieldValue(i, new QvxField(fields.ElementAt(i).Key, QvxFieldType.QVX_SIGNED_INTEGER, QvxNullRepresentation.QVX_NULL_FLAG_SUPPRESS_DATA, FieldAttrType.INTEGER), fields.ElementAt(i).Value); } else if (fields.ElementAt(i).Value == SalesforceDataType.Double || fields.ElementAt(i).Value == SalesforceDataType.Currency || fields.ElementAt(i).Value == SalesforceDataType.Percent) { qvxFields.SetFieldValue(i, new QvxField(fields.ElementAt(i).Key, QvxFieldType.QVX_IEEE_REAL, QvxNullRepresentation.QVX_NULL_FLAG_SUPPRESS_DATA, FieldAttrType.REAL), fields.ElementAt(i).Value); } else if (fields.ElementAt(i).Value == SalesforceDataType.Date) { qvxFields.SetFieldValue(i, new QvxField(fields.ElementAt(i).Key, QvxFieldType.QVX_IEEE_REAL, QvxNullRepresentation.QVX_NULL_FLAG_SUPPRESS_DATA, FieldAttrType.DATE), fields.ElementAt(i).Value); } else if (fields.ElementAt(i).Value == SalesforceDataType.DateTime) { qvxFields.SetFieldValue(i, new QvxField(fields.ElementAt(i).Key, QvxFieldType.QVX_IEEE_REAL, QvxNullRepresentation.QVX_NULL_FLAG_SUPPRESS_DATA, FieldAttrType.TIMESTAMP), fields.ElementAt(i).Value); } else { qvxFields.SetFieldValue(i, new QvxField(fields.ElementAt(i).Key, QvxFieldType.QVX_TEXT, QvxNullRepresentation.QVX_NULL_FLAG_WITH_UNDEFINED_DATA, FieldAttrType.ASCII), fields.ElementAt(i).Value); } } return(qvxFields); }