public List <ExplicitMatch> GetExplicitMatchMappings() { List <ExplicitMatch> explicitMatchList = new List <ExplicitMatch>(); SqlCommand cmd = new SqlCommand(); SqlDataReader reader; cmd.CommandType = CommandType.StoredProcedure; cmd.Connection = SqlConnectionMain; // Get previously defined patient ID mappings cmd.CommandText = "GetExplicitMatchMappings"; reader = cmd.ExecuteReader(); while (reader.Read()) { ExplicitMatch explicitMatch = new ExplicitMatch(); explicitMatch.DataLoadMismatchTestId = UtilitiesDAL.ToInt(reader["DataLoadMismatchTestID"]); explicitMatch.MatchedToUserId = UtilitiesDAL.ToInt(reader["MatchedToUserID"]); explicitMatch.MatchedToTestId = UtilitiesDAL.ToInt(reader["MatchedToTestID"]); explicitMatchList.Add(explicitMatch); } reader.Close(); return(explicitMatchList); }
public List<ExplicitMatch> GetExplicitMatchMappings() { List<ExplicitMatch> explicitMatchList = new List<ExplicitMatch>(); SqlCommand cmd = new SqlCommand(); SqlDataReader reader; cmd.CommandType = CommandType.StoredProcedure; cmd.Connection = SqlConnectionMain; // Get previously defined patient ID mappings cmd.CommandText = "GetExplicitMatchMappings"; reader = cmd.ExecuteReader(); while (reader.Read()) { ExplicitMatch explicitMatch = new ExplicitMatch(); explicitMatch.DataLoadMismatchTestId = UtilitiesDAL.ToInt(reader["DataLoadMismatchTestID"]); explicitMatch.MatchedToUserId = UtilitiesDAL.ToInt(reader["MatchedToUserID"]); explicitMatch.MatchedToTestId = UtilitiesDAL.ToInt(reader["MatchedToTestID"]); explicitMatchList.Add(explicitMatch); } reader.Close(); return explicitMatchList; }