コード例 #1
0
        public static void AddRestaurant(restaurantsContext db)
        {
            Console.WriteLine("Enter Name:");
            string name = Console.ReadLine();

            Console.WriteLine("Enter Type:");
            string type = Console.ReadLine();

            Console.WriteLine("Enter address:");
            string address = Console.ReadLine();

            try
            {
                Restaurant newRestaurant = new Restaurant()
                {
                    AddressRes = address,
                    NameRes    = name,
                    Type       = type
                };
                db.Add(newRestaurant);
                db.SaveChanges();
                Console.WriteLine("Added to database!");
            }
            catch (InvalidOperationException e)
            {
                Console.WriteLine("Restaurant already exists in database");
                //Console.WriteLine(e);
            }
            Console.WriteLine("-----------------------------");
        }
コード例 #2
0
ファイル: Views.cs プロジェクト: maloudt/i4dab-gr1-restaurant
        public static void ViewMenu(restaurantsContext context, string address)
        {
            Console.WriteLine($"\nViewing menu of {address}\n");
            foreach (var dish in context.Dish.Where(p => p.AddressRes.Equals(address)).ToList())
            {
                Console.WriteLine($"Dish:  {dish.DishName}");

                Console.WriteLine($"Price: {dish.Price}");

                List <Review> reviewList = context.Review.Where(p => p.DishId.Equals(dish.DishId)).ToList();
                if (reviewList.Any())
                {
                    int totalRating = 0;
                    foreach (var review in reviewList)
                    {
                        totalRating += review.Stars;
                    }

                    int avgRating = totalRating / reviewList.Count();

                    Console.WriteLine($"Average rating: {avgRating}");
                }
                else
                {
                    Console.WriteLine("There are currently no reviews for this dish");
                }
                Console.WriteLine();
            }
        }
コード例 #3
0
ファイル: Views.cs プロジェクト: maloudt/i4dab-gr1-restaurant
        public static void ViewAllRestaurants(restaurantsContext context)
        {
            Console.WriteLine("\nViewing all restaurants:\n");

            foreach (var restaurant in context.Restaurant)
            {
                Console.WriteLine($"Name:    {restaurant.NameRes}");
                Console.WriteLine($"Type:    {restaurant.Type}");
                Console.WriteLine($"Address: {restaurant.AddressRes}");
                Console.WriteLine("");
            }
        }
コード例 #4
0
        public static void AddReviewDish(restaurantsContext db)
        {
            string addr = Utilities.ReqAddr();

            try
            {
                var restaurant = db.Restaurant.Where(p => p.AddressRes.Equals(addr));
            }
            catch (ArgumentNullException)
            {
                Console.WriteLine("No restaurant exists with that address (address is case sensitive)");
            }

            Console.WriteLine("Enter reviewer name:");
            string DishRevName = Console.ReadLine();

            Console.WriteLine("Enter dish id:");
            int dishID = Convert.ToInt32(Console.ReadLine());

            Console.WriteLine("Enter amount of stars:");
            int starsDish = Convert.ToInt32(Console.ReadLine());

            Console.WriteLine("Enter review text:");
            string dishReviewText = Console.ReadLine();

            Console.WriteLine("Adding review...");

            try
            {
                Review newReview = new Review()
                {
                    DishId       = dishID,
                    ReviewerName = dishReviewText,
                    Stars        = starsDish,
                    ReviewText   = dishReviewText,
                    Time         = DateTime.Now,
                    AddressRes   = addr
                };
                db.Add(newReview);
                db.SaveChanges();
                Console.WriteLine("Added to database!");
            }
            catch (Exception e)
            {
                Console.WriteLine("Something went wrong:");
                //Console.WriteLine(e);
            }
            Console.WriteLine("-----------------------------");
        }
コード例 #5
0
        public static void AddGuest(restaurantsContext db)
        {
            string addr = Utilities.ReqAddr();

            try
            {
                var restaurant = db.Restaurant.Where(p => p.AddressRes.Equals(addr));
            }
            catch (ArgumentNullException)
            {
                Console.WriteLine("No restaurant exists with that address (address is case sensitive)");
            }

            Console.WriteLine("Enter the name of the reservation booker:");
            string booker = Console.ReadLine();

            Console.WriteLine("Enter how many people are in the party:");
            int partySize = Convert.ToInt32(Console.ReadLine());

            Console.WriteLine("Enter the time of the reservation (format 'yyyy-mm-dd hh:ss'):");
            DateTime time = Convert.ToDateTime(Console.ReadLine());

            Console.WriteLine("Enter assigned table number:");
            int tableNo = Convert.ToInt32(Console.ReadLine());

            Console.WriteLine("Adding reservation...");

            try
            {
                Guest newGuest = new Guest()
                {
                    NameBooker  = booker,
                    TableNumber = tableNo,
                    PartySize   = partySize,
                    Time        = time,
                    AddressRes  = addr
                };
                db.Add(newGuest);
                db.SaveChanges();
                Console.WriteLine("Added to database!");
            }
            catch (Exception e)
            {
                Console.WriteLine("Something went wrong:");
                //Console.WriteLine(e);
            }
            Console.WriteLine("-----------------------------");
        }
コード例 #6
0
        public static void AddDish(restaurantsContext db)
        {
            string addr = Utilities.ReqAddr();

            try
            {
                var restaurant = db.Restaurant.Where(p => p.AddressRes.Equals(addr));
            }
            catch (ArgumentNullException)
            {
                Console.WriteLine("No restaurant exists with that address (address is case sensitive)");
            }

            Console.WriteLine("Enter name of dish:");
            string dishName = Console.ReadLine();

            Console.WriteLine("Enter dish description:");
            string dishDesc = Console.ReadLine();

            Console.WriteLine("Enter price of dish:");
            int dishPrice = Convert.ToInt32(Console.ReadLine());

            Console.WriteLine("Enter category of dish:");
            string dishCat = Console.ReadLine();

            Console.WriteLine("Adding dish...");

            try
            {
                Dish newDish = new Dish()
                {
                    DishName        = dishName,
                    DishDescription = dishDesc,
                    Price           = dishPrice,
                    Category        = dishCat
                };
                db.Add(newDish);
                db.SaveChanges();
                Console.WriteLine("Added to database!");
            }
            catch (Exception e)
            {
                Console.WriteLine("Something went wrong:");
                //Console.WriteLine(e);
            }
            Console.WriteLine("-----------------------------");
        }
コード例 #7
0
ファイル: Views.cs プロジェクト: maloudt/i4dab-gr1-restaurant
        public static void ViewDishReviews(restaurantsContext context, string addr)
        {
            Console.WriteLine($"\nViewing dish reviews based on table for {addr}\n");

            List <TableRes> tables = context.TableRes.Where(t => t.AddressRes.Equals(addr)).ToList();

            List <Guest> guests = new List <Guest>();

            foreach (var table in tables)
            {
                guests.AddRange(context.Guest.Where(p => p.TableNumber.Equals(table.TableNumber)));
            }

            List <Review> reviews = new List <Review>();

            foreach (var guest in guests)
            {
                reviews.AddRange(context.Review.Where(r => r.ReviewerName.Equals(guest.NameBooker)));
            }

            foreach (var table in tables)
            {
                Console.WriteLine($"Guests at table {table.TableNumber}:");
                foreach (var guest in guests)
                {
                    if (guest.TableNumber == table.TableNumber)
                    {
                        Console.WriteLine($"Reviews from {guest.NameBooker}:");
                        foreach (var review in reviews)
                        {
                            if (review.ReviewerName == guest.NameBooker && review.DishId != null)
                            {
                                var dishName = context.Dish.Find(review.DishId).DishName;
                                Console.WriteLine($"Dish: {dishName}   Stars: {review.Stars}   Review: {review.ReviewText}");
                            }
                        }
                        Console.WriteLine("");
                    }
                }
            }
        }
コード例 #8
0
        public static void AddTable(restaurantsContext db)
        {
            string addr = Utilities.ReqAddr();

            try
            {
                var restaurant = db.Restaurant.Where(p => p.AddressRes.Equals(addr));
            }
            catch (ArgumentNullException)
            {
                Console.WriteLine("No restaurant exists with that address (address is case sensitive)");
            }

            Console.WriteLine("Enter table number:");
            int tableNo = Convert.ToInt32(Console.ReadLine());

            Console.WriteLine("Enter number of chairs:");
            int chairNo = Convert.ToInt32(Console.ReadLine());

            Console.WriteLine("Adding table...");

            try
            {
                TableRes newTable = new TableRes()
                {
                    TableNumber = tableNo,
                    Chairs      = chairNo,
                    AddressRes  = addr
                };
                db.Add(newTable);
                db.SaveChanges();
                Console.WriteLine("Added to database!");
            }
            catch (Exception e)
            {
                Console.WriteLine("Something went wrong");
                //Console.WriteLine(e);
            }
            Console.WriteLine("-----------------------------");
        }
コード例 #9
0
        public static void AddWaiter(restaurantsContext db)
        {
            string addr = Utilities.ReqAddr();

            try
            {
                var restaurant = db.Restaurant.Where(p => p.AddressRes.Equals(addr));
            }
            catch (ArgumentNullException)
            {
                Console.WriteLine("No restaurant exists with that address (address is case sensitive)");
            }

            Console.WriteLine("Enter assigned table number:");
            int tableNo = Convert.ToInt32(Console.ReadLine());

            Console.WriteLine("Enter salary:");
            int salary = Convert.ToInt32(Console.ReadLine());

            Console.WriteLine("Adding dish...");

            try
            {
                Waiter newWaiter = new Waiter()
                {
                    TableNumber = tableNo,
                    Salary      = salary,
                    AddressRes  = addr
                };
                db.Add(newWaiter);
                db.SaveChanges();
                Console.WriteLine("Added to database!");
            }
            catch (Exception e)
            {
                Console.WriteLine("Something went wrong:");
                //Console.WriteLine(e);
            }
            Console.WriteLine("-----------------------------");
        }
コード例 #10
0
ファイル: Views.cs プロジェクト: maloudt/i4dab-gr1-restaurant
        public static void ViewRestaurantsByType(restaurantsContext context, string type)
        {
            Console.WriteLine($"\nViewing all restaurants of type {type}\n");

            foreach (var restaurant in context.Restaurant.Where(p => p.Type.Equals(type)).ToList())
            {
                Console.WriteLine($"Name: {restaurant.NameRes}");

                List <Review> reviewList = context.Review
                                           .Where(p => p.AddressRes.Equals(restaurant.AddressRes))
                                           .Where(p => p.DishId.Equals(null))
                                           .ToList();

                if (reviewList.Any())
                {
                    int totalRating = 0;
                    foreach (var review in reviewList)
                    {
                        totalRating += review.Stars;
                    }

                    int avgRating = totalRating / reviewList.Count();

                    Console.WriteLine($"Average rating: {avgRating}");

                    for (int i = 0; i < 4 && i < reviewList.Count(); i++)
                    {
                        Console.WriteLine(reviewList[i].ReviewText);
                    }
                }
                else
                {
                    Console.WriteLine("There are currently no reviews for this restaurant");
                }


                Console.WriteLine();
            }
        }
コード例 #11
0
        public static void SeedData()
        {
            restaurantsContext db = new restaurantsContext();

            //************INSERT RESTAURANTS***********
            var        restaurant = db.Restaurant;
            Restaurant kaspers    = new Restaurant()
            {
                AddressRes = "Lillegade",
                NameRes    = "Kaspers Bofhus",
                Type       = "Bofhus"
            };

            db.Add(kaspers);

            Restaurant jensens = new Restaurant()
            {
                AddressRes = "Rosenkrantzgade",
                NameRes    = "Jensens Bofhus",
                Type       = "Bofhus"
            };

            db.Add(jensens);

            Restaurant fiskens = new Restaurant()
            {
                AddressRes = "Fiskehusvej",
                NameRes    = "Thanks For All the Fisk",
                Type       = "Fisk"
            };

            db.Add(fiskens);

            db.SaveChanges();


            //************INSERT DISHES*****************
            var dish = db.Dish;

            // Lillegade *******************************
            Dish bof = new Dish()
            {
                DishName        = "Bof",
                DishDescription = "Den lækreste bof i huset",
                Price           = 199,
                Category        = "Bof",
                AddressRes      = "Lillegade"
            };

            db.Add(bof);

            Dish megabof = new Dish()
            {
                DishName        = "MEGA Bof",
                DishDescription = "Den lækreste MEGA bof i huset",
                Price           = 259,
                Category        = "Bof",
                AddressRes      = "Lillegade"
            };

            db.Add(megabof);

            Dish minibof = new Dish()
            {
                DishName        = "mini Bof",
                DishDescription = "Den lækreste mini bof i huset",
                Price           = 129,
                Category        = "Bof",
                AddressRes      = "Lillegade"
            };

            db.Add(minibof);

            // Rosenkrantzgade *************************
            Dish salatbar = new Dish()
            {
                DishName        = "Salatbar",
                DishDescription = "Tag selv salatbar - all you can eat",
                Price           = 49,
                Category        = "Salat",
                AddressRes      = "Rosenkrantzgade"
            };

            db.Add(salatbar);

            Dish nachos = new Dish()
            {
                DishName        = "Nachos",
                DishDescription = "Sprode tortillachips med ched ­dar og jalapeños. Serveres med guacamole, salsa og creme fraiche",
                Price           = 69,
                Category        = "Frokost",
                AddressRes      = "Rosenkrantzgade"
            };

            db.Add(nachos);

            Dish hakkebof = new Dish()
            {
                DishName        = "Herregårds-hakkebof",
                DishDescription = "Hakkebof serveres med lune ærter, tykke fries og Jensens Bearnaisesauce",
                Price           = 79,
                Category        = "Frokost",
                AddressRes      = "Rosenkrantzgade"
            };

            db.Add(hakkebof);

            // Fiskehusvej *****************************
            Dish rogn = new Dish()
            {
                DishName        = "Stenbiderrogn",
                DishDescription = "Yummmm lidt æg til vinen",
                Price           = 110,
                Category        = "Fisk",
                AddressRes      = "Fiskehusvej"
            };

            db.Add(rogn);

            Dish deller = new Dish()
            {
                DishName        = "Fiskefrikadeller",
                DishDescription = "Dejlig saftige fiskefrikedeller af den bedste torsk fra Gudenåen",
                Price           = 150,
                Category        = "Fisk",
                AddressRes      = "Fiskehusvej"
            };

            db.Add(deller);

            //************INSERT TABLES****************
            var table = db.TableRes;

            // Lillegade *******************************
            var bord1 = new TableRes()
            {
                TableNumber = 1,
                Chairs      = 2,
                AddressRes  = "Lillegade"
            };

            db.Add(bord1);

            var bord2 = new TableRes()
            {
                TableNumber = 2,
                Chairs      = 4,
                AddressRes  = "Lillegade"
            };

            db.Add(bord2);

            var bord3 = new TableRes()
            {
                TableNumber = 3,
                Chairs      = 4,
                AddressRes  = "Lillegade"
            };

            db.Add(bord3);

            // Rosenkrantzgade *************************
            var bord4 = new TableRes()
            {
                TableNumber = 4,
                Chairs      = 4,
                AddressRes  = "Rosenkrantzgade"
            };

            db.Add(bord4);

            var bord5 = new TableRes()
            {
                TableNumber = 5,
                Chairs      = 4,
                AddressRes  = "Rosenkrantzgade"
            };

            db.Add(bord5);

            // Fiskehusvej *****************************
            var bord6 = new TableRes()
            {
                TableNumber = 6,
                Chairs      = 6,
                AddressRes  = "Fiskehusvej"
            };

            db.Add(bord6);

            var bord7 = new TableRes()
            {
                TableNumber = 7,
                Chairs      = 2,
                AddressRes  = "Fiskehusvej"
            };

            db.Add(bord7);

            var bord8 = new TableRes()
            {
                TableNumber = 8,
                Chairs      = 4,
                AddressRes  = "Fiskehusvej"
            };

            db.Add(bord8);

            //************INSERT WAITERS**************

            var waiter  = db.Waiter;
            var tjener1 = new Waiter()
            {
                Salary     = 120000,
                AddressRes = "Lillegade"
            };

            db.Add(tjener1);

            var tjener2 = new Waiter()
            {
                Salary     = 12000,
                AddressRes = "Rosenkrantzgade"
            };

            db.Add(tjener2);

            var tjener3 = new Waiter()
            {
                Salary     = 20000,
                AddressRes = "Fiskehusvej"
            };

            db.Add(tjener3);

            //************INSERT GUESTS
            var guest = db.Guest;

            // Lillegade *******************************
            var gaest1 = new Guest()
            {
                NameBooker  = "Carsten",
                TableNumber = 1,
                PartySize   = 2,
                Time        = new DateTime(2019, 11, 10, 18, 00, 00),
                AddressRes  = "Lillegade"
            };

            db.Add(gaest1);

            var gaest2 = new Guest()
            {
                NameBooker  = "Lillian",
                TableNumber = 2,
                PartySize   = 4,
                Time        = new DateTime(2019, 11, 10, 19, 30, 00),
                AddressRes  = "Lillegade"
            };

            db.Add(gaest2);

            // Rosenkrantzgade *************************
            var gaest3 = new Guest()
            {
                NameBooker  = "Suzanne",
                TableNumber = 4,
                PartySize   = 3,
                Time        = new DateTime(2019, 11, 11, 12, 30, 00),
                AddressRes  = "Rosenkrantzgade"
            };

            db.Add(gaest3);

            var gaest4 = new Guest()
            {
                NameBooker  = "Allan",
                TableNumber = 5,
                PartySize   = 4,
                Time        = new DateTime(2019, 11, 14, 14, 15, 00),
                AddressRes  = "Rosenkrantzgade"
            };

            db.Add(gaest4);

            // Fiskehusvej *****************************
            var gaest5 = new Guest()
            {
                NameBooker  = "Niklas",
                TableNumber = 7,
                PartySize   = 1,
                Time        = new DateTime(2019, 12, 24, 12, 00, 00),
                AddressRes  = "Fiskehusvej"
            };

            db.Add(gaest5);


            //************INSERT RESTAURANT REVIEWS**************
            var review = db.Review;

            // Lillegade *******************************
            var review1 = new Review()
            {
                DishId       = null,
                ReviewerName = "Carsten",
                Stars        = 5,
                ReviewText   = "Fin restaurant",
                Time         = DateTime.Now,
                AddressRes   = "Lillegade"
            };

            db.Add(review1);

            var review2 = new Review()
            {
                DishId       = null,
                ReviewerName = "Frederik",
                Stars        = 3,
                ReviewText   = "Kunne vaere bedre",
                Time         = DateTime.Now,
                AddressRes   = "Lillegade"
            };

            db.Add(review2);

            var review3 = new Review()
            {
                DishId       = null,
                ReviewerName = "Peter",
                Stars        = 1,
                ReviewText   = "Daarlig service",
                Time         = DateTime.Now,
                AddressRes   = "Lillegade"
            };

            db.Add(review3);

            var review4 = new Review()
            {
                DishId       = null,
                ReviewerName = "Suzanne",
                Stars        = 4,
                ReviewText   = "God mad",
                Time         = DateTime.Now,
                AddressRes   = "Lillegade"
            };

            db.Add(review4);

            var review5 = new Review()
            {
                DishId       = null,
                ReviewerName = "Jens",
                Stars        = 4,
                ReviewText   = "Fint",
                Time         = DateTime.Now,
                AddressRes   = "Lillegade"
            };

            db.Add(review5);

            // Rosenkrantzgade *************************
            var review6 = new Review()
            {
                DishId       = null,
                ReviewerName = "Bo",
                Stars        = 3,
                ReviewText   = "Fint",
                Time         = DateTime.Now,
                AddressRes   = "Rosenkrantzgade"
            };

            db.Add(review6);

            // Fiskehusvej *****************************
            var review7 = new Review()
            {
                DishId       = null,
                ReviewerName = "Franz",
                Stars        = 5,
                ReviewText   = "God fisk",
                Time         = DateTime.Now,
                AddressRes   = "Fiskehusvej"
            };

            db.Add(review7);



            //************INSERT DISH REVIEWS**************
            // Lillegade dish 1 ***************************
            var dishReview1 = new Review()
            {
                DishId       = 1,
                ReviewerName = "Carsten",
                Stars        = 5,
                ReviewText   = "Super god bof!",
                Time         = DateTime.Now,
                AddressRes   = "Lillegade"
            };

            db.Add(dishReview1);

            var dishReview2 = new Review()
            {
                DishId       = 1,
                ReviewerName = "Lillian",
                Stars        = 3,
                ReviewText   = "Kunne vaere bedre",
                Time         = DateTime.Now,
                AddressRes   = "Lillegade"
            };

            db.Add(dishReview2);

            var dishReview3 = new Review()
            {
                DishId       = 1,
                ReviewerName = "Lars",
                Stars        = 3,
                ReviewText   = "OK",
                Time         = DateTime.Now,
                AddressRes   = "Lillegade"
            };

            db.Add(dishReview3);

            // Lillegade dish 2 ***************************
            var dishReview4 = new Review()
            {
                DishId       = 2,
                ReviewerName = "Mette",
                Stars        = 5,
                ReviewText   = "Yummy!",
                Time         = DateTime.Now,
                AddressRes   = "Lillegade"
            };

            db.Add(dishReview4);

            var dishReview5 = new Review()
            {
                DishId       = 2,
                ReviewerName = "Abraham",
                Stars        = 3,
                ReviewText   = "Fin bof",
                Time         = DateTime.Now,
                AddressRes   = "Lillegade"
            };

            db.Add(dishReview5);

            // Lillegade dish 3 ***************************
            var dishReview13 = new Review()
            {
                DishId       = 3,
                ReviewerName = "Sandra",
                Stars        = 3,
                ReviewText   = "Meget lille bof",
                Time         = DateTime.Now,
                AddressRes   = "Lillegade"
            };

            db.Add(dishReview13);

            // Rosenkrantzgade dish 1 *********************
            var dishReview6 = new Review()
            {
                DishId       = 4,
                ReviewerName = "Karl",
                Stars        = 5,
                ReviewText   = "Altid godt",
                Time         = DateTime.Now,
                AddressRes   = "Rosenkrantzgade"
            };

            db.Add(dishReview6);

            // Rosenkrantzgade dish 2 *********************
            var dishReview7 = new Review()
            {
                DishId       = 5,
                ReviewerName = "Karl",
                Stars        = 5,
                ReviewText   = "Altid godt",
                Time         = DateTime.Now,
                AddressRes   = "Rosenkrantzgade"
            };

            db.Add(dishReview7);

            var dishReview8 = new Review()
            {
                DishId       = 5,
                ReviewerName = "Preben",
                Stars        = 4,
                ReviewText   = "Godt",
                Time         = DateTime.Now,
                AddressRes   = "Rosenkrantzgade"
            };

            db.Add(dishReview8);

            // Rosenkrantzgade dish 3 *********************
            var dishReview9 = new Review()
            {
                DishId       = 6,
                ReviewerName = "Tuomas",
                Stars        = 5,
                ReviewText   = "Yas",
                Time         = DateTime.Now,
                AddressRes   = "Rosenkrantzgade"
            };

            db.Add(dishReview9);

            // Fiskehusvej dish 1 *************************
            var dishReview10 = new Review()
            {
                DishId       = 7,
                ReviewerName = "Brendan",
                Stars        = 5,
                ReviewText   = "Altid godt",
                Time         = DateTime.Now,
                AddressRes   = "Fiskehusvej"
            };

            db.Add(dishReview10);

            var dishReview11 = new Review()
            {
                DishId       = 7,
                ReviewerName = "Sara",
                Stars        = 3,
                ReviewText   = "OK fisk",
                Time         = DateTime.Now,
                AddressRes   = "Fiskehusvej"
            };

            db.Add(dishReview11);

            // Fiskehusvej dish 2 *************************
            var dishReview12 = new Review()
            {
                DishId       = 8,
                ReviewerName = "Finn",
                Stars        = 4,
                ReviewText   = "Mhmm",
                Time         = DateTime.Now,
                AddressRes   = "Fiskehusvej"
            };

            db.Add(dishReview12);


            db.SaveChanges();
        }
コード例 #12
0
        static void Main(string[] args)
        {
            restaurantsContext db = new restaurantsContext();

            Menu.PrintMenu();

            while (true)
            {
                Console.WriteLine("Press m for menu\n");

                ConsoleKeyInfo pressed = Console.ReadKey();
                Console.WriteLine("");
                switch (pressed.Key)
                {
                case ConsoleKey.M:
                    Menu.PrintMenu();
                    break;

                case ConsoleKey.S:
                    Console.Write("Seeding database... ");
                    DataSeeder.SeedData();
                    Console.WriteLine("Done!");
                    break;

                case ConsoleKey.D1:
                case ConsoleKey.NumPad1:
                    Views.ViewAllRestaurants(db);
                    break;

                case ConsoleKey.D2:
                case ConsoleKey.NumPad2:
                    Views.ViewMenu(db, Utilities.ReqAddr());
                    break;

                case ConsoleKey.D3:
                case ConsoleKey.NumPad3:
                    Views.ViewRestaurantsByType(db, Utilities.ReqType());
                    break;

                case ConsoleKey.D4:
                case ConsoleKey.NumPad4:
                    Views.ViewDishReviews(db, Utilities.ReqAddr());
                    break;

                case ConsoleKey.D5:
                case ConsoleKey.NumPad5:
                    DataAdder.AddRestaurant(db);
                    break;

                case ConsoleKey.D6:
                case ConsoleKey.NumPad6:
                    DataAdder.AddDish(db);
                    break;

                case ConsoleKey.D7:
                case ConsoleKey.NumPad7:
                    DataAdder.AddTable(db);
                    break;

                case ConsoleKey.D8:
                case ConsoleKey.NumPad8:
                    DataAdder.AddWaiter(db);
                    break;

                case ConsoleKey.D9:
                case ConsoleKey.NumPad9:
                    DataAdder.AddReview(db);
                    break;

                case ConsoleKey.D0:
                case ConsoleKey.NumPad0:
                    DataAdder.AddReviewDish(db);
                    break;

                case ConsoleKey.G:
                    DataAdder.AddGuest(db);
                    break;

                default:
                    Console.WriteLine("Not implemented");
                    break;
                }

                Console.WriteLine("");
            }
        }