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