practice/practiceApplicaiton/Models.cs

namespace practiceApplicaiton;

public class Booking
{
    public int BookingId { get; set; }
    public int ClientId { get; set; }
    public int RoomId { get; set; }
    public DateTime CheckInDate { get; set; }
    public DateTime CheckOutDate { get; set; }
    public decimal PricePerNight { get; set; }

    // Из JOIN — для отображения
    public string ClientFullName { get; set; } = "";
    public int RoomNumber { get; set; }
    public string RoomType { get; set; } = "";
    public int Nights => (CheckOutDate - CheckInDate).Days;
    public decimal TotalCost => PricePerNight * Nights; // Расчётный атрибут
}

public class Client
{
    public int ClientId { get; set; }
    public int FirmId { get; set; }
    public string LastName { get; set; } = "";
    public string FirstName { get; set; } = "";
    public string Patronymic { get; set; } = "";
    public string PhoneNumber { get; set; } = "";
    public string FirmName { get; set; } = "";
    public string FullName => $"{LastName} {FirstName} {Patronymic}".Trim();
}

public class Room
{
    public int RoomId { get; set; }
    public int RoomTypeId { get; set; }
    public int RoomNumber { get; set; }
    public int Occupancy { get; set; }
    public decimal Rating { get; set; }
    public string TypeName { get; set; } = "";
}

public class TourFirm
{
    public int FirmId { get; set; }
    public string FirmName { get; set; } = "";
    public int PeopleCount { get; set; }
}