Esempio n. 1
0
        private static List <Supplier> LoadSupplierListFromDataReader(OleDbDataReader reader)
        {
            var suppliers = new List <Supplier>();

            while (reader.Read())
            {
                var supplier = new Supplier();
                supplier.Id   = reader.GetInt32(reader.GetOrdinal("VerdelerID"));
                supplier.Name = reader.GetStringSafe(reader.GetOrdinal("Naam"));
                supplier.MinimumDeliveryDays = reader.GetNullableInt16(reader.GetOrdinal("WS_min_delivery_days"));
                supplier.MaximumDeliveryDays = reader.GetNullableInt16(reader.GetOrdinal("WS_max_delivery_days"));
                supplier.CreatedDttm         = reader.GetNullableDateTime(reader.GetOrdinal("CreateDttm"));
                supplier.UpdatedDttm         = reader.GetNullableDateTime(reader.GetOrdinal("UpdateDttm"));
                supplier.DeletedDttm         = reader.GetNullableDateTime(reader.GetOrdinal("DeleteDttm"));

                suppliers.Add(supplier);
            }

            return(suppliers);
        }