public void InitializeIndex(ConnectParameters connectionString, ConnectParameters source, string jsonTaxonomy)
{
_connectionString = connectionString.ConnectionString;
_taxonomy = jsonTaxonomy;
myIndex = new IndexDataCollection();
dbConn.OpenConnection(connectionString);
sourceAccess.OpenConnection(source, connectionString);
dataAccessDefs = JsonConvert.DeserializeObject <List <DataAccessDef> >(connectionString.DataAccessDefinition);
JsonIndexArray = JArray.Parse(jsonTaxonomy);
_idxData = new List <IndexFileData>();
foreach (JToken level in JsonIndexArray)
{
_idxData.Add(ProcessJTokens(level));
ProcessIndexArray(JsonIndexArray, level);
}
}
public void InsertUserDefinedTable(IndexDataCollection myIndex)
{
string sql = "spInsertIndex";
using (SqlCommand cmd = new SqlCommand(sql, this.sqlCn))
{
try
{
cmd.CommandTimeout = _sqlTimeOut;
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter sqlParam = cmd.Parameters.AddWithValue("@TempTable", myIndex);
sqlParam.SqlDbType = SqlDbType.Structured;
sqlParam.TypeName = "dbo.UDIndexTable";
sqlParam.Value =
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
Exception error = new Exception($"Sorry! Error inserting index", ex);
throw error;
}
}
}
