private PersonNotificationPreference PreferenceMap(IDataReader reader, out int personId) { PersonNotificationPreference pnp = new PersonNotificationPreference(); int ord = 0; personId = reader.GetSafeInt32(ord++); pnp.NotificationEventId = reader.GetSafeInt32(ord++); pnp.NotificationEventName = reader.GetSafeString(ord++); pnp.SendEmail = reader.GetSafeBool(ord++); pnp.SendText = reader.GetSafeBool(ord++); return(pnp); }
public Person PublicSelect(int id) { Person person = null; List <MilitaryBase> mbList = null; List <PersonLanguage> laList = null; List <Skill> skList = null; DataProvider.ExecuteCmd(GetConnection, "dbo.Person_SelectById", inputParamMapper : delegate(SqlParameterCollection paramCollection) { paramCollection.AddWithValue("@Id", id); } , map : delegate(IDataReader reader, short set) { switch (set) { case 0: person = MapPerson(reader); break; case 1: int personId = 0; MilitaryBase mb = MapMilitaryBaseList(reader, out personId); if (mbList == null) { mbList = new List <MilitaryBase>(); } mbList.Add(mb); break; case 2: PersonLanguage la = MapLanguageList(reader, out personId); if (laList == null) { laList = new List <PersonLanguage>(); } laList.Add(la); break; case 3: Skill sk = MapSkillList(reader, out personId); if (skList == null) { skList = new List <Skill>(); } skList.Add(sk); break; case 4: CompanyBase cb = MapCompany(reader, out personId); if (person.Companies == null) { person.Companies = new List <CompanyBase>(); } person.Companies.Add(cb); break; case 5: SquadBase sq = MapSquad(reader, out personId); if (person.Squads == null) { person.Squads = new List <SquadBase>(); } person.Squads.Add(sq); break; case 6: PersonNotificationPreference pnp = PreferenceMap(reader, out personId); if (person.Preferences == null) { person.Preferences = new List <PersonNotificationPreference>(); } person.Preferences.Add(pnp); break; } } ); person.MilitaryBases = mbList; person.Languages = laList; person.Skills = skList; return(person); }