/// <summary> /// Get the helper dataset for the async layer. /// </summary> /// <param name="assistQuery">Assist query.</param> /// <param name="assitTableName">Assist table</param> /// <returns></returns> public async Task <DataSet> GetAsyncHelper(string assistQuery, string assitTableName) { DataSet set = await _sqlExecutor.AsyncDataSetLoad(assistQuery); set.Tables[0].TableName = assitTableName; return(set); }
/// <summary> /// Return the dataset of the delegations given a supplier. /// </summary> /// <param name="supplierCode">code of the supplier</param> /// <returns></returns> public async Task <Tuple <string, DataSet> > GetAsyncDelegations(string supplierCode) { string supplierCodeQuery = ""; DataSet delegationDataSet; if (!String.IsNullOrEmpty(supplierCode)) { supplierCodeQuery = String.Format(GenericSql.DelegationQuery, "'" + supplierCode + "'"); delegationDataSet = await _executor.AsyncDataSetLoad(supplierCodeQuery); } else { supplierCodeQuery = String.Format(GenericSql.DelegationGenericQuery); delegationDataSet = await _executor.AsyncDataSetLoad(supplierCodeQuery); } Tuple <string, DataSet> retValue = new Tuple <string, DataSet>(supplierCodeQuery, delegationDataSet); return(retValue); }
/// <summary> /// Get the commission agent summary in an ADO.NET database. /// </summary> /// <param name="paged">optional parameter indicating if the agent shall be paged</param> /// <param name="pageSize">optional parameter indicating the dimension of the page size</param> /// <returns>Returns the data set of all commission agents present in the system.</returns> public async Task <DataSet> GetCommissionAgentSummary(bool paged = false, long pageSize = 0) { DataSet dataset = await _sqlExecutor.AsyncDataSetLoad(GenericSql.CommissionAgentSummaryQuery).ConfigureAwait(false); logger.Debug("GetCommissionAgentSummary " + GenericSql.CommissionAgentSummaryQuery); if (dataset == null) { logger.Debug("GetCommissionAgent Null DataSet "); } return(dataset); }