private void ShowFormSetting_KeyDown(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.F3) { ShowButton.PerformClick(); } }
//______________________________________________________ private void RemoveButton_Click(object sender, EventArgs e) { //Remove all contacts DialogResult dialogResult = MessageBox.Show("Are you sure you want to delete all your contacts?", "Remove everything?", MessageBoxButtons.YesNo); if (dialogResult == DialogResult.Yes) { connection.Open(); string comand = "DELETE FROM Table1"; OleDbCommand cmd = new OleDbCommand(comand, connection); cmd.ExecuteNonQuery(); connection.Close(); ClearAllTextBoxes(); ShowButton.PerformClick(); } }
//______________________________________________________ void add() { //add to database the followinds based on the key connection.Open(); String query = "Insert into Table1(FName,LName,Phone,EMail,Address,City,ZCode,BDay,Photo,Music) " + "values ('" + FNameTextBox.Text + "','" + LNameTextBox.Text + "'," + "'" + Convert.ToInt32(PhoneTextBox.Text) + "', '" + EMailTextBox.Text + "'," + "'" + AddressTextBox.Text + "','" + CityTextBox.Text + "'," + "'" + Convert.ToInt32(ZCodeTextBox.Text) + "'," + "'" + BDay.Value.ToString() + "', '" + photo + "', '" + music + "' )"; OleDbCommand command = new OleDbCommand(query, connection); int count = command.ExecuteNonQuery(); connection.Close(); MessageBox.Show(count.ToString() + " Contact added successfully!"); ShowButton.PerformClick(); }
//______________________________________________________ private void SaveButton_Click(object sender, EventArgs e) { //Check if requested values are properly seted and procced to add(); if (FNameTextBox.Text != "") { if (LNameTextBox.Text != "") { if (NumberOnly(PhoneTextBox.Text)) { if (!Existance()) { if (CheckEMail(EMailTextBox.Text)) { if (NumberOnly(ZCodeTextBox.Text)) { add(); ShowButton.PerformClick(); } else { MessageBox.Show("Provide a valid Zip Code!"); } } else { MessageBox.Show("Please provide a valid E-Mail address!"); } } } else { MessageBox.Show("Please provide a valid phone number"); } } else { MessageBox.Show("Please provide a Last Name!"); } } else { MessageBox.Show("Please provide a First Name!"); } }