using System;

namespace AccountsDAL.DTO.WarehouseFact
{
    // CRUD-shaped DTO for MWAREHOUSEFACT admin endpoints (Get/Save/Delete) — see the GB5 Data
    // Warehouse developer guide section 09.4 (lowest urgency; facts are added very infrequently).
    public class WarehouseFactDTO
    {
        #region PrivateMembers
        #region WarehouseFact
        private int factid;
        private string factcode;
        private string factname;
        private string facttablename;                  // must match ^[A-Z0-9_]+$ before any SQL substitution
        private string? graindescription;
        private string datedimcolumn = "DATEID";
        private string oudimcolumn = "OUID";
        private string? businessdescription;
        private string? synonyms;
        private byte sourcetype;                        // 1 Framework-shipped by default
        private int tenantid = -1;                       // -1 = shared across tenants
        #endregion

        #region Base
        private int factcreatedbyid;
        private DateTime factcreatedon;
        private int factmodifiedbyid;
        private DateTime factmodifiedon;
        #endregion

        #region Standard
        private byte factstatus;                        // 0.Pending, 1.Active, 2.Deleted, 3.Amended, 4.Inactive, 5.Archived
        private Int16 factversion;
        private Int16 factsortorder;
        #endregion
        #endregion


        #region PublicMembers
        #region WarehouseFact
        public int FactId
        {
            get { return factid; }
            set { factid = value; }
        }

        public string FactCode
        {
            get { return factcode; }
            set { factcode = value; }
        }

        public string FactName
        {
            get { return factname; }
            set { factname = value; }
        }

        public string FactTableName
        {
            get { return facttablename; }
            set { facttablename = value; }
        }

        public string? GrainDescription
        {
            get { return graindescription; }
            set { graindescription = value; }
        }

        public string DateDimColumn
        {
            get { return datedimcolumn; }
            set { datedimcolumn = value; }
        }

        public string OuDimColumn
        {
            get { return oudimcolumn; }
            set { oudimcolumn = value; }
        }

        public string? BusinessDescription
        {
            get { return businessdescription; }
            set { businessdescription = value; }
        }

        public string? Synonyms
        {
            get { return synonyms; }
            set { synonyms = value; }
        }

        public byte SourceType
        {
            get { return sourcetype; }
            set { sourcetype = value; }
        }

        public int TenantId
        {
            get { return tenantid; }
            set { tenantid = value; }
        }
        #endregion

        #region Base
        public int FactCreatedById
        {
            get { return factcreatedbyid; }
            set { factcreatedbyid = value; }
        }

        public DateTime FactCreatedOn
        {
            get { return factcreatedon; }
            set { factcreatedon = value; }
        }

        public int FactModifiedById
        {
            get { return factmodifiedbyid; }
            set { factmodifiedbyid = value; }
        }

        public DateTime FactModifiedOn
        {
            get { return factmodifiedon; }
            set { factmodifiedon = value; }
        }
        #endregion

        #region Standard
        public byte FactStatus
        {
            get { return factstatus; }
            set { factstatus = value; }
        }

        public Int16 FactVersion
        {
            get { return factversion; }
            set { factversion = value; }
        }

        public Int16 FactSortOrder
        {
            get { return factsortorder; }
            set { factsortorder = value; }
        }
        #endregion
        #endregion
    }
}