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

namespace TMSDAL.DTO.EvaluationResponse
{
    /// <summary>
    /// Maps to DBO.TEVALUATIONRESPONSE
    /// The filled evaluation form submitted by a respondent for a specific instance.
    /// Responses are IMMUTABLE — no update after submission.
    /// Submitting a response automatically marks the parent instance as Completed.
    /// One response per respondent per instance.
    /// </summary>
    public class EvaluationResponseDTO
    {
        // =====================================================
        // PRIMARY KEY
        // =====================================================

        /// <summary>
        /// Unique identifier for this evaluation response.
        /// Auto-generated via AutoNumber — do not set manually on insert.
        /// </summary>
        public int EvaluationResponseId { get; set; }


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

        /// <summary>
        /// FK → TEVALUATIONINSTANCE.EVALUATIONINSTANCEID
        /// The evaluation instance this response belongs to.
        /// </summary>
        public int EvaluationInstanceId { get; set; }

        /// <summary>
        /// FK → MEMPLOYEE.EMPLOYEEID
        /// The person who filled and submitted this response.
        /// May differ from EmployeeId if RespondentType = Supervisor / Manager.
        /// </summary>
        public int RespondentId { get; set; }

        /// <summary>
        /// Joined from MEMPLOYEE — display reference only.
        /// Hidden in response if IsAnonymous = 1.
        /// </summary>
        public string? RespondentName { get; set; }


        // =====================================================
        // BUSINESS COLUMNS — RESPONSE DATA
        // =====================================================

        /// <summary>
        /// JSON payload containing answers to all template questions.
        /// Format: [{ "questionId": 1, "answer": "5" }, { "questionId": 2, "answer": "Strongly Agree" }]
        /// Structure mirrors MEVALUATIONTEMPLATE.QUESTIONSJSON question IDs.
        /// Required — cannot be empty on submit.
        /// </summary>
        public string ResponseDataJson { get; set; } = string.Empty;

        /// <summary>
        /// Computed overall rating derived from ResponseDataJson answers.
        /// Numeric(3,1) — e.g. 4.5 out of 5.0.
        /// Calculated and set by the client or BLL before save.
        /// </summary>
        public decimal OverallRating { get; set; } = 0;

        /// <summary>
        /// Timestamp when the respondent submitted the form.
        /// Set by BLL to DateTime.UtcNow on submit — do not set manually.
        /// </summary>
        public DateTime SubmittedOn { get; set; }

        /// <summary>
        /// Whether this response should hide the respondent's identity.
        /// 0 = No — RespondentName visible to HR/L&D.
        /// 1 = Yes — RespondentName hidden; ResponseDataJson still stored.
        /// </summary>
        public byte IsAnonymous { get; set; } = 0;


        // =====================================================
        // 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; }
    }
}