private void saveButton_Click(object sender, EventArgs e) { FormSelection screen = new FormSelection(); this.Hide(); screen.ShowDialog(); }
private void loginButton_Click(object sender, EventArgs e) { Username = usernameTextBox.Text; Password = passwordTextBox.Text; passwordTextBox.PasswordChar = '*'; passwordTextBox.MaxLength = 8; HDClasses.SQLCommands cmd = new HDClasses.SQLCommands(); signIn = cmd.SignInRetrieval(Username, Password); if (signIn == true) { MessageBox.Show("Welcome! "); FormSelection screen = new FormSelection(); this.Hide(); screen.ShowDialog(); } else { MessageBox.Show("This information does not match our records."); usernameTextBox.Clear(); passwordTextBox.Clear(); } }
private void saveButton_Click(object sender, EventArgs e) { lastName = lastNameTextBox.Text; firstName = firstNameTextBox.Text; middleInitial = miTextBox.Text; maritalStatus = maritalTextBox.Text; age = ageTextBox.Text; dobMonth = monthTextBox.Text; dobDay = dayTextBox.Text; dobYear = yearTextBox.Text; ssn = ssnTextBox.Text; gender = sexTextBox.Text; streetAddress = addressTextBox.Text; apt = aptTextBox.Text; city = cityTextBox.Text; state = stateTextBox.Text; zip = zipTextBox.Text; email = emailTextBox.Text; homePhone = homePhoneTextBox.Text; cellphone = cellphoneTextBox.Text; heardAbout = hearAboutTextBox.Text; primaryInsurance = textBox1.Text; primaryPhone = textBox2.Text; primaryPolicyNum = textBox3.Text; primaryCity = textBox4.Text; primaryState = textBox5.Text; secondaryInsurance = textBox12.Text; secondaryPhone = textBox11.Text; secondaryPolicyNum = textBox10.Text; secondaryCity = textBox9.Text; secondaryState = textBox8.Text; SqlConnection con; SqlDataAdapter da; con = new SqlConnection("Data Source=(LocalDB)\\MSSQLLocalDB;AttachDbFilename=C:\\Users\\Lioness\\Documents\\GitHub\\HRHelpdesk\\HRHelpdeskApp\\HRHelpdeskApp\\HRHelpdeskApp\\HDDatabase.mdf"); con.Open(); System.Data.SqlClient.SqlCommand cmmd = new SqlCommand("INSERT INTO GenInfo (LastName, FirstName, MiddleInitial, StreetAddress, " + "Apt, City, State, Zip, " + "MaritalStatus, DOBMonth, DOBDay, DOBYear, SSN, Gender, Age, " + "Email, HomePhone, Cellphone, HeardAbout," + "PrimaryInsurance, PrimaryPhone, PrimaryPolicyNum, PrimaryCity," + "PrimaryState, SecondaryInsurance, SecondaryPhone, SecondaryPolicyNum," + " SecondaryCity, SecondaryState) VALUES (@LastName, @FirstName, @MiddleInitial, " + "@StreetAddress, @Apt, @City, @State, @Zip, " + " @MaritalStatus, @DOBMonth, @DOBDay, @DOBYear, @SSN, @Gender, @Age, " + "@Email, @HomePhone, @Cellphone, @HeardAbout, @PrimaryInsurance, @PrimaryPhone, " + "@PrimaryPolicyNum, @PrimaryCity, @PrimaryState, @SecondaryInsurance, @SecondaryPhone," + "@SecondaryPolicyNum, @SecondaryCity, @SecondaryState)", con); cmmd.Parameters.AddWithValue("@LastName", lastName); cmmd.Parameters.AddWithValue("@FirstName", firstName); cmmd.Parameters.AddWithValue("@MiddleInitial", middleInitial); cmmd.Parameters.AddWithValue("@StreetAddress", streetAddress); cmmd.Parameters.AddWithValue("@Apt", apt); cmmd.Parameters.AddWithValue("@City", city); cmmd.Parameters.AddWithValue("@State", state); cmmd.Parameters.AddWithValue("@Zip", zip); cmmd.Parameters.AddWithValue("@MaritalStatus", maritalStatus); cmmd.Parameters.AddWithValue("@DOBMonth", dobMonth); cmmd.Parameters.AddWithValue("@DOBDay", dobDay); cmmd.Parameters.AddWithValue("@DOBYear", dobYear); cmmd.Parameters.AddWithValue("@SSN", ssn); cmmd.Parameters.AddWithValue("@Gender", gender); cmmd.Parameters.AddWithValue("@Age", age); cmmd.Parameters.AddWithValue("@Email", email); cmmd.Parameters.AddWithValue("@HomePhone", homePhone); cmmd.Parameters.AddWithValue("@cellphone", cellphone); cmmd.Parameters.AddWithValue("@HeardAbout", heardAbout); cmmd.Parameters.AddWithValue("@PrimaryInsurance", primaryInsurance); cmmd.Parameters.AddWithValue("@PrimaryPhone", primaryPhone); cmmd.Parameters.AddWithValue("@PrimaryPolicyNum", primaryPolicyNum); cmmd.Parameters.AddWithValue("@PrimaryCity", primaryCity); cmmd.Parameters.AddWithValue("@PrimaryState", primaryState); cmmd.Parameters.AddWithValue("@SecondaryInsurance", secondaryInsurance); cmmd.Parameters.AddWithValue("@SecondaryPhone", secondaryPhone); cmmd.Parameters.AddWithValue("@SecondaryPolicyNum", secondaryPolicyNum); cmmd.Parameters.AddWithValue("@SecondaryCity", secondaryCity); cmmd.Parameters.AddWithValue("@SecondaryState", secondaryState); cmmd.ExecuteNonQuery(); con.Close(); FormSelection screen = new FormSelection(); this.Hide(); screen.ShowDialog(); }