public async Task <bool> RunSubAlgorithm3Async(string inputFile1Path, string inputFile2Path)
{
bool bHasCalcs = false;
string sBaseURL =
"https://ussouthcentral.services.azureml.net/workspaces/d454361ecdcb4ec4b03fa1aec5a7c0e2/services/8b1074b465ea4258a11ec48ce64ae257/jobs";
string sPlatForm = CalculatorHelpers.GetPlatform(_params.ExtensionDocToCalcURI, inputFile1Path);
if (sPlatForm != CalculatorHelpers.PLATFORM_TYPES.azure.ToString())
{
sBaseURL = "https://ussouthcentral.services.azureml.net/workspaces/d454361ecdcb4ec4b03fa1aec5a7c0e2/services/8b1074b465ea4258a11ec48ce64ae257/execute?api-version=2.0&details=true";
}
string sApiKey =
"RO2Ev5dRSKqNJ4jz+zoT0qDntEsKbyizbgZKlhOR2vGztsjBD3S3C8nmIlZI9TbbmCcsw+unwhky1GgZ5qiHmg==";
string sError = string.Empty;
//web server expects to store in temp/randomid/name.csv
//scoring results
string sOutputData1URL = CalculatorHelpers.GetTempContainerPath("outputdata1.csv");
//model results
string sOutputData2URL = CalculatorHelpers.GetTempContainerPath("outputdata2.csv");
//web service expects urls that start with container names
string sInput1ContainerPath = CalculatorHelpers.GetContainerPathFromFullURIPath("resources", inputFile1Path);
string sInput2ContainerPath = CalculatorHelpers.GetContainerPathFromFullURIPath("resources", inputFile2Path);
//async wait so that results can be stored in output file location and parsed into string lines
SetResponse2(sBaseURL, sApiKey, sInput1ContainerPath, sInput2ContainerPath, sOutputData1URL, sOutputData2URL).Wait();
StringBuilder sb = new StringBuilder();
//if web service successully saved the results, the response will start with Success
if (_response.StartsWith("Success"))
{
//return the output file contents in a string list of lines
//must convert container path to full path
string sOutput1FullDataURL = string.Concat("https://devtreks1.blob.core.windows.net/", sOutputData1URL);
List <string> lines = new List <string>();
//azure emulator can't process real Azure URL so this won't work
//instead, double check that output url is actually saved
lines = CalculatorHelpers.ReadLines(_params.ExtensionDocToCalcURI, sOutput1FullDataURL, out sError);
this.ErrorMessage += sError;
//this results in endless wait
//lines = await CalculatorHelpers.ReadLinesAsync(sOutputDataURL);
if (lines == null)
{
this.ErrorMessage += string.Concat(" ", Errors.MakeStandardErrorMsg("DATAURL_BAD"));
return(bHasCalcs);
}
if (lines.Count == 0)
{
this.ErrorMessage += string.Concat(" ", Errors.MakeStandardErrorMsg("DATAURL_BAD"));
return(bHasCalcs);
}
sb = new StringBuilder();
sb.AppendLine("aml results");
//dep var has to be in the R project 1st column
//string sLine = string.Concat("first variable: ", _colNames[0]);
string[] line = new List <string>().ToArray();
int iPos = 0;
for (int i = 0; i < lines.Count(); i++)
{
line = lines[i].Split(Constants.CSV_DELIMITERS);
//lineout[1] = CalculatorHelpers.ConvertStringToDouble(line[0]).ToString("N4", CultureInfo.InvariantCulture);
sb.AppendLine(Shared.GetLine(line, false));
}
if (this.MathResult.ToLower().StartsWith("http"))
{
sError = string.Empty;
bool bHasSaved = CalculatorHelpers.SaveTextInURI(
_params.ExtensionDocToCalcURI, sb.ToString(), this.MathResult, out sError);
if (!string.IsNullOrEmpty(sError))
{
this.MathResult += sError;
}
}
else
{
this.MathResult = sb.ToString();
}
bHasCalcs = true;
//last line of string should have the QTM vars
if (line != null)
{
//last string is prediction
iPos = line.Count() - 1;
//int iPos = line.Count() - 3;
if (line[iPos] != null)
{
this.QTPredicted = CalculatorHelpers.ConvertStringToDouble(line[iPos]);
}
}
string sOutput2FullDataURL = string.Concat("https://devtreks1.blob.core.windows.net/", sOutputData2URL);
lines = new List <string>();
//azure emulator can't process real Azure URL so this won't work
//instead, double check that output url is actually saved
lines = CalculatorHelpers.ReadLines(_params.ExtensionDocToCalcURI, sOutput2FullDataURL, out sError);
this.ErrorMessage += sError;
if (lines == null)
{
this.ErrorMessage += string.Concat(" ", Errors.MakeStandardErrorMsg("DATAURL_BAD"));
return(bHasCalcs);
}
if (lines.Count == 0)
{
this.ErrorMessage += string.Concat(" ", Errors.MakeStandardErrorMsg("DATAURL_BAD"));
return(bHasCalcs);
}
sb = new StringBuilder();
//dep var has to be in the R project 1st column
//string sLine = string.Concat("first variable: ", _colNames[0]);
line = new List <string>().ToArray();
double dbCI = 0;
for (int i = 0; i < lines.Count(); i++)
{
line = lines[i].Split(Constants.CSV_DELIMITERS);
if (line != null)
{
iPos = 0;
//used to derive conf interval
dbCI = CalculatorHelpers.ConvertStringToDouble(line[iPos]);
sb.AppendLine(string.Format("{0} {1}", "Mean Absolute Error: ", dbCI.ToString()));
double dbScore = 0;
if (line.Count() >= 2)
{
iPos = 1;
dbScore = CalculatorHelpers.ConvertStringToDouble(line[iPos]);
sb.AppendLine(string.Format("{0} {1}", "Root Mean Squared Error: ", dbScore.ToString()));
}
if (line.Count() >= 3)
{
iPos = 2;
dbScore = CalculatorHelpers.ConvertStringToDouble(line[iPos]);
sb.AppendLine(string.Format("{0} {1}", "Relative Absolute Error: ", dbScore.ToString()));
}
if (line.Count() >= 4)
{
iPos = 3;
dbScore = CalculatorHelpers.ConvertStringToDouble(line[iPos]);
sb.AppendLine(string.Format("{0} {1}", "Relative Squared Error: ", dbScore.ToString()));
}
if (line.Count() >= 5)
{
iPos = 4;
dbScore = CalculatorHelpers.ConvertStringToDouble(line[iPos]);
sb.AppendLine(string.Format("{0} {1}", "Coefficient of Determination: ", dbScore.ToString()));
}
//sb.AppendLine(Shared.GetLine(line, false));
}
}
this.MathResult += sb.ToString();
bHasCalcs = true;
//last line of string should have the QTM vars
if (line != null)
{
if (line[iPos] != null)
{
dbCI = CalculatorHelpers.ConvertStringToDouble(line[iPos]);
}
this.QTL = this.QTPredicted - dbCI;
this.QTU = this.QTPredicted + dbCI;
}
}
else
{
this.ErrorMessage += "The calculations could not be run using the web service.";
}
return(bHasCalcs);
}
