예제 #1
0
        private void update_btn_Click(object sender, EventArgs e)
        {
            if (password.Text.Trim() == "")
            {
                MessageBox.Show("PASSWORD IS REQUIRED !!", "ERROR");
                password.Focus();
                return;
            }
            if (password2.Text.Trim() == "")
            {
                MessageBox.Show("PASSWORD VERIFICATION IS REQUIRED !!", "ERROR");
                password2.Focus();
                return;
            }
            if (password.Text.Trim() != password2.Text.Trim())
            {
                MessageBox.Show("PASSWORD AND PASSWORD VERIFICATION ARE MISMATCHED !!", "ERROR");
                password.Focus();
                return;
            }

            String QueryString = "UPDATE USERS SET password='******' WHERE user_id=" + GF.selected_id.ToString();

            GF.showLoading(this);
            DB.beginTrans();
            if (DB.set(QueryString, "UPDATE USER"))
            {
                DB.close();
                GF.closeLoading();

                ((btn_dgv)this.Owner.Controls["btn_dgv"]).refresh_btn.PerformClick();
                this.Close();
            }
            else
            {
                MessageBox.Show("ERROR UPDATE USER !!", "ERROR");
                GF.closeLoading();
                return;
            }
        }
예제 #2
0
        private void save_btn_Click(object sender, EventArgs e)
        {
            if (password.Text.Trim() == "")
            {
                MessageBox.Show("PLEASE ENTER NEW PASSWORD !!", "ERROR");
                password.Focus();
                return;
            }

            if (password2.Text.Trim() == "")
            {
                MessageBox.Show("PLEASE ENTER THE VERIFY PASSWORD !!", "ERROR");
                password2.Focus();
                return;
            }

            if (password.Text.Trim() != password2.Text.Trim())
            {
                MessageBox.Show("NEW PASSWORD AND VERIFY PASSWORD ARE MISMATCHED !!", "ERROR");
                password2.Focus();
                return;
            }

            String queryString = "UPDATE USERS SET PASSWORD = '******' WHERE USER_ID = " + GF.user_id.ToString();

            GF.showLoading(this);
            DB.beginTrans();
            if (!DB.set(queryString, "CHANGE PASSWORD FOR USER_ID[" + GF.user_id.ToString() + "]"))
            {
                MessageBox.Show("ERROR UPDATE PASSWORD !!", "ERROR");
                GF.closeLoading();
                return;
            }
            DB.close();
            MessageBox.Show("PASSWORD IS UPDATED !!", "COMPLETED");
            GF.closeLoading();
            this.Close();
        }
예제 #3
0
        private void add_btn_Click(object sender, EventArgs e)
        {
            if (username.Text.Trim() == "")
            {
                MessageBox.Show("USERNAME IS REQUIRED !!", "ERROR");
                username.Focus();
                return;
            }
            if (password.Text.Trim() == "")
            {
                MessageBox.Show("PASSWORD IS REQUIRED !!", "ERROR");
                password.Focus();
                return;
            }
            if (password2.Text.Trim() == "")
            {
                MessageBox.Show("PASSWORD VERIFICATION IS REQUIRED !!", "ERROR");
                password.Focus();
                return;
            }
            if (password.Text.Trim() != password2.Text.Trim())
            {
                MessageBox.Show("PASSWORD AND PASSWORD VERIFICATION ARE MISMATCHED !!", "ERROR");
                password.Focus();
                return;
            }
            if (emp_id.Text == "")
            {
                MessageBox.Show("YOU DID NOT CHOOSE EMPLOYEE !!", "ERROR");
                emp_id.Focus();
                return;
            }
            String QueryString = "SELECT * FROM USERS WHERE USERNAME = '******'";

            Dictionary <string, string> Params = new Dictionary <string, string>();

            //Params.Add("@username", username.Text);

            using (DataTable DT = DB.getS(QueryString, Params, "CHECK IF USERNAME EXISTED", false))
            {
                if (DT.Rows.Count > 0)
                {
                    MessageBox.Show("THIS USERNAME IS ALREADY EXISTED IN DATABASE !!", "ERROR");
                    return;
                }
            }

            DataTable myDT;
            String    unique_key = "";

            do
            {
                unique_key  = new Random().Next(1000000).ToString();
                QueryString = "SELECT COUNT(*) ROW_COUNT FROM USERS WHERE UNIQUE_KEY = '" + unique_key + "'";
                myDT        = DB.getS(QueryString, null, "CHECK IF THE UNIQUE KEY IS USED.", false);
            } while (Convert.ToInt32(myDT.Rows[0]["ROW_COUNT"].ToString()) > 0);
            myDT.Dispose();

            QueryString = @"
                INSERT INTO USERS ( username, password, emp_id, created_date, created_by, unique_key)
                VALUES (
                    '" + username.Text.Trim().Replace("'", "''") + @"', 
                    '" + GF.SHA256_encode(password.Text.Trim()) + @"', ";
            if (emp_id.currentID == -1)
            {
                QueryString += "NULL";
            }
            else
            {
                QueryString += emp_id.currentID.ToString();
            }
            QueryString += @", CONVERT(DATETIME, '" + GF.NOW() + "', 103), ";

            QueryString += GF.user_id.ToString() + ", '" + unique_key + "')";
            GF.showLoading(this);
            DB.beginTrans();
            if (DB.set(QueryString, "CREATE NEW USER"))
            {
                DB.close();
                GF.closeLoading();

                ((btn_dgv)this.Owner.Controls["btn_dgv"]).refresh_btn.PerformClick();
                this.Close();
            }
            else
            {
                MessageBox.Show("ERROR INSERT INTO DATABASE !!", "ERROR");
                GF.closeLoading();
                return;
            }
        }