] System.Web - for httpContext ... used by .. to access Session var ( get current_db)
] System.Collections - for ieNumerable ... used by ...
] WebMatrix.Data - for Database ... used by ... ] all
] WebMatrix.Data.StronglyTyped - data library
[Properties]
] id - record in UserProfile table autoGenerated,
] name - username ( a valid email address )
] description -
] pw - password field ??
] rememberMe - bool, write login cookie to local machine
] users - db
] role - pulled from "sospeps" table,
] count - int the number of 'sospeps' the user has permissions on
] default_db - the sospep that can be set to load by default vs user choosing from list of
[Constructors]
] User() - default, empty instance of user object
] User(id) - instantiates a new instance of user object by db lookup of user based on passed in arg of user id value
] User(email) - instantiates a new instance of user object by db lookup of user based on passed in arg of username(aka email)
] User(id,name,description) - create a new user by passing in the args of ...
] User(id,name,description,pw,rememberMe) - create a new user instance by passing in the args of ...
[Methods]
add()
edit()
delete()
static delete(id)
****
static add(args[])
static edit(args[])
getMax()
import()
add(name,description) -
[WHERE]
[ called from]
] _PageStart -
] view users -
] view user -
] add user -
] edit user -
[WHEN]
]
[EXAMPLE]
]
[HOW-TO]
]
[REFERENCE]
] CLASS User.cs
developer implementation
[.process]
[.notes]
[.by_date]
[YYYY-mm-DD]
status
[previously]
[20YY-MM-DD] NEW tasak
] # # - CREATE new class,
x] used Warehouse.cs as template
[2013-05-20] NEW task
] - NEW VERSION -v-002
[2013-05-20] NEW task
] CUT GREENSPACE - looks like original used wh class as model, removed 'a bunch' of wh code
[2013-06-21] NEW task
] - add count property (login page)
[2013-06-25] NEW task
] - add static method for returning 'all sospeps' for a user, used on PG open_sospep
[currently]
[2013-06-25] NEW task
x] add sospeps property ( string [] OR ) for all 'sospeps' for a user
i] added default_db property, get by qry 'db_owner' , ( CURRENLTY WORKS TO RETURN THE FIRST sospep that the USER has, NOT a user specified default_db , used for users who have not added had 'public' added to ... )
[2013-07-12] NEW task
] changed 'GetSospeps()' method from a 'static' method to non static, now returns data to calling page BUT
[2013-07-dd NEW task
] PRB is data is not accessible because it is 'dynamic' vs <type sospep>,
] could be some syntactic method to access row/col index OR
] could create class to work with alterd sospep OR
] could rename fields in qry to align with existing 'sospep' class
[2017-04-dd] NEW task
x] # # - ADD distinct db connection close, db close, db dispose statements to logVisit() method
[2017-04-14] NEW task
x] # # - REM ] tracking database property, ] REM method logVisit()
x] open db, but it is never closed, because method with close call (logVisit() is never called)