private void SavePhone() { string insertQuery = "INSERT INTO Phone(Type,AreaCode,PhoneNumberPOne,PhoneNumberPTwo, Extension, PrimaryNumber, ContactId)" + " VALUES (@Type,@AreaCode,@PhoneNumberPOne,@PhoneNumberPTwo, @Extension,@PrimaryNumber,@ContactId)"; using (SqlConnection connection = new SqlConnection(connectionString)) { SqlCommand command = new SqlCommand(insertQuery, connection); command.Parameters.AddWithValue("Type", PhoneTypeList.Text); command.Parameters.AddWithValue("AreaCode", AreaCodeTextBox.Text); command.Parameters.AddWithValue("PhoneNumberPOne", NumberPart1TextBox.Text); command.Parameters.AddWithValue("PhoneNumberPTwo", NumberPart2TextBox.Text); command.Parameters.AddWithValue("Extension", ExtTextBox.Text); command.Parameters.AddWithValue("PrimaryNumber", PrimaryNumberChkBxAdd.Checked.ToString()); command.Parameters.AddWithValue("ContactId", contactId); try { connection.Open(); command.ExecuteNonQuery(); connection.Close(); PhoneGridView.EditIndex = -1; this.BindGrid(); PhoneTypeList.ClearSelection(); AreaCodeTextBox.Text = ""; NumberPart1TextBox.Text = ""; NumberPart2TextBox.Text = ""; ExtTextBox.Text = ""; SqlPhoneInsertError.Text = ""; } catch (SqlException) { SqlPhoneInsertError.Text = "<br />*Invalid entry. Use numeric digits only. "; } } }
private void frmPhoneType_Load(object sender, EventArgs e) { dgvPhoneType.AutoGenerateColumns = false; pt = new PhoneTypeList(); pt.Savable += Pt_Savable; pt = pt.GetAll(); dgvPhoneType.DataSource = pt.List; mnuSave.Enabled = false; }
private void Form1_Load(object sender, EventArgs e) { phoneTypes = new PhoneTypeList(); phoneTypes = phoneTypes.GetAll(); dgvPhone.CellFormatting += DgvPhone_CellFormatting; dgvPhone.RowValidated += DgvPhone_RowValidated; dgvPhone.DataError += DgvPhone_DataError; dgvEmployee.AutoGenerateColumns = false; dgvPhone.AutoGenerateColumns = false; el = new EmployeeList(); dgvEmployee.DataSource = el.List; saveToolStripMenuItem.Enabled = false; el.Savable += El_Savable; dgvEmployee.RowHeaderMouseDoubleClick += DgvEmployee_RowHeaderMouseDoubleClick; }
private void Form1_Load(object sender, EventArgs e) { el = new EmployeeList(); departments = new DepartmentList(); departments = departments.GetAll(); phoneTypes = new PhoneTypeList(); phoneTypes = phoneTypes.GetAll(); emailTypes = new EmailTypeList(); emailTypes = emailTypes.GetAll(); HobbyList hobbyList; hobbyList = new HobbyList(); hobbyList.GetAll(); LoadHobbies(hobbyList); dgvFamily.DataError += DgvFamily_DataError; dgvFamily.CellFormatting += DgvFamily_CellFormatting; dgvEmployee.CellFormatting += DgvEmployee_CellFormatting; dgvEmployeePhones.CellFormatting += DgvEmployeePhones_CellFormatting; dgvEmployeeEmail.CellFormatting += DgvEmployeeEmail_CellFormatting; dgvEmployeePhones.DataError += DgvEmployeePhones_DataError; dgvEmployeeEmail.DataError += DgvEmployeeEmail_DataError; dgvEmployee.DataError += DgvEmployee_DataError; dgvEmployee.AutoGenerateColumns = false; dgvSubordinate.AutoGenerateColumns = false; dgvSubordinate.CellFormatting += DgvSubordinate_CellFormatting; dgvSubordinate.DataError += DgvSubordinate_DataError; dgvFamily.AutoGenerateColumns = false; dgvEmployeePhones.AutoGenerateColumns = false; dgvEmployeeEmail.AutoGenerateColumns = false; el.Savable += El_Savable; mnuSave.Enabled = false; dgvEmployee.RowHeaderMouseDoubleClick += DgvEmployee_RowHeaderMouseDoubleClick; dgvSubordinate.RowHeaderMouseDoubleClick += DgvSubordinate_RowHeaderMouseDoubleClick; }