/// <summary> /// This returns a new supplier. /// </summary> /// <param name="queryList">List of the queries for the supplier</param> /// <returns></returns> public async Task <DataSet> GetNewSupplier(IDictionary <string, string> queryList) { DataSet set = await _executor.AsyncDataSetLoadBatch(queryList).ConfigureAwait(false); string supplierId = GetNewId(); for (int i = 0; i < set.Tables.Count; ++i) { if (set.Tables[i].Columns.Contains("NUM_PROVEE")) { if (set.Tables[i].Rows.Count > 0) { set.Tables[i].Rows[0]["NUM_PROVEE"] = supplierId; } foreach (DataColumn col in set.Tables[i].Columns) { if (col.DataType == typeof(string)) { if (col.ColumnName != "NUM_PROVEE") { set.Tables[i].Rows[0][col] = ""; } } } } } return(set); }
/// <summary> /// Assist query using the data set /// </summary> /// <param name="assitQueryDictionary">Dictionary that contgins the assist query.</param> /// <returns></returns> public async Task <DataSet> GetAsyncHelper(IDictionary <string, string> assitQueryDictionary) { DataSet set = await _sqlExecutor.AsyncDataSetLoadBatch(assitQueryDictionary); return(set); }