private void SigninButton_Click(object sender, EventArgs e) { try { /*when you type default, look for the link to the database you have made*/ string ConnectionString = Properties.Settings.Default.UsersDBConnectionString; string MySQLString; int MaxRows = 0; int Counter = 0; /* this links to the database connection and calls it object connection */ DatabaseConnection objConnect = new DatabaseConnection(); DataSet mydataset; DataRow RecordFromADatabase; objConnect.connection_string = ConnectionString; //to do, test this validation routine for encryptedpassword ValidationRoutines CheckDataEntry = new ValidationRoutines(); CheckDataEntry.GetPassword = PasswordTextBox.Text; MySQLString = "(((SELECT UserID, Firstname, Email FROM Users WHERE Username = '******' AND UserPassword = '******'"; objConnect.SQL = MySQLString; objConnect.SQL = objConnect.PreventInjection(); mydataset = objConnect.GetConnection; //if the record is found, get the data from the database that has been retrieved. MaxRows = mydataset.Tables[0].Rows.Count; if (MaxRows > 0) { //this pulls out username firstname from the database, could pull more if necessary. RecordFromADatabase = mydataset.Tables[0].Rows[Counter]; ProfileRoutines setupUserProfile = new ProfileRoutines(); setupUserProfile.GetUserID = int.Parse(RecordFromADatabase.ItemArray.GetValue(0).ToString()); setupUserProfile.GetFirstname = RecordFromADatabase.ItemArray.GetValue(1).ToString(); setupUserProfile.GetUsername = UsernameTextBox.Text; setupUserProfile.GetEmail = EmailTextBox.Text; this.Hide(); SplashPage DisplaySplashForm = new SplashPage(setupUserProfile); DisplaySplashForm.Show(); } else { //password error message ErrorLabel.ForeColor = System.Drawing.Color.Red; ErrorLabel.Text = "Invalid Username/Password Combination, please try again"; } } catch (Exception err) { MessageBox.Show(err.Message); } }
public SplashPage(ProfileRoutines setupUserProfile) { InitializeComponent(); SingleUserProfile = setupUserProfile; }
private void SignUpFinalButton_Click(object sender, EventArgs e) { string errormessage = ""; //TODO change this into a function? can i send controls to a function //check each of the entries in the group boxes for a value foreach (Control control in this.LoginGroup.Controls) { if (control is TextBox) { //check each of the items in the group to see if any of the information is blank if (control.Text == "") { //remove the word textbox from the name of the box, so it writes the error correctly string textboxname = control.Name.Replace("TextBox", " "); errormessage = errormessage + textboxname + "is missing a value, please try again"; } errormessage = errormessage + "\n\n"; } } // check each of the entries in the signup boxes for a value, have to do 2 of these because there are 2 groups of entry foreach (Control control in this.SignupGroup.Controls) { if (control is TextBox) { //check if any of the information in this group of boxes is blank if (control.Text == "") { //remove the word textbox from the name of the box, so it writes the error correctly string textboxname = control.Name.Replace("textBox", ""); errormessage = errormessage + textboxname + " is missing a value, please try again"; } //add this every time so errors appear in line errormessage = errormessage + "\n\n"; } } //set up the class for the validationroutines ValidationRoutines CheckDataEntry = new ValidationRoutines(); //Build function, encrypt password CheckDataEntry.GetPassword = PasswordTextBox.Text; CheckDataEntry.GetSecondPassword = ConfirmPasswordTextBox.Text; CheckDataEntry.GetEmail = EmailTextBox.Text; // verify password if (!CheckDataEntry.VerifyData()) { errormessage = errormessage + "\n passwords do not match"; } else { errormessage = errormessage + CheckDataEntry.checkpassword(); } //call validation routine to check an email. if (!CheckDataEntry.VerifyEmail()) { errormessage = errormessage + "\n email is not valid"; } //strip out the layout spaces errormessage = errormessage.Replace("\n", ""); //final check to display the message onto the screen if (errormessage != "") { ErrorLabel.Font = new Font("Century Gothic", 11); ErrorLabel.ForeColor = System.Drawing.Color.Red; ErrorLabel.Text = errormessage; } else if (errormessage == "") { //Generate the security code string securitycode = ""; securitycode = ValidationRoutines.GenerateSecurityCode(); //not sure if this is agood idea, need to think of the user, but there are a lot of text boxes....may have to go back to layout //send the confirmation email EmailRoutines sendConfirmEmail = new EmailRoutines(); sendConfirmEmail.SetWebsiteName = PROJECTNAME; sendConfirmEmail.GetUserEmail = EmailTextBox.Text; //put the signin code into their email sendConfirmEmail.addtoHTML = "<p>your signin code is " + securitycode + "</p>"; sendConfirmEmail.sendConfirmationEmail(); //this will all move to the new form, once i've made it. string passwordtoinsert = CheckDataEntry.encryptPassword(); ProfileRoutines setupUserProfile = new ProfileRoutines(); setupUserProfile.GetUsername = UsernameTextBox.Text; setupUserProfile.GetEmail = EmailTextBox.Text; setupUserProfile.GetFirstname = FirstNameTextbox.Text; setupUserProfile.GetPW = passwordtoinsert; this.Hide(); SecurityCodeForm DisplaySecurityForm = new SecurityCodeForm(setupUserProfile, securitycode); DisplaySecurityForm.Show(); } }
public SecurityCodeForm(ProfileRoutines SetupUserProfile, string PassedSecurityCode) { InitializeComponent(); SingleUserProfile = SetupUserProfile; Securitycode = PassedSecurityCode; }