-
Notifications
You must be signed in to change notification settings - Fork 0
/
Image.aspx.cs
480 lines (436 loc) · 16.2 KB
/
Image.aspx.cs
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Web.Security;
using System.Web.Services;
public partial class Image : System.Web.UI.Page
{
//id of image
int id;
//current user
MembershipUser u;
//get the vote on this img by logged in user
string vote;
protected void Page_Load(object sender, EventArgs e)
{
//get the requested img
string reqId = Request.QueryString["id"];
//get currently logged in user
u = Membership.GetUser();
if (reqId != null && reqId != "")
{
id = Int32.Parse(reqId);
}
if (!IsPostBack)
{
//if image not found redirect to 404
if (FuddleImage.getUser(id) == "")
{
Response.Redirect("/Oops.aspx?e=404");
}
}
//set img
string url = "/ShowImage.ashx?imgid=" + id;
Image1.ImageUrl = url;
//set the voting counts
upCount.Text = FuddleVote.getUpCount(id).ToString();
downCount.Text = FuddleVote.getDownCount(id).ToString();
cuddleCount.Text = FuddleVote.getCuddleCount(id).ToString();
//set widths of counts
upCount.Width = upCount.Text.Length * 8;
downCount.Width = downCount.Text.Length * 8;
cuddleCount.Width = cuddleCount.Text.Length * 8;
//set the title of the page
Page.Header.Title = "Fuddle | " + FuddleImage.getTitle(id);
//set title and description of image
imageTitle.Text = FuddleImage.getTitle(id);
imageDescription.Text = FuddleImage.getDescription(id);
//set the user who uploded img
imageUser.Text = "by <b><a href='/user/" + FuddleImage.getUser(id) + "' target='_blank'>" + FuddleImage.getUser(id) + "</a></b>";
//load comments from database
loadComments();
//for simulating button click from javascript when enter is pressed
ScriptManager.GetCurrent(this).RegisterAsyncPostBackControl(this.commentButton);
//add this button (email) script
ScriptManager.RegisterClientScriptInclude(this, UpdatePanel1.GetType(), "Test", "http://s7.addthis.com/js/300/addthis_widget.js#pubid=undefined");
//Show deletebutton if logged inuser is the one who uploaded this picture
string uploadedUser = FuddleImage.getUser(id); //returns the user who uploaded that picture
if (u != null)
{
vote = FuddleVote.checkIfVoted(id, (Guid)u.ProviderUserKey);
if (vote == "up")
{
upButton.Attributes.Add("style", "background-color:#C4C4C4");
}
else if (vote == "down")
{
downButton.Attributes.Add("style", "background-color:#C4C4C4");
}
else
{
downButton.Attributes.Remove("style");
upButton.Attributes.Remove("style");
}
if (uploadedUser == u.UserName)
{
deleteButton.Visible = true;
updateButton.Visible = true;
}
}
if (!IsPostBack)
{
// Spam stuff -------
// Setting a threshold ratio of 1/10
double threshold = 0.1;
// Get the upvote and downvote counts and calculate the spam ratio
double upvoteCount = FuddleVote.getUpCount(id);
double downvoteCount = FuddleVote.getDownCount(id);
downvoteCount *= -1;
double spamRatio = upvoteCount / downvoteCount;
// If the spam ratio is lower than the threshold, then flag the image as spam
if (spamRatio <= threshold && upvoteCount != 0 && downvoteCount != 0)
{
error.Text = "This image has been flagged as spam!";
lightbox.Visible = true;
return;
}
else if (upvoteCount == 0 && downvoteCount >= 10)
{
error.Text = "This image has been flagged as spam!";
lightbox.Visible = true;
return;
}
}
}
//upvoting this image
protected void upButton_Click(object sender, EventArgs e)
{
if (u == null)
{
error.Text = "Please login to vote.";
lightbox.Visible = true;
return;
}
vote = FuddleVote.checkIfVoted(id, (Guid)u.ProviderUserKey);
if (vote == "non")
{
try
{
u = Membership.GetUser();
if (u == null) throw new Exception();
FuddleVote.addToUpCount(id);
upCount.Text = FuddleVote.getUpCount(id).ToString();
upCount.Width = upCount.Text.Length * 8;
upButton.Attributes.Add("style", "background-color:#C4C4C4");
// Clean up the table
FuddleVote.dbGarbageCollector();
}
catch
{
error.Text = "Error voting.";
lightbox.Visible = true;
}
}
//if already upvoted remove
else if (vote == "up")
{
FuddleVote.removeFromUpCount(id);
upCount.Text = FuddleVote.getUpCount(id).ToString();
upCount.Width = upCount.Text.Length * 8;
upButton.Attributes.Remove("style");
}
}
//down voting this image
protected void downButton_Click(object sender, EventArgs e)
{
if (u == null)
{
error.Text = "Please login to vote.";
lightbox.Visible = true;
return;
}
vote = FuddleVote.checkIfVoted(id, (Guid)u.ProviderUserKey);
if (vote == "non")
{
try
{
u = Membership.GetUser();
if (u == null) throw new Exception();
FuddleVote.addToDownCount(id);
downCount.Text = FuddleVote.getDownCount(id).ToString();
downCount.Width = downCount.Text.Length * 8;
downButton.Attributes.Add("style", "background-color:#C4C4C4");
// Clean up the table
FuddleVote.dbGarbageCollector();
}
catch
{
error.Text = "Error voting.";
lightbox.Visible = true;
}
}
//if already downvoted remove
else if (vote == "down")
{
FuddleVote.removeFromDownCount(id);
downCount.Text = FuddleVote.getDownCount(id).ToString();
downCount.Width = downCount.Text.Length * 8;
downButton.Attributes.Remove("style");
}
}
//cuddling this image
protected void cuddleButton_Click(object sender, EventArgs e)
{
if (u == null)
{
error.Text = "Please login to cuddle.";
lightbox.Visible = true;
return;
}
try
{
u = Membership.GetUser();
if (u == null) throw new Exception();
FuddleVote.cuddleIt((Guid)u.ProviderUserKey, id).ToString();
cuddleCount.Text = FuddleVote.getCuddleCount(id).ToString();
cuddleCount.Width = cuddleCount.Text.Length * 8;
}
catch
{
error.Text = "Error cuddling.";
lightbox.Visible = true;
}
}
//adding a comment for this image
//errors don't display due to the fact that jquery keypress registers twice if commentbutton async trigger added both on updatepanel5 and 6.
//panelsUpdated[i].id === "UpdatePanel5" needs to be checked for panel 6 to get the error working
//this will cause twice register though.
protected void commentButton_Click(object sender, EventArgs e)
{
u = Membership.GetUser();
//get comment box
TextBox commentBox = LoginView1.FindControl("AddCommentBox") as TextBox;
//if nothing is entered in commentbox
if (commentBox.Text.Length <= 0)
{
error.Text = "Please enter a comment.";
lightbox.Visible = true;
return;
}
//add comment to database
int commId = FuddleImage.addComment(commentBox.Text, id);
//there is an error adding comment
if (commId == -1)
{
System.Diagnostics.Debug.WriteLine("Error Commenting.");
error.Text = "Error commenting.";
lightbox.Visible = true;
}
//when comments are added clear the commentbox
else
{
//create a comment literal
Literal myComment = new Literal();
myComment.Text = "<div id='comment" + commId + "' class='comment'><div class='pro-image'><img src='/GetAvatar.ashx?user=" + u.UserName + "'/></div><div class='comm-cont'><span class='commenter'><a href='/user/" + u.UserName + "'target='_blank'>" + u.UserName + "</a></span><span class='message'>" + commentBox.Text + "</span><span class='date'> just now <button type='button' class='deleteCommentButton submitButton' value='" + commId + "'>Delete</button></span></div></div>";
//add to comment panel
commentPanel.Controls.AddAt(0, myComment);
//clear comment box
commentBox.Text = "";
//hide no comment
nocomment.Visible = false;
}
}
//load all the comments for this image
protected void loadComments()
{
List<Comment_Info> comments = FuddleImage.getComments(id); //this should return all the comments for that image
//display no comments if non found
if (comments.Count == 0)
{
nocomment.Visible = true;
return;
}
else
{
nocomment.Visible = false;
}
//load comments below
foreach (Comment_Info comment in comments)
{
Literal myComment = new Literal();
if (u != null)
{
if (comment.username == u.UserName)
{
myComment.Text = "<div id='comment" + comment.id + "' class='comment'><div class='pro-image'><img src='/GetAvatar.ashx?user=" + comment.username + "'/></div><div class='comm-cont'><span class='commenter'><a href='/user/" + comment.username + "'target='_blank'>" + comment.username + "</a></span><span class='message'>" + comment.comment + "</span><span class='date'>" + findTimeDiff(comment.date) + " <button type='button' class='deleteCommentButton submitButton' value='" + comment.id + "'>Delete</button></span></div></div>";
}
else
{
myComment.Text = "<div class='comment'><div class='pro-image'><img src='/GetAvatar.ashx?user=" + comment.username + "'/></div><div class='comm-cont'><span class='commenter'><a href='/user/" + comment.username + "'target='_blank'>" + comment.username + "</a></span><span class='message'>" + comment.comment + "</span><span class='date'>" + findTimeDiff(comment.date) + "</span></div></div>";
}
}
else
{
myComment.Text = "<div class='comment'><div class='pro-image'><img src='/GetAvatar.ashx?user=" + comment.username + "'/></div><div class='comm-cont'><span class='commenter'><a href='/user/" + comment.username + "'target='_blank'>" + comment.username + "</a></span><span class='message'>" + comment.comment + "</span><span class='date'>" + findTimeDiff(comment.date) + "</span></div></div>";
}
//add to comment panel
commentPanel.Controls.AddAt(0, myComment);
}
}
//delete button is clicked
protected void delete_Click(object sender, EventArgs e)
{
try
{
//delete this image
FuddleImage.deleteImage(id);
//delete from albums as well, if it exists in any
FuddleAlbum.deleteImage(id);
//display deleted message
error.Text = "Image deleted.";
lightbox.Visible = true;
Session["deleted"] = true;
}
catch
{
error.Text = "Error on deletion.";
lightbox.Visible = true;
Session["deleted"] = false;
}
}
protected string findTimeDiff(DateTime then)
{
var ts = new TimeSpan(DateTime.UtcNow.Ticks - then.Ticks);
double delta = Math.Abs(ts.TotalSeconds);
const int SECOND = 1;
const int MINUTE = 60 * SECOND;
const int HOUR = 60 * MINUTE;
const int DAY = 24 * HOUR;
const int MONTH = 30 * DAY;
if (delta < 0)
{
return "not yet";
}
if (delta < 1 * MINUTE)
{
return ts.Seconds == 1 ? "one second ago" : ts.Seconds + " seconds ago";
}
if (delta < 2 * MINUTE)
{
return "a minute ago";
}
if (delta < 45 * MINUTE)
{
return ts.Minutes + " minutes ago";
}
if (delta < 90 * MINUTE)
{
return "an hour ago";
}
if (delta < 24 * HOUR)
{
return ts.Hours + " hours ago";
}
if (delta < 48 * HOUR)
{
return "yesterday";
}
if (delta < 30 * DAY)
{
return ts.Days + " days ago";
}
if (delta < 12 * MONTH)
{
int months = Convert.ToInt32(Math.Floor((double)ts.Days / 30));
return months <= 1 ? "one month ago" : months + " months ago";
}
else
{
int years = Convert.ToInt32(Math.Floor((double)ts.Days / 365));
return years <= 1 ? "one year ago" : years + " years ago";
}
}
protected void updateButton_Click(object sender, EventArgs e)
{
//change desc to textbox
updateDesc.Text = imageDescription.Text;
updateDesc.Visible = true;
imageDescription.Visible = false;
//change title to textbox
updateTitle.Text = imageTitle.Text;
updateTitle.Visible = true;
imageTitle.Visible = false;
//show save button
saveButton.Visible = true;
//hide update button
updateButton.Visible = false;
//clear error
error.Text = "";
}
protected void saveButton_Click(object sender, EventArgs e)
{
try
{
//get new info
string newTitle = updateTitle.Text;
string newDesc = updateDesc.Text;
//if empty throw exception
if (newTitle == "" || newDesc == "") throw new Exception();
//update to info
FuddleImage.updateTitle(newTitle, id);
FuddleImage.updateDescription(newDesc, id);
//disable save button, and textboxes
saveButton.Visible = false;
updateTitle.Visible = false;
updateDesc.Visible = false;
//copy over text
imageTitle.Text = updateTitle.Text;
imageDescription.Text = updateDesc.Text;
//make labels visible
imageDescription.Visible = true;
imageTitle.Visible = true;
}
catch
{
//disable save button, and textboxes
saveButton.Visible = false;
updateTitle.Visible = false;
updateDesc.Visible = false;
//make labels visible
imageDescription.Visible = true;
imageTitle.Visible = true;
error.Text = "Error updating image info.";
lightbox.Visible = true;
}
}
protected void closeError_Click(object sender, EventArgs e)
{
lightbox.Visible = false;
try
{
bool test = (bool)Session["deleted"];
if (test == true)
{
Session.Remove("deleted");
Response.Redirect("/member/MyProfile.aspx");
}
}
catch
{
//who cares?
}
}
//delete a comment with given id
[WebMethod]
public static bool deleteComment(int id)
{
bool result = FuddleImage.deleteComment(id);
return result;
}
}