private void guardaEstatus(bool estatus, string campo) { cnx = new SqlConnection(cdn); cmd = new SqlCommand(); cmd.Connection = cnx; eh = new Exportacion.Core.ExportacionHelper(); eh.Command = cmd; for (int i = 0; i < lstvOrdenCampos.Items.Count; i++) { Exportacion.Core.Exportacion exp = new Exportacion.Core.Exportacion(); exp.activo = estatus; exp.campo = campo; exp.formulario = "frmListaEmpleados"; try { cnx.Open(); eh.actualizaExportacion(exp); cnx.Close(); } catch { MessageBox.Show("Error: Al actualizar el campo: " + lstvOrdenCampos.Items[i].Text, "Error"); this.Dispose(); } } cnx.Dispose(); }
private void frmExportarEmpleado_FormClosing(object sender, FormClosingEventArgs e) { cnx = new SqlConnection(cdn); cmd = new SqlCommand(); cmd.Connection = cnx; Exportacion.Core.ExportacionHelper exph = new Exportacion.Core.ExportacionHelper(); exph.Command = cmd; for (int i = 0; i < lstvOrdenCampos.Items.Count; i++) { Exportacion.Core.Exportacion exp = new Exportacion.Core.Exportacion(); exp.orden = i; exp.campo = lstvOrdenCampos.Items[i].Text; exp.formulario = "frmListaEmpleados"; try { cnx.Open(); exph.actualizaOrden(exp); cnx.Close(); } catch (Exception) { MessageBox.Show("Error: Al actualizar el orden de los campos.", "Error"); cnx.Dispose(); } } cnx.Dispose(); }