public bool UPDATE(Vo_accion accion) { try { MySqlCommand cmd = new MySqlCommand("sp_updateAction", cnSql); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@id", accion.Clave); cmd.Parameters.AddWithValue("@nombre", accion.Nombre); if (cnSql.State == ConnectionState.Open) { cnSql.Close(); } cnSql.Open(); if (cmd.ExecuteNonQuery() > 0) { return(true); } else { return(false); } } catch (Exception ex) { MessageBox.Show("Ocurrio un error", "Advertencia", MessageBoxButtons.OK, MessageBoxIcon.Error); cnSql.Close(); return(false); } finally { cnSql.Close(); } }
public DataTable SEARCH(Vo_accion accion) { MySqlCommand cmd = new MySqlCommand("sp_searchAction", cnSql); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@termino", accion.Expresion); MySqlDataAdapter da = new MySqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); return(dt); }
public bool UPDATE(Vo_accion accion) { if (m_accion == null) { m_accion = new M_accion(); return(m_accion.UPDATE(accion)); } else { return(m_accion.UPDATE(accion)); } }
public DataTable SEARCH(Vo_accion accion) { if (m_accion == null) { m_accion = new M_accion(); return(m_accion.SEARCH(accion)); } else { return(m_accion.SEARCH(accion)); } }
public C_accion_crud(Vo_accion accion = null) { frm = new Capa_Vista.frm_accion_crud(); c_message = C_message.getInstancia(); message_box = c_message.formulario(); vo_accion.Operacion = "insert"; InitializeEvents(); if (accion != null) { vo_accion.Clave = accion.Clave; vo_accion.Operacion = accion.Operacion; frm.txtName.Text = accion.Nombre; } }