private void btnConfirm_Click(object sender, EventArgs e) { try { string conString = "Server=127.0.0.1;Database=myDB;Uid=root;Pwd=softkitty1"; MySqlConnection con = new MySqlConnection(conString); string query1 = "SET FOREIGN_KEY_CHECKS=0"; MySqlCommand cmd1 = new MySqlCommand(query1, con); con.Open(); cmd1.ExecuteNonQuery(); con.Close(); string query = "insert into myDB.workers(name,surname,dateOfBirth,email,positionId) values('" + this.textName.Text + "','" + this.textSurname.Text + "','" + this.textBirth.Text + "','" + this.textEmail.Text + "','" + this.textPositionId.Text + "');"; MySqlCommand cmd = new MySqlCommand(query, con); con.Open(); cmd.ExecuteNonQuery(); con.Close(); string query2 = "SET FOREIGN_KEY_CHECKS=1"; MySqlCommand cmd2 = new MySqlCommand(query2, con); con.Open(); cmd2.ExecuteNonQuery(); con.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } workersForm.updateWorkersData(); this.Close(); }
private void btnSaveUpdated_Click(object sender, EventArgs e) { int position = -1; if (combo != null) { position = combo.SelectedIndex + 1; } try { string conString = "Server=127.0.0.1;Database=myDB;Uid=root;Pwd=softkitty1"; MySqlConnection con = new MySqlConnection(conString); string query1 = "SET FOREIGN_KEY_CHECKS=0"; MySqlCommand cmd1 = new MySqlCommand(query1, con); con.Open(); cmd1.ExecuteNonQuery(); con.Close(); string query = @"update myDB.workers set surname=@Surname, email=@Email, positionId=@pos where workerId=@worker"; MySqlCommand cmd = new MySqlCommand(query, con); con.Open(); cmd.Parameters.AddWithValue("@Surname", this.updateWorkerDataGridView.CurrentRow.Cells[2].Value.ToString()); cmd.Parameters.AddWithValue("@Email", this.updateWorkerDataGridView.CurrentRow.Cells[4].Value.ToString()); cmd.Parameters.AddWithValue("@pos", position.ToString()); cmd.Parameters.AddWithValue("@worker", this.updateWorkerDataGridView.CurrentRow.Cells[0].Value.ToString()); cmd.ExecuteNonQuery(); con.Close(); string query2 = "SET FOREIGN_KEY_CHECKS=1"; MySqlCommand cmd2 = new MySqlCommand(query2, con); con.Open(); cmd2.ExecuteNonQuery(); con.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } workersForm.updateWorkersData(); this.Close(); }
private void PositionsForm_FormClosing(object sender, FormClosingEventArgs e) { workersform.updateWorkersData(); }