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));
}
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 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 bool DropIQToolsObjects(string emrType, string serverType)
{
string connString = GetConnString();
try
{
DataTable theDt = new DataTable(); int i = 0;
Entity theObject = new Entity(); ClsUtility.Init_Hashtable();
string toDrop = "Select Name FROM sys.synonyms";
theDt = (DataTable)theObject.ReturnObject(connString, ClsUtility.theParams
, toDrop, ClsUtility.ObjectEnum.DataTable, serverType);
DataTableReader dTr;
dTr = theDt.CreateDataReader();
if (serverType.ToLower() == "mssql" || emrType.ToLower() == "" || emrType.ToLower() == "msaccess")
{
while (dTr.Read())
{
try
{
i = (int)theObject.ReturnObject(connString, ClsUtility.theParams
, "DROP Synonym [dbo].[" + dTr[0].ToString().Trim() + "]", ClsUtility.ObjectEnum.ExecuteNonQuery, "mssql");
}
catch { }
try
{
i = (int)theObject.ReturnObject(connString, ClsUtility.theParams
, "DROP Table [" + dTr[0].ToString().Trim() + "]", ClsUtility.ObjectEnum.ExecuteNonQuery, "mssql");
}
catch { }
}
try
{
i = (int)theObject.ReturnObject(connString, ClsUtility.theParams
, "DROP TABLE mst_Patient_decoded", ClsUtility.ObjectEnum.ExecuteNonQuery, "mssql");
}
catch { }
try
{
i = (int)theObject.ReturnObject(connString, ClsUtility.theParams
, "DROP TABLE dtl_PatientContacts", ClsUtility.ObjectEnum.ExecuteNonQuery, "mssql");
}
catch { }
try
{
i = (int)theObject.ReturnObject(connString, ClsUtility.theParams
, "DROP TABLE Person_Decoded", ClsUtility.ObjectEnum.ExecuteNonQuery, "mssql");
}
catch { }
}
return(true);
}
catch (Exception ex)
{
if (ex.Message.ToLower().Substring(0, 21) == "cannot use drop table")
{
//SqlConnection cnn = new SqlConnection(Entity.getconnString(clsGbl.xmlPath));
//cnn.Open();
//SqlCommand cmm = new SqlCommand("UPDATE aa_Database Set Connstring = '' WHERE DBName = 'IQTools'"); cmm.Connection = cnn;
//int i = cmm.ExecuteNonQuery();
//cnn.Close(); cmm.Dispose(); cnn.Dispose();
}
return(true);
}
}
