Use Session as Query Parameter

Question

Hello, I have a method to login the system, soon after I need the user to select an option in a dropdown and save this value in a Session. Now I need to put the stored value in Session, inside a LINQ query. I’ll post the codes, which you’ll understand better.

Method to store the die in a Session:

 public ActionResult Contrato()
    {      
        var contrato = new Usuario() { SqContrato = 0 };

        return View(contrato);
    }

    [HttpPost]
    public ActionResult Contrato(Int16? Contrato)
    {

        System.Web.HttpContext.Current.Session["Contrato"] = Contrato;

        return View();
    }

Method where I need to place the value stored by Session:

    public ViewResult Ferias()
    {
        var usuarios =
            funcionarioFeriasRepository.Lista.Where(r => r.slogin == autenticacaoProvider.UsuarioAutenticado.Login && r.SqContrato == "SESSION AQUI"
                .ToList();

        return View(usuarios);
    }

Answer 1

Make a Helper:

public static class SessionHelper
{
    public static int Contrato {
        get { return (int)HttpContext.Current.Session['Contrato']; }
        set { HttpContext.Current.Session['Contrato'] = value; }
    }
}

Use:

public ViewResult Ferias()
{
    var contrato = SessionHelper.Contrato;
    var usuarios =
        funcionarioFeriasRepository.Lista.Where(r => r.slogin == autenticacaoProvider.UsuarioAutenticado.Login && r.SqContrato == contrato)
            .ToList();

    return View(usuarios);
}