] System.Collections.Generic - for ieNumerable, used by ...
] System Dynamic - for Dynamic types, used by ..
] System.Web - for httpContext, used by ... to access Session var ( get current_db)
] WebMatrix.Data - for Database methods, used by ... ] all
] WebMatrix.Data.StronglyTyped - for data library ST that converts dynamics to ST objects
[Properties]
] id_procedure -
] name_procedure -
] description_procedure -
] parent_id -
] database -
] qryGetProcedures - all procedures
] qryGetProcedure - return single procedure
] qryGetProceduresInApp - return all procedures in a given app
] qryAddProcedure
] qryDeleteProcedure
] qryUpdateProcedure
+
] count - non-persistent -
] lastIn -
[objects]
] app
[Constructors]
x] Procedure() - default, empty, creates a new EMPTY procedure instance with no values set
x] Procedure(int id) - takes id of existing procedure, instantiates this.procedure with properties of existing procedure // creates a new procedure instance by retrieving values-of a procedure persisted in a db
] Procedure(name, description, parent) - creates a new procedure instance populated with the values of passed in args
] Procedure(string name, string description)- takes name and description args of procedure to create a new server OR
] Procedure(string name) - instantiates a new instance of procedure object - based on lookup of existing procedure
+] Procedure(int id,string name, ...) - instantiates a new instance of Procedure object
[Methods]
] GetProcedures()
] GetProceduresInApp()
] add () - add using the currently instantiated instance
] static add (name,description) - where=??
] delete() -
] static delete(id) -
] edit()
] static edit (name,description) args[]
] ById()
] ListAll() -
[OTHER]
] getMaxId()- returns the id of the last record inserted into the procedures table
] import()
] getDefaultProcedureId() - returns the id of the default || user specified 'default procedure'
[STATIC]
] setItemsStatus(status, ids) - sets all items to the given status
] setItemsName(name, ids) - sets all user selected items "names" to the given name
] setItemsDescription(description, ids) - sets all user selected items "descriptions" to the given description
] setItemsCOGS(cogs, ids) - sets all user selected items "cogs" to the given value
] setItemsQuantity(quantity, ids) - sets all user selected items "quantity" to the given value
] setItemsUnit(unit, ids) - sets all user selected items "unit" to the give value