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