public void Delete(Guid id)
{
RestaurantDish restaurantDish = new RestaurantDish
{
Id = id,
};
_restaurantDishRepository.Delete(restaurantDish);
_restaurantDishRepository.Save();
}
public RestaurantDish selectGuest(Restaurant restaurant, Dish dish)
{
List <RestaurantDish> dataOutPut = new List <RestaurantDish>();
dataOutPut = db.RestaurantDish.Where(restaurantDishOut => ((restaurantDishOut.Addresse == restaurant.Address) && (restaurantDishOut.DishId == dish.DishId))).ToList();
RestaurantDish dataOut = new RestaurantDish();
dataOut = dataOutPut[0];
return(dataOut);
}
public void addDish(ref Dish dish, ref Restaurant restaurant)
{
db.Dish.Add(dish);
db.SaveChanges();
var rd = new RestaurantDish();
rd.Dish = dish;
rd.AddresseNavigation = restaurant;
db.RestaurantDish.Add(rd);
restaurant.RestaurantDish.Add(rd);
dish.RestaurantDish.Add(rd);
db.SaveChanges();
}
public void Update(RestaurantDishUpdateModel entity)
{
RestaurantDish restaurantDish = new RestaurantDish
{
Id = entity.Id,
DishName = entity.DishName,
Category = entity.Category,
Ingredients = entity.Ingredients,
Price = entity.Price,
Weight = entity.Weight,
RestaurantId = entity.RestaurantId
};
_restaurantDishRepository.Update(restaurantDish);
_restaurantDishRepository.Save();
}
public static void Initialize(AppDbContext context)
{
context.Database.EnsureCreated();
//Tilføj ting her
context.SaveChanges();
var restaurants = new RestaurantClass[]
{
new RestaurantClass {
Name = "Bob's Place", Address = "Mordor Lane 35", AverageRating = 2, Type = "Dessert"
},
new RestaurantClass {
Name = "The Golden Seagull", Address = "Fast Food Road 88", AverageRating = 4, Type = "Dinner"
},
new RestaurantClass {
Name = "Jelle's Icecream Bar", Address = "Candy Way 15", AverageRating = 0.1, Type = "Dessert"
},
new RestaurantClass {
Name = "Nicolo's Pizza", Address = "Growl Hill 32", AverageRating = 3, Type = "Lunch"
},
new RestaurantClass {
Name = "Jogan's Fine Dining", Address = "Fancy Boulevard 1", AverageRating = 1, Type = "Dinner"
},
new RestaurantClass {
Name = "Frederico's Breakfast", Address = "Early Bird 75", AverageRating = 3.5, Type = "Breakfast"
},
new RestaurantClass {
Name = "Pregante's Sanwitch", Address = "Strange Green 2", AverageRating = 1, Type = "Lunch"
},
new RestaurantClass {
Name = "Only Coffee", Address = "Sleepy Road 14", AverageRating = 5, Type = "Breakfast"
},
};
foreach (RestaurantClass c in restaurants)
{
context.Restaurants.Add(c);
}
context.SaveChanges();
var dishes = new Dish[]
{
new Dish {
DishName = "Cheese Burger", Price = 14, Type = "Main Course"
},
new Dish {
DishName = "Bananasplit", Price = 20, Type = "Dessert"
},
new Dish {
DishName = "Breadsticks", Price = 10, Type = "Appetizer"
},
new Dish {
DishName = "T-Bone", Price = 120, Type = "Main Course"
},
new Dish {
DishName = "Sirloin Steak", Price = 110, Type = "Main Course"
},
new Dish {
DishName = "Muffin", Price = 15, Type = "Dessert"
},
new Dish {
DishName = "King Crabs", Price = 40, Type = "Appetizer"
},
new Dish {
DishName = "Hamburger", Price = 12, Type = "Main Course"
},
new Dish {
DishName = "Bacon Orionrings", Price = 33, Type = "Appetizer"
},
new Dish {
DishName = "Hashbrowns", Price = 20, Type = "Appetizer"
},
new Dish {
DishName = "Milkshake", Price = 30, Type = "Dessert"
},
new Dish {
DishName = "Pizza Slice", Price = 20, Type = "Main Course"
},
new Dish {
DishName = "Dates with Bacon", Price = 30, Type = "Appetizer"
},
new Dish {
DishName = "Chilli Chesse Tops", Price = 8, Type = "Appetizer"
},
new Dish {
DishName = "Pain au Chocolat", Price = 8, Type = "Appetizer"
},
new Dish {
DishName = "Ice Cream", Price = 12, Type = "Dessert"
},
new Dish {
DishName = "Coffee", Price = 15, Type = "Dessert"
},
};
foreach (Dish d in dishes)
{
context.Dishes.Add(d);
}
context.SaveChanges();
var restaurantDishes = new RestaurantDish[]
{
new RestaurantDish
{
DishId = dishes.Single(d => d.DishName == "Breadsticks").DishId,
RestaurantId = restaurants.Single(r => r.Name == "Bob's Place").RestaurantId
},
new RestaurantDish
{
DishId = dishes.Single(d => d.DishName == "Milkshake").DishId,
RestaurantId = restaurants.Single(r => r.Name == "Bob's Place").RestaurantId
},
new RestaurantDish
{
DishId = dishes.Single(d => d.DishName == "Pain au Chocolat").DishId,
RestaurantId = restaurants.Single(r => r.Name == "Bob's Place").RestaurantId
},
new RestaurantDish
{
DishId = dishes.Single(d => d.DishName == "Muffin").DishId,
RestaurantId = restaurants.Single(r => r.Name == "Bob's Place").RestaurantId
},
new RestaurantDish
{
DishId = dishes.Single(d => d.DishName == "Bacon Orionrings").DishId,
RestaurantId = restaurants.Single(r => r.Name == "The Golden Seagull").RestaurantId
},
new RestaurantDish
{
DishId = dishes.Single(d => d.DishName == "Chilli Chesse Tops").DishId,
RestaurantId = restaurants.Single(r => r.Name == "The Golden Seagull").RestaurantId
},
new RestaurantDish
{
DishId = dishes.Single(d => d.DishName == "Hamburger").DishId,
RestaurantId = restaurants.Single(r => r.Name == "The Golden Seagull").RestaurantId
},
new RestaurantDish
{
DishId = dishes.Single(d => d.DishName == "Milkshake").DishId,
RestaurantId = restaurants.Single(r => r.Name == "The Golden Seagull").RestaurantId
},
new RestaurantDish
{
DishId = dishes.Single(d => d.DishName == "Bananasplit").DishId,
RestaurantId = restaurants.Single(r => r.Name == "Jelle's Icecream Bar").RestaurantId
},
new RestaurantDish
{
DishId = dishes.Single(d => d.DishName == "Ice Cream").DishId,
RestaurantId = restaurants.Single(r => r.Name == "Jelle's Icecream Bar").RestaurantId
},
new RestaurantDish
{
DishId = dishes.Single(d => d.DishName == "Milkshake").DishId,
RestaurantId = restaurants.Single(r => r.Name == "Jelle's Icecream Bar").RestaurantId
},
new RestaurantDish
{
DishId = dishes.Single(d => d.DishName == "Muffin").DishId,
RestaurantId = restaurants.Single(r => r.Name == "Jelle's Icecream Bar").RestaurantId
},
new RestaurantDish
{
DishId = dishes.Single(d => d.DishName == "Breadsticks").DishId,
RestaurantId = restaurants.Single(r => r.Name == "Nicolo's Pizza").RestaurantId
},
new RestaurantDish
{
DishId = dishes.Single(d => d.DishName == "Pizza Slice").DishId,
RestaurantId = restaurants.Single(r => r.Name == "Nicolo's Pizza").RestaurantId
},
new RestaurantDish
{
DishId = dishes.Single(d => d.DishName == "Hamburger").DishId,
RestaurantId = restaurants.Single(r => r.Name == "Nicolo's Pizza").RestaurantId
},
new RestaurantDish
{
DishId = dishes.Single(d => d.DishName == "Milkshake").DishId,
RestaurantId = restaurants.Single(r => r.Name == "Nicolo's Pizza").RestaurantId
},
new RestaurantDish
{
DishId = dishes.Single(d => d.DishName == "Dates with Bacon").DishId,
RestaurantId = restaurants.Single(r => r.Name == "Jogan's Fine Dining").RestaurantId
},
new RestaurantDish
{
DishId = dishes.Single(d => d.DishName == "King Crabs").DishId,
RestaurantId = restaurants.Single(r => r.Name == "Jogan's Fine Dining").RestaurantId
},
new RestaurantDish
{
DishId = dishes.Single(d => d.DishName == "T-Bone").DishId,
RestaurantId = restaurants.Single(r => r.Name == "Jogan's Fine Dining").RestaurantId
},
new RestaurantDish
{
DishId = dishes.Single(d => d.DishName == "Sirloin Steak").DishId,
RestaurantId = restaurants.Single(r => r.Name == "Jogan's Fine Dining").RestaurantId
},
new RestaurantDish
{
DishId = dishes.Single(d => d.DishName == "Pain au Chocolat").DishId,
RestaurantId = restaurants.Single(r => r.Name == "Jogan's Fine Dining").RestaurantId
},
new RestaurantDish
{
DishId = dishes.Single(d => d.DishName == "Hashbrowns").DishId,
RestaurantId = restaurants.Single(r => r.Name == "Frederico's Breakfast").RestaurantId
},
new RestaurantDish
{
DishId = dishes.Single(d => d.DishName == "Breadsticks").DishId,
RestaurantId = restaurants.Single(r => r.Name == "Frederico's Breakfast").RestaurantId
},
new RestaurantDish
{
DishId = dishes.Single(d => d.DishName == "Milkshake").DishId,
RestaurantId = restaurants.Single(r => r.Name == "Frederico's Breakfast").RestaurantId
},
new RestaurantDish
{
DishId = dishes.Single(d => d.DishName == "Cheese Burger").DishId,
RestaurantId = restaurants.Single(r => r.Name == "Pregante's Sanwitch").RestaurantId
},
new RestaurantDish
{
DishId = dishes.Single(d => d.DishName == "Hamburger").DishId,
RestaurantId = restaurants.Single(r => r.Name == "Pregante's Sanwitch").RestaurantId
},
new RestaurantDish
{
DishId = dishes.Single(d => d.DishName == "Coffee").DishId,
RestaurantId = restaurants.Single(r => r.Name == "Only Coffee").RestaurantId
},
};
foreach (RestaurantDish rd in restaurantDishes)
{
context.RestaurantDishes.Add(rd);
}
context.SaveChanges();
var reviews = new Review[]
{
new Review {
Text = "Genial Mad oplevelse",
Stars = 5, DishId = dishes.Single(d => d.DishName == "Cheese Burger").DishId,
RestaurantId = restaurants.Single(r => r.Name == "The Golden Seagull").RestaurantId
},
new Review
{
Text = "Jeg fortrød lidt at jeg gik herhen",
Stars = 2, DishId = dishes.Single(d => d.DishName == "Bananasplit").DishId,
RestaurantId = restaurants.Single(r => r.Name == "Jelle's Icecream Bar").RestaurantId
},
new Review
{
Text = "AD!!!!",
Stars = 1, DishId = dishes.Single(d => d.DishName == "Breadsticks").DishId,
RestaurantId = restaurants.Single(r => r.Name == "Frederico's Breakfast").RestaurantId
},
new Review
{
Text = "God betjening og en behagelig oplevelse",
Stars = 4, DishId = dishes.Single(d => d.DishName == "T-Bone").DishId,
RestaurantId = restaurants.Single(r => r.Name == "Jogan's Fine Dining").RestaurantId
},
new Review
{
Text = "Okay til pengene",
Stars = 3, DishId = dishes.Single(d => d.DishName == "Sirloin Steak").DishId,
RestaurantId = restaurants.Single(r => r.Name == "Jogan's Fine Dining").RestaurantId
},
new Review
{
Text = "Uhmmm det kan godt anbefales. Lækkert mad",
Stars = 4, DishId = dishes.Single(d => d.DishName == "Muffin").DishId,
RestaurantId = restaurants.Single(r => r.Name == "Jelle's Icecream Bar").RestaurantId
},
new Review
{
Text = "Hundeæde!!!",
Stars = 1, DishId = dishes.Single(d => d.DishName == "King Crabs").DishId,
RestaurantId = restaurants.Single(r => r.Name == "Jogan's Fine Dining").RestaurantId
},
new Review
{
Text = "The sprinkling of gold flakes lent a top note of bullshit. And that was the good part. The skin had an off-putting tang and a rancid flavor, which seeped into the dried-out meat and left a greasy feeling on the roof of my mouth that, like the demonic clown from It, could not be destroyed",
Stars = 2, DishId = dishes.Single(d => d.DishName == "Hamburger").DishId,
RestaurantId = restaurants.Single(r => r.Name == "Pregante's Sanwitch").RestaurantId
},
new Review
{
Text = "Slowly, gradually, with great mental resistance but still inexorably, it dawned on me that I had paid $98 for a duck with almost no flavor. It was dry, too",
Stars = 1, DishId = dishes.Single(d => d.DishName == "Bacon Orionrings").DishId,
RestaurantId = restaurants.Single(r => r.Name == "The Golden Seagull").RestaurantId
},
new Review
{
Text = "When executed poorly (a gummy mass of vermicelli and shellfish that is presumably a riff on the Korean noodle dish japchae), his dishes just sing out of key",
Stars = 2, DishId = dishes.Single(d => d.DishName == "Hashbrowns").DishId,
RestaurantId = restaurants.Single(r => r.Name == "Frederico's Breakfast").RestaurantId
},
new Review
{
Text = "You’d better have something in the fridge at home, because the likelihood of your joining the Clean Plate Club here is as good as Omarosa Manigault Newman getting invited to a Christmas party at the White House",
Stars = 5, DishId = dishes.Single(d => d.DishName == "Milkshake").DishId,
RestaurantId = restaurants.Single(r => r.Name == "Nicolo's Pizza").RestaurantId
},
new Review
{
Text = "While there are many words I could use to describe Nicolo's Pizza, I’m going to say only this: Nicolo's Pizza is a bad restaurant",
Stars = 1, DishId = dishes.Single(d => d.DishName == "Pizza Slice").DishId,
RestaurantId = restaurants.Single(r => r.Name == "Nicolo's Pizza").RestaurantId
},
new Review
{
Text = "The initial flavor was bland, quickly followed by a fetid, ammonia-like tang. It was an aroma that recalled room-temperature hamburger meat from a grocer that lost power. I felt my eyes water up as I chewed. I tried to swallow. I felt my entire GI tract prepare to purge",
Stars = 2, DishId = dishes.Single(d => d.DishName == "Dates with Bacon").DishId,
RestaurantId = restaurants.Single(r => r.Name == "Jogan's Fine Dining").RestaurantId
},
new Review
{
Text = "Did it have ‘a simple flavor with a touch of sweetness’? It was hard to say after half of it had been simmered in soy sauce to a bony mush, the other half grilled in salt until chewy and served with its head still on, propped up with a wooden stake like a Big Mouth Billy Bass about to sing",
Stars = 5, DishId = dishes.Single(d => d.DishName == "Chilli Chesse Tops").DishId,
RestaurantId = restaurants.Single(r => r.Name == "The Golden Seagull").RestaurantId
},
new Review
{
Text = "When compared to similar restaurants, “Empire is their hollow echo, parroting back a faded, carbon-copied version that takes no risks and contributes little to Detroit’s dining scene dialogue",
Stars = 3, DishId = dishes.Single(d => d.DishName == "Pain au Chocolat").DishId,
RestaurantId = restaurants.Single(r => r.Name == "Bob's Place").RestaurantId
},
new Review
{
Text = "There’s V for Vegan. There’s GF for Gluten Free. There’s DF for Dairy Free. I think they’re missing a few. There should be TF for Taste Free and JF for Joy Free and AAHYWEH for Abandon All Hope, Ye Who Enter Here",
Stars = 1, DishId = dishes.Single(d => d.DishName == "Ice Cream").DishId,
RestaurantId = restaurants.Single(r => r.Name == "Jelle's Icecream Bar").RestaurantId
},
new Review
{
Text = "Nobody told the recipe developer that Americans don’t much like small, stale peas in their pasta",
Stars = 1, DishId = dishes.Single(d => d.DishName == "Coffee").DishId,
RestaurantId = restaurants.Single(r => r.Name == "Only Coffee").RestaurantId
},
new Review
{
Text = "Nobody should pay this much money to be sad",
Stars = 2, DishId = dishes.Single(d => d.DishName == "Sirloin Steak").DishId,
RestaurantId = restaurants.Single(r => r.Name == "Jogan's Fine Dining").RestaurantId
},
new Review
{
Text = "McDonald’s does a better job for one-third of the price",
Stars = 1, DishId = dishes.Single(d => d.DishName == "Bananasplit").DishId,
RestaurantId = restaurants.Single(r => r.Name == "Jelle's Icecream Bar").RestaurantId
},
new Review
{
Text = "I’m not so batty from Trump Derangement Syndrome that I can’t objectively identify what a poor value the food is at Nicolo's Pizza. The only thing Chicagoans on the ground are missing is the spectacular view from occupied territory",
Stars = 3, DishId = dishes.Single(d => d.DishName == "Breadsticks").DishId,
RestaurantId = restaurants.Single(r => r.Name == "Nicolo's Pizza").RestaurantId
},
new Review
{
Text = "To put it mildly, licking Plexiglas is more rewarding than some of the duds on the set menu",
Stars = 2, DishId = dishes.Single(d => d.DishName == "Breadsticks").DishId,
RestaurantId = restaurants.Single(r => r.Name == "Bob's Place").RestaurantId
},
};
foreach (Review rw in reviews)
{
context.Reviews.Add(rw);
}
context.SaveChanges();
var persons = new Person[]
{
new Person {
Name = "Jens Jensen"
},
new Person {
Name = "Anders Andersen"
},
new Person {
Name = "Hanne Hansen"
},
new Person {
Name = "Christiane Christiansen"
},
new Person {
Name = "Trine Triger"
},
new Person {
Name = "Charlotte Charlottenborg"
},
new Person {
Name = "Rasmus Rasmussen"
},
new Person {
Name = "Nicolai Nicolajsen"
},
new Person {
Name = "Frederik Frederico"
},
new Person {
Name = "Jesper Jespersen"
},
new Person {
Name = "Mette Metz"
},
new Person {
Name = "Anna Antonsen"
},
new Person {
Name = "A. Nelprober"
},
new Person {
Name = "A.S. Muncher"
},
new Person {
Name = "Anita Dick"
},
new Person {
Name = "Ben Derhover"
},
new Person {
Name = "Dick Long"
},
new Person {
Name = "Dixon B. Tweenerlegs"
},
new Person {
Name = "Dixon Butts"
},
new Person {
Name = "Harry Nutt"
},
new Person {
Name = "Hugh Janus"
},
new Person {
Name = "Ivana Fuccu"
},
new Person {
Name = "Ivanna B. Spanked"
},
new Person {
Name = "Mike Hunt"
},
new Person {
Name = "Moe Lester"
},
new Person {
Name = "Phil McAvity"
},
new Person {
Name = "Wilma Dickfit"
},
new Person {
Name = "Ho Lee Fuk"
},
};
foreach (Person p in persons)
{
context.Persons.Add(p);
}
context.SaveChanges();
//Tilføj ting her
//Tilføj ting her
context.SaveChanges();
}
public Decorator(RestaurantDish dish)
{
_dish = dish;
}
public Available(RestaurantDish dish, int numAvailable) : base(dish)
{
NumAvailable = numAvailable;
}
public Decorator(RestaurantDish dish)
{
this.dish = dish;
}
private static void InsertDummyDishes(AppDbContext context, int numberOfDishes)
{
string[] dishTypeArray = { "Appertice", "MainCourse", "Dessert", "Snack" };
Random randDishType = new Random();
var dishCount = 0;
var restaurants = context.Restaurants;
foreach (var r in restaurants)
{
if (r.RestaurantDishes == null)
{
r.RestaurantDishes = new List <RestaurantDish>();
}
for (int i = 0; i < numberOfDishes; i++)
{
var dish = new Dish()
{
Name = "Dish" + dishCount++,
Type = dishTypeArray[randDishType.Next(dishTypeArray.Length - 1)],
Price = 10 * numberOfDishes
};
var rd = new RestaurantDish()
{
Dish = dish,
Restaurant = r
};
r.RestaurantDishes.Add(rd);
}
}
for (int i = 0; i < numberOfDishes; i++)
{
var dish = new Dish();
dish.Name = "Dish" + i;
dish.Type = dishTypeArray[randDishType.Next(dishTypeArray.Length - 1)];
dish.Price = 10 * i;
var restaurant = context.Restaurants.SingleOrDefault(r => r.Address == ("Adress" + i));
if (restaurant != null)
{
if (dish.RestaurantDishes == null)
{
dish.RestaurantDishes = new List <RestaurantDish>();
}
var restaurantDish = new RestaurantDish()
{
Restaurant = restaurant,
Dish = dish,
};
dish.RestaurantDishes.Add(restaurantDish);
}
context.Dishes.Add(dish);
}
context.SaveChanges();
}
public AvailableDecorator(RestaurantDish dish)
{
_dish = dish;
}
public AvailableDecorator(RestaurantDish dish, int available)
: this(dish)
{
_numberAvailable = available;
}
