/// <summary> /// ページの取得 /// </summary> /// <param name="pageSize">1ページあたりのレコード件数</param> /// <param name="pageNo">ページ番号</param> /// <returns>ActionResult</returns> public ActionResult Index(long memberId, int? page, int? year, int? month) { //int pageNo = 1; //int pageSize = 3; //UserArticleViewModel viewModel = new UserArticleViewModel(); Member member = Utils.GetMember(memberId); ViewBag.MemberId = memberId; ViewBag.Nickname = member.Nickname; ViewBag.OtherMemberID = memberId; ViewBag.OtherMemberNickName = member.Nickname; //ViewBag.PageNo = pageNo; //ViewBag.PageSize = pageSize; //SetArticles(viewModel, memberId, 0, UserArticleViewModel.INITIAL_SIZE); //return View(viewModel); var articleListDefault = PostedController.GetRecentPosts(10,Convert.ToInt32(memberId)); if (articleListDefault != null) { int pageNumber = (page ?? 1); int postYear = (year != null) ? year.Value : DateTime.Now.Year; int postMonth = DateTime.Now.Month; var spara = com.SystemParamater.Find(1); int pageSize = 10; if (spara != null) pageSize = Convert.ToInt32(spara.Spara); var postMothList = new UserArticleMonthListViewModel(); postMothList.Year = postYear; postMothList.YearList = (from a in articleListDefault select a).GroupBy(m => m.PostYear).Select(l => l.Key).ToList(); if (postMothList.YearList != null) postMothList.YearList.Sort(); postMothList.YearList.Sort(); postMothList.MonthList = (from a in articleListDefault where a.PostYear == postYear select a).GroupBy(m => m.PostMonth).Select(l => l.Key).ToList(); if (postMothList.MonthList != null && postMothList.MonthList.Any()) { postMothList.MonthList.Sort(); if (month != null) postMonth = month.Value; else postMonth = postMothList.MonthList.LastOrDefault(); } ViewBag.PostMonth = postMonth; // get main list of articles postMothList.PostList = (from a in articleListDefault where a.PostYear == postYear && a.PostMonth == postMonth select a).ToPagedList(pageNumber, pageSize); DateTime yesterday = DateTime.Now.AddDays(-1).Date; DateTime yesterdayEnd = DateTime.Today.Date; postMothList.MostViewTopicList = from p in com.PopularTopicsAggregate join t in com.TopicMaster on p.TopicID equals t.TopicID where p.TargetDate >= yesterday && p.TargetDate < yesterdayEnd orderby p.Views descending select t; return View(postMothList); } return View(); }
public ActionResult Index(int? page, int? year, int? month) { //Todo:認証処理 AOPでやりたい。 一旦Session変数を参照し判定 if (Session["CurrentUser"] == null) { return RedirectToActionPermanent("Login", "Member", new { area = "" }); } //MyPageArticleViewModel viewModel = new MyPageArticleViewModel(); //DBから取得する処理 //SetLines(viewModel, 0, MyPageArticleViewModel.INITIAL_SIZE); var articleListDefault = PostedController.GetRecentPosts(9); if (articleListDefault != null) { int pageNumber = (page ?? 1); int postYear = (year != null) ? year.Value : DateTime.Now.Year; int postMonth = DateTime.Now.Month; var spara = com.SystemParamater.Find(1); int pageSize = 10; if (spara != null) pageSize = Convert.ToInt32(spara.Spara); var postMothList = new UserArticleMonthListViewModel(); postMothList.Year = postYear; postMothList.YearList = (from a in articleListDefault select a).GroupBy(m => m.PostYear).Select(l => l.Key).ToList(); if (postMothList.YearList != null) postMothList.YearList.Sort(); postMothList.YearList.Sort(); postMothList.MonthList = (from a in articleListDefault where a.PostYear == postYear select a).GroupBy(m => m.PostMonth).Select(l => l.Key).ToList(); if (postMothList.MonthList != null && postMothList.MonthList.Any()) { postMothList.MonthList.Sort(); if (month != null) postMonth = month.Value; else postMonth = postMothList.MonthList.LastOrDefault(); } ViewBag.PostMonth = postMonth; // get main list of articles postMothList.PostList = (from a in articleListDefault where a.PostYear == postYear && a.PostMonth == postMonth select a).ToPagedList(pageNumber, pageSize); DateTime yesterday = DateTime.Now.AddDays(-1).Date; DateTime yesterdayEnd = DateTime.Today.Date; postMothList.MostViewTopicList = from p in com.PopularTopicsAggregate join t in com.TopicMaster on p.TopicID equals t.TopicID where p.TargetDate >= yesterday && p.TargetDate < yesterdayEnd orderby p.Views descending select t; return View(postMothList); } return View(); }
public ActionResult Index(int? page, int? year, int? month) { var articleListDefault = default(IEnumerable<PostedInfoViewModel>); if (Session["CurrentUser"] != null) { var memberId = Convert.ToInt64(Session["CurrentUser"].ToString()); var email = memberContext.Member.SingleOrDefault(m => m.MemberId == memberId).Mail; var username = memberContext.Member.SingleOrDefault(m => m.MemberId == memberId).Nickname; ViewBag.UserName = username; ViewBag.CurrentPage = "投稿記事トップ"; articleListDefault = PostedController.GetRecentPosts(5); } else { articleListDefault = PostedController.GetRecentPosts(4); } if (articleListDefault != null) { int pageNumber = (page ?? 1); var postYear = (year == null) ? DateTime.Now.Year : year.Value; var postMonth = DateTime.Now.Month; var spara = memberContext.SystemParamater.Find(1); int pageSize = 10; if (spara != null) pageSize = Convert.ToInt32(spara.Spara); var postMothList = new UserArticleMonthListViewModel(); postMothList.Year = postYear; postMothList.YearList = (from a in articleListDefault select a).GroupBy(m => m.PostYear).Select(l => l.Key).ToList(); if (postMothList.YearList != null) postMothList.YearList.Sort(); postMothList.YearList.Sort(); postMothList.MonthList = (from a in articleListDefault where a.PostYear == postYear select a).GroupBy(m => m.PostMonth).Select(l => l.Key).ToList(); if (postMothList.MonthList != null && postMothList.MonthList.Any()) { postMothList.MonthList.Sort(); if (month != null) postMonth = month.Value; else postMonth = postMothList.MonthList.LastOrDefault(); } ViewBag.PostMonth = postMonth; // get main list of articles postMothList.PostList = (from a in articleListDefault where a.PostYear == postYear && a.PostMonth == postMonth select a).ToPagedList(pageNumber, pageSize); var yesterday = DateTime.Now.AddDays(-1).Date; var yesterdayEnd = DateTime.Today.Date; postMothList.MostViewTopicList = from p in memberContext.PopularTopicsAggregate join t in memberContext.TopicMaster on p.TopicID equals t.TopicID where p.TargetDate >= yesterday && p.TargetDate < yesterdayEnd orderby p.Views descending select t; return View(postMothList); } return View(); }
/// <summary> /// /// </summary> /// <param name="newsClassID"> wrong paramesster name : should be topicId</param> /// <param name="contributeID"></param> /// <param name="page"></param> /// <param name="year"></param> /// <param name="month"></param> /// <returns></returns> public ActionResult SearchByCategory(int? newsClassID, long? contributeID, int? page, int? year, int? month) { //#1295対応 Route5_3で呼ばれたとき(contributeIDあり)は新規のURLに301リダイレクト //return RedirectToActionPermanent("Show", "Splg.Controllers.UserArticle", new { area = "", contributeID = contributeID }); ViewBag.pageNO = "5-3"; long memberID = 0; string email = string.Empty; string username = string.Empty; if (Session["CurrentUser"] != null) { memberID = Convert.ToInt64(Session["CurrentUser"].ToString()); email = memberContext.Member.SingleOrDefault(m => m.MemberId == memberID).Mail; username = memberContext.Member.SingleOrDefault(m => m.MemberId == memberID).Nickname; ViewBag.UserName = username; } string topicName = memberContext.TopicMaster.SingleOrDefault(t => t.TopicID == newsClassID.Value).TopicName; if (newsClassID != null && contributeID != null) { var article = (from con in memberContext.Contribution join conQuot in memberContext.ContributionQuotOrg on con.ContributeId equals conQuot.ContributeId join quotTopic in memberContext.QuotTopic on conQuot.ContributeId equals quotTopic.ContributeID join m in memberContext.Member on con.MemberId equals m.MemberId join tm in memberContext.TopicMaster on quotTopic.TopicID equals tm.TopicID where quotTopic.TopicID == newsClassID.Value && con.ContributeId == contributeID select new UserArticleInfoViewModel { SportID = tm.SportID, ContributeId = con.ContributeId, Title = con.Title, Body = con.Body, ImageLink = con.ContributedPicture, ContributeDate = con.ContributeDate.Value, ModifiedDate = con.ModifiedDate, MemberId = con.MemberId, TopicID = quotTopic.TopicID, NewsClassId = conQuot.NewsClassId, QuoteUniqueId1 = conQuot.QuoteUniqueId1, QuoteUniqueId2 = conQuot.QuoteUniqueId2, QuoteUniqueId3 = conQuot.QuoteUniqueId3, Status = conQuot.Status, Nickname = m.Nickname, ProfileImage = m.ProfileImg }).SingleOrDefault(); if (article != null) { if (article.Status == 1) { article = AppliedDetailContent(article); } //(from quotTopic in memberContext.QuotTopic // join topicMST in memberContext.TopicMaster on quotTopic.TopicID equals topicMST.TopicID // where quotTopic.ContributeID == contributeID // select new RelatedTopicViewModel // { // TopicId = quotTopic.TopicID, // TopicName = topicMST.TopicName, // TopicURL = topicMST.JumpUrl // }).ToList<RelatedTopicViewModel>(); var articleListDefault = PostedController.GetRecentPosts(8, newsClassID.Value); //articleListDefault = PostedController.GetRecentPosts(7, newsClassID.Value); article.RightNewsestPosts = PostedController.GetRecentPosts(10, Convert.ToInt32(article.MemberId)); if (Session["CurrentUser"] != null) { int thisYear = DateTime.Now.Year; int thisMonth = DateTime.Now.Month; string query = "SELECT MemberID," + " ISNULL(SUM(PayOffPoints), 0) AS PayOffPoints," + " ISNULL(SUM(fundspoint), 0) AS FundsPoint," + " ISNULL(SUM(possesionpoint), 0) AS PossesionPoint," + " MAX(ExpectPoint_CreatedDate) AS LastExpectedPointDate " + "FROM [Splg].[Com].[Point] p " + "LEFT JOIN" + " (SELECT PointID," + " MAX(CreatedDate) AS ExpectPoint_CreatedDate" + " FROM [Splg].[Com].[ExpectPoint]" + " GROUP BY PointID) e ON p.PointID = e.PointID " + "WHERE p.PayOffFlg = '1'" + " AND p.GiveTargetYear = " + thisYear + " AND p.GiveTargetMonth = " + thisMonth + " GROUP BY p.memberid"; var pointDatas = memberContext.Database.SqlQuery<FollowerMemberForUser>(@query).ToList<FollowerMemberForUser>(); article.FollowedUserInfo = (from m in memberContext.Member from f2 in memberContext.FollowList.Where(x => x.MemberID == article.MemberId && x.FollowerMemberID == memberID).DefaultIfEmpty() where m.MemberId == article.MemberId select new FollowerMemberForUser { MemberId = m.MemberId, Nickname = m.Nickname, ProfileImg = m.ProfileImg, IsFollowing = (f2.MemberID != null), }).FirstOrDefault(); if (pointDatas != null) { var p = pointDatas.SingleOrDefault(x => x.MemberId == article.MemberId); if (p != null && p.MemberId > 0) { article.FollowedUserInfo.PayOffPoints = p.PayOffPoints; article.FollowedUserInfo.FundsPoint = p.FundsPoint; article.FollowedUserInfo.PossesionPoint = p.PossesionPoint; article.FollowedUserInfo.LastExpectedPointDate = p.LastExpectedPointDate; } } } article.RelatedPostList = (from ar in articleListDefault where ar.ContributeId != contributeID.Value orderby ar.ContributeDate descending select ar).Take(10); ViewBag.TopicID = newsClassID.Value; if (article != null && contributeID != null) { ViewBag.SportID = article.SportID; SaveNewRecordToContributionReading(contributeID.Value); } return View("ViewArticleDetail", article); } return View("Error410"); } else if (newsClassID != null && contributeID == null) { int topicID = newsClassID.Value; ViewBag.pageNO = "5-2"; var articleListDefault = default(IEnumerable<PostedInfoViewModel>); if (Session["CurrentUser"] != null) { articleListDefault = PostedController.GetRecentPosts(7, topicID); } else { articleListDefault = PostedController.GetRecentPosts(8, topicID); } if (articleListDefault == null) { ViewBag.SportID = 0; ViewBag.TopicID = topicID; return View("Index"); } int pageNumber = (page ?? 1); int postYear = (year != null) ? year.Value : DateTime.Now.Year; int postMonth = DateTime.Now.Month; var spara = memberContext.SystemParamater.Find(1); int pageSize = 10; if (spara != null) pageSize = Convert.ToInt32(spara.Spara); var postMothList = new UserArticleMonthListViewModel(); postMothList.Year = postYear; postMothList.YearList = (from a in articleListDefault select a).GroupBy(m => m.PostYear).Select(l => l.Key).ToList(); if (postMothList.YearList != null) postMothList.YearList.Sort(); postMothList.YearList.Sort(); postMothList.MonthList = (from a in articleListDefault where a.PostYear == postYear select a).GroupBy(m => m.PostMonth).Select(l => l.Key).ToList(); if (postMothList.MonthList != null && postMothList.MonthList.Any()) { postMothList.MonthList.Sort(); if (month != null) postMonth = month.Value; else postMonth = postMothList.MonthList.LastOrDefault(); } ViewBag.PostMonth = postMonth; // get main list of articles postMothList.PostList = (from a in articleListDefault where a.PostYear == postYear && a.PostMonth == postMonth select a).ToPagedList(pageNumber, pageSize); DateTime yesterday = DateTime.Now.AddDays(-1).Date; DateTime yesterdayEnd = DateTime.Today.Date; postMothList.MostViewTopicList = from p in memberContext.PopularTopicsAggregate join t in memberContext.TopicMaster on p.TopicID equals t.TopicID where p.TargetDate >= yesterday && p.TargetDate < yesterdayEnd orderby p.Views descending select t; ViewBag.SportID = 0; ViewBag.TopicID = topicID; return View("Index", postMothList); } return View("Error"); }
public ActionResult ViewArticleBySport(int? sportID, int? page, int? year, int? month) { if (sportID.HasValue) { var articleListDefault = default(IEnumerable<PostedInfoViewModel>); if (Session["CurrentUser"] != null) { articleListDefault = PostedController.GetRecentPosts(6, sportID.Value); } else { articleListDefault = PostedController.GetRecentPosts(0, sportID.Value); } if (articleListDefault == null) { ViewBag.SportID = sportID.Value; return View("Index"); } int pageNumber = (page ?? 1); int postYear = (year != null) ? year.Value : DateTime.Now.Year; int postMonth = DateTime.Now.Month; var spara = memberContext.SystemParamater.Find(1); int pageSize = 10; if (spara != null) pageSize = Convert.ToInt32(spara.Spara); var postMothList = new UserArticleMonthListViewModel(); postMothList.Year = postYear; postMothList.YearList = (from a in articleListDefault select a).GroupBy(m => m.PostYear).Select(l => l.Key).ToList(); if (postMothList.YearList != null) postMothList.YearList.Sort(); postMothList.YearList.Sort(); postMothList.MonthList = (from a in articleListDefault where a.PostYear == postYear select a).GroupBy(m => m.PostMonth).Select(l => l.Key).ToList(); if (postMothList.MonthList != null && postMothList.MonthList.Any()) { postMothList.MonthList.Sort(); if (month != null) postMonth = month.Value; else postMonth = postMothList.MonthList.LastOrDefault(); } ViewBag.PostMonth = postMonth; // get main list of articles postMothList.PostList = (from a in articleListDefault where a.PostYear == postYear && a.PostMonth == postMonth select a).ToPagedList(pageNumber, pageSize); DateTime yesterday = DateTime.Now.AddDays(-1).Date; DateTime yesterdayEnd = DateTime.Today.Date; postMothList.MostViewTopicList = from p in memberContext.PopularTopicsAggregate join t in memberContext.TopicMaster on p.TopicID equals t.TopicID where p.TargetDate >= yesterday && p.TargetDate < yesterdayEnd orderby p.Views descending select t; ViewBag.SportID = sportID.Value; return View("Index", postMothList); } return View("Error"); }