MixERP.Net.Schemas.Transactions.Data.StockReturn Class Reference

Provides simplified data access features to perform SCRUD operation on the database table "transactions.stock_return". More...

Inheritance diagram for MixERP.Net.Schemas.Transactions.Data.StockReturn:
PetaPoco.DbAccess PetaPoco.IDBAccess

Public Member Functions

long Count ()
 Performs SQL count on the table "transactions.stock_return". More...
 
IEnumerable< MixERP.Net.Entities.Transactions.StockReturnGet ()
 Executes a select query on the table "transactions.stock_return" to return a all instances of the "StockReturn" class to export. More...
 
MixERP.Net.Entities.Transactions.StockReturn Get (long salesReturnId)
 Executes a select query on the table "transactions.stock_return" with a where filter on the column "sales_return_id" to return a single instance of the "StockReturn" class. More...
 
IEnumerable< MixERP.Net.Entities.Transactions.StockReturnGet (long[] salesReturnIds)
 Executes a select query on the table "transactions.stock_return" with a where filter on the column "sales_return_id" to return a multiple instances of the "StockReturn" class. More...
 
IEnumerable< PetaPoco.CustomFieldGetCustomFields (string resourceId)
 Custom fields are user defined form elements for transactions.stock_return. More...
 
IEnumerable< DisplayFieldGetDisplayFields ()
 Displayfields provide a minimal name/value context for data binding the row collection of transactions.stock_return. More...
 
void AddOrEdit (MixERP.Net.Entities.Transactions.StockReturn stockReturn, List< EntityParser.CustomField > customFields)
 Inserts or updates the instance of StockReturn class on the database table "transactions.stock_return". More...
 
object Add (MixERP.Net.Entities.Transactions.StockReturn stockReturn)
 Inserts the instance of StockReturn class on the database table "transactions.stock_return". More...
 
List< object > BulkImport (List< MixERP.Net.Entities.Transactions.StockReturn > stockReturns)
 Inserts or updates multiple instances of StockReturn class on the database table "transactions.stock_return"; More...
 
void Update (MixERP.Net.Entities.Transactions.StockReturn stockReturn, long salesReturnId)
 Updates the row of the table "transactions.stock_return" with an instance of "StockReturn" class against the primary key value. More...
 
void Delete (long salesReturnId)
 Deletes the row of the table "transactions.stock_return" against the primary key value. More...
 
IEnumerable< MixERP.Net.Entities.Transactions.StockReturnGetPagedResult ()
 Performs a select statement on table "transactions.stock_return" producing a paged result of 25. More...
 
IEnumerable< MixERP.Net.Entities.Transactions.StockReturnGetPagedResult (long pageNumber)
 Performs a select statement on table "transactions.stock_return" producing a paged result of 25. More...
 
long CountWhere (List< EntityParser.Filter > filters)
 Performs a filtered count on table "transactions.stock_return". More...
 
IEnumerable< MixERP.Net.Entities.Transactions.StockReturnGetWhere (long pageNumber, List< EntityParser.Filter > filters)
 Performs a filtered select statement on table "transactions.stock_return" producing a paged result of 25. More...
 
long CountFiltered (string filterName)
 Performs a filtered count on table "transactions.stock_return". More...
 
IEnumerable< MixERP.Net.Entities.Transactions.StockReturnGetFiltered (long pageNumber, string filterName)
 Performs a filtered select statement on table "transactions.stock_return" producing a paged result of 25. More...
 
- Public Member Functions inherited from PetaPoco.DbAccess
void Validate (AccessTypeEnum type, long loginId, bool noException)
 Validates application user access rights to execute the function. More...
 

Public Attributes

override string ObjectNamespace => "transactions"
 The schema of this table. Returns literal "transactions". More...
 
override string ObjectName => "stock_return"
 The schema unqualified name of this table. Returns literal "stock_return". More...
 

Properties

long LoginId [get, set]
 Login id of application user accessing this table. More...
 
int UserId [get, set]
 User id of application user accessing this table. More...
 
string Catalog [get, set]
 The name of the database on which queries are being executed to. More...
 
- Properties inherited from PetaPoco.DbAccess
abstract string ObjectNamespace [get]
 
abstract string ObjectName [get]
 
bool HasAccess [get]
 
bool Validated [get]
 
bool SkipValidation [get, set]
 
- Properties inherited from PetaPoco.IDBAccess
bool HasAccess [get]
 

Detailed Description

Provides simplified data access features to perform SCRUD operation on the database table "transactions.stock_return".

Member Function Documentation

object MixERP.Net.Schemas.Transactions.Data.StockReturn.Add ( MixERP.Net.Entities.Transactions.StockReturn  stockReturn)

Inserts the instance of StockReturn class on the database table "transactions.stock_return".

Parameters
stockReturnThe instance of "StockReturn" class to insert.
Exceptions
UnauthorizedExceptionThown when the application user does not have sufficient privilege to perform this action.
void MixERP.Net.Schemas.Transactions.Data.StockReturn.AddOrEdit ( MixERP.Net.Entities.Transactions.StockReturn  stockReturn,
List< EntityParser.CustomField customFields 
)

Inserts or updates the instance of StockReturn class on the database table "transactions.stock_return".

Parameters
stockReturnThe instance of "StockReturn" class to insert or update.
customFieldsThe custom field collection.
Exceptions
UnauthorizedExceptionThown when the application user does not have sufficient privilege to perform this action.
List<object> MixERP.Net.Schemas.Transactions.Data.StockReturn.BulkImport ( List< MixERP.Net.Entities.Transactions.StockReturn stockReturns)

Inserts or updates multiple instances of StockReturn class on the database table "transactions.stock_return";

Parameters
stockReturnsList of "StockReturn" class to import.
Returns
long MixERP.Net.Schemas.Transactions.Data.StockReturn.Count ( )

Performs SQL count on the table "transactions.stock_return".

Returns
Returns the number of rows of the table "transactions.stock_return".
Exceptions
UnauthorizedExceptionThown when the application user does not have sufficient privilege to perform this action.
long MixERP.Net.Schemas.Transactions.Data.StockReturn.CountFiltered ( string  filterName)

Performs a filtered count on table "transactions.stock_return".

Parameters
filterNameThe named filter.
Returns
Returns number of rows of "StockReturn" class using the filter.
Exceptions
UnauthorizedExceptionThown when the application user does not have sufficient privilege to perform this action.
long MixERP.Net.Schemas.Transactions.Data.StockReturn.CountWhere ( List< EntityParser.Filter filters)

Performs a filtered count on table "transactions.stock_return".

Parameters
filtersThe list of filter conditions.
Returns
Returns number of rows of "StockReturn" class using the filter.
Exceptions
UnauthorizedExceptionThown when the application user does not have sufficient privilege to perform this action.
void MixERP.Net.Schemas.Transactions.Data.StockReturn.Delete ( long  salesReturnId)

Deletes the row of the table "transactions.stock_return" against the primary key value.

Parameters
salesReturnIdThe value of the column "sales_return_id" which will be deleted.
Exceptions
UnauthorizedExceptionThown when the application user does not have sufficient privilege to perform this action.
IEnumerable<MixERP.Net.Entities.Transactions.StockReturn> MixERP.Net.Schemas.Transactions.Data.StockReturn.Get ( )

Executes a select query on the table "transactions.stock_return" to return a all instances of the "StockReturn" class to export.

Returns
Returns a non-live, non-mapped instances of "StockReturn" class.
Exceptions
UnauthorizedExceptionThown when the application user does not have sufficient privilege to perform this action.
MixERP.Net.Entities.Transactions.StockReturn MixERP.Net.Schemas.Transactions.Data.StockReturn.Get ( long  salesReturnId)

Executes a select query on the table "transactions.stock_return" with a where filter on the column "sales_return_id" to return a single instance of the "StockReturn" class.

Parameters
salesReturnIdThe column "sales_return_id" parameter used on where filter.
Returns
Returns a non-live, non-mapped instance of "StockReturn" class mapped to the database row.
Exceptions
UnauthorizedExceptionThown when the application user does not have sufficient privilege to perform this action.
IEnumerable<MixERP.Net.Entities.Transactions.StockReturn> MixERP.Net.Schemas.Transactions.Data.StockReturn.Get ( long[]  salesReturnIds)

Executes a select query on the table "transactions.stock_return" with a where filter on the column "sales_return_id" to return a multiple instances of the "StockReturn" class.

Parameters
salesReturnIdsArray of column "sales_return_id" parameter used on where filter.
Returns
Returns a non-live, non-mapped collection of "StockReturn" class mapped to the database row.
Exceptions
UnauthorizedExceptionThown when the application user does not have sufficient privilege to perform this action.
IEnumerable<PetaPoco.CustomField> MixERP.Net.Schemas.Transactions.Data.StockReturn.GetCustomFields ( string  resourceId)

Custom fields are user defined form elements for transactions.stock_return.

Returns
Returns an enumerable custom field collection for the table transactions.stock_return
Exceptions
UnauthorizedExceptionThown when the application user does not have sufficient privilege to perform this action.
IEnumerable<DisplayField> MixERP.Net.Schemas.Transactions.Data.StockReturn.GetDisplayFields ( )

Displayfields provide a minimal name/value context for data binding the row collection of transactions.stock_return.

Returns
Returns an enumerable name and value collection for the table transactions.stock_return
Exceptions
UnauthorizedExceptionThown when the application user does not have sufficient privilege to perform this action.
IEnumerable<MixERP.Net.Entities.Transactions.StockReturn> MixERP.Net.Schemas.Transactions.Data.StockReturn.GetFiltered ( long  pageNumber,
string  filterName 
)

Performs a filtered select statement on table "transactions.stock_return" producing a paged result of 25.

Parameters
pageNumberEnter the page number to produce the paged result.
filterNameThe named filter.
Returns
Returns collection of "StockReturn" class.
Exceptions
UnauthorizedExceptionThown when the application user does not have sufficient privilege to perform this action.
IEnumerable<MixERP.Net.Entities.Transactions.StockReturn> MixERP.Net.Schemas.Transactions.Data.StockReturn.GetPagedResult ( )

Performs a select statement on table "transactions.stock_return" producing a paged result of 25.

Returns
Returns the first page of collection of "StockReturn" class.
Exceptions
UnauthorizedExceptionThown when the application user does not have sufficient privilege to perform this action.
IEnumerable<MixERP.Net.Entities.Transactions.StockReturn> MixERP.Net.Schemas.Transactions.Data.StockReturn.GetPagedResult ( long  pageNumber)

Performs a select statement on table "transactions.stock_return" producing a paged result of 25.

Parameters
pageNumberEnter the page number to produce the paged result.
Returns
Returns collection of "StockReturn" class.
Exceptions
UnauthorizedExceptionThown when the application user does not have sufficient privilege to perform this action.
IEnumerable<MixERP.Net.Entities.Transactions.StockReturn> MixERP.Net.Schemas.Transactions.Data.StockReturn.GetWhere ( long  pageNumber,
List< EntityParser.Filter filters 
)

Performs a filtered select statement on table "transactions.stock_return" producing a paged result of 25.

Parameters
pageNumberEnter the page number to produce the paged result.
filtersThe list of filter conditions.
Returns
Returns collection of "StockReturn" class.
Exceptions
UnauthorizedExceptionThown when the application user does not have sufficient privilege to perform this action.
void MixERP.Net.Schemas.Transactions.Data.StockReturn.Update ( MixERP.Net.Entities.Transactions.StockReturn  stockReturn,
long  salesReturnId 
)

Updates the row of the table "transactions.stock_return" with an instance of "StockReturn" class against the primary key value.

Parameters
stockReturnThe instance of "StockReturn" class to update.
salesReturnIdThe value of the column "sales_return_id" which will be updated.
Exceptions
UnauthorizedExceptionThown when the application user does not have sufficient privilege to perform this action.

Member Data Documentation

override string MixERP.Net.Schemas.Transactions.Data.StockReturn.ObjectName => "stock_return"

The schema unqualified name of this table. Returns literal "stock_return".

override string MixERP.Net.Schemas.Transactions.Data.StockReturn.ObjectNamespace => "transactions"

The schema of this table. Returns literal "transactions".

Property Documentation

string MixERP.Net.Schemas.Transactions.Data.StockReturn.Catalog
getset

The name of the database on which queries are being executed to.

long MixERP.Net.Schemas.Transactions.Data.StockReturn.LoginId
getset

Login id of application user accessing this table.

int MixERP.Net.Schemas.Transactions.Data.StockReturn.UserId
getset

User id of application user accessing this table.


The documentation for this class was generated from the following file: