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