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