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("-----------------------------");
}
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();
}
}
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("");
}
}
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("-----------------------------");
}
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("-----------------------------");
}
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("-----------------------------");
}
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("");
}
}
}
}
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("-----------------------------");
}
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("-----------------------------");
}
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();
}
}
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();
}
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("");
}
}