We need to develop a web site for church sermons to be uploaded to - very basic site but it will be database driven content.
Everything should be done in [url removed, login to view] using controls and a business tier as the data source. Business tier will simply query sql server (we'll redo the business tier with more complex functions at a later time).
Each church will be assigned a ChurchID - each ChurchID can have multiple sermons. Their sermons should be editable (simple web form). Each church will have basic information: ChurchName, Address, City, State, Country, Zip, Telephone, Fax, Email, WebSite, brief summary of church..
Each sermon will have the following information: SermonID, ChurchID, DateUploaded, DateApproved, DatePreached, Title, Summary, LongDescription, Text (full text of sermon, i.e. text field in sql), audiourl.
When a sermon is uploaded first it should be created with the above information, then an option to upload a .mp3 file in a web form should be there. The .mp3 file should be stored on the server disk, if you aren't capable of this part just bid excluding this.
There may be a few other fields added, but this is basically it.
The site will display all sermons which have DateApproved not null - The DateApproved will be a yes/no checkbox when editing the sermon - i.e. they aren't approved when uploaded, but once someone verifies the sermon details they can click the box (or link) to approve it.
We're looking for someone who understands the goals and can complete this without many questions. Feel free to PMB, but the less questions and firmer bid amount the more you match what we want to work with on this project.