public async Task InsertEdits(ReportData reportData, string sourceName)
{
ConnectParameters connector = await Common.GetConnectParameters(azureConnectionString, sourceName);
IndexModel index = await _indexData.GetIndexFromSP(reportData.Id, connector.ConnectionString);
JObject dataObject = JObject.Parse(reportData.JsonData);
if (reportData.ColumnType == "number")
{
dataObject[reportData.ColumnName] = reportData.NumberValue;
}
else if (reportData.ColumnType == "string")
{
dataObject[reportData.ColumnName] = reportData.TextValue;
}
string remark = dataObject["REMARK"] + $";{reportData.ColumnName} has been manually edited;";
dataObject["REMARK"] = remark;
index.JsonDataObject = dataObject.ToString();
string failRule = reportData.RuleKey + ";";
index.QC_String = index.QC_String.Replace(failRule, "");
await _indexData.UpdateIndex(index, connector.ConnectionString);
if (connector.SourceType == "DataBase")
{
UpdateDatabase(index.JsonDataObject, connector.ConnectionString, reportData.DataType);
}
}
private async Task DeleteAction(PredictionResult result, string qcStr)
{
IndexModel idxResults = await _indexData.GetIndexFromSP(result.IndexId, databaseConnectionString);
if (idxResults != null)
{
DeleteChildren(result.IndexId, qcStr);
DeleteParent(qcStr, idxResults);
}
else
{
//logger.LogWarning("Cannot find data key during update");
}
}