private void btnUpdate_Click(object sender, MouseButtonEventArgs e)
{
QuestionDialog pregunta = new QuestionDialog("Realmente desea modificar los datos?", main);
pregunta.ShowDialog();
if (pregunta.DialogResult == true)
{
Personal per = new Personal(this.tRut.Text);
if (new Departamento(int.Parse(this.tId.Text), this.tName.Text, per.get_idPersonal().ToString()).update() > 0)
{
this.data.ItemsSource = new Departamento().findAll_administrativo();
}
}
}
//ACTUALIZA DATOS EMPLEADO
public void btnUpdateReg_Click(object sender, MouseButtonEventArgs e)
{
this.listAfp = new Afp().findAll();
this.listSalud = new Salud().findAll();
this.listDpto = new Departamento().findAll();
this.listReg = new Regiones().findAll();
this.listCom = new Comunas().FindByidReg(this.Regi.SelectedIndex + 1);
this.listBank = new Banco().findAll();
if (validacion.validaFecha(this.tDateNaci.Text.Trim()))
{
Personal per = new Personal(this.tRut.Text.Trim(), this.tName.Text.Trim(), this.tSurname.Text.Trim(),
int.Parse(this.tYear.Text.Trim()), this.tPhone.Text.Trim(), this.Tdireccion.Text.Trim(),
this.tEmail.Text.Trim(), this.tCtaBancaria.Text.Trim(), this.tNacionalidad.Text.Trim(),
this.tDateNaci.Text.Trim(), listCom[this.Comu.SelectedIndex].id_comuna, listReg[this.Regi.SelectedIndex].id_region,
listAfp[this.cAfp.SelectedIndex].id, listSalud[this.cSalud.SelectedIndex].id, listBank[this.tBank.SelectedIndex].id
);
if (per.Update() > 0)
{
this.Search();
new Dialog("Datos actualizados correctamente.", main).ShowDialog();
}
else new Dialog("Ocurrio un error al actualizar los datos", main).ShowDialog();
}
else new Dialog("Ingrese formato fecha nacimiento 'YYYY-MM-DD'", main).ShowDialog();
}
//INGRESA NUEVO USUARIO
public void btnAddUser_Click(object sender, MouseButtonEventArgs e)
{
this.tRut.IsEnabled = true;
main.iAddUser.IsEnabled = true;
QuestionDialog pregunta = new QuestionDialog("Desea agregar a esta persona?", main);
pregunta.ShowDialog();
if (pregunta.DialogResult == true && validacionAddUser())
{
byte[] foto = File.ReadAllBytes(path.Content.ToString());
listDpto = new Departamento().findAll();
listAfp = new Afp().findAll();
listSalud = new Salud().findAll();
listReg = new Regiones().findAll();
listCom = new Comunas().FindByidReg(this.Regi.SelectedIndex + 1);
listBank = new Banco().findAll();
Personal per = new Personal(this.tRut.Text.Trim(), this.tName.Text.Trim(), this.tSurname.Text.Trim(),
int.Parse(this.tYear.Text.Trim()), foto, this.tPhone.Text.Trim(), this.Tdireccion.Text.Trim(),
this.tEmail.Text.Trim(), this.tCtaBancaria.Text.Trim(), this.tNacionalidad.Text.Trim(),
this.tDateNaci.Text.Trim(), listCom[this.Comu.SelectedIndex].id_comuna, listReg[this.Regi.SelectedIndex].id_region,
listAfp[this.cAfp.SelectedIndex].id, listSalud[this.cSalud.SelectedIndex].id
);
if (per.Save() > 0)
{
Personal_Departamento pd = new Personal_Departamento(new Personal(this.tRut.Text.Trim()).get_idPersonal(), listDpto[this.cDepto.SelectedIndex].id);
Banco_Personal bp = new Banco_Personal(listBank[this.tBank.SelectedIndex].id, new Personal(this.tRut.Text.Trim()).get_idPersonal(), tCtaBancaria.Text.Trim());
if (pd.save() > 0 && bp.save() > 0)
{
main.listAutocomplet = new Clases.Personal().findAll(0);
main.cBusqueda.IsEnabled = true;
this.iPerfil.IsEnabled = false;
this.btnCancelAdd.Visibility = Visibility.Hidden;
this.btnUpdateReg.Visibility = Visibility.Visible;
this.btnDeleteReg.Visibility = Visibility.Visible;
QuestionDialog pregunta2 = new QuestionDialog("¿Desea contratar a este nuevo personal?", main);
pregunta2.ShowDialog();
if (pregunta2.DialogResult == true)
{
this.tabControl1.SelectedIndex = 1;
cargarDatosPersonal(this.tRut.Text, "rut");
}
else cargarDatosPersonal(this.tRut.Text, "rut");
}
}
else
{
new Dialog("Personal no pudo ser ingresado", main).ShowDialog();
}
}
}
public int DeleteByRut(Personal per)
{
try {
string sql = "";
//string sql = "Select id from personal where rut = '" + per.rut + "'";
//DataTable dataTable = new Clases.Consultas().QueryDB(sql);
//String id_contrato = "";
//foreach (DataRow dtRow in dataTable.Rows) id_contrato = dtRow["contrato_id_contrato"].ToString();
sql = "DELETE c.* FROM contrato c"
+" INNER JOIN personal_contrato pc ON pc.id_contrato = c.id_contrato"
+" INNER JOIN personal p ON p.id_personal = pc.id_personal"
+" WHERE (p.rut='"+per.rut+"')";
return new Clases.Consultas().Update(sql);
}catch(Exception ex)
{
Console.Write("error: " + ex.Message);
return 0;
}
}
