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; }