using TMSDAL.DTO.AttemptResponse;

namespace TMSDAL.DTO.AssessmentAttempt
{
    /// <summary>
    /// Maps to DBO.TASSESSMENTATTEMPT
    /// One assessment attempt per employee per enrollment.
    /// Same employee can attempt multiple times up to MSESSIONASSESSMENT.MAXATTEMPTS.
    /// Lifecycle: Started → Submitted → Evaluated (manual) → Pass/Fail.
    /// AttemptIsPassed = 0 (Pending) until submitted or manually evaluated.
    /// </summary>
    public class AssessmentAttemptDTO
    {
        // =====================================================
        // PRIMARY KEY
        // =====================================================
        public int AssessmentAttemptId { get; set; }

        // =====================================================
        // FOREIGN KEYS + JOINED DISPLAY FIELDS
        // =====================================================

        /// <summary>FK → MSESSIONASSESSMENT.ASSESSMENTID</summary>
        public int AssessmentId { get; set; }

        /// <summary>Joined from MSESSIONASSESSMENT.ASSESSMENTTITLE</summary>
        public string? AssessmentTitle { get; set; }

        /// <summary>FK → TTRAININGENROLLMENT.ENROLLMENTID</summary>
        public int EnrollmentId { get; set; }

        /// <summary>Joined from TTRAININGENROLLMENT → MEMPLOYEE.EMPLOYEENAME</summary>
        public string? EmployeeName { get; set; }

        /// <summary>
        /// FK → MEMPLOYEE.EMPLOYEEID
        /// -1 = Auto-evaluated. Positive = manual evaluator.
        /// </summary>
        public int EvaluatedById { get; set; } = -1;

        /// <summary>Joined from MEMPLOYEE.EMPLOYEENAME — null when auto-evaluated.</summary>
        public string? EvaluatedByName { get; set; }

        // =====================================================
        // BUSINESS COLUMNS
        // =====================================================

        /// <summary>Attempt sequence. BLL computes as existingCount + 1.</summary>
        public short AttemptNo { get; set; } = 1;

        /// <summary>Set by BLL to DateTime.UtcNow on start.</summary>
        public DateTime StartedOn { get; set; }

        /// <summary>Null while in progress. Set by BLL on submit.</summary>
        public DateTime? CompletedOn { get; set; }

        /// <summary>Total possible marks. Copied from MSESSIONASSESSMENT.TOTALMARKS.</summary>
        public int TotalMarks { get; set; } = 0;

        /// <summary>Numeric(9,4) — sum of TATTEMPTRESPONSE.MARKSAWARDED.</summary>
        public decimal MarksObtained { get; set; } = 0;

        /// <summary>Numeric(9,4) — (MarksObtained / TotalMarks) * 100.</summary>
        public decimal ScorePct { get; set; } = 0;

        /// <summary>
        /// 0 = No / Pending manual evaluation.
        /// 1 = Yes — ScorePct >= MSESSIONASSESSMENT.PASSTHRESHOLDPCT.
        /// </summary>
        public byte AttemptIsPassed { get; set; } = 0;

        /// <summary>0 = No, 1 = Yes — synced to LMS by background job.</summary>
        public byte IsLmsSynced { get; set; } = 0;

        /// <summary>Optional evaluator or system remarks. Max 1000 chars.</summary>
        public string? Remarks { get; set; }

        /// <summary>0 = InApp, 1 = Fls (link-delivered), 2 = Manual (offline/proctored entry).</summary>
        public byte DeliveryChannel { get; set; } = 0;

        // =====================================================
        // CHILD COLLECTION
        // Uses TMSDAL.DTO.AttemptResponse.AttemptResponseDTO — NOT a local class
        // Populated on GetAttempt and GetAttemptList.
        // Pass on Save/Submit with all responses included.
        // =====================================================
        public List<AttemptResponseDTO>? Responses { get; set; }

        // =====================================================
        // STANDARD FIELDS
        // =====================================================
        public short Version { get; set; }
        public byte Status { get; set; } = 1;
        public short SortOrder { get; set; } = 9999;
        public byte SourceType { get; set; } = 5;
        public int TenantId { get; set; }
        public int CreatedById { get; set; }
        public DateTime CreatedOn { get; set; }
        public int ModifiedById { get; set; }
        public DateTime ModifiedOn { get; set; }
    }


    /// <summary>
    /// Lightweight DTO for list views — no child collections.
    /// Used by GetAssessmentAttemptList endpoint.
    /// </summary>
    public class AssessmentAttemptListDTO
    {
        public int AssessmentAttemptId { get; set; }
        public int AssessmentId { get; set; }
        public string AssessmentTitle { get; set; } = string.Empty;

        /// <summary>0=Quiz, 1=PracticalTest, 2=Assignment, 3=Observation, 4=Simulation, 5=Portfolio</summary>
        public byte AssessmentType { get; set; }

        public int EnrollmentId { get; set; }
        public int EmployeeId { get; set; }
        public string EmployeeName { get; set; } = string.Empty;

        public short AttemptNo { get; set; }
        public DateTime StartedOn { get; set; }
        public DateTime? CompletedOn { get; set; }

        public int TotalMarks { get; set; }
        public decimal MarksObtained { get; set; }
        public decimal ScorePct { get; set; }

        /// <summary>0 = No/Pending, 1 = Yes</summary>
        public byte AttemptIsPassed { get; set; }

        public byte Status { get; set; }
        public DateTime CreatedOn { get; set; }
    }

    /// <summary>
    /// Full list DTO — all attempts across all enrollments with complete enrollment context.
    /// Used by GetAssessmentAttemptFullList endpoint (no EnrollmentId filter).
    /// </summary>
    public class AssessmentAttemptFullListDTO
    {
        public int AssessmentAttemptId { get; set; }
        public int AssessmentId { get; set; }
        public string AssessmentTitle { get; set; } = string.Empty;
        public byte AssessmentType { get; set; }

        public int EnrollmentId { get; set; }
        public string? EnrollmentCode { get; set; }
        public string? EnrollmentName { get; set; }

        public int InstanceId { get; set; }
        public string? InstanceCode { get; set; }
        public string? InstanceTitle { get; set; }

        public int ProgrammeId { get; set; }
        public string? ProgrammeCode { get; set; }
        public string? ProgrammeTitle { get; set; }

        public int EmployeeId { get; set; }
        public string? EmployeeCode { get; set; }
        public string? EmployeeName { get; set; }

        public short AttemptNo { get; set; }
        public DateTime StartedOn { get; set; }
        public DateTime? CompletedOn { get; set; }

        public int TotalMarks { get; set; }
        public decimal MarksObtained { get; set; }
        public decimal ScorePct { get; set; }
        public byte AttemptIsPassed { get; set; }

        public int? EvaluatedById { get; set; }
        public string? EvaluatedByName { get; set; }

        public byte IsLmsSynced { get; set; }
        public string? Remarks { get; set; }

        public short Version { get; set; }
        public byte Status { get; set; }
        public short SortOrder { get; set; }
        public byte SourceType { get; set; }
        public int TenantId { get; set; }
        public int CreatedById { get; set; }
        public DateTime CreatedOn { get; set; }
        public int ModifiedById { get; set; }
        public DateTime ModifiedOn { get; set; }

        /// <summary>Responses still at IsCorrect=-1 (Pending manual evaluation).</summary>
        public int PendingResponseCount { get; set; }
    }


    /// <summary>
    /// Minimal DTO for selectlist / picklist dropdowns.
    /// Used by GetSelectListAssessmentAttempt endpoint.
    /// </summary>
    public class AssessmentAttemptSelectDTO
    {
        public int Id { get; set; }
        public string Code { get; set; } = string.Empty;
        public string Name { get; set; } = string.Empty;
    }


    /// <summary>
    /// Request DTO for submitting a completed attempt with all responses.
    /// Used by SubmitAssessmentAttempt endpoint.
    /// Wraps the attempt identity + full response array in one payload.
    /// </summary>
    public class SubmitAttemptDTO
    {
        /// <summary>The attempt being submitted.</summary>
        public int AssessmentAttemptId { get; set; }

        public int AssessmentId { get; set; }
        public int EnrollmentId { get; set; }
        public int EmployeeId { get; set; }

        public int TotalMarks { get; set; }
        public decimal PassMark { get; set; }

        /// <summary>
        /// All per-question responses for this submission.
        /// Uses TMSDAL.DTO.AttemptResponse.AttemptResponseDTO.
        /// </summary>
        public List<AttemptResponseDTO> Responses { get; set; } = new();
    }
}