private void Edu_Click(object sender, EventArgs e) { this.Hide(); SignUp_EducationalDetails edu = new SignUp_EducationalDetails(); edu.Show(); }
private void EdDet_Click(object sender, System.EventArgs e) { this.Hide(); SignUp_EducationalDetails educationalDetails = new SignUp_EducationalDetails(); educationalDetails.Show(); }
private void Validate_Click(object sender, EventArgs e) { //Doing Validation if (LastNameBox.Text == "Last Name" || LastNameBox.Text == "") { MessageBox.Show("You have not entered Your Last Name", "Missing Last Name", MessageBoxButtons.RetryCancel, MessageBoxIcon.Error); } else if (FirstNameBox.Text == "First Name" || FirstNameBox.Text == "") { MessageBox.Show("You have not entered Your First Name", "Missing First Name", MessageBoxButtons.RetryCancel, MessageBoxIcon.Error); } else if (eMailAddBox.Text == "") { MessageBox.Show("You have not entered your email address", "Missing Email Address", MessageBoxButtons.RetryCancel, MessageBoxIcon.Error); } else if (DomainComboBox.Text == "") { MessageBox.Show("You have not selected email domain", "Missing Email Domain", MessageBoxButtons.RetryCancel, MessageBoxIcon.Error); } else if (BirthDatePicker.Value == DateTime.Today) { MessageBox.Show("Invalid Date Entered", "Wrong Date Input", MessageBoxButtons.RetryCancel); } /*else if (textGenderbox.Text == "") * { * MessageBox.Show("You have not Selected Gender", "Gender Missing", MessageBoxButtons.RetryCancel, MessageBoxIcon.Error); * }*/ else if (textAdd1.Text == "") { MessageBox.Show("You have not entered your Address", "Missing Address", MessageBoxButtons.RetryCancel, MessageBoxIcon.Error); } else if (textLandmark.Text == "") { MessageBox.Show("You have not entered your Landmark", "Missing Landmark", MessageBoxButtons.RetryCancel, MessageBoxIcon.Error); } else if (textNationality.Text == "") { MessageBox.Show("You have not selected your Nationality", "Missing Naationality", MessageBoxButtons.RetryCancel, MessageBoxIcon.Error); } else if (textState.Text == "") { MessageBox.Show("You have not selected your State", "Missing State", MessageBoxButtons.RetryCancel, MessageBoxIcon.Error); } else if (textCity.Text == "") { MessageBox.Show("You have not selcted your City", "Missing City", MessageBoxButtons.RetryCancel, MessageBoxIcon.Error); } else if (textPin.Text == "") { MessageBox.Show("You have not entered your PIN", "Missing PIN Code", MessageBoxButtons.RetryCancel, MessageBoxIcon.Error); } /*else if (textPin.Text.Length != 6) * { * MessageBox.Show("Incorrect PIN Code", "Wrong PIN Code", MessageBoxButtons.RetryCancel, MessageBoxIcon.Error); * }*/ else if (textMobile.Text == "") { MessageBox.Show("You have not entered your Mobile Number", "Missing Mobile Number", MessageBoxButtons.RetryCancel, MessageBoxIcon.Error); } /*else if(textMobile.Text.Length != 10) * { * MessageBox.Show("Incorrect Mobile Number", "Wrong Mobile Number", MessageBoxButtons.RetryCancel, MessageBoxIcon.Error); * }*/ else { //Connection & Data Input Will be Here //Opening Connection ServerInfo.MySQLConnect.Open(); //Creating Command MySqlCommand mySqlCommand = new MySqlCommand(); //Connecting command mySqlCommand.Connection = ServerInfo.MySQLConnect; string commandone = "Select count(*) from UserMaster Where UserName = '******' " + "and UserPassword = '******' "; string commandtwo = "INSERT INTO `MastersSchema`.`UserMaster` (`UserName`, `UserPassword`) " + "VALUES ('" + UserTextBox.Text + "', '" + PassTextBox.Text + "');"; string commandthree = "INSERT INTO `MastersSchema`.`NameMaster` (`LastName`, `FirstName`, `MiddleName`, " + "`UsernameID`) " + "VALUES ('" + LastNameBox.Text + "', '" + FirstNameBox.Text + "', '" + MiddleNameBox.Text + "', '');"; mySqlCommand.CommandText = commandone; mySqlCommand.ExecuteNonQuery(); MySqlDataAdapter MySQLDataAdapt = new MySqlDataAdapter(mySqlCommand); //Creating a new Data Table DataTable DatTable = new DataTable(); MySQLDataAdapt.Fill(DatTable); int i = Convert.ToInt32(DatTable.Rows.Count.ToString()); if (i == 1) { mySqlCommand.CommandText = commandtwo; mySqlCommand.ExecuteNonQuery(); mySqlCommand.CommandText = commandthree; mySqlCommand.ExecuteNonQuery(); this.Hide(); SignUp_EducationalDetails educationalDetails = new SignUp_EducationalDetails(); } else if (i == 0) { MessageBox.Show("User Already Exists, kindly Sign In", "User Exist", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("Something Went Wrong\nLine 196 PrimDet", "Error Occurred", MessageBoxButtons.OK, MessageBoxIcon.Error); } //mySqlCommand.CommandText = commandtwo; //mySqlCommand.CommandText = commandthree; } }