public static List<ProblemsPerOtherMemberMigration> GetAllByOtherMemberMigrationID(int OtherMemberMigrationID)
        {
            List<ProblemsPerOtherMemberMigration> lstProblemsPerOtherMemberMigration = new List<ProblemsPerOtherMemberMigration>();

            DataView objDataView = new DocumentsBehindDAO().Select("*", "tbl_problems_per_other_member_migration", "OtherMemberMigrationID=" + OtherMemberMigrationID);

            foreach (DataRowView drv in objDataView)
            {
                ProblemsPerOtherMemberMigration objProblemsPerOtherMemberMigration = new ProblemsPerOtherMemberMigration();
                objProblemsPerOtherMemberMigration.ProblemPerOtherMemberMigrationID = (int)drv["ProblemPerOtherMemberMigrationID"];
                objProblemsPerOtherMemberMigration.OtherMemberMigrationID = (int)drv["OtherMemberMigrationID"];
                objProblemsPerOtherMemberMigration.ProblemTypeID = (int)drv["ProblemTypeID"];
                lstProblemsPerOtherMemberMigration.Add(objProblemsPerOtherMemberMigration);
            }
            return lstProblemsPerOtherMemberMigration;
        }
        public static List<DocumentsPerOtherMemberMigration> GetAllByOtherMemberMigrationID(int OtherMemberMigrationID)
        {
            List<DocumentsPerOtherMemberMigration> lstDocumentsPerOtherMemberMigration = new List<DocumentsPerOtherMemberMigration>();

            DataView objDataView = new DocumentsBehindDAO().Select("*", "tbl_documents_per_other_member_migration", "OtherMemberMigrationID=" + OtherMemberMigrationID);

            foreach (DataRowView drv in objDataView)
            {
                DocumentsPerOtherMemberMigration objDocumentsPerOtherMemberMigration = new DocumentsPerOtherMemberMigration();
                objDocumentsPerOtherMemberMigration.DocumentsPerOtherMemberMigrationID = (int)drv["DocumentsPerOtherMemberMigrationID"];
                objDocumentsPerOtherMemberMigration.OtherMemberMigrationID = (int)drv["OtherMemberMigrationID"];
                objDocumentsPerOtherMemberMigration.DocumentBehindID = (int)drv["DocumentBehindID"];
                lstDocumentsPerOtherMemberMigration.Add(objDocumentsPerOtherMemberMigration);
            }

            return lstDocumentsPerOtherMemberMigration;
        }