namespace DMSDAL.DTO.ESSDocument
{
    /// <summary>
    /// Projection of TATTACHMENT for ESS (Employee Self-Service) document retrieval.
    /// StoragePath (CMSID) is internal only — never serialised to the frontend response.
    /// </summary>
    public class ESSDocumentDTO
    {
        public int      AttachmentId      { get; set; }
        public int      ObjectTypeId      { get; set; }
        public int      EmployeeId        { get; set; }   // OBJECTID — ownership key
        public int      DocumentTypeId    { get; set; }
        public string   CategoryCode      { get; set; } = string.Empty;
        public string   CategoryName      { get; set; } = string.Empty;
        public DateTime ValidFrom         { get; set; }
        public DateTime ValidTo           { get; set; }
        public string?  PeriodLabel       { get; set; }   // FOLDERNAME re-used as label
        public string?  DisplayFileName   { get; set; }   // DISPLAYFILENAME
        public string?  AttachedFileName  { get; set; }   // ATTACHEDFILENAME (physical name)
        public string?  StoragePath       { get; set; }   // CMSID — internal, not sent to client
        public string?  MimeType          { get; set; }   // MIMETYPE (new column)
        public long     FileSizeBytes     { get; set; }   // FILESIZEBYTES (new column)
        public int      AttachmentOption  { get; set; }   // 0=system-gen, 1=emp-upload, 2=admin
        public int      Status            { get; set; }
        public DateTime CreatedOn         { get; set; }
    }
    // ── Internal resolver DTO ─────────────────────────────────────────────
    public class EmployeeIdDTO
    {
        public int EmployeeId { get; set; }
    }

}