ASP.Net MVC Controller Constructor shows error System.Web.Mvc.Controller.Session.get returned null

Question

Basically I want to filter customers of current business from many businesses and I want to done it on one place (constructor). So that I can easily query on db.Customers in rest of the controller. But when I use (Employee)Session["CurrentUser"]; it show error

System.Web.Mvc.Controller.Session.get returned null.

public class SOSRController : Controller
    {
        private BusinessContext db = new BusinessContext();
        public SOSRController()
        {
            Employee employee= (Employee)Session["CurrentUser"];
            db.Customers = (DbSet<Customer>) db.Customers.AsQueryable().Where(x => x.Business.Id == employee.bizId);
        }
        public ActionResult Index()
        {
            List<Customer> LstCust= db.Customers.Where(x => x.Name.Contains("asd")).ToList();
        }
}

Or what could be any other solution of filtering db.Customers at one place only?

Waqas Javaid · Accepted Answer · 2020-03-02 09:36:58Z

1

It worked. I override Initialize method and now I can get session value. Constructor is concept of classes and Initialize is concept of MVC.

protected override void Initialize(RequestContext requestContext)
        {
            base.Initialize(requestContext);

             Employee employee= (Employee)Session["CurrentUser"];
            db.Customers = (DbSet<Customer>) db.Customers.AsQueryable().Where(x => x.Business.Id == employee.bizId);

        }

answered Mar 2, 2020 at 9:36

Waqas Javaid

2152 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

ASP.Net MVC Controller Constructor shows error System.Web.Mvc.Controller.Session.get returned null

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related