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