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