예제 #1
0
        private void login()
        {
            try
            {
                Varibles.setConnection();
                cmd = Varibles.getCommand();

                String username = userNametextBox.Text;
                String pass     = PasstextBox.Text;

                if (username == "MMM" && pass == "M123M123M")
                {
                    DBConfiguration form = new DBConfiguration();
                    this.Hide();
                    form.ShowDialog();
                    this.Close();
                }
                else
                {
                    String condition = "USR_NAME LIKE '" + username + "' AND " + "USR_PASS LIKE '" + pass + "' ";
                    cmd.CommandText = "SELECT        USR_NAME , USR_ID" +
                                      " FROM            merp.users" +
                                      " WHERE        ( " + condition + " )";



                    reader = cmd.ExecuteReader();
                    int usr_id = 0;
                    while (reader.Read())
                    {
                        usr_id = reader.GetInt32("USR_ID");
                        break;
                    }

                    Varibles.setUserId(usr_id);


                    if (reader.HasRows)
                    {
                        MainForm form = new MainForm();
                        this.Hide();
                        form.ShowDialog();
                        this.Close();
                    }
                    else
                    {
                        MessageBox.Show("اسم المستخدم او كلمة المرور خاطئة");
                    }

                    reader.Close();
                    Varibles.closeConnection();
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }
예제 #2
0
 private void LoginForm_Load(object sender, EventArgs e)
 {
     if (!Varibles.getValidConnection())
     {
         try
         {
             DBConfiguration form = new DBConfiguration();
             this.Hide();
             form.ShowDialog();
             this.Close();
         }
         catch (Exception ex)
         {
             MessageBox.Show(ex.Message);
         }
     }
 }