private void btnSave_Click(object sender, EventArgs e) { userInMemory holdUser = new userInMemory(getValuesFromFields()); using (SqlCommand cmd = new SqlCommand("procedure_EditStaff", con)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@StaffID", SqlDbType.Int).Value = holdUser.StaffID; cmd.Parameters.Add("@PermLevel", SqlDbType.Int).Value = holdUser.PermLevel; cmd.Parameters.Add("@Forename", SqlDbType.VarChar, 20).Value = holdUser.Forename; cmd.Parameters.Add("@Surname", SqlDbType.VarChar, 30).Value = holdUser.Surname; cmd.Parameters.Add("@Title", SqlDbType.VarChar, 10).Value = holdUser.Title; cmd.Parameters.Add("@Gender", SqlDbType.Char, 1).Value = holdUser.Gender; cmd.Parameters.Add("@DOB", SqlDbType.Date).Value = holdUser.DOB; cmd.Parameters.Add("@Role", SqlDbType.VarChar, 20).Value = holdUser.Role; cmd.Parameters.Add("@EmploymentBasis", SqlDbType.Char, 4).Value = holdUser.EmploymentBasis; cmd.Parameters.Add("@Address1", SqlDbType.VarChar, 50).Value = holdUser.Address1; cmd.Parameters.Add("@Address2", SqlDbType.VarChar, 50).Value = holdUser.Address2; cmd.Parameters.Add("@City", SqlDbType.VarChar, 20).Value = holdUser.City; cmd.Parameters.Add("@Postcode", SqlDbType.VarChar, 10).Value = holdUser.Postcode; cmd.Parameters.Add("@ContactNumber", SqlDbType.VarChar, 20).Value = holdUser.ContactNumber; cmd.Parameters.Add("@Email", SqlDbType.VarChar, 50).Value = holdUser.Email; cmd.ExecuteNonQuery(); } if (qualificationsToAdd != null) { using (SqlCommand cmd = new SqlCommand("procedure_ClearQualification")) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("StaffID", SqlDbType.Int).Value = holdUser.StaffID; cmd.ExecuteNonQuery(); } foreach (string qualification in qualificationsToAdd) { using (SqlCommand cmd = new SqlCommand("procedure_AddQualification")) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("StaffID", SqlDbType.Int).Value = holdUser.StaffID; cmd.Parameters.Add("Field", SqlDbType.VarChar, 15).Value = qualification; cmd.ExecuteNonQuery(); } } } userToEdit = holdUser; }
private void btnLoad_Click(object sender, EventArgs e) { qualificationsToAdd = null; if (splitContainer1.Panel2Collapsed) { splitContainer1.Panel2Collapsed = false; tblSearch.Visible = false; btnLoad.Text = "Search"; int staffIDToEdit; if (!int.TryParse(lbxResults.SelectedItem.ToString().Substring(0, 3), out staffIDToEdit)) { MessageBox.Show("Not a valid user"); return; } using (SqlCommand cmd = new SqlCommand("procedure_GetUser", con)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@StaffID", SqlDbType.Int).Value = staffIDToEdit; SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { string[] dataArray = new string[16]; for (int i = 0; i < 16; i++) { dataArray[i] = dr[i].ToString(); } userToEdit = new userInMemory(dataArray); } dr.Close(); if (userToEdit.UserSet) { lblStaffID.Text = userToEdit.StaffID.ToString(); nudPermLevel.Value = userToEdit.PermLevel; tbxForename.Text = userToEdit.Forename; tbxSurname.Text = userToEdit.Surname; cbxTitle.SelectedIndex = cbxTitle.FindStringExact(userToEdit.Title); if (userToEdit.Gender.ToString().ToUpper() == "M") rbtnMale.Checked = true; else rbtnFemale.Checked = true; dtpDOB.Value = userToEdit.DOB; cbxRole.SelectedIndex = cbxRole.FindStringExact(userToEdit.Role); if (userToEdit.EmploymentBasis.ToString().ToUpper().StartsWith("F")) rbtnFullTime.Checked = true; else rbtnPartTime.Checked = true; tbxAddress1.Text = userToEdit.Address1; tbxAddress2.Text = userToEdit.Address2; tbxCity.Text = userToEdit.City; tbxPostcode.Text = userToEdit.Postcode; tbxContactNo.Text = userToEdit.ContactNumber; tbxEmail.Text = userToEdit.Email; } } } else { splitContainer1.Panel2Collapsed = true; tblSearch.Visible = true; btnLoad.Text = "Load"; } }