Requirements:
VB.Net
Utilize Stored Procedures
Built as a Module of DNN (no changes to core source of DNN)
Must include all source
Module Names Begin with PremierSched_TableName (replace table name with below info)
Must work in DNN 3.0 and DNN 3.1
Need modules to Add/Edit/Delete/List The following tables:
_**PremierSched_Facilities
**_PortalId (int, for all tables this should automatically be filled and hidden from user)
FacilityId (int identity)
Facilty Name (string 100)
Notes (text)
This can be a grid with inplace editing
**_PremierSched_EventTypes
_**PortalId (int)
EventTypeId (int)
EventType (string 100)
Notes (Text)
This can be a grid with inplace editing
**_PremierSched_Events
_**PortalId (int)
EventId (int)
EventTitle (String 100)
EventType (String 100, foreign key)
StartDate (Dateime)
EndDate (DateTime)
Instructor (int, foreign key to table users in DNN with role of Instructor, must show names in drop down)
Facility (int, foreign key to table facilities, must show facility name in drop down)
DayofWeek1 (int)
DayofWeek2 (int)
DayofWeek3 (int)
Length (int)
Capacity (int)
Price (money)
Notes (Text)
* This should be a separate edit screen not a grid for editing.
* For the list screen user should be able to narrow list by ability to filter on Instructor/Facility/Start Date
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
## Platform
DNN 3.x
VB.Net
Microsoft SQL
Must use stored procedures for all Database interactions