//Updates the profile private void UpdateProfile() { int intResult; string strResult = ""; //Checks to see if it exists try { strResult = CProfiles.CheckProfileExists(Convert.ToInt32(txtProfileID.Text)); } catch (Exception ex) { MessageBox.Show("Failed to get single value in UpdateProfile: " + ex.ToString(), "Database error", MessageBoxButtons.OK, MessageBoxIcon.Error); } if (!(strResult == "1")) { tslStatus.Text = "Profile Does Not Exist"; return; } else { try { ArrayList parameters = new ArrayList(); parameters.Add(new SqlParameter("profileID", txtProfileID.Text)); parameters.Add(new SqlParameter("firstName", txtFName.Text)); parameters.Add(new SqlParameter("lastName", txtLName.Text)); if (!(txtMiddleInitial.Text == "" || txtMiddleInitial.Text == null)) { parameters.Add(new SqlParameter("middleInitial", txtMiddleInitial.Text)); } parameters.Add(new SqlParameter("dateOfBirth", Convert.ToDateTime(dtmDOB.Text))); parameters.Add(new SqlParameter("phoneNumber", mtbPhone.Text)); parameters.Add(new SqlParameter("mailingAddress", txtMailing.Text)); parameters.Add(new SqlParameter("City", txtCity.Text)); parameters.Add(new SqlParameter("ZIP", mtbZip.Text)); parameters.Add(new SqlParameter("userName", txtUsername.Text)); parameters.Add(new SqlParameter("password", txtPassword.Text)); parameters.Add(new SqlParameter("email", txtEmail.Text)); intResult = CProfiles.UpdateProfile(parameters); if (!(intResult == 1)) { errP.SetError(btnSave, "Unable to update profile"); tslStatus.Text = "Unable To Update"; } else { tslStatus.Text = "Updated Profile"; } } catch (Exception ex) { MessageBox.Show("Failed to update profile in btnSave_Click: " + ex.ToString(), "Database error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } }
//Search for profile using profile ID, populates form if found private void btnSearch_Click(object sender, EventArgs e) { //Used to check if Profile exists or Not string strResult = ""; //Check to see if it exists try { strResult = CProfiles.CheckProfileExists(Convert.ToInt32(txtProfileID.Text)); } catch (Exception ex) { MessageBox.Show("Failed to get single value in btnSearch_Click: " + ex.ToString(), "Database error", MessageBoxButtons.OK, MessageBoxIcon.Error); } if (!(strResult == "1")) { tslStatus.Text = "Profile Does Not Exist"; return; } else { //Load the profile try { SqlDataReader objDR; objDR = CProfiles.GetProfileByID(txtProfileID.Text); if (objDR.Read()) { txtFName.Text = objDR.GetString(1); txtLName.Text = objDR.GetString(2); dtmDOB.Text = objDR.GetDateTime(4).ToString(); mtbPhone.Text = objDR.GetString(5); txtMailing.Text = objDR.GetString(6); txtCity.Text = objDR.GetString(7); mtbZip.Text = objDR.GetInt32(8).ToString(); txtUsername.Text = objDR.GetString(9); txtPassword.Text = objDR.GetString(10); txtEmail.Text = objDR.GetString(11); } objDR.Close(); LoadAccounts(); tslStatus.Text = "Profile Found"; } catch (Exception ex) { MessageBox.Show("Failed to get data reader in btnSearch_Click: " + ex.ToString(), "Database error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } }
//Loads accounts into the listview private void LoadAccounts() { SqlDataReader objDR; objDR = CProfiles.GetAccountsByID(txtProfileID.Text); lvwAccounts.Items.Clear(); try { while (objDR.Read()) { //Turn this into a loop once we find out how to considering they are all different data types ListViewItem lvRow = new ListViewItem(); lvRow.Text = objDR.GetInt32(0).ToString(); ListViewItem.ListViewSubItem lsiCol1 = new ListViewItem.ListViewSubItem(); ListViewItem.ListViewSubItem lsiCol2 = new ListViewItem.ListViewSubItem(); ListViewItem.ListViewSubItem lsiCol3 = new ListViewItem.ListViewSubItem(); ListViewItem.ListViewSubItem lsiCol4 = new ListViewItem.ListViewSubItem(); ListViewItem.ListViewSubItem lsiCol5 = new ListViewItem.ListViewSubItem(); ListViewItem.ListViewSubItem lsiCol6 = new ListViewItem.ListViewSubItem(); ListViewItem.ListViewSubItem lsiCol7 = new ListViewItem.ListViewSubItem(); lsiCol1.Text = objDR.GetInt32(1).ToString(); lsiCol2.Text = objDR.GetString(2); lsiCol3.Text = objDR.GetString(3); lsiCol4.Text = objDR.GetSqlMoney(4).ToString(); lsiCol5.Text = objDR.GetDateTime(5).ToString(); lsiCol6.Text = objDR.GetInt32(6).ToString(); lvRow.SubItems.Add(lsiCol1); lvRow.SubItems.Add(lsiCol2); lvRow.SubItems.Add(lsiCol3); lvRow.SubItems.Add(lsiCol4); lvRow.SubItems.Add(lsiCol5); lvRow.SubItems.Add(lsiCol6); lvwAccounts.Items.Add(lvRow); } } catch (Exception ex) { MessageBox.Show("Failed to get data reader in LoadAccounts: " + ex.ToString(), "Database error", MessageBoxButtons.OK, MessageBoxIcon.Error); } objDR.Close(); }
//Creates the profile private void CreateProfile() { int intResult; try { ArrayList parameters = new ArrayList(); parameters.Add(new SqlParameter("firstName", txtFName.Text)); parameters.Add(new SqlParameter("lastName", txtLName.Text)); if (!(txtMiddleInitial.Text == "" || txtMiddleInitial.Text == null)) { parameters.Add(new SqlParameter("middleInitial", txtMiddleInitial.Text)); } parameters.Add(new SqlParameter("dateOfBirth", Convert.ToDateTime(dtmDOB.Text))); parameters.Add(new SqlParameter("phoneNumber", mtbPhone.Text)); parameters.Add(new SqlParameter("mailingAddress", txtMailing.Text)); parameters.Add(new SqlParameter("City", txtCity.Text)); parameters.Add(new SqlParameter("ZIP", mtbZip.Text)); parameters.Add(new SqlParameter("userName", txtUsername.Text)); parameters.Add(new SqlParameter("password", txtPassword.Text)); parameters.Add(new SqlParameter("email", txtEmail.Text)); intResult = CProfiles.CreateProfile(parameters); if (!(intResult == 1)) { errP.SetError(btnSave, "Unable to create profile"); tslStatus.Text = "Unable To Save"; } else { tslStatus.Text = "Created Profile"; } } catch (Exception exeption) { MessageBox.Show("Failed to get create profile in btnSave_Click: " + exeption.ToString(), "Database error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }