private List <JoinedProspect> FillObjectCollection(IDataReader dataReader) { List <JoinedProspect> prospects = new List <JoinedProspect>(); while (dataReader.Read()) { JoinedProspect prospect = this.FillObject(dataReader); prospects.Add(prospect); } return(prospects); }
private JoinedProspect FillObject(IDataReader dataReader) { JoinedProspect joinedProspect = new JoinedProspect(); joinedProspect.incorpName = DatabaseUtil.ToString(dataReader["NAME"]); joinedProspect.incropNameLSAD = DatabaseUtil.ToString(dataReader["NAMELSAD"]); joinedProspect.classFP = DatabaseUtil.ToString(dataReader["CLASSFP"]); joinedProspect.Address = DatabaseUtil.ToString(dataReader["CorrectedAddressLine1"]); joinedProspect.doNotContactFlag = DatabaseUtil.ToInt32(dataReader["DoNotContactFlag"]); joinedProspect.currentCustomerFlag = DatabaseUtil.ToInt32(dataReader["CurrentCustomerFlag"]); joinedProspect.CorrectedLatitude = DatabaseUtil.ToDouble(dataReader["CorrectedLatitude"]); joinedProspect.CorrectedLongitude = DatabaseUtil.ToDouble(dataReader["CorrectedLongitude"]); joinedProspect.cancelledFlag = DatabaseUtil.ToInt32(dataReader["CancelledFlag"]); joinedProspect.firstName = DatabaseUtil.ToString(dataReader["FirstName"]); joinedProspect.lastName = DatabaseUtil.ToString(dataReader["LastName"]); return(joinedProspect); }