private string CheckHeaderForeignKeys(string json, ReferenceTable reference) { try { JObject dataObject = JObject.Parse(json); string field = dataObject[reference.ReferenceAttribute].ToString(); field = Common.FixAposInStrings(field); string select = $"Select * from {reference.Table} "; string query = $" where {reference.KeyAttribute} = '{field}'"; DataTable dt = _dbConn.GetDataTable(select, query); if (dt.Rows.Count == 0) { if (reference.Insert) { string strInsert = $"insert into {reference.Table} "; string strValue = $" ({reference.KeyAttribute}, {reference.ValueAttribute}) values ('{field}', '{field}')"; string strQuery = ""; _dbConn.DBInsert(strInsert, strValue, strQuery); } else { dataObject[reference.ReferenceAttribute] = "UNKNOWN"; } } } catch (Exception) { throw new System.Exception("Error handling reference data"); } string newJson = json; return(newJson); }