public List <GuestDish> GetGuestDishes()
{
List <GuestDish> list = new List <GuestDish>();
using (var SqlConn = ConnectionProvider.GetConnection())
{
var SqlCmd = new SqlCommand();
SqlCmd.Connection = SqlConn;
SqlCmd.CommandText = @"
SELECT distinct guest.Id as GuestId, prod.Id AS ProductId
FROM dbo.MediaGuest AS guest INNER JOIN
dbo.Orders AS ord ON guest.GuestUid = ord.MemberCardNo INNER JOIN
dbo.OrderDetails AS detail ON ord.Id = detail.OrderId INNER JOIN
dbo.Product AS prod ON detail.ProductId = prod.Id
";
var reader = SqlCmd.ExecuteReader();
while (reader.Read())
{
var entity = new GuestDish();
entity.GuestId = Convert.ToInt32(reader["GuestId"]);
entity.ProductId = Guid.Parse(reader["ProductId"].ToString());
list.Add(entity);
}
}
return(list);
}
public void addDishToGuest(ref Dish dish, ref Guest guest)
{
var gd = new GuestDish();
gd.DishId = dish.DishId;
gd.GuestId = guest.GuestId;
db.GuestDish.Add(gd);
db.SaveChanges();
}
public GuestDish selectGuestDish(Guest guest, Dish dish)
{
List <GuestDish> dataOutPut = new List <GuestDish>();
dataOutPut = db.GuestDish.Where(guestDishOut => ((guestDishOut.GuestId == guest.GuestId) && (guestDishOut.DishId == dish.DishId))).ToList();
GuestDish dataOut = new GuestDish();
dataOut = dataOutPut[0];
return(dataOut);
}
public void addDish(ref Dish dish, ref Restaurant restaurant, ref Guest guest)
{
db.Dish.Add(dish);
db.SaveChanges();
var gd = new GuestDish();
gd.Dish = dish;
gd.Guest = guest;
dish.GuestDish.Add(gd);
db.SaveChanges();
}
private static void InsertDummyGuest(AppDbContext context, int numberOfGuestsToAdd)
{
var restaurants = context.Restaurants;
var guestCount = 0;
var rand = new Random();
foreach (var r in restaurants)
{
var dishes = r.RestaurantDishes.Select(rd => rd.Dish).ToList();
foreach (var t in r.Tables)
{
for (var i = 0; i < numberOfGuestsToAdd; i++)
{
var guest = new Guest()
{
Name = "Guest" + guestCount++,
Time = "01:01:2000",
Table = t,
};
for (var index = 0; index < 3; index++)
{
var guestDish = new GuestDish()
{
Guest = guest,
Dish = dishes[rand.Next(0, dishes.Count - 1)]
};
if (guest.GuestDishes == null)
{
guest.GuestDishes = new List <GuestDish>();
}
guest.GuestDishes.Add(guestDish);
}
if (t.Guests == null)
{
t.Guests = new List <Guest>();
}
t.Guests.Add(guest);
context.Guests.Add(guest);
}
}
}
context.SaveChanges();
}
public static Guest CreateGuest(AppDbContext context)
{
var table = Find.FindTable(context);
Console.Write("Guest name: ");
var name = Console.ReadLine();
Console.Write("date of restaurant visit(dd:mm:yyyy) : ");
var time = Console.ReadLine();
var guest = new Guest()
{
Name = name,
Time = time
};
if (table != null)
{
guest.Table = table;
}
Console.WriteLine("Number of dishes: ");
var numberOfDishes = int.Parse(Console.ReadLine());
for (var i = 0; i < numberOfDishes; i++)
{
var dish = CreateDish(context);
var guestDish = new GuestDish()
{
Dish = dish,
Guest = guest
};
}
return(guest);
}
