Пример #1
0
        public static Boolean updateUser(UserLoginDTO userLoginDTO)
        {
            try
            {
                string query = "update pos.userlogin SET password=@password,position=@position,name=@name where username=@username";

                MySqlCommand command = new MySqlCommand(query, conn);
                command.Parameters.AddWithValue("@password", userLoginDTO.getPassword());
                command.Parameters.AddWithValue("@position", userLoginDTO.getPosition());
                command.Parameters.AddWithValue("@username", userLoginDTO.getUsername());
                command.Parameters.AddWithValue("@name", userLoginDTO.getName());

                conn.Open();

                if (command.ExecuteNonQuery() != 1)
                {
                    return(false);
                }
            }
            catch (Exception ex)
            {
                Console.WriteLine("Error: " + ex.Message);
                conn.Close();
                return(false);
            }

            Console.Read();
            conn.Close();
            return(true);
        }
Пример #2
0
        public static Boolean createUser(UserLoginDTO userLoginDTO)
        {
            int result = 0;

            try
            {
                String query = "INSERT INTO pos.userlogin (username,name,password,position) VALUES (@username, @name, @password,@position)";

                MySqlCommand command = new MySqlCommand(query, conn);

                //Console.WriteLine(custDTO.getNic()+" "+custDTO.getName());

                command.Parameters.AddWithValue("username", userLoginDTO.getUsername());
                command.Parameters.AddWithValue("@name", userLoginDTO.getName());
                command.Parameters.AddWithValue("@password", userLoginDTO.getPassword());
                command.Parameters.AddWithValue("@position", userLoginDTO.getPosition());

                conn.Open();

                result = command.ExecuteNonQuery();
            }
            catch (Exception ex)
            {
                Console.WriteLine("Error: " + ex.Message);
                conn.Close();
                return(false);
            }


            Console.Read();
            conn.Close();
            if (result == 1)
            {
                return(true);
            }
            else
            {
                return(false);
            }
        }
Пример #3
0
 private void Loginbtn_Click(object sender, EventArgs e)
 {
     try
     {
         /*LoginDTO loginDTO = LoginController.searchUser(int.Parse(txtUserName.text));
          * if (loginDTO.getLoginid() == int.Parse(txtUserName.text) && loginDTO.getPassword() == txtPassword.text)
          * {
          *  this.Hide();
          *  main m = new main(loginDTO.getUsername());
          *  m.ShowDialog();
          * }
          * else
          * {
          *  MessageBox.Show("Invalid Username or password ");
          *  txtUserName.text = "";
          *  txtPassword.text = "";
          *  txtUserName.Focus();
          * }*/
         UserLoginDTO loginDTO = LoginController.searchUser((txtUserName.text));
         if (loginDTO.getUsername() == txtUserName.text && loginDTO.getPassword() == txtPassword1.Text)
         {
             this.Hide();
             main m = new main(loginDTO.getName(), loginDTO.getPosition());
             m.ShowDialog();
         }
         else
         {
             MessageBox.Show("Invalid Username or password ");
             txtUserName.text  = "";
             txtPassword1.Text = "";
             txtUserName.Focus();
         }
     }
     catch (Exception ex)
     {
         MessageBox.Show("Invalid Username or password ");
         Console.WriteLine(ex.ToString());
     }
 }
Пример #4
0
        private void BtnUserSearch_Click(object sender, EventArgs e)
        {
            string       searchUser   = txtUserSearch.Text;
            UserLoginDTO userLoginDTO = LoginController.searchUser(searchUser);

            if (userLoginDTO == null)
            {
                MessageBox.Show("No user found....");
            }
            else
            {
                txtUsername.Text = userLoginDTO.getUsername();
                txtName.Text     = userLoginDTO.getName();
                if (userLoginDTO.getPosition() == "M")
                {
                    rdbManager.Checked = true;
                }
                else
                {
                    rdbUser.Checked = true;
                }
            }
        }