private void svechngesbtn_Click(object sender, EventArgs e)
        {
            if (!string.IsNullOrWhiteSpace(firstnametxtbox.Text) && (!string.IsNullOrWhiteSpace(usernametxtbox.Text) && (!string.IsNullOrWhiteSpace(passwordtxtbox.Text) && (!string.IsNullOrWhiteSpace(roletxtbox.Text)))))
            {
                DBSQL insert = new DBSQL(_conn);
                if (insert.checkusereExist(usernametxtbox.Text) > 0)//בדיקת שהמשתמש לא קיים
                {
                    MessageBox.Show("This Username Is Already Exist");
                }
                else
                {
                    User newUsr = new User();
                    newUsr.Firstname = firstnametxtbox.Text;
                    newUsr.Username  = usernametxtbox.Text;
                    newUsr.Pass      = passwordtxtbox.Text;
                    newUsr.Role      = roletxtbox.Text;

                    try
                    {
                        insert.addUser(newUsr);
                        MessageBox.Show("The new User has been added successfuly");
                        AllUserData frm = new AllUserData();
                        frm.Show();
                    }
                    catch (Exception ex)
                    {
                        MessageBox.Show("Error " + ex);
                    }
                }
            }
            else
            {
                MessageBox.Show("Please insert the all details");
            }
        }
Beispiel #2
0
        private void delusrbtn_Click(object sender, EventArgs e)
        {
            if (!string.IsNullOrEmpty(usrtodeltxtbox.Text))
            {
                User delusr = new User();
                delusr.Username = usrtodeltxtbox.Text;
                try
                {
                    DBSQL delete = new DBSQL(_conn);

                    delete.deleteUser(delusr);
                    MessageBox.Show("The User Has been Deleted ");
                    AllUserData frm = new AllUserData();
                    frm.Show();
                    this.Close();
                }
                catch (Exception ex)
                {
                    MessageBox.Show("Error " + ex);
                }
            }
        }
        private void button1_Click_1(object sender, EventArgs e)
        {
            AllUserData frm = new AllUserData();

            frm.Show();
        }