private void registerButton_Click(object sender, EventArgs e)
        {
            string uname = txtUser.Text;
            string password = txtPass.Text;
            string email = txtEmail.Text;
            string name = txtName.Text;

            if (string.IsNullOrEmpty(uname) ||
                string.IsNullOrEmpty(password) ||
                string.IsNullOrEmpty(email) ||
                string.IsNullOrEmpty(name))
            {
                MessageBox.Show("Error: Complete all the fields!");
            }
            else
            {
                _eduassistant = new EducationAssistant(uname, password, email, name);
                this.DialogResult = System.Windows.Forms.DialogResult.OK;
                Database.getDatabase().addUser(_eduassistant);
                MessageBox.Show("Count: " + Database.getDatabase().countOfUsers());
                txtUser.Text = "";
                txtPass.Text = "";
                txtEmail.Text = "";
                txtName.Text = "";
                //this.Close();

            }
        }
        private void registerButton_Click(object sender, EventArgs e)
        {
            string uname    = txtUser.Text;
            string password = txtPass.Text;
            string email    = txtEmail.Text;
            string name     = txtName.Text;

            if (string.IsNullOrEmpty(uname) ||
                string.IsNullOrEmpty(password) ||
                string.IsNullOrEmpty(email) ||
                string.IsNullOrEmpty(name))
            {
                MessageBox.Show("Error: Complete all the fields!");
            }
            else
            {
                _eduassistant     = new EducationAssistant(uname, password, email, name);
                this.DialogResult = System.Windows.Forms.DialogResult.OK;
                Database.getDatabase().addUser(_eduassistant);
                MessageBox.Show("Count: " + Database.getDatabase().countOfUsers());
                txtUser.Text  = "";
                txtPass.Text  = "";
                txtEmail.Text = "";
                txtName.Text  = "";
                //this.Close();
            }
        }
        //User related Functions
        public void addUser(EducationAssistant user)
        {
            //edAssistants.Add(user);

            string query;

            query = "Insert into users (username, password, email) VALUES ('" + user.Username + "','" + user.Password + "','" + user.Email + "')";
            con.Insert(query);
        }
        //User related Functions
        public void addUser(EducationAssistant user)
        {
            //edAssistants.Add(user);

            string query;
            query = "Insert into users (username, password, email) VALUES ('"+user.Username + "','"+user.Password+ "','" + user.Email + "')" ;
            con.Insert(query);
        }