// subscribe to a set
public static void SubscribeToSet(string userName, int setId)
{
// do nothing if user is already subscribed
if (IsUserSetSubscriber(userName, setId))
{
return;
}
using (var db = new whoaverseEntities())
{
// add a new set subscription
var newSubscription = new Usersetsubscription {
Username = userName, Set_id = setId
};
db.Usersetsubscriptions.Add(newSubscription);
// record new set subscription in sets table subscribers field
var tmpUserSet = db.Usersets.Find(setId);
if (tmpUserSet != null)
{
tmpUserSet.Subscribers++;
}
db.SaveChanges();
}
}
// GET: /v2
public ActionResult IndexV2(int?page)
{
ViewBag.SelectedSubverse = "frontpage";
var submissions = new List <SetSubmission>();
try
{
var frontPageResultModel = new SetFrontpageViewModel();
// show user sets
// get names of each set that user is subscribed to
// for each set name, get list of subverses that define the set
// for each subverse, get top ranked submissions
if (User.Identity.IsAuthenticated && Utils.User.SetsSubscriptionCount(User.Identity.Name) > 0)
{
var userSetSubscriptions = _db.Usersetsubscriptions.Where(usd => usd.Username == User.Identity.Name);
var blockedSubverses = _db.UserBlockedSubverses.Where(x => x.Username.Equals(User.Identity.Name)).Select(x => x.SubverseName);
foreach (var set in userSetSubscriptions)
{
Usersetsubscription setId = set;
var userSetDefinition = _db.Usersetdefinitions.Where(st => st.Set_id == setId.Set_id);
foreach (var subverse in userSetDefinition)
{
// get top ranked submissions
var submissionsExcludingBlockedSubverses = SetsUtility.TopRankedSubmissionsFromASub(subverse.Subversename, _db.Messages, subverse.Userset.Name, 2, 0)
.Where(x => !blockedSubverses.Contains(x.Subverse));
submissions.AddRange(submissionsExcludingBlockedSubverses);
}
}
frontPageResultModel.HasSetSubscriptions = true;
frontPageResultModel.UserSets = userSetSubscriptions;
frontPageResultModel.SubmissionsList = new List <SetSubmission>(submissions.OrderByDescending(s => s.Rank));
return(View("~/Views/Home/IndexV2.cshtml", frontPageResultModel));
}
// show default sets since user is not logged in or has no set subscriptions
// get names of default sets
// for each set name, get list of subverses
// for each subverse, get top ranked submissions
var defaultSets = _db.Usersets.Where(ds => ds.Default && ds.Usersetdefinitions.Any());
var defaultFrontPageResultModel = new SetFrontpageViewModel();
foreach (var set in defaultSets)
{
Userset setId = set;
var defaultSetDefinition = _db.Usersetdefinitions.Where(st => st.Set_id == setId.Set_id);
foreach (var subverse in defaultSetDefinition)
{
// get top ranked submissions
submissions.AddRange(SetsUtility.TopRankedSubmissionsFromASub(subverse.Subversename, _db.Messages, set.Name, 2, 0));
}
}
defaultFrontPageResultModel.DefaultSets = defaultSets;
defaultFrontPageResultModel.HasSetSubscriptions = false;
defaultFrontPageResultModel.SubmissionsList = new List <SetSubmission>(submissions.OrderByDescending(s => s.Rank));
return(View("~/Views/Home/IndexV2.cshtml", defaultFrontPageResultModel));
}
catch (Exception)
{
return(RedirectToAction("HeavyLoad", "Error"));
}
}
// subscribe to a set
public static void SubscribeToSet(string userName, int setId)
{
// do nothing if user is already subscribed
if (IsUserSetSubscriber(userName, setId)) return;
using (var db = new whoaverseEntities())
{
// add a new set subscription
var newSubscription = new Usersetsubscription { Username = userName, Set_id = setId };
db.Usersetsubscriptions.Add(newSubscription);
// record new set subscription in sets table subscribers field
var tmpUserSet = db.Usersets.Find(setId);
if (tmpUserSet != null)
{
tmpUserSet.Subscribers++;
}
db.SaveChanges();
}
}
