// GET: comments for a given submission
public ActionResult Comments(int?id, string subversetoshow, int?startingcommentid, string sort)
{
var subverse = _db.Subverses.Find(subversetoshow);
if (subverse == null)
{
return(View("~/Views/Errors/Error_404.cshtml"));
}
ViewBag.SelectedSubverse = subverse.name;
ViewBag.SubverseAnonymized = subverse.anonymized_mode;
if (startingcommentid != null)
{
ViewBag.StartingCommentId = startingcommentid;
}
if (sort != null)
{
ViewBag.SortingMode = sort;
}
if (id == null)
{
return(View("~/Views/Errors/Error.cshtml"));
}
var message = _db.Messages.Find(id);
if (message == null)
{
return(View("~/Views/Errors/Error_404.cshtml"));
}
// make sure that the combination of selected subverse and message subverse are linked
if (!message.Subverse.Equals(subversetoshow, StringComparison.OrdinalIgnoreCase))
{
return(View("~/Views/Errors/Error_404.cshtml"));
}
// experimental
// register a new session for this subverse
try
{
var currentSubverse = (string)RouteData.Values["subversetoshow"];
SessionTracker.Add(currentSubverse, Session.SessionID);
}
catch (Exception)
{
//
}
// check if this is a new view and register it
string clientIpAddress = String.Empty;
if (Request.ServerVariables["HTTP_X_FORWARDED_FOR"] != null)
{
clientIpAddress = Request.ServerVariables["HTTP_X_FORWARDED_FOR"];
}
else if (Request.UserHostAddress.Length != 0)
{
clientIpAddress = Request.UserHostAddress;
}
if (clientIpAddress == String.Empty)
{
return(View("~/Views/Home/Comments.cshtml", message));
}
// generate salted hash of client IP address
string ipHash = IpHash.CreateHash(clientIpAddress);
// check if this hash is present for this submission id in viewstatistics table
var existingView = _db.Viewstatistics.Find(message.Id, ipHash);
// this IP has already viwed this thread, skip registering a new view
if (existingView != null)
{
return(View("~/Views/Home/Comments.cshtml", message));
}
// this is a new view, register it for this submission
var view = new Viewstatistic {
submissionId = message.Id, viewerId = ipHash
};
_db.Viewstatistics.Add(view);
message.Views++;
_db.SaveChanges();
return(View("~/Views/Home/Comments.cshtml", message));
}
// GET: comments for a given submission
public ActionResult Comments(int?id, string subversetoshow, int?startingcommentid, string sort, int?commentToHighLight)
{
var subverse = SubverseCache.Retrieve(subversetoshow);
//var subverse = _db.Subverses.Find(subversetoshow);
if (subverse == null)
{
return(View("~/Views/Errors/Error_404.cshtml"));
}
//HACK: Disable subverse
if (subverse.admin_disabled.HasValue && subverse.admin_disabled.Value)
{
ViewBag.Subverse = subverse.name;
return(View("~/Views/Errors/SubverseDisabled.cshtml"));
}
ViewBag.SelectedSubverse = subverse.name;
ViewBag.SubverseAnonymized = subverse.anonymized_mode;
//Temp cache user votes for this thread
ViewBag.VoteCache = UserVotesBySubmission(id.Value);
ViewBag.SavedCommentCache = UserSavedCommentsBySubmission(id.Value);
if (startingcommentid != null)
{
ViewBag.StartingCommentId = startingcommentid;
}
if (commentToHighLight != null)
{
ViewBag.CommentToHighLight = commentToHighLight;
}
if (sort != null)
{
ViewBag.SortingMode = sort;
}
if (id == null)
{
return(View("~/Views/Errors/Error.cshtml"));
}
var submission = _db.Messages.Find(id);
if (submission == null)
{
return(View("~/Views/Errors/Error_404.cshtml"));
}
// make sure that the combination of selected subverse and message subverse are linked
if (!submission.Subverse.Equals(subversetoshow, StringComparison.OrdinalIgnoreCase))
{
return(View("~/Views/Errors/Error_404.cshtml"));
}
// experimental: register a new session for this subverse
string clientIpAddress = String.Empty;
if (Request.ServerVariables["HTTP_X_FORWARDED_FOR"] != null)
{
clientIpAddress = Request.ServerVariables["HTTP_X_FORWARDED_FOR"];
}
else if (Request.UserHostAddress.Length != 0)
{
clientIpAddress = Request.UserHostAddress;
}
if (clientIpAddress == String.Empty)
{
return(View("~/Views/Home/Comments.cshtml", submission));
}
// generate salted hash of client IP address
string ipHash = IpHash.CreateHash(clientIpAddress);
var currentSubverse = (string)RouteData.Values["subversetoshow"];
// register a new session for this subverse
SessionTracker.Add(currentSubverse, ipHash);
// register a new view for this thread
// check if this hash is present for this submission id in viewstatistics table
var existingView = _db.Viewstatistics.Find(submission.Id, ipHash);
// this IP has already viwed this thread, skip registering a new view
if (existingView != null)
{
return(View("~/Views/Home/Comments.cshtml", submission));
}
// this is a new view, register it for this submission
var view = new Viewstatistic {
submissionId = submission.Id, viewerId = ipHash
};
_db.Viewstatistics.Add(view);
submission.Views++;
_db.SaveChanges();
return(View("~/Views/Home/Comments.cshtml", submission));
}
// GET: comments for a given submission
public ActionResult Comments(int?id, string subversetoshow, int?startingcommentid, string sort, int?commentToHighLight)
{
#region Validation
if (id == null)
{
return(View("~/Views/Errors/Error.cshtml"));
}
var submission = _db.Messages.Find(id.Value);
if (submission == null)
{
return(View("~/Views/Errors/Error_404.cshtml"));
}
// make sure that the combination of selected subverse and submission subverse are linked
if (!submission.Subverse.Equals(subversetoshow, StringComparison.OrdinalIgnoreCase))
{
return(View("~/Views/Errors/Error_404.cshtml"));
}
var subverse = DataCache.Subverse.Retrieve(subversetoshow);
//var subverse = _db.Subverse.Find(subversetoshow);
if (subverse == null)
{
return(View("~/Views/Errors/Error_404.cshtml"));
}
//HACK: Disable subverse
if (subverse.admin_disabled.HasValue && subverse.admin_disabled.Value)
{
ViewBag.Subverse = subverse.name;
return(View("~/Views/Errors/SubverseDisabled.cshtml"));
}
#endregion
ViewBag.SelectedSubverse = subverse.name;
ViewBag.SubverseAnonymized = subverse.anonymized_mode;
//Temp cache user votes for this thread
ViewBag.VoteCache = UserCommentVotesBySubmission(id.Value);
ViewBag.SavedCommentCache = UserSavedCommentsBySubmission(id.Value);
ViewBag.CCP = Karma.CommentKarma(User.Identity.Name);
if (startingcommentid != null)
{
ViewBag.StartingCommentId = startingcommentid;
}
if (commentToHighLight != null)
{
ViewBag.CommentToHighLight = commentToHighLight;
}
var SortingMode = (sort == null ? "top" : sort).ToLower();
ViewBag.SortingMode = SortingMode;
// experimental: register a new session for this subverse
string clientIpAddress = String.Empty;
if (Request.ServerVariables["HTTP_X_FORWARDED_FOR"] != null)
{
clientIpAddress = Request.ServerVariables["HTTP_X_FORWARDED_FOR"];
}
else if (Request.UserHostAddress.Length != 0)
{
clientIpAddress = Request.UserHostAddress;
}
if (clientIpAddress != String.Empty)
{
// generate salted hash of client IP address
string ipHash = IpHash.CreateHash(clientIpAddress);
var currentSubverse = (string)RouteData.Values["subversetoshow"];
// register a new session for this subverse
SessionTracker.Add(currentSubverse, ipHash);
// register a new view for this thread
// check if this hash is present for this submission id in viewstatistics table
var existingView = _db.Viewstatistics.Find(submission.Id, ipHash);
// this IP has already viwed this thread, skip registering a new view
if (existingView == null)
{
// this is a new view, register it for this submission
var view = new Viewstatistic {
submissionId = submission.Id, viewerId = ipHash
};
_db.Viewstatistics.Add(view);
submission.Views++;
_db.SaveChanges();
}
}
var commentTree = DataCache.CommentTree.Retrieve <usp_CommentTree_Result>(submission.Id, null, null);
var model = new CommentBucketViewModel()
{
StartingIndex = 0,
EndingIndex = 5,
Subverse = subverse,
Submission = submission,
CommentTree = commentTree,
//DisplayTree = displayTree,
ParentID = null,
Sort = (CommentSort)Enum.Parse(typeof(CommentSort), SortingMode, true)
};
IQueryable <usp_CommentTree_Result> displayTree = commentTree.AsQueryable().Where(x => x.ParentId == null);
model.TotalInDisplayBranch = displayTree.Count();
if (model.Sort == CommentSort.Top)
{
displayTree = displayTree.OrderByDescending(x => x.Likes - x.Dislikes).Take(model.EndingIndex);
}
else
{
displayTree = displayTree.OrderByDescending(x => x.Date).Take(model.EndingIndex);
}
model.DisplayTree = displayTree;
return(View("~/Views/Home/Comments.cshtml", model));
}