예제 #1
0
        private void changePass()
        {
            sqlcon userConnect = new sqlcon();

            userConnect.dbIn();
            SqlCommand modify = new SqlCommand("[ChangePW]", sqlcon.con);

            modify.CommandType = System.Data.CommandType.StoredProcedure;
            modify.Parameters.AddWithValue("@passkey", metroTextBox4.Text);
            modify.Parameters.AddWithValue("@newpass", metroTextBox5.Text);
            modify.Parameters.AddWithValue("@userID", globalVar.x.ToString());
            modify.Parameters.AddWithValue("@name", globalVar.name.ToString());
            modify.ExecuteNonQuery();
            userConnect.dbOut();
            DesktopAlert.Show("Password has been changed, please Log IN");
            this.FormClosing -= new System.Windows.Forms.FormClosingEventHandler(this.Form1_FormClosing);
            this.Close();
            loginForm lF = new loginForm();

            lF.ShowDialog();
        }
예제 #2
0
        private void metroTile1_Click(object sender, EventArgs e)
        {
            Form1 fm1 = new Form1();

            fm1.Hide();
            sqlcon userOUT = new sqlcon();

            userOUT.dbIn();
            SqlCommand    logOut = new SqlCommand("[timeLogoUT] '" + globalVar.x + "','" + globalVar.name + "'", sqlcon.con);
            SqlDataReader lO     = logOut.ExecuteReader();

            while (lO.Read())
            {
            }
            this.Hide();
            userOUT.dbOut();
            fm1.Close();
            Application.Exit();
            loginForm lF = new loginForm();

            lF.Show();
        }