public static object getdbConn(NpgsqlConnection conn, string pmm) { string connStr; string pmmType; connStr = ""; pmmType = ""; try { NpgsqlCommand comm; comm = new NpgsqlCommand("SELECT connString, PMMSType From iqtools.aa_Database WHERE DbName = '" + pmm + "'", conn); NpgsqlDataReader sDR = comm.ExecuteReader(); while (sDR.Read()) { connStr = ClsUtility.Decrypt(sDR[0].ToString()); pmmType = sDR[1].ToString(); break; } } catch (Exception ex) { connStr = ex.Message; connStr = ""; } return(GetConnection(connStr, pmmType)); }
public static string getconnString(string xmlPath) { XmlDocument theXML = new XmlDocument(); theXML.Load(xmlPath); XmlNode nd = theXML.SelectSingleNode("//add[@key='IQToolconstr']"); //get the node with an attribute of “key” = IQToolconstr if (nd != null) { return(ClsUtility.Decrypt(nd.Attributes["value"].Value)); //return the value of the value attribute of this node } return(""); }
public static string GetEMRConnString() { string versionDependent = Application.UserAppDataRegistry.Name; string versionIndependent = versionDependent.Substring(0, versionDependent.LastIndexOf("\\")); string ConnectionString = String.Empty; if (Registry.GetValue(versionIndependent, "EMRConnectionString", null) != null) { return(ClsUtility.Decrypt(Registry.GetValue(versionIndependent, "EMRConnectionString", null).ToString())); } else { return(ConnectionString); } }
public static object getdbConn(SqlConnection conn, String pmm) { string connStr; string pmmType; connStr = ""; pmmType = ""; try { SqlCommand comm; if (pmm == "msaccess") { comm = new SqlCommand("SELECT connString, PMMSType From aa_database WHERE DbName = '" + "IQTools" + "'", conn); } else { comm = new SqlCommand("SELECT connString, PMMSType From aa_database WHERE DbName = '" + pmm + "'", conn); } SqlDataReader sDR = comm.ExecuteReader(); while (sDR.Read()) { connStr = ClsUtility.Decrypt(sDR[0].ToString()); if (pmm == "msaccess") { pmmType = "msaccess"; } else { pmmType = sDR[1].ToString(); } break; } } catch (Exception ex) { connStr = ex.Message; connStr = ""; } return(GetConnection(connStr, pmmType)); }
public static string getdbConnString(SqlConnection conn, String pmm) { string connStr; connStr = ""; try { SqlCommand comm = new SqlCommand("SELECT connString From aa_database WHERE DbName = '" + pmm + "'", conn); SqlDataReader sDR = comm.ExecuteReader(); while (sDR.Read()) { connStr = ClsUtility.Decrypt(sDR[0].ToString()); //+ "Allow User Variables=True"; break; } } catch (Exception ex) { connStr = ex.Message; connStr = ""; } return(connStr); }