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);
}
