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