public static void SetEMRConnString(string IQToolsConnectionString, string EMRConnectionString, string IPAddress, string EMRDB, string EMRType, string ServerType, string EMRVersion) { string versionDependent = Application.UserAppDataRegistry.Name; string versionIndependent = versionDependent.Substring(0, versionDependent.LastIndexOf("\\")); Registry.SetValue(versionIndependent, "EMRConnectionString", ClsUtility.Encrypt(EMRConnectionString)); try { Entity en = new Entity(); ClsUtility.Init_Hashtable(); string sql = "UPDATE aa_Database SET " + "IPAddress = '" + IPAddress + "', " + "DBase = '" + EMRDB + "', connString='" + ClsUtility.Encrypt(EMRConnectionString) + "', PMMSType = '" + ServerType + "', IQStatus='No Data', UpdateDate=Null, PMMS = '" + EMRType + "',EMRVersion = '" + EMRVersion + "' WHERE DBName='IQTools'"; int i = (int)en.ReturnObject(IQToolsConnectionString, ClsUtility.theParams , sql , ClsUtility.ObjectEnum.ExecuteNonQuery, "mssql"); if (i == 0) { sql = "INSERT INTO aa_Database (DBName, IPAddress,ConnString, DBase, PMMSType, IQStatus, PMMS, EMRVersion, CreateDate) " + "VALUES ('IQTools','" + IPAddress + "','" + ClsUtility.Encrypt(EMRConnectionString) + "','" + EMRDB + "','" + ServerType + "','No Data','" + EMRType + "','" + EMRVersion + "', GETDATE())"; i = (int)en.ReturnObject(IQToolsConnectionString, ClsUtility.theParams , sql , ClsUtility.ObjectEnum.ExecuteNonQuery, "mssql"); } } catch (Exception ex) { throw ex; } }
public static void SetConnString(string ConnectionString) { string versionDependent = Application.UserAppDataRegistry.Name; string versionIndependent = versionDependent.Substring(0, versionDependent.LastIndexOf("\\")); Registry.SetValue(versionIndependent, "ConnectionString", ClsUtility.Encrypt(ConnectionString)); }