public async Task <List <string> > ProceedContractorsAsync(int debug = 1) { List <string> procOutput = new List <string>(); using (var db = new SageDb("Db")) { db.CommandTimeout = 0; var response = await db.QueryProcAsync <string>( "[FK].[sp_C21_importKH]", new DataParameter("Debug", debug, DataType.Int32) ).ConfigureAwait(false); procOutput = response.ToList(); } return(procOutput); }
public async void ProceedDocumentsAsync(int pack, int ticketId, int debug = 0) { //List<string> procOutput = new List<string>(); Console.WriteLine($"Task ticket id:{ticketId} Packiet size:{pack} Packiet Log lines: {_procOutput.Count} Start time: {DateTime.Now}"); using (var db = new SageDb("Db")) { db.CommandTimeout = 0; var response = await db.QueryProcAsync <string>( "[FK].[sp_C21_importDK]", new DataParameter("Debug", debug, DataType.Int32) ).ConfigureAwait(false); _procOutput.AddRange(response.ToList()); } Console.WriteLine($"Task ticket id:{ticketId} Packiet size:{pack} Packiet Log lines: {_procOutput.Count} End time: {DateTime.Now}"); }