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;
}
}
