using SmartStack.Domain.Platform.Administration.Tenants.Organisation;
using SmartStack.Domain.Platform.Administration.Users;
using {{ProjectName}}.Domain.Common;

namespace {{ProjectName}}.Domain.Entities;

/// <summary>
/// Example entity demonstrating REAL navigation properties + SQL foreign keys
/// to Core entities in the V1 whitelist (User, TenantOrganisation).
///
/// The owning side carries the GUID FK column AND a navigation property to
/// the Core principal. EF Core emits a real cross-schema FK in the migration
/// (targeting <c>core.auth_Users(Id)</c> / <c>core.tenant_TenantOrganisations(Id)</c>)
/// because <c>SmartStackExtensionDbContext</c> exposes those entities via
/// <c>ExcludeFromMigrations</c> — see the base class.
///
/// You can <c>.Include(o =&gt; o.Customer)</c> / <c>.Include(o =&gt; o.Organisation)</c>
/// to hydrate the principal in the same SQL query (INNER JOIN), or query a
/// nav field directly: <c>_db.Orders.Where(o =&gt; o.Customer.Email == ...)</c>.
/// </summary>
public class Order : ExtensionBaseEntity
{
    public string OrderNumber { get; private set; } = null!;

    /// <summary>FK to <c>core.auth_Users(Id)</c> — the user placing the order.</summary>
    public Guid CustomerUserId { get; private set; }

    /// <summary>FK to <c>core.tenant_TenantOrganisations(Id)</c> — the customer's organisation.</summary>
    public Guid OrganisationId { get; private set; }

    public OrderStatus Status { get; private set; }
    public decimal TotalAmount { get; private set; }
    public DateTime OrderDate { get; private set; }
    public string? Notes { get; private set; }

    /// <summary>Navigation to the placing User. Real cross-schema FK.</summary>
    public User Customer { get; private set; } = null!;

    /// <summary>Navigation to the TenantOrganisation (the shared organisation directory). Real cross-schema FK.</summary>
    public TenantOrganisation Organisation { get; private set; } = null!;

    // Private constructor for EF Core
    private Order() { }

    /// <summary>
    /// Creates a new order. The Customer / Organisation navigations are lazily
    /// hydrated by <c>.Include(...)</c> at query time — the factory only
    /// stores the FK GUIDs.
    /// </summary>
    public static Order Create(string orderNumber, Guid customerUserId, Guid organisationId, decimal totalAmount)
    {
        ArgumentException.ThrowIfNullOrWhiteSpace(orderNumber);

        return new Order
        {
            OrderNumber = orderNumber,
            CustomerUserId = customerUserId,
            OrganisationId = organisationId,
            Status = OrderStatus.Pending,
            TotalAmount = totalAmount,
            OrderDate = DateTime.UtcNow
        };
    }

    public void Confirm()
    {
        if (Status != OrderStatus.Pending)
            throw new InvalidOperationException("Only pending orders can be confirmed.");

        Status = OrderStatus.Confirmed;
    }

    public void Ship()
    {
        if (Status != OrderStatus.Confirmed)
            throw new InvalidOperationException("Only confirmed orders can be shipped.");

        Status = OrderStatus.Shipped;
    }

    public void Complete()
    {
        if (Status != OrderStatus.Shipped)
            throw new InvalidOperationException("Only shipped orders can be completed.");

        Status = OrderStatus.Completed;
    }

    public void Cancel()
    {
        if (Status == OrderStatus.Completed)
            throw new InvalidOperationException("Completed orders cannot be cancelled.");

        Status = OrderStatus.Cancelled;
    }

    public void AddNotes(string notes)
    {
        Notes = notes;
    }
}

/// <summary>
/// Order status enum.
/// </summary>
public enum OrderStatus
{
    Pending = 0,
    Confirmed = 1,
    Shipped = 2,
    Completed = 3,
    Cancelled = 4
}