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)
{
}
}