private void buttonRegister_Click(object sender, EventArgs e)
{
// Set variables with the values from the textboxes
classification = classificationComboBox.Text;
first_name = first_NameTextBox.Text;
last_name = last_NameTextBox.Text;
// date_of_birth = date_of_BirthDateTimePicker.Value.Date;
gender = genderComboBox.Text;
street_address = street_AddressTextBox.Text;
city = cityTextBox.Text;
state = stateTextBox.Text;
zip_code = zip_CodeTextBox.Text;
password = passwordTextBox.Text;
username = usernameTextBox.Text;
email = emailTextBox.Text;
phone_number = phone_NumberTextBox.Text;
if (classification == "Patient")
{
social_security_number = social_Security_NumberTextBox.Text;
age = int.Parse(ageTextBox.Text);
// need to calculate the age...
// for testing
// age = ageTextBox.Text;
country_of_origin = country_of_OriginTextBox.Text;
insurance_Provider = health_Insurance_ProviderTextBox.Text;
insurance_Contact_Number = health_Insurance_Contact_NumberTextBox.Text;
medical_history = medical_HistoryTextBox.Text;
doctor = doctor_NameComboBox.Text;
}
// After user presses the Register button, they will receive a prompt
// Do they want to login as the newly registered user? Yes, No, or Cancel
string message = "Would you like to login as this user now?";
string title = "Do you want to Login as this newly registered user?";
MessageBoxButtons buttons = MessageBoxButtons.YesNoCancel;
DialogResult result = MessageBox.Show(message, title, buttons);
if (result == System.Windows.Forms.DialogResult.Yes)
{
//Register user
Register();
//Show the LoggingIn form for user to login
this.Close();
LoggingIn formLI = new LoggingIn();
formLI.Visible = true;
}
else if (result == System.Windows.Forms.DialogResult.No)
{
//Register user
Register();
//Show the Welcome form for current user to continue using IPIMS
this.Close();
try
{
Welcome formW = new Welcome();
formW.Visible = true;
}
catch (Exception ex)
{
throw ex;
}
}
else if (result == System.Windows.Forms.DialogResult.Cancel)
{
// Do Nothing, and return to registration form
}
}
// Function to call when the code should implement registration features
void Register()
{
try
{
// Validate form and stop editing databinding source reader
this.Validate();
this.user_dataBindingSource1.EndEdit();
string connectionString = (@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\E860536\Source\Group_9\IPIMS_9\IPIMS_9\IPIMS_Group_9\IPIMS_Group_9\IPIMS_9.mdf;Integrated Security=True");
using (SqlConnection connection = new SqlConnection(connectionString))
{
SqlCommand cmd = new SqlCommand("INSERT INTO user_data (Classification,First_Name,Last_Name,Gender,Social_Security_Number,Street_Address,City,State,Zip_Code,Phone_Number,Email,Username,Password) VALUES (@Classification, @First_Name, @Last_Name, @Gender, @Social_Security_Number, @Street_Address, @City, @State, @Zip_Code, @Phone_Number, @Email, @Username, @Password)");
cmd.CommandType = CommandType.Text;
cmd.Connection = connection;
cmd.Parameters.AddWithValue("@Classification", classification.ToString());
cmd.Parameters.AddWithValue("@First_Name", first_name.ToString());
cmd.Parameters.AddWithValue("@Last_Name", last_NameTextBox.Text);
cmd.Parameters.AddWithValue("@Gender", gender.ToString());
cmd.Parameters.AddWithValue("@Social_Security_Number", social_security_number.ToString());
cmd.Parameters.AddWithValue("@Street_Address", street_address.ToString());
cmd.Parameters.AddWithValue("@City", city.ToString());
cmd.Parameters.AddWithValue("@State", state.ToString());
cmd.Parameters.AddWithValue("@Zip_Code", zip_code.ToString());
cmd.Parameters.AddWithValue("@Phone_Number", phone_number.ToString());
cmd.Parameters.AddWithValue("@Email", email.ToString());
cmd.Parameters.AddWithValue("@Username", username.ToString());
cmd.Parameters.AddWithValue("@Password", password.ToString());
connection.Open();
cmd.ExecuteNonQuery();
}
using (SqlConnection connection = new SqlConnection(connectionString))
{
SqlCommand cmdPatient = new SqlCommand("INSERT INTO patient_data (Classification,First_Name,Last_Name,Age,Country_of_Origin,Health_Insurance_Provider,Health_Insurance_Contact_Number,Medical_History,Is_Smoker,Is_Drug_User,Doctor_Name) VALUES (@Classification, @First_Name, @Last_Name, @Age, @Country_of_Origin, @Health_Insurance_Provider, @Health_Insurance_Contact_Number, @Medical_History, @Is_Smoker, @Is_Drug_User, @Doctor_Name)");
cmdPatient.CommandType = CommandType.Text;
cmdPatient.Connection = connection;
cmdPatient.Parameters.AddWithValue("@Classification", classification.ToString());
cmdPatient.Parameters.AddWithValue("@First_Name", first_name.ToString());
cmdPatient.Parameters.AddWithValue("@Last_Name", last_NameTextBox.Text);
cmdPatient.Parameters.AddWithValue("@Age", age);
cmdPatient.Parameters.AddWithValue("@Country_of_Origin", country_of_origin.ToString());
cmdPatient.Parameters.AddWithValue("@Health_Insurance_Provider", health_Insurance_ProviderTextBox.Text);
cmdPatient.Parameters.AddWithValue("@Health_Insurance_Contact_Number",health_Insurance_Contact_NumberTextBox.Text);
cmdPatient.Parameters.AddWithValue("@Medical_History", medical_history.ToString());
cmdPatient.Parameters.AddWithValue("@Is_Smoker", is_SmokerCheckBox.CheckState.ToString());
cmdPatient.Parameters.AddWithValue("@Is_Drug_User", is_Drug_UserCheckBox.CheckState.ToString());
cmdPatient.Parameters.AddWithValue("@Doctor_Name", doctor.ToString());
connection.Open();
cmdPatient.ExecuteNonQuery();
}
// Create a new row with the values from the form
// Create new row for user data and patient data tables
// IPIMS_9DataSet.user_dataRow newUserDataRow;
// IPIMS_9DataSet.patient_dataRow newPatientDataRow;
/* newUserDataRow = iPIMS_9DataSet.user_data.Newuser_dataRow();
newPatientDataRow = iPIMS_9DataSet.patient_data.Newpatient_dataRow();
// Fill the new user data row with the variable data
newUserDataRow.Classification = classification.ToString();
newUserDataRow.First_Name = first_name.ToString();
newUserDataRow.Last_Name = last_name.ToString();
newUserDataRow.Gender = gender.ToString();
newUserDataRow.Date_of_Birth = date_of_birth.Date;
newUserDataRow.Street_Address = street_address.ToString();
newUserDataRow.City = city.ToString();
newUserDataRow.State = state.ToString();
newUserDataRow.Zip_Code = zip_code.ToString();
newUserDataRow.Phone_Number = phone_number.ToString();
newUserDataRow.Email = email.ToString();
newUserDataRow.Username = username.ToString();
newUserDataRow.Password = password.ToString();
newUserDataRow.Social_Security_Number = "000-00-0000";
//Add the row to the user_data table
this.iPIMS_9DataSet.user_data.Rows.Add(newUserDataRow);
//Save the new rows to the database
this.user_dataTableAdapter.Update(this.iPIMS_9DataSet.user_data);
if (classification == "Patient")
{
//newPatientDataRow details
newPatientDataRow.Classification = classification.ToString();
newPatientDataRow.First_Name = first_name.ToString();
newPatientDataRow.Last_Name = last_name.ToString();
newPatientDataRow.Date_of_Birth = date_of_birth.Date;
newUserDataRow.Social_Security_Number = social_security_number.ToString();
newPatientDataRow.Age = age;
newPatientDataRow.Medical_History = medical_history.ToString();
newPatientDataRow.Country_of_Origin = country_of_origin.ToString();
newPatientDataRow.Health_Insurance_Provider = insurance_Provider.ToString();
newPatientDataRow.Health_Insurance_Contact_Number = insurance_Contact_Number.ToString();
newPatientDataRow.Doctor_Name = doctor.ToString();
if (smoker == false)
{
newPatientDataRow.Is_Smoker = false;
}
else
{
newPatientDataRow.Is_Smoker = true;
}
if (drug_user == false)
{
newPatientDataRow.Is_Drug_User = false;
}
else
{
newPatientDataRow.Is_Drug_User = true;
}
//Add the row to the patient_data table
this.iPIMS_9DataSet.patient_data.Rows.Add(newPatientDataRow);
this.patient_dataTableAdapter.Update(this.iPIMS_9DataSet.patient_data);
}
*/
// this.user_dataTableAdapter.Insert(classification.ToString(), first_name.ToString(), last_name.ToString(), date_of_birth.Date, gender.ToString(), social_security_number.ToString(), street_address.ToString(), city.ToString(), state.ToString(), zip_code.ToString(), phone_number.ToString(), email.ToString(), username.ToString(), password.ToString());
}
catch (Exception ex)
{
//throw ex;
this.Close();
LoggingIn formLog = new LoggingIn();
formLog.Visible = true;
}
}