Beispiel #1
0
 private void btnEndorse_Click(object sender, EventArgs e)
 {
     try
     {
         insertEndorsee();
         FormHome frmHome = new FormHome();
         this.Hide();
         frmHome.Show();
     }
     catch (Exception ex)
     {
     }
 }
Beispiel #2
0
 private void btnLogin_Click(object sender, EventArgs e)
 {
     try
     {
         conn.Open();
         MySqlCommand     comm = new MySqlCommand("SELECT * FROM member_tbl WHERE membUsername = '******';", conn);
         MySqlDataAdapter adp  = new MySqlDataAdapter(comm);
         DataTable        dt   = new DataTable();
         adp.Fill(dt);
         if (dt.Rows.Count == 1)
         {
             user       = dt.Rows[0]["membUsername"].ToString();
             pass       = dt.Rows[0]["membPassword"].ToString();
             membertype = int.Parse(dt.Rows[0]["memberType"].ToString());
         }
         if (txtUsername.Text == "" || txtPassword.Text == "")
         {
             MessageBox.Show("The user must supply the necessary fields.");
         }
         else if (txtUsername.Text == user && txtPassword.Text == pass && membertype <= 2)
         {
             FormHome frmhome = new FormHome();
             frmhome.reference_to_frmlogin = this;
             this.Hide();
             frmhome.Show();
         }
         else
         {
             if (txtUsername.Text != user || txtPassword.Text != pass)
             {
                 MessageBox.Show("The user credentials are incorrect.");
             }
             //else if (accstatus != 0)
             //    MessageBox.Show("The user is inactive.");
         }
         conn.Close();
     }
     catch (Exception ex)
     {
         conn.Close();
         MessageBox.Show(ex.ToString());
     }
 }
        private void btnRegister_Click(object sender, EventArgs e)
        {
            try
            {
                conn.Open();
                if (reference_to_frmchooseleader.ifFormChooseLeader())
                {
                    MySqlCommand comm = new MySqlCommand("UPDATE member_tbl SET membUsername = '******', "
                                                         + "membPassword = '******' WHERE memberID = "
                                                         + "" + reference_to_frmchooseleader.getMemberID() + ";", conn);
                    comm.ExecuteNonQuery();
                }
                else if (reference_to_frmregisternewcomer.ifFormRegisterNewComer())
                {
                    MySqlCommand comm = new MySqlCommand("UPDATE member_tbl SET membUsername = '******', "
                                                         + "membPassword = '******' WHERE memberID = "
                                                         + "" + reference_to_frmregisternewcomer.getMemberID() + ";", conn);
                    comm.ExecuteNonQuery();
                }
                conn.Close();
            }
            catch (Exception ex)
            {
                MySqlCommand comm = new MySqlCommand("UPDATE member_tbl SET membUsername = '******', "
                                                     + "membPassword = '******' WHERE memberID = "
                                                     + "" + reference_to_frmregisternewcomer.getMemberID() + ";", conn);
                comm.ExecuteNonQuery();
                //MessageBox.Show(ex.ToString());
            }
            FormHome frmhome = new FormHome();

            frmhome.reference_to_frmregisterusepass = this;
            frmhome.reference_to_frmlogin           = reference_to_frmlogin;
            username = txtUsername.Text;
            this.Hide();
            frmhome.Show();
        }