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