/// <summary> /// /// This method will do a data lookup of the value by looking for the value in the cached domain. /// /// </summary> public string ExecuteCacheCheck(string psArg1, string psArg2, string psArg3, string psArg4) { string sResultValue = ""; if (IsDomainQuery && !String.IsNullOrEmpty(psArg1) && CachedDomain.Contains(psArg1)) { sResultValue = psArg1; } return(sResultValue); }
/// <summary> /// /// This method will assist with retrieving the entire domain /// /// NOTE: UNDER CONSTRUCTION /// /// </summary> public HashSet <string> RetrieveDomainSet() { var DomainSet = new HashSet <string>(); if (IsDomainQuery) { try { using (SqlConnection DbConn = GetConnection()) { DbConn.Open(); // NOTE: Use parameters in prepared statement with query here? string sSqlQuery = String.Format(this.CustomOpSource.SqlQueryOrProcedure); using (SqlCommand QueryCmd = new SqlCommand(sSqlQuery, DbConn)) { using (SqlDataReader dataReader = QueryCmd.ExecuteReader()) { if (dataReader.Read()) { // NOTE: For the time being, it will return the first value of the first column if (!dataReader.IsDBNull(0)) { string sResultValue = dataReader[0].ToString(); CachedDomain.Add(sResultValue); } } } } } } catch (Exception ex) { // NOTE: Do something here? } } return(DomainSet); }