Esempio n. 1
0
        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));
        }
Esempio n. 2
0
        //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));
        }