Ejemplo n.º 1
0
        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
            }
        }
Ejemplo n.º 2
0
        // 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;
            }
        }