public async Task GetIndexQCFlagData()
{
IEnumerable <IndexModel> enumerable = await _indexData.GetIndexesFromSP(_connectionString);
idxList = enumerable.ToList();
qcFlags = new QcFlags();
foreach (var idx in idxList)
{
qcFlags[idx.IndexId] = idx.QC_String;
}
}
public ManageIndexTable(List <DataAccessDef> accessDefs, string connectionString,
string dataType = "", string qcRule = "")
{
_accessDefs = accessDefs;
IndexAccess idxAccess = new IndexAccess();
string select = idxAccess.GetSelectSQL();
if (!string.IsNullOrEmpty(dataType))
{
select = select + $" where DATATYPE = '{dataType}'";
if (!string.IsNullOrEmpty(qcRule))
{
select = select + $" and QC_STRING like '%{qcRule}%'";
}
}
sqlCn = new SqlConnection(connectionString);
indexAdapter = new SqlDataAdapter();
indexAdapter.SelectCommand = new SqlCommand(select, sqlCn);
indexTable = new DataTable();
indexAdapter.Fill(indexTable);
qcFlags = new QcFlags();
}
public ManageIndexTable()
{
qcFlags = new QcFlags();
}
