public void GetQueriesInfoTest()
{
const string queryCountSQL = @"select count (*) from tasQuery where blnSubQuery = 0";
lock (m_LayoutDB.Connection)
{
EidssUserContext.CheckUserLoggedIn();
LookupManager.ClearByTable("Query");
LookupManager.ClearAndReloadOnIdle();
int queryCount = GetCount(queryCountSQL);
int actualQueryCount = AvrQueryLayoutTreeDbHelper.ReLoadQueries().Count;
Assert.AreEqual(queryCount, actualQueryCount);
}
}
internal static Dictionary <long, string> GetAvrQueries()
{
List <AvrTreeElement> queries = AvrQueryLayoutTreeDbHelper.ReLoadQueries(true);
Dictionary <long, string> result = queries.ToDictionary(query => query.QueryID, query => query.NationalName);
return(result);
//
// DataView view = LookupBinder.GetQueryDataView(false);
// view.Sort = "intOrder, QueryName";
//
// foreach (DataRowView row in view)
// {
// var queryId = (long)row["idflQuery"];
// string queryName = row["QueryName"].ToString();
//
// result.Add(queryId, queryName);
// }
}
