namespace TCMSDAL.DTO;

// ── Test Environment list / detail ───────────────────────────────────────────

/// <summary>
/// Row returned by GetTestEnvironments — one per MSERVERCONFIG row where DBINSTANCETYPE=1.
/// </summary>
public class TCMSTestEnvListDTO
{
    public int    ServerConfigId   { get; set; }
    public string ConnectionName   { get; set; } = string.Empty;
    public string DatabaseName     { get; set; } = string.Empty;
    public string ServerIP         { get; set; } = string.Empty;
    public string ServerName       { get; set; } = string.Empty;
    public int    DatabaseType     { get; set; }   // 0=SQL, 1=Oracle, 2=PostgreSQL, 3=MySQL
    public string DatabaseTypeText { get; set; } = string.Empty;
    public string ControlSourceDb  { get; set; } = string.Empty;
    public int    Status           { get; set; }
    public int    DbInstanceType   { get; set; }   // always 1 (TEST) in this list
    public DateTime? LastResetOn   { get; set; }
    public string? LastResetBy     { get; set; }
    public bool   IsStale          { get; set; }   // true if CTRL was updated after last sync
}

/// <summary>
/// Decrypted connection details returned by GetTestDbConnection.
/// Used by Cypress queryDb task to establish a direct test DB connection.
/// Only returned for DBINSTANCETYPE=1 (TEST) configs — never for LIVE.
/// </summary>
public class TCMSTestDbConnectionDTO
{
    public int    ServerConfigId { get; set; }
    public string ConnectionName { get; set; } = string.Empty;
    public string ServerIP       { get; set; } = string.Empty;
    public string DatabaseName   { get; set; } = string.Empty;
    public int    DatabaseType   { get; set; }   // 0=SQL, 1=Oracle, 2=PostgreSQL, 3=MySQL
    public string UserName       { get; set; } = string.Empty;   // decrypted
    public string Password       { get; set; } = string.Empty;   // decrypted
    public string Port           { get; set; } = string.Empty;
    public int    DbInstanceType { get; set; }   // 1=TEST — used to guard against exposing LIVE configs
}

/// <summary>
/// DTO for registering a new test run DB or cloning from a control copy.
/// </summary>
public class TCMSRegisterTestDbDTO
{
    public string ConnectionName     { get; set; } = string.Empty;
    public int    ServerId           { get; set; }
    public string DatabaseName       { get; set; } = string.Empty;
    public int    DatabaseType       { get; set; }   // 0=SQL, 1=Oracle, 2=PostgreSQL, 3=MySQL
    public string DatabaseUserName   { get; set; } = string.Empty;
    public string DatabasePassword   { get; set; } = string.Empty;   // plaintext — BLL encrypts before insert
    public string Port               { get; set; } = string.Empty;
    public string ControlSourceDbName{ get; set; } = string.Empty;   // stored in CONTROLSOURCEDBNAME column
    public int    ClientId           { get; set; }
    public int    ClientSiteId       { get; set; }
}

/// <summary>
/// Payload for Clone / Sync (Reset) operations.
/// </summary>
public class TCMSCloneDbDTO
{
    public string ControlDbName     { get; set; } = string.Empty;
    public string RunDbName         { get; set; } = string.Empty;
    public string ConnectionName    { get; set; } = string.Empty;   // MSERVERCONFIG.CONNECTIONNAME of the run copy
    public string TriggeredBy       { get; set; } = string.Empty;   // UserId or 'CI-PIPELINE-{id}'
}

/// <summary>
/// Payload for DB snapshot checkpoint operations.
/// </summary>
public class TCMSSnapshotDTO
{
    public int    ServerConfigId  { get; set; }
    public string SnapshotName    { get; set; } = string.Empty;   // user-provided label
    public string SnapshotDbName  { get; set; } = string.Empty;   // actual SQL Server snapshot DB name
    public string SnapshotFilePath{ get; set; } = string.Empty;   // .ss file path on server
    public DateTime CreatedOn     { get; set; }
    public string CreatedBy       { get; set; } = string.Empty;
}

// ── Reset log ─────────────────────────────────────────────────────────────────

public class TCMSTestEnvResetLogDTO
{
    public int      ResetLogId      { get; set; }
    public int      ServerConfigId  { get; set; }
    public string   ConnectionName  { get; set; } = string.Empty;
    public string   ControlSource   { get; set; } = string.Empty;
    public string   TriggeredBy     { get; set; } = string.Empty;
    public DateTime TriggeredOn     { get; set; }
    public int?     DurationMs      { get; set; }
    public bool     Success         { get; set; }
    public string?  ErrorMessage    { get; set; }
}

// ── Snapshot list item (response) ─────────────────────────────────────────────

/// <summary>
/// One snapshot row returned by GetSnapshots.
/// SQL Server: from sys.databases (COW snapshot, near-instant creation).
/// PostgreSQL: from pg_database (full-copy template clone, naming convention {RunDb}_snap_{label}).
/// </summary>
public class TCMSTestEnvSnapshotListDTO
{
    public string   SnapshotName   { get; set; } = string.Empty;
    public string   SourceDatabase { get; set; } = string.Empty;
    public DateTime CreateDate     { get; set; }
    public long     SizeMb         { get; set; }
}

// ── Sync / Deregister request DTOs ───────────────────────────────────────────

/// <summary>Payload for SyncFromControl — re-clone an existing run DB from its control source.</summary>
public class TCMSSyncFromControlDTO
{
    public int    ServerConfigId { get; set; }
    public string TriggeredBy   { get; set; } = string.Empty;
}

/// <summary>Payload for DeregisterTestDb.</summary>
public class TCMSDeregisterTestDbDTO
{
    public int  ServerConfigId { get; set; }

    /// <summary>
    /// When true, BLL will DROP the physical database on the run DB server
    /// before setting MSERVERCONFIG.STATUS=0.
    /// </summary>
    public bool DropPhysicalDb { get; set; }
}

// ── Snapshot request DTOs ─────────────────────────────────────────────────────

/// <summary>Request to create a snapshot checkpoint of a run DB.</summary>
public class TCMSCreateSnapshotDTO
{
    public int    ServerConfigId { get; set; }

    /// <summary>
    /// User-provided label. Full snapshot DB name: {RunDb}_snap_{SnapshotLabel}.
    /// Must be a valid database identifier (no spaces, no special characters).
    /// </summary>
    public string SnapshotLabel  { get; set; } = string.Empty;
}

/// <summary>Request to restore a run DB to a named snapshot.</summary>
public class TCMSRestoreToSnapshotDTO
{
    public int    ServerConfigId { get; set; }
    public string SnapshotLabel  { get; set; } = string.Empty;
}

/// <summary>Request to drop a snapshot (free disk space).</summary>
public class TCMSDeleteSnapshotDTO
{
    public int    ServerConfigId { get; set; }
    public string SnapshotLabel  { get; set; } = string.Empty;
}

// ── Dropdown ──────────────────────────────────────────────────────────────────

/// <summary>MSERVER select-list item for the Register form's server dropdown.</summary>
public class TCMSMServerSelectDTO
{
    public int    ServerId   { get; set; }
    public string ServerName { get; set; } = string.Empty;
    public string ServerIP   { get; set; } = string.Empty;
}