private void btnNext_Click(object sender, EventArgs e) { try { conn.Open(); MySqlCommand comm = new MySqlCommand("INSERT INTO member_tbl(firstName, middleName, lastName, " + "nickName, birthdate, gender, civilStatus, citizenship, homeAddress, homePhoneNumber, contactNum, emailAd, " + "occupation, companyName, companyContactNum, companyAddress, schoolName, schoolContactNum, " + "schoolAddress, spouseName, spouseContactNum, spouseBirthdate, memberType) VALUES('" + txtFirstName.Text + "', '" + txtMiddleName.Text + "', " + "'" + txtLastName.Text + "', '" + txtNickName.Text + "', '" + convertBirthDate()[0] + "', " + "'" + convertGender() + "','" + convertCivilStatus() + "', '" + convertCitizenship() + "', " + "'" + txtHomeAddress.Text + "', '" + txtHomeNumber.Text + "', '" + txtMobileNumber.Text + "', " + "'" + txtEmailAddress.Text + "', '" + txtProfession.Text + "', '" + txtCompanySchoolName.Text + "', " + "'" + txtCompanyPhoneNumber.Text + "', '" + txtCompanySchoolAddress.Text + "', " + "'" + txtCompanySchoolName.Text + "', '" + txtCompanyPhoneNumber.Text + "', " + "'" + txtCompanySchoolAddress.Text + "', '" + txtSpouse.Text + "', '" + txtMobileNumberSpouse.Text + "', " + "'" + convertBirthDate()[1] + "', 0);", conn); comm.ExecuteNonQuery(); conn.Close(); FormRegisterUsePass frmregisterusepass = new FormRegisterUsePass(); frmregisterusepass.reference_to_frmregisternewcomer = this; frmregisterusepass.reference_to_frmlogin = reference_to_frmlogin; this.Hide(); frmregisterusepass.Show(); } catch (Exception ex) { } }
private void btnNext_Click(object sender, EventArgs e) { try { memberID = reference_to_frmregisterdgroup.getMemberID(); conn.Open(); MySqlCommand comm1 = new MySqlCommand("UPDATE discipleshipgroupmembers_tbl SET dgroupID = " + dgroupID + ", " + "memberID = " + memberID + " WHERE dgroupmemberID = " + getDgroupMemberID() + ";", conn); comm1.ExecuteNonQuery(); conn.Close(); FormRegisterUsePass frmregisterusepass = new FormRegisterUsePass(); frmregisterusepass.reference_to_frmchooseleader = this; frmregisterusepass.reference_to_frmlogin = reference_to_frmlogin; this.Hide(); frmregisterusepass.Show(); } catch (Exception ex) { } }