public int[] SEARCH(Vo_login login) { try { MySqlCommand cmd = new MySqlCommand("sp_readLogin", cnSql); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@usuario", login.Usuario); cmd.Parameters.AddWithValue("@contrasena", login.Contrasena); MySqlDataAdapter da = new MySqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); if (dt.Rows.Count == 1) { clave[0] = Convert.ToInt16(dt.Rows[0]["int_id_persona"]); clave[1] = Convert.ToInt16(dt.Rows[0]["pf_rol"]); return(clave); } else { return(clave); } } catch (Exception ex) { MessageBox.Show(ex.ToString(), "Advertencia", MessageBoxButtons.OK, MessageBoxIcon.Error); return(clave); } }
public int[] SEARCH(Vo_login login) { if (m_login == null) { m_login = new M_login(); return(m_login.SEARCH(login)); } else { return(m_login.SEARCH(login)); } }