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