예제 #1
0
        public frmDatabase(Server server)
        {
            // Information that is used to connect to the MySql Database
            string dbhost = "localhost";
            string dbuser = "******";
            string dbpass = "******";
            string dbdatabase = "dataman";

            // The server connection that is used to connect to the database.
            this.server = server;

            // Creates all the controls for the form.
            InitializeComponent();

            // Checks to make sure the connection to the server is still active and then
            // attempts to connect to the database.
            if (server.isJschConnected())
            {
                this.statLbl1.Text = "Connected To Server";
                server.setPortForwarding("131-server.ecs.csus.edu");
                mySqlConn = new SqlDatabase(dbhost, dbuser, dbpass, dbdatabase);

                data = new DataTable();
                data = mySqlConn.queryDatabase("show tables;");
                fillDataGrid(data);
            }
        }
예제 #2
0
파일: Program.cs 프로젝트: Wiks00/D2.Task1
 static void Main(string[] args)
 {
     try
     {
         server = BackEnd.Server.Instance;
         Thread listenThread = new Thread(server.BeginListen);
         listenThread.Start();
     }
     catch (Exception ex)
     {
         server.EndListen();
         Console.WriteLine(ex.Message);
     }
 }
예제 #3
0
        public frmController(Server server)
        {
            // Information that is used to connect to the MySql Database
            string dbhost = "localhost";
            string dbuser = "******";
            string dbpass = "******";
            string dbdatabase = "dataman";

            // The server connection that is used to connect to the database.
            this.server = server;

            // Creates all the controls for the form.
            InitializeComponent();

            // Checks to make sure the connection to the server is still active and then
            // attempts to connect to the database.
            if (server.isJschConnected())
            {
                this.statLbl1.Text = "Connected To Server";
                server.setPortForwarding("131-server.ecs.csus.edu");

                mySqlConn = new SqlDatabase(dbhost, dbuser, dbpass, dbdatabase);

                // Will return the result of trying to connect to the database. Will have
                // a null string if it was able to connect.
                string result = mySqlConn.connectDatabase();

                if (result == null)
                {
                    if ( rdoDatabase.Checked )
                    {
                        loadDatabaseAccounts();
                    }
                    else if ( rdoProject.Checked )
                    {
                        loadProjectAccounts();
                    }
                }
                else
                {
                    MessageBox.Show(result, "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    Application.Exit();
                }
                // Defaults the combo box to unsynced.
                this.cmboAcctStatus.SelectedIndex = 0;
            }
        }
예제 #4
0
        public frmDatabase(Server server)
        {
            // Information that is used to connect to the MySql Database

            string dbhost = "131-server.ecs.csus.edu";
            string dbuser = "******";
            string dbpass = "******";
            string dbdatabase = "dataman";

            // The server connection that is used to connect to the database.
            this.server = server;

            // Creates all the controls for the form.
            InitializeComponent();

            // Checks to make sure the connection to the server is still active and then
            // attempts to connect to the database.
            if (server.isJschConnected())
            {
                this.statLbl1.Text = "Connected To Server";
                server.setPortForwarding(dbhost);
                mySqlConn = new SqlDatabase(dbhost, dbuser, dbpass, dbdatabase);

                // Will return the result of trying to connect to the database. Will have
                // a null string if it was able to connect.
                string result = mySqlConn.connectDatabase();

                if (result == null)
                {
                    data = new DataTable();
                    data = mySqlConn.queryDatabase("show tables;");
                    fillDataGrid(data);
                }
                else
                {
                    MessageBox.Show(result, "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    Application.Exit();
                }
            }
        }
예제 #5
0
파일: LogIn.cs 프로젝트: Anthoknee/BackEnd
        private void btnLogIn_Click(object sender, EventArgs e)
        {
            Boolean process = true;

            host = txtHost.Text;
            username = txtUsername.Text;
            password = txtPassword.Text;

            // Checks to make sure that values are entered into each textbox.
            if (host.Trim() == "")
            {
                lblHostError.Text = "*Need to enter a valid server name.";
                lblHostError.Visible = true;
                txtHost.Focus();
                process = false;
            }
            else
            {
                lblHostError.Visible = false;
            }
            if (username.Trim() == "")
            {
                lblUserError.Text = "*Need to enter a valid username.";
                lblUserError.Visible = true;
                txtUsername.Focus();
                process = false;
            }
            else
            {
                lblUserError.Visible = false;
            }
            if (password.Trim() == "")
            {
                lblPassError.Text = "*Need to enter a password.";
                lblPassError.Visible = true;
                txtPassword.Focus();
                process = false;
            }
            else
            {
                lblPassError.Visible = false;
            }

            // Checks to see whether to proceed or not
            if (process == false)
            {
                return;
            }

            server = new Server();
            string result = server.jschServer(host, username, password);

            // If an error was not encountered when logging into server then it will skip this block.
            if (result != null)
            {
                // Throws an excpetion that username and/or password is incorrect
                if (result == "Auth cancel")
                {
                    MessageBox.Show("Username and/or Password is incorrect!", "Error!", MessageBoxButtons.OK,
                        MessageBoxIcon.Error);
                    txtPassword.Focus();
                    return;
                }
                // Throws an exception that program cannot connect to host.
                else
                {
                    MessageBox.Show("Cannot connect to server. Is host name entered correctly?", "Error!",
                        MessageBoxButtons.OK, MessageBoxIcon.Error);
                    txtHost.Focus();
                    return;
                }
            }

            // If successively connects, will attempt to connect to database.
            frmController databaseWindow = new frmController(server);

            this.Hide();
            databaseWindow.ShowDialog();
            this.Close();
        }
예제 #6
0
 public frmCreateUser(Server server)
 {
     InitializeComponent();
     this.server = server;
 }