private void cleanbuttonstrip_Click(object sender, EventArgs e) { comboname.Text = ""; edadbox.Text = ""; cargobox.Text = ""; workingbox.Text = "SI"; trabajandopanel.Hide(); string userDataName = UserAccessForm.getusername() + "_employee_table"; string allorden = "select `NOMBRE COMPLETO`, CEDULA, `FECHA DE NACIMIENTO`,SEXO , `TITULO UNIVERSITARIO`, PUESTO , EDAD, HORARIO, TELEFONO, DIRECCION from " + userDataName + " where TRABAJANDO = '" + workingbox.Text + "'; "; EmployeeClass show = new EmployeeClass(UserAccessForm.getdbserver(), UserAccessForm.getdbname(), UserAccessForm.getdbuser(), UserAccessForm.getdbpassword(), UserAccessForm.getdbport()); show.ShowDataGrid(findinggrid, allorden); encontradoslabel.Text = show.getcuenta().ToString(); getoutdateTimePicker.Text = DateTime.Today.ToString(); getindateTimePicker.Text = DateTime.Today.ToString(); birthdatebox.Text = DateTime.Today.ToString(); }
private void eliminarbutton_Click(object sender, EventArgs e) { if (workingbox.Text == "NO") { MessageBox.Show("Solo se pueden Despedir Empleados."); workingbox.BackColor = Color.Red; } else { if (cargobox.Text == "" || edadbox.Text == "" || comboname.Text == "") { MessageBox.Show("Hay datos importantes faltantes."); if (cargobox.Text == "") { cargobox.BackColor = Color.Red; } if (edadbox.Text == "") { edadbox.BackColor = Color.Red; } if (comboname.Text == "") { comboname.BackColor = Color.Red; } } else { EmployeeClass show = new EmployeeClass(UserAccessForm.getdbserver(), UserAccessForm.getdbname(), UserAccessForm.getdbuser(), UserAccessForm.getdbpassword(), UserAccessForm.getdbport()); string userDataName = UserAccessForm.getusername() + "_employee_table"; string mandosql = "update " + userDataName + " set TRABAJANDO ='NO' where `NOMBRE COMPLETO` ='" + comboname.Text + "' and EDAD = '" + edadbox.Text + "' and PUESTO = '" + cargobox.Text + "' and ID='" + EmployeeClass.getids() + "';"; if (show.ordensql(mandosql) == true) { MessageBox.Show("Empleado ha sido despedido"); } else { MessageBox.Show("Empleado Despedido"); } show.ShowDataGrid(findinggrid, userDataName); encontradoslabel.Text = show.getcuenta().ToString(); } } }