public async Task InsertAsync(/*Order order*/)
{
var room = new Shower {
Price = 200
};
_context.Rooms.Add(room);
var room2 = new Bedroom {
Price = 100
};
_context.Rooms.Add(room2);
var room3 = new Bedroom {
Price = 100
};
_context.Rooms.Add(room3);
_context.Add(new Order
{
Costumer = new Costumer {
Name = "nevem"
},
StartDate = DateTime.Now.AddDays(-5),
EndDate = DateTime.Now.AddDays(1),
OrderRooms = new List <OrderRoom>
{
new OrderRoom {
Room = room, Note = "megrendeles"
},
new OrderRoom {
Room = room2, Note = "megrendeles"
},
new OrderRoom {
Room = room3, Note = "megrendeles "
}
},
Price = (room.Price + room2.Price + room3.Price) * 6
});
await _context.SaveChangesAsync();
//var foglalasi_szobak = order.Rooms.Select(r => r.Id).ToList();
//var marFoglalva = await _context.Orders.AnyAsync(o => o.Rooms.Any(r => foglalasi_szobak.Contains(r.Id)));
//var roomId = 7;
//var szabad = _context.Rooms.Where(r => r.Id == roomId && r.OrderRooms.Any(or => or.Order.EndDate < DateTime.Now ))
}
public async Task SaveChangesAsync()
{
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException e)
{
throw new Exception("Concurrency error");
}
catch (Exception e)
{
throw;
}
}