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