SQL server 2008
ASP net C#
VS 2008
Make upload button, save to HD, then to filestream enabled server.?
Then download image again and display in [login to view URL] control.
## Deliverables
SQL server 2008
ASP net C#
VS 2008
I want everything scripted for reuse on multiple servers (SQL server side of course)
SQL server side
--enable filestream on the server for remote level
--Create database GBB
--enable filesteam for GBB (I want this step seperated from the create statement)
--create table [login to view URL]
-id int identity(1,1) PK CLustered
-Imagetype (Full, thumbs, TechSheet)
-image
From ASP .net size
Create a web application project and make 2 folders, 1 called "upload" and another called "copied"
1- Create an interface to upload the image that I provided in the zip file.? Save it in the folder "upload"
2- After it's saved, make a copy of the image in the folder copied, make sure that the same method can work on unc paths (file server share)
3- After it's saved on the hard drive, save the full size image to the db in a file stream enabled table/column (not sure it's the right term but you get the idea).? Make sure to flag this picture to the type "Full"
4- Whatever the size of the image, resize it to 250 Px width keeping the ratio for the height.? Please also make sure I can adjust the picture quality here, we need to have the pictures in good quality but not with 500 KB weigth at that point.
5- After the resize, save the image to database, this time with the image type to TechSheet
6- Make a 2nd resize of the original picture to a thumbs size.? This time 25 PX wide.
7- Upload to db with the image type thumbs
8- After the 3 uploads are completed.? I want you to redownload the 3 images from the databases (don't bother with the sql query too much, I'll need to adapt it to our application later on, just take SELECT TOP 3 * from TblImg order by ID desc).? Then I want you to display them in asp image controls.
9- In a datagrid, show me 2 columns, #1 id of the image and a small icon.
10- On the icon click, I want a "popup" div to appear on the page.? If possible without the full postback on the server (the page is really big and somewhat long to download)
So here's the cycle again
0 - Prepare DB
1 - Browse button to select picture to upload
2 - Upload button
3 - Save local
4 - Copy local
5 - Save DB full size
6 - Resize to 250PX width and keep ratio and save to DB (no need for local here)
7 - resize to 25PX width and keep ratio and save to DB
8 - Postback is complete, show the page ready to upload again and with the 3 images on the page in asp image controls and the datagrid (Only show the images that are in full size)
9 - Display the list of full images in a datagrid with a icon to click on the see the photo.
If you're still reading all the way to here, put "aqsw1234"? at the top of your bid / questions.
10 - On the icon click, show the chosen image in a popup div with the smallest possible postback on the server.