Hi,
You will have to modify the provided website project (VS2005, SQL Server 2005). THE PRESENT PROJECT IS THE FIRST STEP OF A BIGGER PROJECT (later modifications will be made on the resulting project - originating others SL projects).
It's based on the Personal Website Starter Kit of VS2005. We've changed the DB to use our database, and the DB contains 2 tables IdeaPicture and IdeaCollectionCD, that are similar (though different) to Photos y Albums (respectively) of the original starter kit.
The website we need for now does basically the same as the perso website does: to allow administrators to enter and manage albums (named here CollectionCD, as we have CD's with photos on it) and photos (named here pictures).
Admin can manage all this, though anonymous visitors will only be able to view all photos/albums - but not modify anything.
Tasks:
- modify the project/stored procedures so that it works with the new tables: fields names have changed, there are some new fields, and primary key is now a GUID,
- modify forms where an admin user adds/edits a photo/album record, to take into account the new fields (that the admin will be able to fulfill/modify),
- the photos in high and medium resolution formats are NOT stored in the DB: they are stored as files in a protected folder of the server
- any visitor will be able to see the thumbnails, and also the low res photo with the full description/fields. The download option will allow to download (DIRECTLY - no 'save as...' manipulation) the medium res photo ONLY TO THE REGISTERED (friends) users.
Thanks. I attach the VS2005 project.
Pascal