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