Sales Class

Data sales handling

Inheritance Hierarchy

SystemObject
Velo.DataSales

Namespace: Velo.Data
Assembly: Velo.Data (in Velo.Data.dll) Version: 22.2.10.1 (22.2.10.450)

Syntax

public static class Sales

<ExtensionAttribute>
Public NotInheritable Class Sales

The Sales type exposes the following members.

Properties

	Name	Description
	GetSQLSelect	Sales SQL SELECT statement (include date format dmy)
	GetSQLSelectJoinAddress	Sales SQL SELECT statement with relationship to table Address (include date format dmy)

Methods

	Name	Description
	Add	Add a sale data record to database
	Archive	Sales to archive by address
	Delete	Delete a sales data item by ID
	DeleteByAddress	Delete all sales data item by address ID
	GetAll	Gives a list of sales
	GetByAddressFirstName	Gives a list of sales data by address first name (search wild card)
	GetByAddressID	Gives a list of sales data by address ID
	GetByAddressName	Gives a list of sales data by address name (search wild card)
	GetByDate	Gives a list of sales by date (date range 30 days)
	GetByID	Gives a sales data item by ID
	GetByWithoutAddress	Gives a list of sales data by without address
	GetSQLWhereArchive	Gives SQL filter WHERE by Archives
	Update	Update sales data