public ActionResult DeleteConfirmed(int MinistryID) { ministry ministry = MinistryRepository.GetMinistryByID(MinistryID); int goalCt = GoalRepository.GetGoalByMinistry(ministry.ministryID).Count(); int meetingCt = MeetingRepository.GetMeetingByMinistry(ministry.ministryID).Count(); int calendarCt = CalendarRepository.GetCalendarByMinistry(ministry.ministryID).Count(); int storyCt = StoryRepository.GetStoryByMinistry(ministry.ministryID).Count(); int pictureCt = PictureRepository.GetPictureByMinistry(ministry.ministryID).Count(); int ListTableCt = ListTableRepository.GetListByMinistry(ministry.ministryID).Count(); if ((goalCt > 0) || (meetingCt > 0) || (calendarCt > 0) || (storyCt > 0) || (pictureCt > 0) || (ListTableCt > 0)) { return(RedirectToAction("Details")); } MinistryRepository.DeleteRecord(ministry); return(RedirectToAction("Details")); }
public ActionResult List(DateTime bDate, DateTime eDate, string SearchType = "", int codeID = 0, string code = "") { IEnumerable <listtable> ListTable; ViewBag.MinistryID = codeID; if (SearchType == "MinistrySearch") { ListTable = ListTableRepository.GetListByMinistry(codeID); } else if (SearchType == "StatusSearch") { ListTable = ListTableRepository.GetListByStatus(code); } else { ListTable = ListTableRepository.GetListByDateRange(bDate, eDate); } ViewBag.RecordCount = ListTable.Count(); GetData(codeID); return(PartialView(ListTable)); }
public ActionResult GetMinistryPage(int ministryID = 0) { ministry ministry; if (ministryID == 0) { ministry = MinistryRepository.GetMainChurchMinistry(); } else { ministry = MinistryRepository.GetMinistryByID(ministryID); } ViewBag.MinistryID = ministry.ministryID; DateTime beginDate = DateTime.Now; DateTime endDate = beginDate.AddDays(60); IEnumerable <calendar> currentCalendar = CalendarRepository.GetCalendarByMinistryDate(ministryID, beginDate, endDate); foreach (calendar m in currentCalendar) { m.ministry = MinistryRepository.GetMinistryByID(m.ministryID); } ViewBag.CurrentCalendar = currentCalendar; GetData(); IEnumerable <announcement> announcements = AnnouncementRepository.GetAnnouncementByMinistry(ministryID, beginDate, endDate); ViewBag.Announcements = announcements; IEnumerable <document> documents = DocumentRepository.GetDocumentByMinistry(ministryID); ViewBag.Document = documents; IEnumerable <listtable> tables = ListTableRepository.GetListByMinistry(ministryID); ViewBag.Tables = tables; //banner ViewBag.BannerID = null; if (ministry.PictureID != null) { picture banner = PictureRepository.GetPictureByID((int)ministry.PictureID); ViewBag.BannerID = banner.pictureID; } else { picture banner = PictureRepository.GetMinistryDefaultBanner(); ViewBag.BannerID = banner.pictureID; } //pictures IEnumerable <picture> pictures = PictureRepository.GetPictureByMinistry(ministryID).Take(30); ViewBag.Pictures = pictures; //videos IEnumerable <video> videos = VideoRepository.GetVideoByMinistry(ministryID, beginDate, endDate); ViewBag.Videos = videos; if (ministry.PageStyleID != 0) { ministry.PageStyle = ConstantRepository.GetConstantID((int)ministry.PageStyleID).Value2; } //calendar dates int year = DateTime.Now.Year; string bDateString = "1/1/" + year.ToString(); DateTime bDate = Convert.ToDateTime(bDateString).Date; ViewBag.CalendarBeginDate = bDate; string eDateString = "12/31/" + year.ToString(); DateTime eDate = Convert.ToDateTime(eDateString).Date; ViewBag.CalendarEndDate = eDate; //announcement dates DateTime AnnEndDate = DateTime.Now; DateTime AnnBeginDate = beginDate.AddDays(-90); ViewBag.AnnouncementBeginDate = AnnBeginDate; ViewBag.AnnouncementEndDate = AnnEndDate; IEnumerable <announcement> AnnouncementList = AnnouncementRepository.GetAnnouncementByMinistry(ministryID, AnnBeginDate, AnnEndDate); ViewBag.AnnouncementRecordCount = AnnouncementList.Count(); //ministry tables IEnumerable <listtable> ListTable = ListTableRepository.GetListByMinistry(ministryID); ViewBag.TableRecordCount = ListTable.Count(); ViewBag.Tables = ListTable; ViewBag.IsRental = false; if (ministry.CodeDesc == "Rental") { ViewBag.IsRental = true; } return(PartialView(ministry)); }