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