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;
            }
        }
        public DataSettingList(string ctrName)
        {
            InitializeComponent();

            tableName = ctrName;
            string strServer, strDatabase, strUser, strPassword;
            DBConnection dbCon = new DBConnection();
            dbCon.getDBConnectionInfo(out strServer, out strDatabase, out strUser, out strPassword);
            m_objManager.Parent = this;
            m_objManager.DBEngine = new EzSql2(strServer, strDatabase, strUser, strPassword);
            m_objManager.DBEngine.open();
        }
Example #3
0
        private static void LoadMainData()
        {
            string strServer, strDatabase, strUser, strPassword;
            bool nReturn = false;
            try
            {
                DBConnection dbCon = new DBConnection();
                dbCon.getDBConnectionInfo(out strServer, out strDatabase, out strUser, out strPassword);
                m_objManager.Parent = null;
                m_objManager.DBEngine = new EzSql2(strServer, strDatabase, strUser, strPassword);
                m_objManager.DBEngine.open();
                nReturn = true;
                UIMessage.ENTER_TO_TAB = HPA.Properties.Settings.Default.EnterToTab;
                UIMessage.DBEngine = m_objManager.DBEngine;
                UIMessage.StoreProcName = "MST_Message_Get";
                UIMessage.StoreProcParamMessageID = "@MessageID";
                UIMessage.StoreProcParamLanguage = "@Language";
                UIMessage.StoreProcParamOutName = "@Content";
                UIMessage.MessageBoxTitle = "Paradise-HPA";
                //UIMessage.TA_LoadLogTimeWhenOpen = true;
                UIMessage.LoginWallpaper = HPA.Properties.Settings.Default.LoginWallpaper;
                m_objManager.UserID = 3;

                return;
            }
            catch
            {
                if (nReturn == false)
                {
                    object obj;
                    SetConnection frmCn = new SetConnection() { AssemblyName = "HPA.Component.SystemAdmin", ClassName = "SetConnection" };
                    m_objManager.OpenObject(frmCn, true, null, out obj);
                }
                return;
            }
        }
        public override bool Commit()
        {
            // remember current Action State
            HPA.Component.Framework.Base.EActionState eOldActionState = ActionState;
            try
            {
                // switch to COMMITING state
                ActionState = HPA.Component.Framework.Base.EActionState.BUSY;

                // wait-cursor
                this.Cursor = Cursors.WaitCursor;

                try
                {
                    if (DBEngine == null)
                    {
                        string strServer, strDatabase, strUser, strPassword;
                        try
                        {
                            DBConnection dbCon = new DBConnection();
                            dbCon.getDBConnectionInfo(out strServer, out strDatabase, out strUser, out strPassword);
                            DBEngine = new EzSql2(strServer, strDatabase, strUser, strPassword);
                            DBEngine.open();
                        }
                        catch(Exception ex)
                        {
                            HPA.Common.Helper.ShowException(ex, ex.Message, "Commit");
                        }
                    }
                    object objRetVal = DBEngine.execReturnValue("SC_UserPassword_Update",
                                                            "@p_UserName", xteUserID.Text,
                                                            "@p_OldPassword", Encryption.EncryptText(xteOldPass.Text,true),
                                                            "@p_NewPassword", Encryption.EncryptText(xteNewPass.Text,true));
                    int iRetVal = Convert.ToInt32(objRetVal);
                    switch (iRetVal)
                    {
                        case 0:
                            UIMessage.ShowMessage("PASS_CHANGED_SUCCESSFULL",
                                MessageBoxButtons.OK, MessageBoxIcon.Information);
                            break;
                        case 1:
                            UIMessage.ShowMessage("USER_NOT_EXISTS",
                                MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                            xteUserID.Focus();
                            break;
                        case 2:
                            UIMessage.ShowMessage("PASS_WRONG",
                                MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                            xteOldPass.Focus();
                            break;
                    }
                }
                catch (Exception ex)
                {
                    throw (ex);
                }

                // restore cursor
                this.Cursor = Cursors.Default;

                // restore action state
                ActionState = eOldActionState;
            }
            catch (Exception e)
            {
                // restore cursor
                this.Cursor = Cursors.Default;

                // show error
                HPA.Common.Helper.ShowException(e, this.Name + ".Commit()", null);

                // restore action state
                ActionState = eOldActionState;

                // unable to commit
                return false;
            }

            // commit successfully
            return true;
        }
        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);
            }
        }
        private void btnTest_Click(object sender, EventArgs e)
        {
            // ConnectionString cs = new ConnectionString(txeServer.Text, txeDatabase.Text, txeUsername.Text, txePassword.Text);
            DBConnection dbCon = new DBConnection(txeServer.Text, txeDatabase.Text, txeUsername.Text, txePassword.Text);
            //m_bTestStatus = cs.TestConnection();
            m_bTestStatus = dbCon.checkConnectionInfo();
            if (m_bTestStatus == true)
            {
                MessageBox.Show(this, "Test Connection string successfully!", "Paradise", MessageBoxButtons.OK, MessageBoxIcon.Information);
                btnFWSave.Enabled = true;
            }
            else
                MessageBox.Show(this, "Test Connection string failed!", "Paradise", MessageBoxButtons.OK, MessageBoxIcon.Error);

            //btnFWSave.Focus();
        }