public static void Init(string servername, string dbname, string passsql, string usersql)
{
if (!string.IsNullOrWhiteSpace(_connectionString))
{
return;
}
else
{
SqlConnectionStringBuilder sqlStringBuilder = new SqlConnectionStringBuilder();
sqlStringBuilder.DataSource = servername;
sqlStringBuilder.InitialCatalog = dbname;
sqlStringBuilder.Password = EncryptDecryptServices.DecryptString(passsql, "Th41$0nJSC");
sqlStringBuilder.UserID = usersql;
sqlStringBuilder.PersistSecurityInfo = true;
sqlStringBuilder.MultipleActiveResultSets = true;
sqlStringBuilder.ConnectTimeout = 600;
sqlStringBuilder.ApplicationName = "EntityFramework";
EntityConnectionStringBuilder entityStringBuilder = new EntityConnectionStringBuilder();
entityStringBuilder.ProviderConnectionString = sqlStringBuilder.ConnectionString;
entityStringBuilder.Provider = "System.Data.SqlClient";
entityStringBuilder.Metadata = "res://*/TSM.csdl|res://*/TSM.ssdl|res://*/TSM.msl";
_connectionString = entityStringBuilder.ConnectionString;
}
}
private void LoadConfig()
{
tbx_server_name.Text = Properties.Settings.Default.servername;
tbx_user_sql.Text = Properties.Settings.Default.usersql;
tbx_pass_sql.Text = EncryptDecryptServices.DecryptString(Properties.Settings.Default.passsql, "Th41$0nJSC");
tbx_user_name.Text = Properties.Settings.Default.username;
tbx_db_name.Text = Properties.Settings.Default.dbname;
}
private void SaveConfig()
{
Properties.Settings.Default.servername = tbx_server_name.Text;
Properties.Settings.Default.usersql = tbx_user_sql.Text;
Properties.Settings.Default.passsql = EncryptDecryptServices.EncryptString(tbx_pass_sql.Text, "Th41$0nJSC");
Properties.Settings.Default.username = tbx_user_name.Text;
Properties.Settings.Default.dbname = tbx_db_name.Text;
Properties.Settings.Default.Save();
}
