public override bool OnSave()
{
DBConnection dbCon = null;
try
{
// make new connection object:
dbCon = new DBConnection();
if (dbCon.saveConnectionInfo(txeServer.Text, txeDatabase.Text, txeUsername.Text, txePassword.Text, DBConnection.ENCRYPTED))
{
MessageBox.Show(this, "Connection setting has saved successfully. Changes will be applied for the next log on.", "Paradise", MessageBoxButtons.OK, MessageBoxIcon.Information);
isNewConnection = true;
}
else
MessageBox.Show(this, "Connection setting can not saved. Please re-install Paradise if you can.", "Paradise", MessageBoxButtons.OK, MessageBoxIcon.Error);
btnFWSave.Enabled = false;
dbCon = null;
// return Good:
return true;
}
catch(Exception exc)
{
MessageBox.Show(exc.Message,"Paradise",MessageBoxButtons.OK,MessageBoxIcon.Error);
return false;
}
}
private void SetConnection_Load(object sender, EventArgs e)
{
string strConnection = "";
SqlConnection connection;
SqlCommand cmd;
string strCreateUser = "";
string strAttachDB = "";
string strServer, strDatabase, strUser, strPassword, strEncrypted;
DBConnection dbCon = null;
try
{
//Connect to Master Database
//strConnection = @"Data Source=.\SQLExpress;Initial Catalog=master;User Id=sa;Password=123;";
// register dll for zk SDK
if (!System.IO.File.Exists("Paradise.ini"))
{
Process.Start(@"C:\windows\system32\RegiszkDll.bat");
strConnection = @"Data Source=.\SQLEXPRESS;Initial Catalog=master;Integrated Security=True";
connection = new SqlConnection(strConnection);
connection.Open();
//Attach Database file
cmd = new SqlCommand("if exists (select 1 from sys.databases where Name = 'Att_VTS') EXEC master.dbo.sp_detach_db N'Att_VTS','true'", connection);
cmd.ExecuteNonQuery();
strAttachDB = @"if not exists (select 1 from sys.databases where name = 'Att_VTS') CREATE DATABASE [Att_VTS] ON ( FILENAME = N'C:\Windows\Att_VTS.mdf' ),( FILENAME = N'C:\Windows\Att_VTS_log.ldf' ) FOR ATTACH ";
cmd = new SqlCommand(strAttachDB, connection);
cmd.ExecuteNonQuery();
//Create new login name saFree, Pass:LuaThiengFree
//Retry to connect new SQL String again
strCreateUser = @"if not exists (select 1 from master.dbo.syslogins where name = 'SaFree') CREATE LOGIN saFree WITH PASSWORD=N'LuaThiengFree', DEFAULT_DATABASE=[Att_VTS], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF;";
cmd = new SqlCommand(strCreateUser, connection);
cmd.ExecuteNonQuery();
cmd = new SqlCommand("EXEC master..sp_addsrvrolemember @loginame = N'saFree', @rolename = N'sysadmin'", connection);
cmd.ExecuteNonQuery();
try
{
cmd = new SqlCommand(@"xp_regwrite N'HKEY_LOCAL_MACHINE', N'Software\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer', N'LoginMode', REG_DWORD, 2", connection);
cmd.ExecuteNonQuery();
}
catch { }
try
{
cmd = new SqlCommand(@"xp_regwrite N'HKEY_LOCAL_MACHINE', N'Software\Microsoft\Microsoft SQL Server\MSSQL.2\MSSQLServer', N'LoginMode', REG_DWORD, 2", connection);
cmd.ExecuteNonQuery();
}
catch { }
try
{
cmd = new SqlCommand(@"xp_regwrite N'HKEY_LOCAL_MACHINE', N'Software\Microsoft\Microsoft SQL Server\MSSQL.3\MSSQLServer', N'LoginMode', REG_DWORD, 2", connection);
cmd.ExecuteNonQuery();
}
catch { }
connection.Close();
strServer = @".\SQLEXPRESS";
strDatabase = "Att_VTS";
strUser = "******";
strPassword = "******";
strEncrypted = DBConnection.NO_ENCRYPTED;
dbCon = new DBConnection();
dbCon.saveConnectionInfo(strServer, strDatabase, strUser, strPassword, DBConnection.ENCRYPTED);
//Reset computer
if (MessageBox.Show("Need restart compurter to complete the First configuration. Do you want to restart your computer?", "Vietinsoft", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes)
Process.Start("ShutDown", "/r /t 000");
else
Application.Exit();
}
dbCon = new DBConnection();
dbCon.getDBConnectionInfo(out strServer, out strDatabase, out strUser, out strPassword, out strEncrypted);
}
catch
{
strServer = @".\SQLEXPRESS";
strDatabase = "Att_VTS";
strUser = "******";
strPassword = "******";
strEncrypted = DBConnection.NO_ENCRYPTED;
dbCon = new DBConnection();
dbCon.saveConnectionInfo(strServer, strDatabase, strUser, strPassword, DBConnection.ENCRYPTED);
}
// ConnectionString cs = new ConnectionString();
// cs.GetConnectParam();
// cs.GetParam(out strServer, out strDatabase, out strUser, out strPassword, out strEncrypted);
//
txeServer.Text = strServer;
txeDatabase.Text = strDatabase;
txeUsername.Text = strUser;
txePassword.Text = strPassword;
if (strEncrypted.Trim() == DBConnection.ENCRYPTED)
chkEncrypt.Checked = true;
else
chkEncrypt.Checked = false;
dbCon = null;
// load language interface
if ((strServer != null) && (!string.Empty.Equals(strServer)))
{
Control.ControlCollection ctrls = this.Controls;
UIMessage.LoadLableName(ref ctrls);
}
}