private int GeIndextNode(string dataType, int parentid) { int nodeid = 0; string nodeName = dataType + "s"; string query = $" where INDEXID = {parentid}"; IndexAccess idxAccess = new IndexAccess(); List <IndexModel> idxResults = idxAccess.SelectIndexesByQuery(query, databaseConnectionString); if (idxResults.Count == 1) { string indexNode = idxResults[0].TextIndexNode; int indexLevel = idxResults[0].IndexLevel + 1; string strProcedure = $"EXEC spGetNumberOfDescendants '{indexNode}', {indexLevel}"; query = ""; DataTable idx = _dbConn.GetDataTable(strProcedure, query); if (idx.Rows.Count == 1) { string condition = $"DATANAME={nodeName}"; var rows = indexTable.Select(condition); if (rows.Length > 0) { nodeid = Convert.ToInt32(rows[0]["INDEXID"]); } } if (nodeid == 0) { nodeid = _dbConn.InsertIndex(parentid, nodeName, nodeName, "", "", 0.0, 0.0); } } return(nodeid); }
private IndexRootJson GetIndexRootData() { IndexRootJson rootJson = new IndexRootJson(); string idxQuery = $" where INDEXNODE = '/'"; IndexAccess idxAccess = new IndexAccess(); List <IndexModel> idxResults = idxAccess.SelectIndexesByQuery(idxQuery, databaseConnectionString); if (idxResults.Count > 0) { string jsonStringObject = idxResults[0].JsonDataObject; rootJson = JsonConvert.DeserializeObject <IndexRootJson>(jsonStringObject); } return(rootJson); }
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"); } }