private void UpdateDatabase(string jsonDataObject, string connectionString, string dataType)
{
JObject dataObject = JObject.Parse(jsonDataObject);
dataObject["ROW_CHANGED_BY"] = Environment.UserName;
jsonDataObject = dataObject.ToString();
jsonDataObject = Helpers.Common.SetJsonDataObjectDate(jsonDataObject, "ROW_CHANGED_DATE");
DbUtilities dbConn = new DbUtilities();
dbConn.OpenWithConnectionString(connectionString);
dbConn.UpdateDataObject(jsonDataObject, dataType);
dbConn.CloseConnection();
}
private void UpdateAction(PredictionResult result, string qcStr)
{
string idxQuery = $" where INDEXID = {result.IndexId}";
IndexAccess idxAccess = new IndexAccess();
List <IndexModel> idxResults = idxAccess.SelectIndexesByQuery(idxQuery, databaseConnectionString);
if (idxResults.Count == 1)
{
string condition = $"INDEXID={result.IndexId}";
var rows = indexTable.Select(condition);
rows[0]["JSONDATAOBJECT"] = result.DataObject;
rows[0]["QC_STRING"] = qcStr;
indexTable.AcceptChanges();
if (syncPredictions)
{
string jsonDataObject = result.DataObject;
JObject dataObject = JObject.Parse(jsonDataObject);
dataObject["ROW_CHANGED_BY"] = Environment.UserName;
jsonDataObject = dataObject.ToString();
jsonDataObject = Helpers.Common.SetJsonDataObjectDate(jsonDataObject, "ROW_CHANGED_DATE");
string dataType = idxResults[0].DataType;
try
{
_dbConn.UpdateDataObject(jsonDataObject, dataType);
}
catch (Exception ex)
{
string error = ex.ToString();
//logger.LogWarning($"Error updating data object");
throw;
}
}
}
else
{
//logger.LogWarning("Cannot find data key during update");
}
}
