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

namespace GB5Shared.DTO.Framework.DBObject
{
    public class DBObjectDTO
    {
        #region PrivateMembers
        #region DBObject
        private int dbobjectid;
        private string dbobjectname;
        private int moduleid;
        private string modulecode;
        private string modulename;
        private string dbobjectsection;
        private byte dbobjecttype;                          //0-Tables,1-Procedure,2-Function,3-Trigger
        private string dbobjectremarks;
        private byte dbobjectisstandarddatarequired;
        private string dbobjectdatekey;
        #region NewFields
        #region DataSourceType
        private int datasourcetypeid = -1;
        private string datasourcetypecode;
        private string datasourcetypename;
        #endregion
        private string dbobjectdisplayname = "";
        private byte dbobjectobjectnature = 0;
        private byte dbobjecttabletype = 0;
        private byte dbobjectisanalysis = 0;
        #region BaseObject
        private int baseobjectid = -1;
        private string baseobjectcode = "";
        private string baseobjectname = "";
        #endregion
        private string dbobjectcondition = "";
        private byte dbobjectissystem = 0;
        private byte dbobjectisdeveloper = 0;
        private byte dbobjectisimplementation = 0;
        private byte dbobjectisadmin = 0;
        private byte dbobjectisuser = 0;
        private string dbobjectexpression = "";
        private string dbobjectvariables = "";
        private byte dbobjectquerytype = 0;
        private byte dbobjectisarchive = 0;
        private byte dbobjectreplayunit = 0;
        private decimal dbobjectreplayamount = 0;
        #region ParentObject
        private int parentobjectid = -1;
        private string parentobjectcode = "";
        private string parentobjectname = "";
        #endregion
        #region SourceObject
        private byte sourcedbobjectkind = 0;                //0-OwnTenantDb,1-ExternalClientDb
        private int? sourceclientdbid = null;
        #endregion


        #endregion
        #endregion

        #region Base
        private int dbobjectcreatedbyid;                //Created By Person (User Id)
        private DateTime dbobjectcreatedon;                //Created On Date
        private int dbobjectmodifiedbyid;               //Modified By Person (User Id)
        private DateTime dbobjectmodifiedon;               //Modified On Date
        private string dbobjectcreatedbyname;
        private string dbobjectmodifiedbyname;
        #endregion

        #region Standard
        private Int16 dbobjectsortorder;
        private byte dbobjectstatus;                        //0.Pending, 1.Active, 2.Deleted, 3.Amended, 4.Inactive, 5.Archived
        private Int16 dbobjectversion;                       //No Of Times Updated
        private byte dbobjectsourcetype;                    //Data From (1.Framework, 2.Devadmin, 3.Impadmin, 4.Admin, 5.User)
        #endregion
        private int dbobjectscreenoperationmode = 1;
        private List<DBObjectFieldsDTO> dbobjectfieldsdtos;
        private int dbobjectgroupid;
        private string dbobjectgroupname;
        private string dbobjectdeletequery = "";
        private byte dbobjectisidentityobject = 1;
        private string dbobjectdeletequerypostgre = "";
        #endregion

        #region PublicMembers
        #region DBObject
        public int DBObjectId
        {
            get { return dbobjectid; }
            set { dbobjectid = value; }
        }

        public string DBObjectName
        {
            get { return dbobjectname; }
            set { dbobjectname = value; }
        }

        public int ModuleId
        {
            get { return moduleid; }
            set { moduleid = value; }
        }
        public string ModuleCode
        {
            get { return modulecode; }
            set { modulecode = value; }
        }
        public string ModuleName
        {
            get { return modulename; }
            set { modulename = value; }
        }

        public string DBObjectSection
        {
            get { return dbobjectsection; }
            set { dbobjectsection = value; }
        }

        public byte DBObjectType
        {
            get { return dbobjecttype; }                          //0-Tables,1-Procedure,2-Function,3-Trigger
            set { dbobjecttype = value; }                          //0-Tables,1-Procedure,2-Function,3-Trigger
        }

        public string DBObjectRemarks
        {
            get { return dbobjectremarks; }
            set { dbobjectremarks = value; }
        }
        public byte DBObjectIsStandardDataRequired
        {
            get { return dbobjectisstandarddatarequired; }
            set { dbobjectisstandarddatarequired = value; }
        }
        public string DBObjectDateKey
        {
            get { return dbobjectdatekey; }
            set { dbobjectdatekey = value; }
        }
        #region DataSourceType
        public int DataSourceTypeId
        {
            get { return datasourcetypeid; }
            set { datasourcetypeid = value; }
        }


        public string DataSourceTypeCode
        {
            get { return datasourcetypecode; }
            set { datasourcetypecode = value; }
        }
        public string DataSourceTypeName
        {
            get { return datasourcetypename; }
            set { datasourcetypename = value; }
        }
        #endregion

        public string DBObjectDisplayName
        {
            get { return dbobjectdisplayname; }
            set { dbobjectdisplayname = value; }
        }
        public byte DBObjectObjectNature
        {
            get { return dbobjectobjectnature; }
            set { dbobjectobjectnature = value; }
        }
        public byte DBObjectTableType
        {
            get { return dbobjecttabletype; }
            set { dbobjecttabletype = value; }
        }
        public byte DBObjectIsAnalysis
        {
            get { return dbobjectisanalysis; }                          //0-Tables,1-Procedure,2-Function,3-Trigger
            set { dbobjectisanalysis = value; }                          //0-Tables,1-Procedure,2-Function,3-Trigger
        }
        #region BaseObject
        public int BaseObjectId
        {
            get { return baseobjectid; }                          //0-Tables,1-Procedure,2-Function,3-Trigger
            set { baseobjectid = value; }                          //0-Tables,1-Procedure,2-Function,3-Trigger
        }

        public string BaseObjectCode
        {
            get { return baseobjectcode; }                          //0-Tables,1-Procedure,2-Function,3-Trigger
            set { baseobjectcode = value; }                          //0-Tables,1-Procedure,2-Function,3-Trigger
        }

        public string BaseObjectName
        {
            get { return baseobjectname; }                          //0-Tables,1-Procedure,2-Function,3-Trigger
            set { baseobjectname = value; }                          //0-Tables,1-Procedure,2-Function,3-Trigger
        }

        #endregion
        public string DBObjectCondition
        {
            get { return dbobjectcondition; }                          //0-Tables,1-Procedure,2-Function,3-Trigger
            set { dbobjectcondition = value; }                          //0-Tables,1-Procedure,2-Function,3-Trigger
        }
        public byte DBObjectIsSystem
        {
            get { return dbobjectissystem; }                          //0-Tables,1-Procedure,2-Function,3-Trigger
            set { dbobjectissystem = value; }                          //0-Tables,1-Procedure,2-Function,3-Trigger



        }
        public byte DBObjectIsDeveloper
        {
            get { return dbobjectisdeveloper; }                          //0-Tables,1-Procedure,2-Function,3-Trigger
            set { dbobjectisdeveloper = value; }                          //0-Tables,1-Procedure,2-Function,3-Trigger
        }
        public byte DBObjectIsImplementation
        {
            get { return dbobjectisimplementation; }                          //0-Tables,1-Procedure,2-Function,3-Trigger
            set { dbobjectisimplementation = value; }                          //0-Tables,1-Procedure,2-Function,3-Trigger
        }
        public byte DBObjectIsAdmin
        {
            get { return dbobjectisadmin; }                          //0-Tables,1-Procedure,2-Function,3-Trigger
            set { dbobjectisadmin = value; }                          //0-Tables,1-Procedure,2-Function,3-Trigger
        }
        public byte DBObjectIsUser
        {
            get { return dbobjectisuser; }                          //0-Tables,1-Procedure,2-Function,3-Trigger
            set { dbobjectisuser = value; }                          //0-Tables,1-Procedure,2-Function,3-Trigger
        }
        public string DBObjectExpression
        {
            get { return dbobjectexpression; }                          //0-Tables,1-Procedure,2-Function,3-Trigger
            set { dbobjectexpression = value; }                          //0-Tables,1-Procedure,2-Function,3-Trigger
        }
        public string DBObjectVariables
        {
            get { return dbobjectvariables; }                          //0-Tables,1-Procedure,2-Function,3-Trigger
            set { dbobjectvariables = value; }                          //0-Tables,1-Procedure,2-Function,3-Trigger
        }
        public byte DBObjectQueryType
        {
            get { return dbobjectquerytype; }
            set { dbobjectquerytype = value; }
        }
        public byte DBObjectIsArchive
        {
            get { return dbobjectisarchive; }
            set { dbobjectisarchive = value; }
        }
        public byte DBObjectReplayUnit
        {
            get { return dbobjectreplayunit; }
            set { dbobjectreplayunit = value; }
        }
        public decimal DBObjectReplayAmount
        {
            get { return dbobjectreplayamount; }
            set { dbobjectreplayamount = value; }
        }


        #region ParentObject
        public int ParentObjectId
        {
            get { return parentobjectid; }
            set { parentobjectid = value; }
        }

        public string ParentObjectCode
        {
            get { return parentobjectcode; }
            set { parentobjectcode = value; }
        }

        public string ParentObjectName
        {
            get { return parentobjectname; }
            set { parentobjectname = value; }
        }

        #endregion

        #region SourceObject
        public byte SourceDbObjectKind
        {
            get { return sourcedbobjectkind; }                //0-OwnTenantDb,1-ExternalClientDb
            set { sourcedbobjectkind = value; }                //0-OwnTenantDb,1-ExternalClientDb
        }

        public int? SourceClientDbId
        {
            get { return sourceclientdbid; }
            set { sourceclientdbid = value; }
        }
        #endregion



        #endregion

        #region Base
        public int DBObjectCreatedById
        {
            get { return dbobjectcreatedbyid; }                   //Created By Person (User Id)
            set { dbobjectcreatedbyid = value; }                   //Created By Person (User Id)
        }

        public DateTime DBObjectCreatedOn
        {
            get { return dbobjectcreatedon; }                     //Created On Date
            set { dbobjectcreatedon = value; }                     //Created On Date
        }

        public int DBObjectModifiedById
        {
            get { return dbobjectmodifiedbyid; }                  //Modified By Person (User Id)
            set { dbobjectmodifiedbyid = value; }
        }

        public DateTime DBObjectModifiedOn
        {
            get { return dbobjectmodifiedon; }                    //Modified On Date
            set { dbobjectmodifiedon = value; }
        }

        public string DBObjectCreatedByName
        {
            get { return dbobjectcreatedbyname; }                   //GcmTypeCreatedByName
            set { dbobjectcreatedbyname = value; }                   //GcmTypeCreatedByName
        }

        public string DBObjectModifiedByName
        {
            get { return dbobjectmodifiedbyname; }                   //GcmTypeModifiedByName
            set { dbobjectmodifiedbyname = value; }                   //GcmTypeModifiedByName
        }
        #endregion

        #region Standard
        public Int16 DBObjectSortOrder
        {
            get { return dbobjectsortorder; }
            set { dbobjectsortorder = value; }
        }

        public byte DBObjectStatus
        {
            get { return dbobjectstatus; }                        //0.Pending, 1.Active, 2.Deleted, 3.Amended, 4.Inactive, 5.Archived
            set { dbobjectstatus = value; }
        }

        public Int16 DBObjectVersion
        {
            get { return dbobjectversion; }                       //No Of Times Updated
            set { dbobjectversion = value; }
        }

        public byte DBObjectSourceType
        {
            get { return dbobjectsourcetype; }                    //Data From (1.Framework, 2.Devadmin, 3.Impadmin, 4.Admin, 5.User)
            set { dbobjectsourcetype = value; }
        }



        #endregion
        public int DBObjectScreenOperationMode
        {
            get { return dbobjectscreenoperationmode; }
            set { dbobjectscreenoperationmode = value; }
        }

        public List<DBObjectFieldsDTO> DBObjectFields
        {
            get { return dbobjectfieldsdtos; }
            set { dbobjectfieldsdtos = value; }
        }

        #region Added For Analysis on 09 June 2015
        private string filterexpression;
        public string FilterExpression
        {
            get { return filterexpression; }
            set { filterexpression = value; }
        }
        #endregion



        public int GroupDBObjectId
        {
            get { return dbobjectgroupid; }
            set { dbobjectgroupid = value; }
        }
        public string GroupDBObjectName
        {
            get { return dbobjectgroupname; }
            set { dbobjectgroupname = value; }
        }

        public string DBObjectDeleteQuery
        {
            get { return dbobjectdeletequery; }
            set { dbobjectdeletequery = value; }
        }


        public byte DBObjectIsIdentityObject
        {
            get { return dbobjectisidentityobject; }
            set { dbobjectisidentityobject = value; }
        }

        public string DBObjectDeleteQueryPostgre
        {
            get { return dbobjectdeletequerypostgre; }
            set { dbobjectdeletequerypostgre = value; }
        }


        #endregion
    }
}