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