private void AddMember(object sender, RoutedEventArgs e)
{
DateTime dob = DateTime.Today;
string firstName = FirstNameTextBox.Text;
string lastName = LastNameTextBox.Text;
string idNumber = IdNumTextBox.Text;
string cellPhone = CellphoneTextBox.Text;
string email = EmailTextBox.Text;
string address = AddressTextBox.Text;
//Make sure DOB is not blank
if (DOBDatePicker.SelectedDate.HasValue)
{
dob = DOBDatePicker.SelectedDate.Value;
}
else {
DisplayError("Please enter a valid date for Date of Birth.");
}
//Error handling First Name
if (firstName.Length == 0){
DisplayError("Please enter a valid first name.");
}
//Error handling Last Name
if (lastName.Length == 0){
DisplayError("Please enter a valid last name.");
}
//Error handling Id number
if (idNumber.Length == 0){
DisplayError("Please enter a valid Id Number.");
}
Member m = new Member();
m.stokvel_idStr = stokvel_id;
m.firstNameStr = firstName;
m.lastNameStr = lastName;
m.idNumberStr = idNumber;
m.emailStr = email;
m.cellPhoneStr = cellPhone;
m.addressStr = address;
m.dobDt = dob;
m.insert();
//Check if user is busy with Wizard and continue if true.
if (StaticStokvel.wizard)
{
MessageBoxResult result = MessageBox.Show("Would you like to verify this member now?", "Verify Member", MessageBoxButton.YesNo, MessageBoxImage.Question);
if (result == MessageBoxResult.Yes)
{
//Get member OTP
var connectionString = ConfigurationManager.ConnectionStrings["conString"].ConnectionString;
string CmdString;
using (SqlConnection con = new SqlConnection(connectionString))
{
Console.WriteLine(StaticMemberOTP.member_id);
CmdString = String.Format("select OTP from member_otp where member_id = {0}", StaticMemberOTP.member_id);
SqlCommand cmd = new SqlCommand(CmdString, con);
SqlDataAdapter sda = new SqlDataAdapter(cmd);
DataTable dt = new DataTable("MemberID");
sda.Fill(dt);
foreach (DataRow row in dt.Rows)
{
StaticMemberOTP.otp = row["OTP"].ToString();
string number = cellPhone.Substring(1, 9);
number = String.Concat("27", number);
Sms_OTP_Send.SmsSendYes(StaticMemberOTP.otp, number);
Member_Verification_OTP mvo = new Member_Verification_OTP();
mvo.Show();
}
}
}
}
this.Close();
}
private void AddMember(object sender, RoutedEventArgs e)
{
DateTime dob = DateTime.Today;
string firstName = FirstNameTextBox.Text;
string lastName = LastNameTextBox.Text;
string idNumber = IdNumTextBox.Text;
string cellPhone = CellphoneTextBox.Text;
string email = EmailTextBox.Text;
string address = AddressTextBox.Text;
//Make sure DOB is not blank
if (DOBDatePicker.SelectedDate.HasValue)
{
dob = DOBDatePicker.SelectedDate.Value;
}
else
{
DisplayError("Please enter a valid date for Date of Birth.");
}
//Error handling First Name
if (firstName.Length == 0)
{
DisplayError("Please enter a valid first name.");
}
//Error handling Last Name
if (lastName.Length == 0)
{
DisplayError("Please enter a valid last name.");
}
//Error handling Id number
if (idNumber.Length == 0)
{
DisplayError("Please enter a valid Id Number.");
}
Member m = new Member();
m.stokvel_idStr = stokvel_id;
m.firstNameStr = firstName;
m.lastNameStr = lastName;
m.idNumberStr = idNumber;
m.emailStr = email;
m.cellPhoneStr = cellPhone;
m.addressStr = address;
m.dobDt = dob;
m.insert();
//Check if user is busy with Wizard and continue if true.
if (StaticStokvel.wizard)
{
MessageBoxResult result = MessageBox.Show("Would you like to verify this member now?", "Verify Member", MessageBoxButton.YesNo, MessageBoxImage.Question);
if (result == MessageBoxResult.Yes)
{
//Get member OTP
var connectionString = ConfigurationManager.ConnectionStrings["conString"].ConnectionString;
string CmdString;
using (SqlConnection con = new SqlConnection(connectionString))
{
Console.WriteLine(StaticMemberOTP.member_id);
CmdString = String.Format("select OTP from member_otp where member_id = {0}", StaticMemberOTP.member_id);
SqlCommand cmd = new SqlCommand(CmdString, con);
SqlDataAdapter sda = new SqlDataAdapter(cmd);
DataTable dt = new DataTable("MemberID");
sda.Fill(dt);
foreach (DataRow row in dt.Rows)
{
StaticMemberOTP.otp = row["OTP"].ToString();
string number = cellPhone.Substring(1, 9);
number = String.Concat("27", number);
Sms_OTP_Send.SmsSendYes(StaticMemberOTP.otp, number);
Member_Verification_OTP mvo = new Member_Verification_OTP();
mvo.Show();
}
}
}
}
this.Close();
}
