public ATTACHMENTDC GetLastInsertedAttachment(string entityType, int parentId, int recordId)
        {
            ATTACHMENTBL objAttachment = new ATTACHMENTBL();
            ATTACHMENTDC objResult     = new ATTACHMENTDC();

            if (entityType != "" && recordId > 0)
            {
                if (entityType == "JOB")
                {
                    objResult = objAttachment.LoadSingleByJobId(parentId, recordId);
                }
                else if (entityType == "PROJECT")
                {
                    objResult = objAttachment.LoadSingleByProjectId(parentId, recordId);
                }
                else if (entityType == "PERMIT")
                {
                    objResult = objAttachment.LoadSingleByPermitId(parentId, recordId);
                }
                else if (entityType == "Daily")
                {
                    objResult = objAttachment.LoadSingleByDailyId(parentId, recordId);
                }
            }
            return(objResult);
        }
        public List <ATTACHMENTDC> GetAttachmentListBasedOnType(string entityType, int recordId)
        {
            ATTACHMENTBL        objAttachment = new ATTACHMENTBL();
            List <ATTACHMENTDC> objResultList = new List <ATTACHMENTDC>();

            if (entityType != "" && recordId > 0)
            {
                if (entityType == "JOB")
                {
                    objResultList = objAttachment.LoadByJobId(recordId);
                }
                else if (entityType == "PROJECT")
                {
                    objResultList = objAttachment.LoadByProjectId(recordId);
                }
                else if (entityType == "PERMIT")
                {
                    objResultList = objAttachment.LoadByPermitId(recordId);
                }
                else if (entityType == "DAILY")
                {
                    objResultList = objAttachment.LoadByDailyId(recordId);
                }
            }
            return(objResultList);
        }