public List <AutoMatch> GetAutoMatchMappings()
{
List <AutoMatch> autoMatchList = new List <AutoMatch>();
SqlCommand cmd = new SqlCommand();
SqlDataReader reader;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = SqlConnectionMain;
// Get previously defined patient ID mappings
cmd.CommandText = "GetAutoMatchMappings";
reader = cmd.ExecuteReader();
while (reader.Read())
{
AutoMatch autoMatch = new AutoMatch();
autoMatch.LastName = UtilitiesDAL.ToString(reader["LastName"]);
autoMatch.FirstName = UtilitiesDAL.ToString(reader["FirstName"]);
autoMatch.Gender = UtilitiesDAL.ToString(reader["Gender"]);
autoMatch.DOB = UtilitiesDAL.ToDateTime(reader["DateOfBirth"]);
autoMatch.SSN = UtilitiesDAL.ToString(reader["SSN"]).Replace("-", "");
autoMatch.MatchedToUserId = UtilitiesDAL.ToInt(reader["MatchedToUserID"]);
autoMatchList.Add(autoMatch);
}
reader.Close();
return(autoMatchList);
}
public List<AutoMatch> GetAutoMatchMappings()
{
List<AutoMatch> autoMatchList = new List<AutoMatch>();
SqlCommand cmd = new SqlCommand();
SqlDataReader reader;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = SqlConnectionMain;
// Get previously defined patient ID mappings
cmd.CommandText = "GetAutoMatchMappings";
reader = cmd.ExecuteReader();
while (reader.Read())
{
AutoMatch autoMatch = new AutoMatch();
autoMatch.LastName = UtilitiesDAL.ToString(reader["LastName"]);
autoMatch.FirstName = UtilitiesDAL.ToString(reader["FirstName"]);
autoMatch.Gender = UtilitiesDAL.ToString(reader["Gender"]);
autoMatch.DOB = UtilitiesDAL.ToDateTime(reader["DateOfBirth"]);
autoMatch.SSN = UtilitiesDAL.ToString(reader["SSN"]).Replace("-", "");
autoMatch.MatchedToUserId = UtilitiesDAL.ToInt(reader["MatchedToUserID"]);
autoMatchList.Add(autoMatch);
}
reader.Close();
return autoMatchList;
}
