Share photos to friends using asp.net, C#.net, SQL server 2005

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

, +

HI,

i have 2 tables like tbl_userprofile,tbl_images.
in tbl_userprofile page there are 5 colums are there,
1.name,2.email,3.pwd,4.friends,and 5.location

tbl_images page there are 4 columns are there

1. imageid, 2. Image name, 3. Location, 4. share

for sharing i am using checkbox in asp.net, if i want to share photos to my friends i will checked that check box. that images will display the user profile page.
can u please suggest me the any idea for to do this.

please help me write query in sql and asp.net code for to shate photos to friens..

Posted 18-Dec-12 19:28pm

suma2212

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) · Answer 1 · 2012-12-18T21:06:00

Solution 1

You should have an ID column in table tbl_userprofile, which should be UserID.

For Sharing Images
Make another table tbl_sharedImages.
Columns will be like below.

1. imageID - ID of image from table tbl_images
2. sharedBy - UserID of user who is sharing, in your terms checking the checkbox.
3. sharedTo - UserID of friends you want to share. You can use this column for custom sharing or can remove this column if not needed. I mean if you want the picture to be shown to all then don't use it, if you have some options for custom sharing, then you have to store the UserIDs to which you want to share.
4. sharedDate - Date and Time when the picture is shared.
5. modifiedDate - If any modification is done to the shared picture.
6. isDeleted - extra column for checking the existence of row. Default is 0 always.

This is the most simple implementation. This can be modified according to your requirements. But this is the concept which you can apply.
Please check and let me know if any questions.

[update]

New requirement of Album Sharing

For Album Sharing, you need do the below DataBase stuffs.

1. Create new table for Albums
tbl_albums

Colums may be -
> albumID - ID of Album
> albumName - Name of Album
> createdBy - ID of User who is creating
> createdOn - DateTime of Album Creation
> updatedBy - ID of User who is updating the album
> updatedOn - DateTime when Album got Updated
> isDeleted - extra column for checking the existence of row. Default is 0 always.

2. Create new table for Images in Albums
tbl_albumImages

Colums may be -
> ID - Primary key of this table.
> albumID - ID of Album
> imageID - ID of Image

3. Create new table for Sharing of Albums
tbl_sharedAlbums

Columns may be -
> ID - Primary key of this table.
> albumID - ID of album from table tbl_albums
> sharedBy - UserID of user who is sharing.
> sharedTo - UserID of friends you want to share. You can use this column for custom sharing or can remove this column if not needed. I mean if you want the album to be shown to all then don't use it, if you have some options for custom sharing, then you have to store the UserIDs to which you want to share.
> sharedDate - Date and Time when the album is shared.
> modifiedBy - UserID of user who modified.
> modifiedDate - If any modification is done to the shared album.
> isDeleted - extra column for checking the existence of row. Default is 0 always.

In coding you have to do like below.

1. While the creation of Album, insert rows in tables tbl_albums and tbl_albumImages.
2. On clicking of share album button, you have to insert row to the table tbl_sharedAlbums.
3. While showing the albums of user, you just need to go through this table and match sharedBy column with the current UserID.
If exists then go for step-4.
4. Fetch the records in step-3 and from the albumID column, you can then get the album details from table tbl_albums.
5. After getting the album details, then you have to check if any records (pictures) exists in table tbl_albumImages.
If exists, then go for step-6.
6. Get all imageID for the album and fetch the image details from your table tbl_images and show in the Profile.

[/update]

Thanks...

Posted 18-Dec-12 21:06pm

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ)

Updated 19-Dec-12 21:45pm

v2

Comments

suma2212 19-Dec-12 3:49am

Hi Tadit,

thank you for your answer. i want query and asp.net code for this functionality. please provide me. i tried it but i did not get the correct solution.
please help me....

suma2212 19-Dec-12 3:54am

Hi Tadit,

For this i am using Datalist. in that datalist i add image button. in that down of the image button i insert Link button (share). when i click that share link button it will display all my friends list.

please help me

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 19-Dec-12 5:44am

Hi @suma2212,

It sounds nice that you are trying to complete the task.

I have given the idea. You need to implement.

As you said that you have one DataList and on clicking of share linkbutton, you are displaying the friends list. I guess it is working.

But what you want to do with this friends list?

You needed the concept how to implement the share image, correct?
Have you tried what I explained to you?

Please reply.

Thanks,
Tadit

suma2212 20-Dec-12 2:25am

Hi thanq for ur reply. My TL changed this requirement. first we have to create an album,in down of that album insert share button. when i click share button that album will shared to all his friends.

please give me any idea, and please give any example.

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 20-Dec-12 3:46am

Check my updated answer.
Thanks...

suma2212 26-Dec-12 4:01am

Hi thanks for ur help. In above example i did all.i have my tbl_userprofile table in that friends column is there. when i add friend, their userid's will add to that column(ex: 12,13,14). when i click share button how can i share photos. i did what u told but i didn't get the proper solution please help me. its very urgent.

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 2-Jan-13 2:29am

Hi @suma2212,

Adding one friends column in tbl_userprofile is not the usual way.
You should have another table for the friends information.
Something like tbl_userfriends, where you should have columns like below,
1. ID - Primary Key
2. userID - User ID of the user.
3. friendID - User ID of the friend.

So, for one user you will have multiple rows like
ID userID friendID
-------------------------
1 1 12
2 1 13
3 1 14

Now comes the sharing album part.
For this scenario, when one user is going to share the album you need to insert rows into table tbl_sharedAlbums.

The column sharedTo is for the friend id to whom you want to share.
So, the table will have row like below.
ID albumID sharedBy sharedTo (.....other columns)
-------------------------------------
1 1 1 12
2 1 1 13
3 1 1 14

So, while showing the album in user profile, you need to check the sharedTo column with the user id and if there are rows, then fetch the albumID. After getting the ID of album, you can get the corresponding images from the table tbl_albumImages and show them in the user's profile, that's it.

Hope you got what I want to say...
Please ask more, if you have doubts.... :)

Thanks,
Tadit

suma2212 7-Jan-13 0:45am

Hi,
how to write query for sharing please help me.
and
how can i set default photo for album. i have defaultphotoid column in my tbl_albums table.

please help me

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 7-Jan-13 4:29am

Hi @suma2212,

For Sharing Album

The store procedure may look something like below.


CREATE PROCEDURE sp_ShareAlbums
@albumID INT,
@UserID INT,
@sharedTo INT = 0

AS
BEGIN TRANSACTION

INSERT INTO tbl_sharedAlbums (albumID, sharedBy, sharedTo, sharedDate, modifiedBy, modifiedDate, isDeleted)
VALUES (@albumID, @UserID, @sharedTo, GETDATE(), @UserID, GETDATE(), 0)

IF @@ERROR > 0    
BEGIN    
 ROLLBACK TRANSACTION    
END    
ELSE    
BEGIN    
 COMMIT TRANSACTION    
END

Here @sharedTo column is default to "0", if you want to share to all.
Otherwise you will send the ID of Friend whom to share.

If you have number of friends, then call this procedure for each friends in a loop through code.

For Setting Default Photo of Album

While creation of Album (tbl_albums), an Album Images (tbl_albumImages), after the upload, you should have an option(/button) in front end application for each photo like
"Set this photo as default Photo of this Album".

When user clicks on this option, that particular photoID gets stored as defaultphotoid for that Album. Something like below on that button click will happen...


INSERT INTO tbl_albums(....(all columns), defaultphotoid)
VALUES(....(all column values), @PhotoID)

Here @PhotoID is the ID of Photo which you want to set as default.

Thanks,
Tadit

suma2212 8-Jan-13 6:36am

Hi Tadit,

thanks for ur help. you helped me a lot.
i want to share that album in to facebook. is it possible to do this.
i am new of asp.net.

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 8-Jan-13 7:29am

For sharing to Facebook, you need to go through the documentations
1. Facebook C# SDK for ASP.NET.
2. Album
3. Photo

See all the discussions here.

suma2212 8-Jan-13 6:59am

HI,
i tried this. but i am getting the whole page not album it shows whole page like
http://localhost:2361/HAI/Albums.aspx?userId=71.

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 8-Jan-13 7:03am

This is the localhost link, I cannot access it.
If you have some live website link, then I can access and see.

suma2212 8-Jan-13 7:34am

sorry i dont have live website links.

what i am saying is like that url is shared in facebook not that album. how can i connect that album and facebook share button.
i want to share the album in facebook.