public static void Init(string sqlConnectionString)
{
cache = new Entities.TourMemberCollection();
persons = new Repository.Sql.Phonebook(sqlConnectionString);
contacts = new Repository.Sql.PersonContacts(sqlConnectionString);
members = new Repository.Sql.TourGroupMembers(sqlConnectionString);
LoadAll();
}
protected void MapMemberToObject(SqlDataReader reader, object userData)
{
Entities.TourMember member = new Entities.TourMember();
member.Id = Utils.GetSafeInt32(reader, "MemberId");
member.Title = DomainModel.PersonTitleTypes.GetById(
Utils.GetSafeInt32(reader, "TitleId"));
member.FirstName = Utils.GetSafeString(reader, "FirstName");
member.LastName = Utils.GetSafeString(reader, "LastName");
member.MemberShip = DomainModel.TourMembershipTypes.GetById(
Utils.GetSafeInt32(reader, "MembershipType"));
member.IsDirty = false;
member.IsInPhonebook = true;
Entities.TourMemberCollection persons = (Entities.TourMemberCollection)userData;
persons.Add(member);
}
internal bool LoadAll(Entities.TourMemberCollection persons)
{
bool res = false;
try
{
this.query.Parameters.Clear();
res = this.query.ExecuteReader("PhonebookGetAll", MapMemberToObject, persons);
}
catch (Exception ex)
{
try
{
DomainModel.Application.Status.Update(
StatusController.Abstract.StatusTypes.Error,
"",
ex.Message);
}
catch { }
}
return(res);
}