/// <summary>
/// Takes an prepopulated IDataReader and creates an array of Businesss
/// </summary>
public static List<Business> PopulateObject(IDataReader dr)
{
ColumnFieldList list = new ColumnFieldList(dr);
List<Business> arr = new List<Business>();
Business obj;
while (dr.Read())
{
obj = new Business();
if (list.IsColumnPresent("BusinessID")) { obj._businessID = (int)dr["BusinessID"]; }
if (list.IsColumnPresent("MemberID")) { obj._memberID = (int)dr["MemberID"]; }
if (list.IsColumnPresent("CompanyName")) { obj._companyName = (string)dr["CompanyName"]; }
if (list.IsColumnPresent("YearFounded")) { obj._yearFounded = (int)dr["YearFounded"]; }
if (list.IsColumnPresent("IndustrySector")) { obj._industrySector = (string)dr["IndustrySector"]; }
if (list.IsColumnPresent("NumberOfEmployees")) { obj._numberOfEmployees = (int)dr["NumberOfEmployees"]; }
if (list.IsColumnPresent("BasicInfo")) { obj._basicInfo = (string)dr["BasicInfo"]; }
if (list.IsColumnPresent("CompanyWebsite")) { obj._companyWebsite = (string)dr["CompanyWebsite"]; }
if (list.IsColumnPresent("TagLine")) { obj._tagLine = (string)dr["TagLine"]; }
if (list.IsColumnPresent("ContactFirst")) { obj._contactFirst = (string)dr["ContactFirst"]; }
if (list.IsColumnPresent("ContactLast")) { obj._contactLast = (string)dr["ContactLast"]; }
if (list.IsColumnPresent("CompanySize")) { obj._companySize = (string)dr["CompanySize"]; }
if (list.IsColumnPresent("StreetAddress")) { obj._streetAddress = (string)dr["StreetAddress"]; }
if (list.IsColumnPresent("City")) { obj._city = (string)dr["City"]; }
if (list.IsColumnPresent("State")) { obj._state = (string)dr["State"]; }
if (list.IsColumnPresent("Country")) { obj._country = (string)dr["Country"]; }
if (list.IsColumnPresent("ZipCode")) { obj._zipCode = (string)dr["ZipCode"]; }
if (list.IsColumnPresent("MySpaceURL")) { obj._mySpaceURL = (string)dr["MySpaceURL"]; }
if (list.IsColumnPresent("FaceBookURL")) { obj._faceBookURL = (string)dr["FaceBookURL"]; }
if (list.IsColumnPresent("BlogURL")) { obj._blogURL = (string)dr["BlogURL"]; }
if (list.IsColumnPresent("BlogFeedURL")) { obj._blogFeedURL = (string)dr["BlogFeedURL"]; }
if (list.IsColumnPresent("OtherWebsites")) { obj._otherWebsites = (string)dr["OtherWebsites"]; }
if (list.IsColumnPresent("DTLastUpdated")) { obj._dTLastUpdated = (DateTime)dr["DTLastUpdated"]; }
if (list.IsColumnPresent("EmbeddedContent")) { obj._embeddedContent = (string)dr["EmbeddedContent"]; }
if (list.IsColumnPresent("OurCompany")) { obj._ourCompany = (string)dr["OurCompany"]; }
if (list.IsColumnPresent("BusinessHeader1")) { obj._businessHeader1 = (string)dr["BusinessHeader1"]; }
if (list.IsColumnPresent("BusinessDescription1")) { obj._businessDescription1 = (string)dr["BusinessDescription1"]; }
if (list.IsColumnPresent("BusinessHeader2")) { obj._businessHeader2 = (string)dr["BusinessHeader2"]; }
if (list.IsColumnPresent("BusinessDescription2")) { obj._businessDescription2 = (string)dr["BusinessDescription2"]; }
if (list.IsColumnPresent("BusinessHeader3")) { obj._businessHeader3 = (string)dr["BusinessHeader3"]; }
if (list.IsColumnPresent("BusinessDescription3")) { obj._businessDescription3 = (string)dr["BusinessDescription3"]; }
arr.Add(obj);
}
dr.Close();
return arr;
}
/// <summary>
/// Takes an prepopulated IDataReader and creates an array of Businesss
/// </summary>
public static List<Business> PopulateObjectWithJoin(IDataReader dr)
{
ColumnFieldList list = new ColumnFieldList(dr);
List<Business> arr = new List<Business>();
Business obj;
while (dr.Read())
{
obj = new Business();
if (list.IsColumnPresent("BusinessID")) { obj._businessID = (int)dr["BusinessID"]; }
if (list.IsColumnPresent("MemberID")) { obj._memberID = (int)dr["MemberID"]; }
if (list.IsColumnPresent("CompanyName")) { obj._companyName = (string)dr["CompanyName"]; }
if (list.IsColumnPresent("YearFounded")) { obj._yearFounded = (int)dr["YearFounded"]; }
if (list.IsColumnPresent("IndustrySector")) { obj._industrySector = (string)dr["IndustrySector"]; }
if (list.IsColumnPresent("NumberOfEmployees")) { obj._numberOfEmployees = (int)dr["NumberOfEmployees"]; }
if (list.IsColumnPresent("BasicInfo")) { obj._basicInfo = (string)dr["BasicInfo"]; }
if (list.IsColumnPresent("CompanyWebsite")) { obj._companyWebsite = (string)dr["CompanyWebsite"]; }
if (list.IsColumnPresent("TagLine")) { obj._tagLine = (string)dr["TagLine"]; }
if (list.IsColumnPresent("ContactFirst")) { obj._contactFirst = (string)dr["ContactFirst"]; }
if (list.IsColumnPresent("ContactLast")) { obj._contactLast = (string)dr["ContactLast"]; }
if (list.IsColumnPresent("CompanySize")) { obj._companySize = (string)dr["CompanySize"]; }
if (list.IsColumnPresent("StreetAddress")) { obj._streetAddress = (string)dr["StreetAddress"]; }
if (list.IsColumnPresent("City")) { obj._city = (string)dr["City"]; }
if (list.IsColumnPresent("State")) { obj._state = (string)dr["State"]; }
if (list.IsColumnPresent("Country")) { obj._country = (string)dr["Country"]; }
if (list.IsColumnPresent("ZipCode")) { obj._zipCode = (string)dr["ZipCode"]; }
if (list.IsColumnPresent("MySpaceURL")) { obj._mySpaceURL = (string)dr["MySpaceURL"]; }
if (list.IsColumnPresent("FaceBookURL")) { obj._faceBookURL = (string)dr["FaceBookURL"]; }
if (list.IsColumnPresent("BlogURL")) { obj._blogURL = (string)dr["BlogURL"]; }
if (list.IsColumnPresent("BlogFeedURL")) { obj._blogFeedURL = (string)dr["BlogFeedURL"]; }
if (list.IsColumnPresent("OtherWebsites")) { obj._otherWebsites = (string)dr["OtherWebsites"]; }
if (list.IsColumnPresent("DTLastUpdated")) { obj._dTLastUpdated = (DateTime)dr["DTLastUpdated"]; }
if (list.IsColumnPresent("EmbeddedContent")) { obj._embeddedContent = (string)dr["EmbeddedContent"]; }
if (list.IsColumnPresent("OurCompany")) { obj._ourCompany = (string)dr["OurCompany"]; }
if (list.IsColumnPresent("BusinessHeader1")) { obj._businessHeader1 = (string)dr["BusinessHeader1"]; }
if (list.IsColumnPresent("BusinessDescription1")) { obj._businessDescription1 = (string)dr["BusinessDescription1"]; }
if (list.IsColumnPresent("BusinessHeader2")) { obj._businessHeader2 = (string)dr["BusinessHeader2"]; }
if (list.IsColumnPresent("BusinessDescription2")) { obj._businessDescription2 = (string)dr["BusinessDescription2"]; }
if (list.IsColumnPresent("BusinessHeader3")) { obj._businessHeader3 = (string)dr["BusinessHeader3"]; }
if (list.IsColumnPresent("BusinessDescription3")) { obj._businessDescription3 = (string)dr["BusinessDescription3"]; }
obj.Member = new Member();
if (list.IsColumnPresent("MemberMemberID")) { obj.Member.MemberID = (int)dr["MemberMemberID"]; }
if (list.IsColumnPresent("MemberWebMemberID")) { obj.Member.WebMemberID = (string)dr["MemberWebMemberID"]; }
if (list.IsColumnPresent("MemberAdminStatusID")) { obj.Member.AdminStatusID = (int)dr["MemberAdminStatusID"]; }
if (list.IsColumnPresent("MemberNickName")) { obj.Member.NickName = (string)dr["MemberNickName"]; }
if (list.IsColumnPresent("MemberChannelID")) { obj.Member.ChannelID = (int)dr["MemberChannelID"]; }
if (list.IsColumnPresent("MemberPassword")) { obj.Member.Password = (string)dr["MemberPassword"]; }
if (list.IsColumnPresent("MemberEmail")) { obj.Member.Email = (string)dr["MemberEmail"]; }
if (list.IsColumnPresent("MemberGender")) { obj.Member.Gender = (int)dr["MemberGender"]; }
if (list.IsColumnPresent("MemberFirstName")) { obj.Member.FirstName = (string)dr["MemberFirstName"]; }
if (list.IsColumnPresent("MemberLastName")) { obj.Member.LastName = (string)dr["MemberLastName"]; }
if (list.IsColumnPresent("MemberProfilePhotoResourceFileID")) { obj.Member.ProfilePhotoResourceFileID = (int)dr["MemberProfilePhotoResourceFileID"]; }
if (list.IsColumnPresent("MemberDOB")) { obj.Member.DOB = (DateTime)dr["MemberDOB"]; }
if (list.IsColumnPresent("MemberISOCountry")) { obj.Member.ISOCountry = (string)dr["MemberISOCountry"]; }
if (list.IsColumnPresent("MemberAccountType")) { obj.Member.AccountType = (int)dr["MemberAccountType"]; }
if (list.IsColumnPresent("MemberZipPostcode")) { obj.Member.ZipPostcode = (string)dr["MemberZipPostcode"]; }
if (list.IsColumnPresent("MemberPhoneNumber")) { obj.Member.PhoneNumber = (string)dr["MemberPhoneNumber"]; }
if (list.IsColumnPresent("MemberMobilePhoneID")) { obj.Member.MobilePhoneID = (int)dr["MemberMobilePhoneID"]; }
if (list.IsColumnPresent("MemberIPLocationID")) { obj.Member.IPLocationID = (int)dr["MemberIPLocationID"]; }
if (list.IsColumnPresent("MemberCreatedDT")) { obj.Member.CreatedDT = (DateTime)dr["MemberCreatedDT"]; }
arr.Add(obj);
}
dr.Close();
return arr;
}
