public static ObservableCollection<ContactpersoonType> GetContactpersoonType()
{
ObservableCollection<ContactpersoonType> ocCpt = new ObservableCollection<ContactpersoonType>();
string sSql = "Select * from ContactpersoonType";
DbDataReader reader = DbAccess.GetData(sSql);
while (reader.Read())
{
ContactpersoonType tt = new ContactpersoonType()
{
ID = (int)reader[0],
Name = (string)reader[1],
};
ocCpt.Add(tt);
}
return ocCpt;
}
private static ContactpersoonType MakeContactpersoonType(DbDataReader reader)
{
ContactpersoonType conType = new ContactpersoonType()
{
ID = (int)reader[10],
Name = (string)reader[11]
};
return conType;
}
private static Contactpersoon MakeContactpersoon(DbDataReader reader, ContactpersoonType conType, Access acc)
{
Contactpersoon person = new Contactpersoon()
{
ID = (int)reader[0],
Name = (string)reader[1],
Company = (string)reader[2],
JobRole = conType,
Accesszone = acc,
City = (string)reader[5],
Email = (string)reader[6],
Phone = (string)reader[7],
Cellphone = (string)reader[8],
Print = (bool)reader[9]
};
return person;
}
