I need a program built in Visual Basic 2008 that stores information about an artist, the artist’s artwork, and art shows that he/she will attend in an SQL Server 2005 Express database.? There are 3 user levels that can login to the program.? The Artist (Primary User) who has full access to all of the data in the database and data input capabilities, an Authorized User (typically an instructor or show promoter) who also has full access and data input capabilities, and a Guest User (such as a prospective buyer) who can only review art inventory and art shows but cannot access personal information.
There are 4 tables in the SQL database: Primary User Information table (FirstName, LastName, and DateofBirth, ), UserAudit table (UserID, FirstName, LastName, AccessDate/Time, Relationship (Artist, Instructor, Show Administrator, or Guest), and DataChange), Art Inventory table (ItemID, ItemName, and Media (Painting, Pen and Ink, Sculpture), and an Art Show table (ShowID, ShowName, City, and Date).
The login sequence (designated by which login forms are presented to a user) is determined a) by whether this is the first time the program is being opened (and therefore each of the 4 tables in the database is empty) and b) by which user type is logging in. ? Every User login episode is recorded in the User Audit table of the database and records Name (First and Last), Access Date (current DateTime stamp), User Level, and whether any data was added or changed during that login session.? The Name, Access Date, and User Level fields are all entered into the Data Row of the table at the conclusion of the login sequence, whereas the DataChange Boolean (yes/no) operator result of that row is changed from the default of no to yes when and only if any data is added to or updated in any of the data input fields in either the Art Inventory table and/or the Art Show table.? Therefore, the Primary User or any Authorized Users can view data that has been previously saved in the database and displayed on the main User Interface form without making any changes.? In this scenario, the program only records (audits) that the user logged in to the program to review data but did not make any changes (Boolean operator = No).? The Guest Users can only view and cannot add or change any data.
Need a subroutine that runs when the program first opens and executes before any login form is presented.? This subroutine determines whether the Primary User Information table in the SQL database is populated with data or not.? If the table has not yet been populated (first time the program is opened) and therefore only contains the default null values for each field in the row then the initial login form will open.? If the Primary User Information table has been previously populated with data then a secondary login form will open.
Need a subroutine that will update a TextBox (DateLastUpdated) with the current Date/Time stamp every time any field in the Art Inventory and/or the Art Show tables is changed or is updated.
Need a similar subroutine to update a TextBox (UpdatedBy) with the current logged in user’s name (concatenated from the FirstName and LastName values from the last UserID data row in the User Audit table) whenever any of the fields in the Art Inventory and/or the Art Show tables is changed or updated.
Need a form that has two radiobutton selections for the Primary User and Other User.? If the Primary User button is selected then the Primary User data entry form opens.? If the Other User button is selected then the Other User form is opened.?
Need an Other User form that has two radiobutton selections for Authorized User and Guest User.? The Authorized User login requires a Password TextBox entry which is initially grayed out (before the radiobutton is selected) when the form is first opened but becomes highlighted and therefore available for data entry after the Authorized User radiobutton is selected. ? ? The Guest User login does not require a Password entry and the Password TextBox remains grayed out after the Guest User radiobutton is selected.