public ActionResult resturantsList() { Admin customer = (Admin)Session["user"]; IEnumerable <Order> orders = _context.Orders; IEnumerable <OrderedMenuItems> orderedMenuItems = _context.OrderedMenuItems; IEnumerable <ResturantOwner> resturantOwners = _context.ResturantOwners.Include(r => r.Area); IEnumerable <ResturantMenu> resturantMenu = _context.ResturantMenus; var resturants = from order in orders join orderedMenuItem in orderedMenuItems on order.Id equals orderedMenuItem.OrderId join resturantMenus in resturantMenu on orderedMenuItem.Id equals resturantMenus.Id join resturantOwner in resturantOwners on resturantMenus.Id equals resturantOwner.Id select resturantOwner; CustomerOrdersViewModels viewModel = new CustomerOrdersViewModels(); viewModel.Orders = orders; viewModel.OrderedMenuItems = orderedMenuItems; viewModel.ResturantOwner = resturantOwners; return(View(viewModel)); }
//Show Orders of the customer public ActionResult orders_customer() { Customer customer = (Customer)Session["user"]; IEnumerable <Order> orders = _context.Orders.Where(o => o.CustomerId == customer.Id); IEnumerable <OrderedMenuItems> orderedMenuItems = _context.OrderedMenuItems; IEnumerable <ResturantOwner> resturantOwners = _context.ResturantOwners; IEnumerable <ResturantMenu> resturantMenu = _context.ResturantMenus; var resturants = from order in orders join orderedMenuItem in orderedMenuItems on order.Id equals orderedMenuItem.OrderId join resturantMenus in resturantMenu on orderedMenuItem.Id equals resturantMenus.Id join resturantOwner in resturantOwners on resturantMenus.Id equals resturantOwner.Id select resturantOwner; CustomerOrdersViewModels viewModel = new CustomerOrdersViewModels(); viewModel.Orders = orders; viewModel.OrderedMenuItems = orderedMenuItems; viewModel.ResturantOwner = resturants; return(View(viewModel)); }