Click or drag to resize

BikeHistory Class

Data bike history handling
Inheritance Hierarchy
SystemObject
  Velo.DataBikeHistory

Namespace:  Velo.Data
Assembly:  Velo.Data (in Velo.Data.dll) Version: 22.2.10.1 (22.2.10.450)
Syntax
public static class BikeHistory

The BikeHistory type exposes the following members.

Properties
  NameDescription
Private propertyStatic memberGetSQLSelect
BikeHistory SQL SELECT statement (include date format dmy)
Private propertyStatic memberGetSQLSelectJoinAddress
BikeHistory SQL SELECT statement with relationship to table Address (include date format dmy)
Private propertyStatic memberGetSQLSelectJoinBike
BikeHistory SQL SELECT statement with relationship to table Bike (include date format dmy)
Top
Methods
  NameDescription
Public methodStatic memberAdd
Add a bike history data record to database
Public methodStatic memberDelete
Delete a bike history data item by ID
Public methodStatic memberDeleteByAddress
Delete all bike history data item by address
Public methodStatic memberDeleteByBike
Delete all bike history data item by bike
Public methodStatic memberGetAll
Gives a list of bike history
Public methodStatic memberGetByAddressFirstName
Gives a list of bike history data by address first name (search wild card)
Public methodStatic memberGetByAddressID
Gives a list of bike history data by address ID
Public methodStatic memberGetByAddressName
Gives a list of bike history data by address name (search wild card)
Public methodStatic memberGetByBikeBrand
Gives a list of bike history data by bike brand (search wild card)
Public methodStatic memberGetByBikeID
Gives a list of bike history data by bike ID
Public methodStatic memberGetByBikeNumber
Gives a list of bike history data by bike number (search wild card)
Public methodStatic memberGetByBikeNumberPerformanceTest
Gives a list of bike history data by bike number (search wild card). Use only for test!
Public methodStatic memberGetByBikeType
Gives a list of bike history data by bike type (search wild card)
Public methodStatic memberGetByID
Gives a bike history data item by ID
Public methodStatic memberUpdate
Update bike history data
Top
See Also