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"); } }