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();
}
