public string MahoaConnect(string objConnect) { var key = "b14ca5898a4e4133bbce2ea2315a1916"; var str = objConnect.ToString(); //ma hoa var encryptedString = EncryptSymectricKey_AesOperation.EncryptString(key, str); //giai ma var decryptedString = EncryptSymectricKey_AesOperation.DecryptString(key, encryptedString); return(objConnect); }
public string Connect2DB(bool checklocalDB, string sername, string DatabaseName, string UserName, string Passwords, string message) { try { if (checklocalDB != true) { ConnectString = "Data Source=" + sername + ";Network Library=DBMSSOCN; Initial Catalog=" + DatabaseName + "; User ID=" + UserName + "; Password="******";Integrated Security=True"; } else { ConnectString = "Data Source=" + sername + "; Initial Catalog=" + DatabaseName + ";Persist Security Info=True; User ID=" + UserName + "; Password="******";Integrated Security=" + checklocalDB + ""; } conn = new SqlConnection(ConnectString); conn.Open(); RegistryKey key = Registry.CurrentUser.CreateSubKey("Software\\Asset Management"); // ma hoa & luu servername trong regedit var Encrypt_Key = "b14ca5898a4e4133bbce2ea2315a1916"; // key "ma hoa" & "giai ma" doi xung var Sername_Encrypt = sername.ToString(); var Servername_encryptedString = EncryptSymectricKey_AesOperation.EncryptString(Encrypt_Key, Sername_Encrypt); key.SetValue("ServerName", Servername_encryptedString); // khong ma hoa databasename trong regedit key.SetValue("DatabaseName", DatabaseName); // ma hoa & luu username trong regedit var UserName_Encrypt = UserName.ToString(); var UserName_encryptedString = EncryptSymectricKey_AesOperation.EncryptString(Encrypt_Key, UserName_Encrypt); key.SetValue("UserName", UserName_encryptedString); // ma hoa & luu passwords trong regedit var Passwords_Encrypt = Passwords.ToString(); var Passwords_encryptedPasswords = EncryptSymectricKey_AesOperation.EncryptString(Encrypt_Key, Passwords_Encrypt); key.SetValue("Passwords", Passwords_encryptedPasswords); //key.SetValue("ComputerName", sername.Substring(0, sername.IndexOf("\\"))); if (checklocalDB != true) { key.SetValue("LocalCheck", "false"); } else { key.SetValue("LocalCheck", "True"); } key.SetValue("WSLCheck", "Off"); key.SetValue("WSLValue", "100"); key.SetValue("WHSDCheck", "Off"); key.SetValue("WHSDValue", "30"); key.SetValue("MCNCheck", "Off"); key.SetValue("WHHCheck", "Off"); key.SetValue("MCNValue", "15000000"); key.Close(); message = "Kết nối thành công"; return(message); } catch (Exception ex) { string mess_erro = ex.ToString(); message = "Lỗi kết nối : " + mess_erro; return(message); } finally { if (conn.State == ConnectionState.Open) { conn.Close(); } //this.Close(); } }