//Common function to process login. To be called by other functions //processing shop login private void processLogin() { //RMEOVE JSDLKSDJHLSJDLJDKSJDLS var applicationForm = new ShopEntryForm(); applicationForm.Show(); this.Close(); //REMOVE KSLFNSLDHLSKDJSLDJLSDKJSLDK string query = "SELECT " + LOGIN_USERNAME_FIELD + " FROM " + LOGIN_TABLE + " WHERE " + LOGIN_USERNAME_FIELD + "=" + BaseConnection.STRING_SEPARATOR + MySqlHelper.EscapeString(userNameText.Text) + BaseConnection.STRING_SEPARATOR + " AND " + LOGIN_PASSWORD_FIELD + "=MD5(" + BaseConnection.STRING_SEPARATOR + MySqlHelper.EscapeString(passwordText.Text) + BaseConnection.STRING_SEPARATOR + ")"; MySqlDataReader queryOutcome = singletonConnection.queryResult(query); if (queryOutcome != null) { processLoginQuery(queryOutcome); } else { errorSignal.ForeColor = Color.Red; errorSignal.Text = LOGIN_CONNECTION_FAILED; } }
//Function process login query based on outcome provided private void processLoginQuery(MySqlDataReader queryOutcome) { int rowCount = 0; string username = ""; while (queryOutcome.Read()) { username = (string) queryOutcome[LOGIN_USERNAME_FIELD]; rowCount++; } //Only one username/password combination should exist if (rowCount == 1) { singletonConnection.setBaseUser(username); var applicationForm = new ShopEntryForm(); applicationForm.Show(); this.Close(); } else { errorSignal.ForeColor = Color.Red; errorSignal.Text = LOGIN_COMBINATION_FAILED; } }