public ActionResult MinistryMember(int ministryID, int memberID, string officeTitle, DateTime membershipDate) { ministrymember member = new ministrymember(); member.memberID = memberID; member.ministryID = ministryID; if (officeTitle.Length == 0) { member.OfficeTitle = " "; } else { member.OfficeTitle = officeTitle; } member.MembershipDate = membershipDate.Date; member.EnteredBy = User.Identity.Name.ToString(); member.DateEntered = DateTime.Now.Date; member.SortOrder = 1; db.ministrymembers.Add(member); db.SaveChanges(); MinistryMemberRepository.AddRecord(member); int id = 0; Dictionary <int, string> MemberRoster; MemberRoster = MinistryMemberRepository.GetMinistryMemberList(ministryID); ViewBag.MemberRoster = new SelectList(MemberRoster, "Key", "Value", id); return(PartialView()); }
public void DeleteMinistryMember(int ministryID,int memberID) { ministrymember member = MinistryMemberRepository.GetMinistryMemberByID(ministryID, memberID); if (member != null) { MinistryMemberRepository.DeleteRecord(member); } }
public void DeleteRecord(ministrymember record) { using (churchdatabaseEntities context = new churchdatabaseEntities()) { // myRecords.Remove(record); ministrymember aRecord = context.ministrymembers.FirstOrDefault(e => e.MinistryMemberID == record.MinistryMemberID); context.ministrymembers.Remove(aRecord); context.SaveChanges(); } }
public ActionResult GetMinistryGeneralTables(int ministryID = 0, string Requestor = "") { ViewBag.MinistryID = ministryID; ViewBag.Requestor = Requestor; IEnumerable <listtable> ListTable = ListTableRepository.GetListByMinistry(ministryID).OrderByDescending(e => e.DateCreated).Take(10); int memberID = Convert.ToInt16(System.Web.HttpContext.Current.Session["personID"]); ViewBag.IsMember = false; ministrymember mm = MinistryMemberRepository.GetMinistryMemberByID(ministryID, memberID); if (mm != null) { ViewBag.IsMember = true; } ViewBag.RecordCount = ListTable.Count(); GetData(ministryID); return(PartialView(ListTable)); }
public bool AddRecord(ministrymember Record) { myRecords.Add(record); return(true); }
public ministrymember GetMinistryMemberByID(int ministryID, int memberID) { record = context.ministrymembers.FirstOrDefault(e => e.ministryID == ministryID && e.memberID == memberID); return(record); }