public dbConnect() //code ket noi { // sua lai chuoi ket noi cho phu hop database và sua lai AppConfig //conn = new SqlConnection("Data Source=JR163\\SQLEXPRESS;Initial Catalog=QLVT_test;Integrated Security=True"); RegistryKey key = Registry.CurrentUser.OpenSubKey("Software\\Asset Management"); if (key != null) { var localMachine = RegistryKey.OpenBaseKey(RegistryHive.CurrentUser, RegistryView.Registry64); var rk = localMachine.OpenSubKey("SOFTWARE\\Asset Management"); var DataBaseName = rk.GetValue("DatabaseName"); var ComputerName = rk.GetValue("ComputerName"); var Encrypt_Key = "b14ca5898a4e4133bbce2ea2315a1916"; // key giai ma doi xung var UserNameEncrytped = Convert.ToString(rk.GetValue("UserName")); var UserName_decryptedString = EncryptSymectricKey_AesOperation.DecryptString(Encrypt_Key, UserNameEncrytped); var UserName = UserName_decryptedString; var PasswordsEncrytped = Convert.ToString(rk.GetValue("Passwords")); var Passwords_decryptedString = EncryptSymectricKey_AesOperation.DecryptString(Encrypt_Key, PasswordsEncrytped); var Passwords = Passwords_decryptedString; var ServerSQLEncrytped = Convert.ToString(rk.GetValue("ServerName")); var ServerSQL_decryptedString = EncryptSymectricKey_AesOperation.DecryptString(Encrypt_Key, ServerSQLEncrytped); var ServerSQL = ServerSQL_decryptedString; var CheckLocal = rk.GetValue("LocalCheck"); conn = new SqlConnection("Data Source=" + ServerSQL.ToString() + ";Initial Catalog=" + DataBaseName.ToString() + ";Persist Security Info=True;User ID=" + UserName + ";Password="******";Integrated Security=" + CheckLocal + ""); } }
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); }