using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace TMSDAL.DTO.EvaluationInsight
{
    /// <summary>
    /// Maps to DBO.TEVALUATIONINSIGHT
    /// HR / L&D synthesis record summarising findings from a cohort of evaluation responses.
    /// Created manually by HR after reviewing collected responses for an evaluation plan.
    /// Drives downstream actions: programme revisions, skill gap analysis, follow-up training.
    /// Editable — can be revised as more data becomes available.
    /// </summary>
    public class EvaluationInsightDTO
    {
        // =====================================================
        // PRIMARY KEY
        // =====================================================

        /// <summary>
        /// Unique identifier for this evaluation insight record.
        /// Auto-generated via AutoNumber — do not set manually on insert.
        /// InsightId = 0 → BLL will INSERT. InsightId > 0 → BLL will UPDATE.
        /// </summary>
        public int EvaluationInsightId { get; set; }


        // =====================================================
        // BUSINESS COLUMNS — FOREIGN KEYS
        // =====================================================

        /// <summary>
        /// FK → MEVALUATIONPLAN.EVALUATIONPLANID
        /// The evaluation plan this insight summarises.
        /// </summary>
        public int EvaluationPlanId { get; set; }

        /// <summary>
        /// Joined from MEVALUATIONPLAN — display reference only.
        /// </summary>
        public string? PlanTitle { get; set; }

        /// <summary>
        /// FK → TTRAININGINSTANCE.INSTANCEID
        /// -1 = Not linked to a specific training run (multi-programme or period evaluation).
        /// Set to the specific training instance when insight is for a single programme cohort.
        /// </summary>
        public int InstanceId { get; set; } = -1;


        // =====================================================
        // BUSINESS COLUMNS — COHORT METRICS
        // =====================================================

        /// <summary>
        /// Total number of employees in the evaluation cohort.
        /// Denominator for ResponseRate calculation.
        /// </summary>
        public int CohortSize { get; set; } = 0;

        /// <summary>
        /// Number of employees who actually submitted a response.
        /// Numerator for ResponseRate calculation.
        /// </summary>
        public int ResponseCount { get; set; } = 0;

        /// <summary>
        /// Percentage of cohort who responded.
        /// Numeric(9,4) — e.g. 87.5000 = 87.5%.
        /// Computed as (ResponseCount / CohortSize) * 100.
        /// </summary>
        public decimal ResponseRate { get; set; } = 0;

        /// <summary>
        /// Average rating across all submitted responses.
        /// Numeric(3,1) — e.g. 4.2 out of 5.0.
        /// Computed from TEVALUATIONRESPONSE.OVERALLRATING values.
        /// </summary>
        public decimal AvgRating { get; set; } = 0;


        // =====================================================
        // BUSINESS COLUMNS — QUALITATIVE ANALYSIS
        // =====================================================

        /// <summary>
        /// Key themes identified from the evaluation responses.
        /// Free text or structured summary written by HR/L&D analyst.
        /// e.g. "Strong positive feedback on trainer delivery; concerns about pacing."
        /// </summary>
        public string? KeyThemes { get; set; }

        /// <summary>
        /// HR/L&D narrative summarising the overall evaluation findings.
        /// Supports multi-paragraph free text.
        /// </summary>
        public string? SummaryNotes { get; set; }

        /// <summary>
        /// Specific actions recommended based on evaluation outcomes.
        /// e.g. "Revise Module 3 content; increase practical exercises."
        /// </summary>
        public string? RecommendedActions { get; set; }

        /// <summary>
        /// Observable skill improvements noted post-training (L3 Behaviour level).
        /// Populated for Kirkpatrick Level 3 evaluation plans.
        /// </summary>
        public string? SkillImpactObserved { get; set; }

        /// <summary>
        /// Competency framework impact observed from the training cohort.
        /// Populated for Kirkpatrick Level 3–4 evaluation plans.
        /// </summary>
        public string? CompetencyImpact { get; set; }


        // =====================================================
        // BUSINESS COLUMNS — GENERATION AUDIT
        // =====================================================

        /// <summary>
        /// FK → MEMPLOYEE.EMPLOYEEID
        /// The HR/L&D staff member who created this insight record.
        /// Set by BLL to loginDTO.UserId on insert — do not set manually.
        /// </summary>
        public int GeneratedById { get; set; }

        /// <summary>
        /// Joined from MEMPLOYEE — display reference only.
        /// </summary>
        public string? GeneratedByName { get; set; }

        /// <summary>
        /// Timestamp when this insight was first generated.
        /// Set by BLL to DateTime.UtcNow on insert — do not set manually.
        /// </summary>
        public DateTime GeneratedOn { get; set; }


        // =====================================================
        // STANDARD FIELDS
        // =====================================================

        /// <summary>Optimistic concurrency version counter.</summary>
        public short Version { get; set; }

        /// <summary>
        /// Record status.
        /// 0 = Inactive, 1 = Active, 2–5 = Custom workflow states.
        /// </summary>
        public byte Status { get; set; } = 1;

        /// <summary>Display sort order. Default 9999 = append to end.</summary>
        public short SortOrder { get; set; } = 9999;

        /// <summary>
        /// Source of record creation.
        /// 1–4 = Import sources, 5 = Manual entry (default).
        /// </summary>
        public byte SourceType { get; set; } = 5;

        /// <summary>FK → MCLIENT.CLIENTID. Set by BLL from LoginDTO.</summary>
        public int TenantId { get; set; }

        /// <summary>FK → MUSER.USERID. Set by BLL from LoginDTO.</summary>
        public int CreatedById { get; set; }

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

        /// <summary>FK → MUSER.USERID. Updated by BLL on every save.</summary>
        public int ModifiedById { get; set; }

        /// <summary>Set by BLL to DateTime.UtcNow on every save.</summary>
        public DateTime ModifiedOn { get; set; }
    }
}