public ActionResult SlideShow() { DateTime beginDate = DateTime.Now; DateTime endDate = beginDate.AddDays(60); ViewBag.BeginDate = beginDate; ViewBag.EndDate = endDate; //get public ministries for banner post IEnumerable <ministry> PublicMinistry = MinistryRepository.GetDisplayMinistry(); ViewBag.PublcMinistry = PublicMinistry; ViewBag.PublicMinistryCount = PublicMinistry.Count(); //get banner calendar events //check if available banner events int bannerCount = CalendarRepository.GetBannerCalendarEvent(beginDate, endDate).Count(); ViewBag.HasCalendarBanner = false; if (bannerCount > 0) { ViewBag.HasCalendarBanner = true; } IEnumerable <calendar> BannerCalendarEvents = CalendarRepository.GetBannerCalendarEvent(beginDate, endDate); foreach (calendar c in BannerCalendarEvents) { if (c.DocumentID != null) { c.document = DocumentRepository.GetDocumentByID((int)c.DocumentID); } c.picture = PictureRepository.GetPictureByID((int)c.PictureID); } ViewBag.CalendarBannerEvent = BannerCalendarEvents; return(PartialView()); }