public void UpConstant(string aCategory, string value1, string ConstantName = "", int SortOrder = 0, string value2 = "", string value3 = "") { constant cont = ConstantRepository.GetConstantByName(ConstantName); if (cont != null) { cont.Category = aCategory; if (ConstantName == "") { cont.ConstantName = value1; } else { cont.ConstantName = ConstantName; } cont.Value1 = value1; if (SortOrder == 0) { cont.SortOrder = 1; } else { cont.SortOrder = SortOrder; } cont.Status = "Active"; cont.Value2 = value2; cont.Value3 = value3; cont.EnteredBy = User.Identity.Name.ToString(); cont.DateEntered = DateTime.Now; db.Entry(cont).State = EntityState.Modified; db.SaveChanges(); } }
public ActionResult DeleteConfirmed(int ConstantID) { constant constant = ConstantRepository.GetConstantID(ConstantID); ConstantRepository.DeleteRedord(constant); return(RedirectToAction("List")); }
public void AddConstant(string aCategory, string value1, string ConstantName = "", int SortOrder = 0, string value2 = "", string value3 = "") { constant cont = new constant(); cont.Category = aCategory; if (ConstantName == "") { cont.ConstantName = value1; } else { cont.ConstantName = ConstantName; } cont.Value1 = value1; if (SortOrder == 0) { cont.SortOrder = 1; } else { cont.SortOrder = SortOrder; } cont.Status = "Active"; cont.Value2 = value2; cont.Value3 = value3; cont.EnteredBy = User.Identity.Name.ToString(); cont.DateEntered = DateTime.Now; db.constants.Add(cont); db.SaveChanges(); ConstantRepository.AddRecord(cont); }
// // GET: /Constant/Delete/5 public ActionResult Delete(int ConstantID) { ViewBag.ConstantID = ConstantID; constant constant = ConstantRepository.GetConstantID(ConstantID); return(PartialView(constant)); }
public ActionResult MiscUpdate(string category, string ConstantName, string UpdateField) { ViewBag.Value1 = false; ViewBag.Value2 = false; ViewBag.Value3 = false; if (UpdateField == "Value1") { ViewBag.Value1 = true; } else if (UpdateField == "Value2") { ViewBag.Value2 = true; } else if (UpdateField == "Value3") { ViewBag.Value3 = true; } else { } constant constant = ConstantRepository.GetConstantByCategoryName(category, ConstantName); return(PartialView(constant)); }
public ActionResult Create(meeting meeting, string CallerType = "") { meeting mtg = db.meetings.FirstOrDefault(e => e.meetingID == meeting.meetingID && e.Title == meeting.Title); if (mtg != null) { TempData["Message2"] = "Meeting already exist"; return(PartialView(meeting)); } try { //if (budget.Comment == null) { budget.Comment = ""; } constant cont = ConstantRepository.GetConstantListByCategory("Ministry Activity").FirstOrDefault(e => e.ConstantName == "Ministry Meeting"); //set meeting on calendar calendar cal = new calendar(); cal.ministryID = meeting.ministryID; cal.EventType = cont.constantID; cal.CalendarDate = meeting.meetingDate; cal.StartTime = meeting.StartTime; cal.EndTime = meeting.EndTime; cal.Location = meeting.meetingVenue; cal.Title = meeting.Title; cal.Conductor = meeting.Conductor; cal.PublicAccess = false; cal.Description = ""; cal.EnteredBy = User.Identity.Name.ToString(); cal.DateEntered = System.DateTime.Today; cal.Status = "Active"; db.calendars.Add(cal); db.SaveChanges(); CalendarRepository.AddRecord(cal); meeting.CalendarID = cal.calendarID; if (ModelState.IsValid) { db.meetings.Add(meeting); db.SaveChanges(); MeetingRepository.AddRecord(meeting); TempData["Message2"] = "Meeting created successfully."; GetData(meeting.ministryID); if (CallerType == "Ministry") { return(RedirectToAction("Create", new { MinistryID = meeting.ministryID, CallerType = "Ministry" })); } else { return(RedirectToAction("Create")); } } } catch (Exception ex) { TempData["Message2"] = "Error adding meeting record"; } GetData(meeting.ministryID); return(PartialView(meeting)); }
public void UpdateRecord(constant constant) { if (constant.constantID > 0) { context.Entry(constant).State = System.Data.EntityState.Modified; } context.SaveChanges(); }
public ActionResult MemberPledgeEnable() { GetData(); //Member pledge entry status constant MemberPledgeEntry = ConstantRepository.GetConstantByName("Member Pledge Entry"); ViewBag.MemberPledgeEntry = ""; if (MemberPledgeEntry.Value1 == "Enable") { ViewBag.MemberPledgeEntry = string.Format("Note: Member Pledge Entry is currently Active for {0}.", MemberPledgeEntry.Value2); } else { ViewBag.MemberPledgeEntry = "Note: Member Pledge Entry is Not Active."; } return(PartialView()); }
public ActionResult Index() { string role = Convert.ToString(System.Web.HttpContext.Current.Session["memberRole"]); ViewBag.Log = true; if (role.Trim() == "") { ViewBag.Log = false; } //front page postal ViewBag.HasFixedBanner1 = false; ViewBag.HasFixedBanner2 = false; ViewBag.HasFixedBanner3 = false; ViewBag.FixedBanner1 = CalendarRepository.GetCalendarByDescription("FixedBanner1"); ViewBag.FixedBanner2 = CalendarRepository.GetCalendarByDescription("FixedBanner2"); ViewBag.FixedBanner3 = CalendarRepository.GetCalendarByDescription("FixedBanner3"); if (ViewBag.FixedBanner1 != null) { ViewBag.HasFixedBanner1 = true; } if (ViewBag.FixedBanner2 != null) { ViewBag.HasFixedBanner2 = true; } if (ViewBag.FixedBanner3 != null) { ViewBag.HasFixedBanner3 = true; } ViewBag.DisplayFixedBanner = false; constant DisplayFixedBanner = ConstantRepository.GetConstantByName("DisplayFixedBanner"); if (DisplayFixedBanner.Value1 == "Yes") { ViewBag.DisplayFixedBanner = true; } ViewBag.Role = role; return(PartialView()); }
public ActionResult Create(programevent programevent) { int ministryID = GoalRepository.GetGoalByID(programevent.goalID).ministryID; constant cont = ConstantRepository.GetConstantListByCategory("Ministry Activity").FirstOrDefault(e => e.ConstantName == "Program/Event"); try { //set meeting on calendar calendar cal = new calendar(); cal.ministryID = ministryID; cal.EventType = cont.constantID; cal.CalendarDate = programevent.C_When; cal.StartTime = programevent.BeginTime; cal.EndTime = programevent.EndTime; cal.Location = programevent.C_Where; cal.Title = programevent.Title; cal.Conductor = MemberRepository.GetMemberByID(programevent.C_Who).FullNameTitle; cal.PublicAccess = true; cal.Description = ""; cal.EnteredBy = User.Identity.Name.ToString(); cal.DateEntered = System.DateTime.Today; cal.Status = "Active"; db.calendars.Add(cal); db.SaveChanges(); CalendarRepository.AddRecord(cal); programevent.CalendarID = cal.calendarID; if (ModelState.IsValid) { db.programevents.Add(programevent); db.SaveChanges(); ProgramEventRepository.AddRecord(programevent); TempData["Message2"] = "Event added successfully."; GetData(ministryID); return(RedirectToAction("Create", new { GoalID = programevent.goalID })); } } catch (Exception ex) { TempData["Message2"] = "Error adding event"; } GetData(ministryID); return(PartialView(programevent)); }
public ActionResult Edit(constant constant) { try { if (ModelState.IsValid) { db.Entry(constant).State = EntityState.Modified; db.SaveChanges(); TempData["Message2"] = string.Format("{0} record update successfully.", constant.ConstantName); return(RedirectToAction("List", new {})); } } catch (Exception ex) { TempData["Message2"] = string.Format("Error editing {0} record.", constant.ConstantName); } return(PartialView(constant)); }
public ActionResult Create(constant constant) { constant c = ConstantRepository.GetAllConstantList().FirstOrDefault(e => e.Category == constant.Category && e.ConstantName == constant.ConstantName); if (c != null) { TempData["Message2"] = string.Format("Constant <{0}> already exist for category <{1}>.", c.ConstantName, c.Category); return(RedirectToAction("Create")); } try { if (constant.Value2 == null) { constant.Value2 = "Null"; } if (constant.Value3 == null) { constant.Value3 = "Null"; } if (ModelState.IsValid) { db.constants.Add(constant); db.SaveChanges(); ConstantRepository.AddRecord(constant); TempData["Message2"] = "Constant created successfully."; GetData(); return(RedirectToAction("Create")); } } catch (Exception ex) { TempData["Message2"] = "Error ocurred creating constant."; } return(PartialView(constant)); }
public void TaxReport(int memberID) { string FileName = string.Format("{0}","ContributionTaxFile.pdf"); // var path = Path.Combine(Server.MapPath("~/public_html/ClientFiles"), FileName); var path = Path.Combine(Server.MapPath("~/App_Data/ClientFiles"), FileName); bool exist = System.IO.File.Exists(string.Format("{0}", path)); if (exist) { System.IO.File.Delete(string.Format("{0}", path)); //System.IO.File.Delete(@"C:\test.txt"); } member member = MemberRepository.GetMemberByID(memberID); Document doc = new Document(iTextSharp.text.PageSize.LETTER, 10, 10, 42, 35); PdfWriter wri = PdfWriter.GetInstance(doc, new FileStream(path, FileMode.Create)); doc.Open(); //image picture icon = PictureRepository.GetLetterHeadImage(); if (icon != null) { iTextSharp.text.Image image = iTextSharp.text.Image.GetInstance(icon.ImageData); //image.ScalePercent(50f); //image.SetAbsolutePosition(doc.PageSize.Width - 36f - 72f, doc.PageSize.Height - 36f - 216.6f); image.ScaleToFit(250f, 250f); // image.Border = iTextSharp.text.Rectangle.BOX; // image.BorderColor = iTextSharp.text.BaseColor.GREEN; // image.BorderWidth = 5f; doc.Add(image); } //get contribution data //ministry ministry = string ChurchName = ConstantRepository.GetConstantByName("Church Name").Value1; string ChurchAddress = ConstantRepository.GetConstantByName("Church Address").Value1; string ChurchPhone = ConstantRepository.GetConstantByName("Church Phone").Value1; constant signature1 = ConstantRepository.GetConstantByName("TaxSignature1"); constant signature2 = ConstantRepository.GetConstantByName("TaxSignature2"); Paragraph data; data = new Paragraph(string.Format("{0}\n", ChurchName)); doc.Add(data); data = new Paragraph(string.Format("{0}\n", ChurchAddress)); doc.Add(data); data = new Paragraph(string.Format("{0}\n", ChurchPhone)); doc.Add(data); data = new Paragraph(Environment.NewLine); doc.Add(data); data = new Paragraph("Member Contribution Tax Statement"); doc.Add(data); data = new Paragraph(Environment.NewLine); doc.Add(data); string memberTitle = SpouseRepository.JointTitheTitle(memberID); data = new Paragraph(string.Format("For: {0}", memberTitle)); doc.Add(data); data = new Paragraph(Environment.NewLine); doc.Add(data); int ContributionYear = DateTime.Today.Year; DateTime BeginDate = Convert.ToDateTime("1/1/" + ContributionYear.ToString()); DateTime EndDate = Convert.ToDateTime("12/31/" + ContributionYear.ToString()); int thiteID = ConstantRepository.GetConstantByName("Tithes").constantID; int offeringID = ConstantRepository.GetConstantByName("Offering").constantID; decimal TithesTotal = ContributionRepository.GetContributionByMemberCategoryRange(memberID, thiteID, BeginDate, EndDate).Sum(e => e.Amount); decimal OfferingTotal = ContributionRepository.GetContributionByMemberCategoryRange(memberID, offeringID, BeginDate, EndDate).Sum(e => e.Amount); decimal Totalcontribution = ContributionRepository.GetContributionByMemberDateRange(memberID,BeginDate, EndDate).Sum(e => e.Amount); decimal OthersTotal = Totalcontribution - TithesTotal - OfferingTotal; data = new Paragraph(string.Format("Tithes: {0:c}", TithesTotal)); doc.Add(data); data = new Paragraph(string.Format("Offerings: {0:c}", OfferingTotal)); doc.Add(data); data = new Paragraph(string.Format("Others: {0:c}", OthersTotal)); doc.Add(data); data = new Paragraph(string.Format("-----------------------------------")); doc.Add(data); data = new Paragraph(string.Format("Total: {0:c}", Totalcontribution)); doc.Add(data); data = new Paragraph(Environment.NewLine); doc.Add(data); data = new Paragraph(string.Format("-----------------------------------")); doc.Add(data); if (signature1.Value1 != "") { data = new Paragraph(string.Format("Signed: {0} ({1})", signature1.Value2, signature1.Value1)); doc.Add(data); } data = new Paragraph(Environment.NewLine); doc.Add(data); if (signature2.Value1 != "") { data = new Paragraph(string.Format("-----------------------------------")); doc.Add(data); data = new Paragraph(string.Format("Signed: {0} ({1})", signature2.Value2, signature2.Value1)); doc.Add(data); } doc.Close(); //document doc = DocumentRepository.GetDocumentByID(DocumentID); //string path = AppDomain.CurrentDomain.BaseDirectory + "App_Data/ClientFiles/"; path = AppDomain.CurrentDomain.BaseDirectory + "App_Data/ClientFiles/"; // path = AppDomain.CurrentDomain.BaseDirectory + "public_html/ClientFiles/"; Response.ContentType = "application/pdf"; Response.AddHeader("Content-Disposition", @"filename=""IT Report.xls"""); Response.TransmitFile(@path + FileName); //Response.TransmitFile(FileName); }
public ActionResult List(DateTime bDate, DateTime eDate, int codeID = 0, string SearchType = "",string CallingMethod = "Details") { ViewBag.BeginDate = bDate; ViewBag.EndDate = eDate; ViewBag.CodeID = codeID; ViewBag.SearchType = SearchType; ViewBag.AllowEdit = false; if (ViewBag.CallingMethod == "Details") { ViewBag.AllowEdit = true; } GetData(); IEnumerable<contribution> ContributionList; ViewBag.Title = ""; ViewBag.DefaultSearch = false; if (SearchType == "MemberSearch") { ContributionList = ContributionRepository.GetContributionByMemberDateRange(codeID, bDate, eDate); member member = MemberRepository.GetMemberByID(codeID); spouse spouse1 = SpouseRepository.GetSpouseByID1(codeID); spouse spouse2 = SpouseRepository.GetSpouseByID2(codeID); if (spouse1 != null) { ViewBag.Title = string.Format("{0} Contributions ({1} - {2})", spouse1.JointTitheTitle, bDate.ToShortDateString(), eDate.ToShortDateString()); } else if (spouse2 != null) { ViewBag.Title = string.Format("{0} Contributions ({1} - {2})", spouse2.JointTitheTitle, bDate.ToShortDateString(), eDate.ToShortDateString()); } else { ViewBag.Title = string.Format("{0} Contributions ({1} - {2})", member.FullNameTitle, bDate.ToShortDateString(), eDate.ToShortDateString()); } } else if (SearchType == "FundSearch") { ViewBag.DefaultSearch = true; ContributionList = ContributionRepository.GetContributionByCategoryRange(codeID, bDate, eDate); constant category = ConstantRepository.GetConstantID(codeID); ViewBag.Title = string.Format("{0} Contributions ({1} - {2})", category.Value1, bDate.ToShortDateString(), eDate.ToShortDateString()); } else { ViewBag.DefaultSearch = true; ContributionList = ContributionRepository.GetContributionByDateRange(bDate, eDate); ViewBag.Title = string.Format("All Contributions ({0} - {1})", bDate.ToShortDateString(), eDate.ToShortDateString()); } ViewBag.RecordCount = ContributionList.Count(); foreach (var i in ContributionList) { i.FundName = ConstantRepository.GetConstantID(i.subCategoryID).Value1; i.member = MemberRepository.GetMemberByID(i.memberID); } decimal sum = ContributionList.Sum(e => e.Amount); ViewBag.Heading = string.Format("Total: {0:c}",sum); return PartialView(ContributionList); }
// // GET: /Constant/Edit/5 public ActionResult Edit(int ConstantID) { constant constant = ConstantRepository.GetConstantID(ConstantID); return(PartialView(constant)); }
public bool AddRecord(constant Record) { myRecords.Add(record); return(true); }
public void DeleteRedord(constant constant) { myRecords.Remove(record); context.constants.Remove(constant); context.SaveChanges(); }
public constant GetConstantByCategoryName(string Category, string Name) { record = myRecords.FirstOrDefault(e => e.Category == Category && e.ConstantName == Name); return(record); }
public void TaxReport2(int memberID, int Year) { try { string FileName = string.Format("{0}", "ContributionTaxFile.pdf"); // var path = Path.Combine(Server.MapPath("~/public_html/ClientFiles"), FileName); var path = Path.Combine(Server.MapPath("~/App_Data/ClientFiles"), FileName); bool exist = System.IO.File.Exists(string.Format("{0}", path)); if (exist) { System.IO.File.Delete(string.Format("{0}", path)); //System.IO.File.Delete(@"C:\test.txt"); } member member = MemberRepository.GetMemberByID(memberID); Document doc = new Document(iTextSharp.text.PageSize.LETTER, 70, 40, 42, 35); PdfWriter wri = PdfWriter.GetInstance(doc, new FileStream(path, FileMode.Create)); doc.Open(); //image //picture icon = PictureRepository.GetLetterHeadImage(); //if ((icon != null) || (DisplayLog0 == "Yes")) //{ // iTextSharp.text.Image image = iTextSharp.text.Image.GetInstance(icon.ImageData); // image.ScaleToFit(250f, 250f); // doc.Add(image); //} //get contribution data //ministry ministry = string ChurchName = ConstantRepository.GetConstantByName("Church Name").Value1; string ChurchAddress = ConstantRepository.GetConstantByName("Church Address").Value1; string ChurchPhone = ConstantRepository.GetConstantByName("Church Phone").Value1; string DisplayLog0 = ConstantRepository.GetConstantByName("Tax ChurchPicture").Value1; string DisplayChurchHeading = ConstantRepository.GetConstantByName("Tax ChurchAddress").Value1; constant signature1 = ConstantRepository.GetConstantByName("TaxSignature1"); constant signature2 = ConstantRepository.GetConstantByName("TaxSignature2"); Font fdefault = FontFactory.GetFont("Arial", 18, Font.NORMAL, BaseColor.BLACK); Paragraph data; //Add space string text = @" "; data = new Paragraph(string.Format("{0}", text)); doc.Add(data); if (DisplayChurchHeading == "Yes") { data = new Paragraph(string.Format("{0}\n", ChurchName), fdefault); doc.Add(data); fdefault = FontFactory.GetFont("Arial", 12, Font.NORMAL, BaseColor.BLACK); data = new Paragraph(string.Format("{0}\n", ChurchAddress), fdefault); doc.Add(data); data = new Paragraph(string.Format("{0}\n", ChurchPhone), fdefault); doc.Add(data); data = new Paragraph(Environment.NewLine); data.SpacingAfter = 15; doc.Add(data); } else { data = new Paragraph(); data.SpacingAfter = 25; doc.Add(data); } fdefault = FontFactory.GetFont("Arial", 18, Font.BOLD, BaseColor.BLACK); data = new Paragraph(Year.ToString() + " Member Contribution Tax Statement", fdefault); data.SpacingBefore = 35; doc.Add(data); data = new Paragraph(Environment.NewLine); data.SpacingAfter = 15; doc.Add(data); string memberTitle = SpouseRepository.JointTitheTitle(memberID); data = new Paragraph(string.Format("Dear {0},", memberTitle)); data.SpacingAfter = 3; doc.Add(data); text = @"Thanks for your financial support to the " + ChurchName + ". The Pastor and leaders of the church truly appreciate your contributions and pray the Lord bless you and keep You. Amen."; fdefault = FontFactory.GetFont("Arial", 14, Font.NORMAL, BaseColor.BLACK); data = new Paragraph(string.Format("{0}", text, fdefault)); data.SpacingAfter = 25; doc.Add(data); data = new Paragraph(Environment.NewLine); doc.Add(data); int ContributionYear = Year; // DateTime.Today.Year; DateTime BeginDate = Convert.ToDateTime("1/1/" + ContributionYear.ToString()); DateTime EndDate = Convert.ToDateTime("12/31/" + ContributionYear.ToString()); int thiteID = ConstantRepository.GetConstantByName("Tithes").constantID; int offeringID = ConstantRepository.GetConstantByName("Offering").constantID; decimal TithesTotal = ContributionRepository.GetContributionByMemberCategoryRange(memberID, thiteID, BeginDate, EndDate).Sum(e => e.Amount); decimal OfferingTotal = ContributionRepository.GetContributionByMemberCategoryRange(memberID, offeringID, BeginDate, EndDate).Sum(e => e.Amount); decimal Totalcontribution = ContributionRepository.GetContributionByMemberDateRange(memberID, BeginDate, EndDate).Sum(e => e.Amount); decimal OthersTotal = Totalcontribution - TithesTotal - OfferingTotal; Font fdefault2 = FontFactory.GetFont("Arial", 18, Font.BOLD, BaseColor.BLACK); data = new Paragraph(string.Format("Tithes: {0:c}", TithesTotal, fdefault2)); doc.Add(data); data = new Paragraph(string.Format("Offerings: {0:c}", OfferingTotal, fdefault2)); doc.Add(data); data = new Paragraph(string.Format("Others: {0:c}", OthersTotal, fdefault2)); doc.Add(data); data = new Paragraph(string.Format("--------------------------------------------")); doc.Add(data); data = new Paragraph(string.Format("Total: {0:c}", Totalcontribution, fdefault2)); doc.Add(data); data = new Paragraph(Environment.NewLine); doc.Add(data); //Add space text = @" "; data = new Paragraph(string.Format("{0}", text)); doc.Add(data); data.SpacingBefore = 25; data = new Paragraph(string.Format("--------------------------------------------")); doc.Add(data); if (signature1.Value1 != "") { fdefault = FontFactory.GetFont("Arial", 10, Font.ITALIC, BaseColor.RED); data = new Paragraph(string.Format("Signed: {0} ({1})", signature1.Value2, signature1.Value1, fdefault2)); doc.Add(data); } data.SpacingBefore = 5; data = new Paragraph(Environment.NewLine); doc.Add(data); //Add space text = @" "; data = new Paragraph(string.Format("{0}", text)); doc.Add(data); if (signature2.Value1 != "") { fdefault = FontFactory.GetFont("Arial", 10, Font.ITALIC, BaseColor.RED); data = new Paragraph(string.Format("--------------------------------------------")); doc.Add(data); data = new Paragraph(string.Format("Signed: {0} ({1})", signature2.Value2, signature2.Value1, fdefault2)); doc.Add(data); } doc.Close(); //document doc = DocumentRepository.GetDocumentByID(DocumentID); //string path = AppDomain.CurrentDomain.BaseDirectory + "App_Data/ClientFiles/"; path = AppDomain.CurrentDomain.BaseDirectory + "App_Data/ClientFiles/"; // path = AppDomain.CurrentDomain.BaseDirectory + "public_html/ClientFiles/"; Response.ContentType = "application/pdf"; Response.AddHeader("Content-Disposition", @"filename=""IT Report.xls"""); Response.TransmitFile(@path + FileName); //Response.TransmitFile(FileName); } catch (Exception ex) { TempData["Message2"] = string.Format("Error printing tax report."); } }
public IEnumerable <ministry> GetMyDefaultMinistries(int memberID) { List <ministry> ministryList = new List <ministry>(); var member = context.members.FirstOrDefault(e => e.memberID == memberID); double age = DateTime.Now.Date.Subtract(member.DOB).TotalDays / 365; IEnumerable <ministry> allMinistries = myRecords.Where(e => e.DefaultMemberType != null && e.Status == "Active"); using (churchdatabaseEntities context2 = new churchdatabaseEntities()) { foreach (ministry m in allMinistries) { if (m.DefaultMemberType == "Children") { constant c = context2.constants.SingleOrDefault(e => e.Category == "Member Category" && e.ConstantName == "Children"); int age1 = Convert.ToInt16(c.Value2); int age2 = Convert.ToInt16(c.Value3); if ((age >= age1) && (age <= age2)) { ministryList.Add(m); } } else if (m.DefaultMemberType == "Youths") { constant c = context2.constants.SingleOrDefault(e => e.Category == "Member Category" && e.ConstantName == "Youths"); int age1 = Convert.ToInt16(c.Value2); int age2 = Convert.ToInt16(c.Value3); if ((age >= age1) && (age <= age2)) { ministryList.Add(m); } } else if (m.DefaultMemberType == "Young Adults") { constant c = context2.constants.SingleOrDefault(e => e.Category == "Member Category" && e.ConstantName == "Young Adults"); int age1 = Convert.ToInt16(c.Value2); int age2 = Convert.ToInt16(c.Value3); if ((age >= age1) && (age <= age2)) { ministryList.Add(m); } } else if (m.DefaultMemberType == "Adults") { constant c = context2.constants.SingleOrDefault(e => e.Category == "Member Category" && e.ConstantName == "Adults"); int age1 = Convert.ToInt16(c.Value2); int age2 = Convert.ToInt16(c.Value3); if ((age >= age1) && (age <= age2)) { ministryList.Add(m); } } else if (m.DefaultMemberType == "Men") { constant c = context2.constants.SingleOrDefault(e => e.Category == "Member Category" && e.ConstantName == "Men"); int age1 = Convert.ToInt16(c.Value2); if ((age >= age1) && (member.Gender == "Male")) { ministryList.Add(m); } } else if (m.DefaultMemberType == "Women") { constant c = context2.constants.SingleOrDefault(e => e.Category == "Member Category" && e.ConstantName == "Women"); int age1 = Convert.ToInt16(c.Value2); if ((age >= age1) && (member.Gender == "Female")) { ministryList.Add(m); } } else if (m.DefaultMemberType == "Seniors") { constant c = context.constants.SingleOrDefault(e => e.Category == "Member Category" && e.ConstantName == "Seniors"); int age1 = Convert.ToInt16(c.Value2); int age2 = Convert.ToInt16(c.Value3); if ((age >= age1) && (age >= age2)) { ministryList.Add(m); } } else if (m.DefaultMemberType == "All Members") { constant c = context2.constants.SingleOrDefault(e => e.Category == "Member Category" && e.ConstantName == "All Members"); int age1 = Convert.ToInt16(c.Value2); int age2 = Convert.ToInt16(c.Value3); if ((age >= age1) && (age <= age2)) { ministryList.Add(m); } } else if (m.DefaultMemberType == "Married Couples") { using (churchdatabaseEntities context3 = new churchdatabaseEntities()) { var spouse = context3.spouses.FirstOrDefault(e => e.spouse1ID == memberID); if (spouse != null) { ministryList.Add(m); } spouse = context3.spouses.FirstOrDefault(e => e.spouse2ID == memberID); if (spouse != null) { ministryList.Add(m); } } } else { } } } return(ministryList.ToList()); }
public Dictionary <int, string> GetMinistryMemberList(int ministryID) { Dictionary <int, string> MinistryMemberList = new Dictionary <int, string>(); ministry ministry = context.ministries.SingleOrDefault(e => e.ministryID == ministryID); var memberlist = context.members.Where(e => e.Status == "Active"); if (ministry.CodeDesc == "Church") { memberlist = context.members.Where(e => e.Status == "Active"); } else if (ministry.CodeDesc == "Babies") { constant Membercategory = context.constants.SingleOrDefault(e => e.Category == "Member Category" && e.ConstantName == "Babies"); int lowerAgeYear = Convert.ToInt16(Membercategory.Value2); int upperAgeYear = Convert.ToInt16(Membercategory.Value3); int year = System.DateTime.Today.Year; int lowerYear = year - lowerAgeYear; int upperYear = year - upperAgeYear; DateTime aDate = System.DateTime.Today; DateTime BeginDate = Convert.ToDateTime(aDate.Month + "/" + aDate.Day + "/" + lowerYear.ToString()); DateTime EndDate = Convert.ToDateTime(aDate.Month + "/" + aDate.Day + "/" + upperYear.ToString()); memberlist = context.members.Where(e => e.Status == "Active" && e.DOB >= BeginDate && e.DOB <= EndDate); } else if (ministry.CodeDesc == "Children") { constant Membercategory = context.constants.SingleOrDefault(e => e.Category == "Member Category" && e.ConstantName == "Children"); int lowerAgeYear = Convert.ToInt16(Membercategory.Value2); int upperAgeYear = Convert.ToInt16(Membercategory.Value3); int year = System.DateTime.Today.Year; int upperYear = year - lowerAgeYear; int lowerYear = year - upperAgeYear; DateTime aDate = System.DateTime.Today; DateTime BeginDate = Convert.ToDateTime(aDate.Month + "/" + aDate.Day + "/" + lowerYear.ToString()); DateTime EndDate = Convert.ToDateTime(aDate.Month + "/" + aDate.Day + "/" + upperYear.ToString()); memberlist = context.members.Where(e => e.Status == "Active" && e.DOB >= BeginDate && e.DOB <= EndDate); } else if (ministry.CodeDesc == "Youth") { constant Membercategory = context.constants.SingleOrDefault(e => e.Category == "Member Category" && e.ConstantName == "Youths"); int lowerAgeYear = Convert.ToInt16(Membercategory.Value2); int upperAgeYear = Convert.ToInt16(Membercategory.Value3); int year = System.DateTime.Today.Year; int upperYear = year - lowerAgeYear; int lowerYear = year - upperAgeYear; DateTime aDate = System.DateTime.Today; DateTime BeginDate = Convert.ToDateTime(aDate.Month + "/" + aDate.Day + "/" + lowerYear.ToString()); DateTime EndDate = Convert.ToDateTime(aDate.Month + "/" + aDate.Day + "/" + upperYear.ToString()); memberlist = context.members.Where(e => e.Status == "Active" && e.DOB >= BeginDate && e.DOB <= EndDate); } else if (ministry.CodeDesc == "Men") { constant Membercategory = context.constants.SingleOrDefault(e => e.Category == "Member Category" && e.ConstantName == "Men"); int lowerAgeYear = Convert.ToInt16(Membercategory.Value2); int year = System.DateTime.Today.Year; int lowerYear = year - lowerAgeYear; DateTime aDate = System.DateTime.Today; DateTime BeginDate = Convert.ToDateTime(aDate.Month + "/" + aDate.Day + "/" + lowerYear.ToString()); memberlist = context.members.Where(e => e.Status == "Active" && e.Gender == "Male" && e.DOB >= BeginDate); } else if (ministry.CodeDesc == "Women") { constant Membercategory = context.constants.SingleOrDefault(e => e.Category == "Member Category" && e.ConstantName == "Women"); int lowerAgeYear = Convert.ToInt16(Membercategory.Value2); int year = System.DateTime.Today.Year; int lowerYear = year - lowerAgeYear; DateTime aDate = System.DateTime.Today; DateTime BeginDate = Convert.ToDateTime(aDate.Month + "/" + aDate.Day + "/" + lowerYear.ToString()); memberlist = context.members.Where(e => e.Status == "Active" && e.Gender == "Female" && e.DOB >= BeginDate); } else if (ministry.CodeDesc == "Seniors") { constant Membercategory = context.constants.SingleOrDefault(e => e.Category == "Member Category" && e.ConstantName == "Seniors"); int lowerAgeYear = Convert.ToInt16(Membercategory.Value2); int year = System.DateTime.Today.Year; int lowerYear = year - lowerAgeYear; DateTime aDate = System.DateTime.Today; DateTime BeginDate = Convert.ToDateTime(aDate.Month + "/" + aDate.Day + "/" + lowerYear.ToString()); memberlist = context.members.Where(e => e.Status == "Active" && e.DOB >= BeginDate); } else if (ministry.CodeDesc == "Marriage") { var spouse1Group = from g in context.members.Where(e => e.Status == "Active") join c in context.spouses on g.memberID equals c.spouse1ID select g; var spouse2Group = from g in context.members.Where(e => e.Status == "Active") join c in context.spouses on g.memberID equals c.spouse2ID select g; memberlist = spouse1Group.Concat(spouse2Group); } else if (ministry.CodeDesc == "Singles") { ministryID = context.ministries.SingleOrDefault(e => e.CodeDesc == "Singles").ministryID; memberlist = from g in context.members.Where(e => e.Status == "Active") join c in context.ministrymembers.Where(e => e.ministryID == ministryID) on g.memberID equals c.memberID //where c.ministryID == ministryID select g; } else { memberlist = from g in context.members.Where(e => e.Status == "Active") join c in context.ministrymembers.Where(e => e.ministryID == ministryID) on g.memberID equals c.memberID //where c.ministryID == ministryID select g; } if (memberlist.Count() == 0) { return(MinistryMemberList); } MinistryMemberList = memberlist .OrderBy(e => (string)e.FirstName) .ToDictionary(e => (int)e.memberID, e => (string)string.Format("{0} {1}", e.FirstName, e.LastName)); return(MinistryMemberList); }
public IEnumerable <member> GetMemberListCategory(string MemberGroup) { var memberlist = myRecords.Where(e => e.Status == "Active"); if (MemberGroup == "Babies") { constant Membercategory = context.constants.SingleOrDefault(e => e.Category == "Member Category" && e.ConstantName == "Babies"); int lowerAgeYear = Convert.ToInt16(Membercategory.Value2); int upperAgeYear = Convert.ToInt16(Membercategory.Value3); int year = System.DateTime.Today.Year; int lowerYear = year - lowerAgeYear; int upperYear = year - upperAgeYear; DateTime aDate = System.DateTime.Today; DateTime BeginDate = Convert.ToDateTime(aDate.Month + "/" + aDate.Day + "/" + lowerYear.ToString()); DateTime EndDate = Convert.ToDateTime(aDate.Month + "/" + aDate.Day + "/" + upperYear.ToString()); memberlist = myRecords.Where(e => e.Status == "Active" && e.DOB >= BeginDate && e.DOB <= EndDate); } else if (MemberGroup == "Children") { constant Membercategory = context.constants.SingleOrDefault(e => e.Category == "Member Category" && e.ConstantName == "Children"); int lowerAgeYear = Convert.ToInt16(Membercategory.Value2); int upperAgeYear = Convert.ToInt16(Membercategory.Value3); int year = System.DateTime.Today.Year; int upperYear = year - lowerAgeYear; int lowerYear = year - upperAgeYear; DateTime aDate = System.DateTime.Today; DateTime BeginDate = Convert.ToDateTime(aDate.Month + "/" + aDate.Day + "/" + lowerYear.ToString()); DateTime EndDate = Convert.ToDateTime(aDate.Month + "/" + aDate.Day + "/" + upperYear.ToString()); memberlist = myRecords.Where(e => e.Status == "Active" && e.DOB >= BeginDate && e.DOB <= EndDate); } else if (MemberGroup == "Youth") { constant Membercategory = context.constants.SingleOrDefault(e => e.Category == "Member Category" && e.ConstantName == "Youths"); int lowerAgeYear = Convert.ToInt16(Membercategory.Value2); int upperAgeYear = Convert.ToInt16(Membercategory.Value3); int year = System.DateTime.Today.Year; int upperYear = year - lowerAgeYear; int lowerYear = year - upperAgeYear; DateTime aDate = System.DateTime.Today; DateTime BeginDate = Convert.ToDateTime(aDate.Month + "/" + aDate.Day + "/" + lowerYear.ToString()); DateTime EndDate = Convert.ToDateTime(aDate.Month + "/" + aDate.Day + "/" + upperYear.ToString()); memberlist = myRecords.Where(e => e.Status == "Active" && e.DOB >= BeginDate && e.DOB <= EndDate); } else if (MemberGroup == "Young Adults") { constant Membercategory = context.constants.SingleOrDefault(e => e.Category == "Member Category" && e.ConstantName == "Young Adults"); int lowerAgeYear = Convert.ToInt16(Membercategory.Value2); int upperAgeYear = Convert.ToInt16(Membercategory.Value3); int year = System.DateTime.Today.Year; int upperYear = year - lowerAgeYear; int lowerYear = year - upperAgeYear; DateTime aDate = System.DateTime.Today; DateTime BeginDate = Convert.ToDateTime(aDate.Month + "/" + aDate.Day + "/" + lowerYear.ToString()); DateTime EndDate = Convert.ToDateTime(aDate.Month + "/" + aDate.Day + "/" + upperYear.ToString()); memberlist = myRecords.Where(e => e.Status == "Active" && e.DOB >= BeginDate && e.DOB <= EndDate); } else if (MemberGroup == "Adults") { constant Membercategory = context.constants.SingleOrDefault(e => e.Category == "Member Category" && e.ConstantName == "Adults"); int lowerAgeYear = Convert.ToInt16(Membercategory.Value2); int upperAgeYear = Convert.ToInt16(Membercategory.Value3); int year = System.DateTime.Today.Year; int upperYear = year - lowerAgeYear; int lowerYear = year - upperAgeYear; DateTime aDate = System.DateTime.Today; DateTime BeginDate = Convert.ToDateTime(aDate.Month + "/" + aDate.Day + "/" + lowerYear.ToString()); DateTime EndDate = Convert.ToDateTime(aDate.Month + "/" + aDate.Day + "/" + upperYear.ToString()); memberlist = myRecords.Where(e => e.Status == "Active" && e.DOB >= BeginDate && e.DOB <= EndDate); } else if (MemberGroup == "Men") { constant Membercategory = context.constants.SingleOrDefault(e => e.Category == "Member Category" && e.ConstantName == "Men"); int lowerAgeYear = Convert.ToInt16(Membercategory.Value2); int year = System.DateTime.Today.Year; int lowerYear = year - lowerAgeYear; DateTime aDate = System.DateTime.Today; DateTime BeginDate = Convert.ToDateTime(aDate.Month + "/" + aDate.Day + "/" + lowerYear.ToString()); memberlist = myRecords.Where(e => e.Status == "Active" && e.Gender == "Male" && e.DOB <= BeginDate); } else if (MemberGroup == "Women") { constant Membercategory = context.constants.SingleOrDefault(e => e.Category == "Member Category" && e.ConstantName == "Women"); int lowerAgeYear = Convert.ToInt16(Membercategory.Value2); int year = System.DateTime.Today.Year; int lowerYear = year - lowerAgeYear; DateTime aDate = System.DateTime.Today; DateTime BeginDate = Convert.ToDateTime(aDate.Month + "/" + aDate.Day + "/" + lowerYear.ToString()); memberlist = myRecords.Where(e => e.Status == "Active" && e.Gender == "Female" && e.DOB <= BeginDate); } else if (MemberGroup == "Seniors") { constant Membercategory = context.constants.SingleOrDefault(e => e.Category == "Member Category" && e.ConstantName == "Seniors"); int lowerAgeYear = Convert.ToInt16(Membercategory.Value2); int year = System.DateTime.Today.Year; int lowerYear = year - lowerAgeYear; DateTime aDate = System.DateTime.Today; DateTime BeginDate = Convert.ToDateTime(aDate.Month + "/" + aDate.Day + "/" + lowerYear.ToString()); memberlist = myRecords.Where(e => e.Status == "Active" && e.DOB <= BeginDate); } else if (MemberGroup == "Marriage") { var spouse = from g in context.members.Where(e => e.Status == "Active") join c in context.spouses on g.memberID equals c.spouse1ID select g; memberlist = spouse; } else if (MemberGroup == "Singles") { //get all adults constant Membercategory = context.constants.SingleOrDefault(e => e.Category == "Member Category" && e.ConstantName == "Adults"); int lowerAgeYear = Convert.ToInt16(Membercategory.Value2); int upperAgeYear = Convert.ToInt16(Membercategory.Value3); int year = System.DateTime.Today.Year; int upperYear = year - lowerAgeYear; int lowerYear = year - upperAgeYear; DateTime aDate = System.DateTime.Today; DateTime BeginDate = Convert.ToDateTime(aDate.Month + "/" + aDate.Day + "/" + lowerYear.ToString()); DateTime EndDate = Convert.ToDateTime(aDate.Month + "/" + aDate.Day + "/" + upperYear.ToString()); var All_memberlist = myRecords.Where(e => e.Status == "Active" && e.DOB >= BeginDate && e.DOB <= EndDate); //get all married couples var spouse = from g in context.members.Where(e => e.Status == "Active") join c in context.spouses on g.memberID equals c.spouse1ID select g; var Married_memberlist1 = spouse; var spouse2 = from g in context.members.Where(e => e.Status == "Active") join c in context.spouses on g.memberID equals c.spouse2ID select g; var Married_memberlist2 = spouse2; //remove married couples from adult list var excludeIds = new HashSet <int>(Married_memberlist1.Select(x => x.memberID)); var excludeIds2 = new HashSet <int>(Married_memberlist2.Select(x => x.memberID)); var MemberPartialList = All_memberlist.Where(x => !excludeIds.Contains(x.memberID)).ToList(); var MemberPartialList2 = MemberPartialList.Where(x => !excludeIds2.Contains(x.memberID)).ToList(); memberlist = MemberPartialList2.Distinct(); } else { memberlist = myRecords.Where(e => e.Status == "Active"); } return(memberlist); }