private async Task <List <string> > WorkWithResult(Connect connect, string command)
{
return(await Task.Run(() =>
{
BMTools.BmDebug.Debug.SaveCall().Info(command);
BMTools.BmDebug.Debug.SaveCall().Info("BEGIN" + " connect=" + connect.Name + " command=" + command);
var oracle = new Ora();
var answer = oracle.GetFromDb(connect, command);
foreach (var a in answer)
{
BMTools.BmDebug.Debug.SaveCall().Info("connect=" + connect.Name + " command=" + command + " DATA=", a);
}
BMTools.BmDebug.Debug.SaveCall().Info("END" + " connect=" + connect.Name + " command=" + command);
return answer;
}));
}
private async void Work(Connect connect, string command)
{
BMTools.BmDebug.Debug.SaveCall().Info(command);
BMTools.BmDebug.Debug.SaveCall().Info("BEGIN" + " connect=" + connect.Name + " command=" + command);
var oracle = new Ora();
var answer = oracle.GetFromDb(connect, command);
foreach (var a in answer)
{
BMTools.BmDebug.Debug.SaveCall().Info("connect=" + connect.Name + " command=" + command + " DATA=", a);
}
if (command == Ora.OraStrings.SqlOperDay ||
command == Ora.OraStrings.SqlLastDay ||
command == Ora.OraStrings.SqlRegions)
{
connect.LastUsed = DateTime.Now;
try
{
if (answer.Count == 1 && answer[0].Contains("ORA-"))
{
throw new Exception();
}
if (command == Ora.OraStrings.SqlOperDay)
{
connect.OperDay = Convert.ToDateTime(answer[0]).ToShortDateString();
}
if (command == Ora.OraStrings.SqlLastDay)
{
connect.PrevDay = Convert.ToDateTime(answer[0]).ToShortDateString();
}
if (command == Ora.OraStrings.SqlRegions)
{
connect.Regions = answer[0];
}
}
catch
{
if (command == Ora.OraStrings.SqlOperDay)
{
connect.OperDay = answer.Aggregate(string.Empty, (current, a) => current + (a + ";"));
}
if (command == Ora.OraStrings.SqlLastDay)
{
connect.PrevDay = answer.Aggregate(string.Empty, (current, a) => current + (a + ";"));
}
if (command == Ora.OraStrings.SqlRegions)
{
connect.Regions = answer.Aggregate(string.Empty, (current, a) => current + (a + ";"));
}
}
LoadList(connect);
}
else
{
throw new Exception("Unknown command");
}
BMTools.BmDebug.Debug.SaveCall().Info("END" + " connect=" + connect.Name + " command=" + command);
}