public static async Task CountCustomersAsync()
{
using var context = new CegidDbContext();
var query = context.Customers
.Where(c => c.IsEnabled);
WriteLine($"Customers: {await query.CountAsync()}");
}
public static async Task CreateCustomerAsync()
{
Write("First name: ");
var firstName = ReadLine();
Write("Last name: ");
var lastName = ReadLine();
var customer = new Customer
{
FirstName = firstName,
LastName = lastName
};
WriteLine($"Creation of \n{customer}");
using var context = new CegidDbContext();
context.Add(customer);
await context.SaveChangesAsync();
}
public static async Task ListCustomersAsync()
{
using var context = new CegidDbContext();
var query = context.Customers
.Where(c => c.IsEnabled);
WriteLine("Number of clients to take:");
var take = int.Parse(ReadLine());
query = query.Take(take);
WriteLine("Number of clients to skip:");
var skip = int.Parse(ReadLine());
query = query.Skip(skip);
foreach (var customer in await query.ToListAsync())
{
WriteLine(customer);
}
}
public static async Task CreateRoomsAsync()
{
using var context = new CegidDbContext();
if (await context.Rooms.AnyAsync())
{
WriteLine("Already created.");
return;
}
for (int floor = 0; floor < 6; floor++)
{
for (int n = 0; n < 10; n++)
{
var room = new Room
{
Number = floor * 100 + n,
Floor = floor
};
context.Add(room);
}
}
await context.SaveChangesAsync();
}
public static async Task CreateReservationAsync()
{
Write("Customer id:");
var customerId = ReadLine();
DateTime start;
do
{
Write("Start date (dd/mm/yyyy):");
} while (!DateTime.TryParseExact(ReadLine(), "dd/MM/yyyy", null, System.Globalization.DateTimeStyles.None, out start));
DateTime end;
do
{
Write("End date (dd/mm/yyyy):");
} while (!DateTime.TryParseExact(ReadLine(), "dd/MM/yyyy", null, System.Globalization.DateTimeStyles.None, out end));
Write("Room number:");
var roomN = int.Parse(ReadLine());
using (var context = new CegidDbContext())
{
var room = await context.Rooms.FirstOrDefaultAsync(r => r.Number == roomN);
var reservation = new Reservation
{
CustomerId = customerId,
Start = start,
End = end,
RoomId = room.Id
};
context.Reservations.Add(reservation);
await context.SaveChangesAsync();
}
}