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