public string GetDisplayName(int subCategoryID) { subcategory s = myRecords.FirstOrDefault(e => e.subCategoryID == subCategoryID); using (churchdatabaseEntities context = new churchdatabaseEntities()) { subcategoryitem item = context.subcategoryitems.FirstOrDefault(e => e.ChildCategoryID == s.subCategoryID); if (item != null) { subcategory child = myRecords.FirstOrDefault(e => e.subCategoryID == item.ChildCategoryID); subcategory parent = myRecords.FirstOrDefault(e => e.subCategoryID == item.ParentCategoryID); if (parent.ShortTitle == "") { s.DisplayName = string.Format("{0}-{1}", parent.SubCategoryName, child.SubCategoryName); } else { s.DisplayName = string.Format("{0}-{1}", parent.ShortTitle, child.SubCategoryName); } } else { //s.DisplayName = s.SubCategoryName; if (s.ShortTitle != "") { s.DisplayName = string.Format("{0}-{1}", s.ShortTitle, s.SubCategoryName); } else { s.DisplayName = s.SubCategoryName; } } } return(s.DisplayName); }
public member GetMemberByID(int memberID) { using (churchdatabaseEntities context = new churchdatabaseEntities()) { record = myRecords.FirstOrDefault(e => e.memberID == memberID); } return(record); }
public ministry GetParentMinistryByID(int ministryID) { using (churchdatabaseEntities context = new churchdatabaseEntities()) { record = myGroupRecords.FirstOrDefault(e => e.ministryID == ministryID); } return(record); }
public IEnumerable <income> GetIncomeChildren(int categoryID, DateTime bDate, DateTime eDate) { using (churchdatabaseEntities context = new churchdatabaseEntities()) { IEnumerable <subcategoryitem> children = context.subcategoryitems.Where(e => e.ParentCategoryID == categoryID).ToList(); if (children.Count() > 0) { foreach (var child in children) { parent = null; using (churchdatabaseEntities context2 = new churchdatabaseEntities()) { int i = context2.subcategoryitems.Where(e => e.ParentCategoryID == child.ChildCategoryID).Count(); if (i == 0) { var income = GetIncomeByCategory(child.ChildCategoryID, bDate, eDate); if (income.Count() > 0) { if (IncomeList.Count() == 0) { IncomeList = income.ToList(); } else { IncomeList.AddRange(income); } } } else { var extraChildren = context2.subcategoryitems.Where(e => e.ParentCategoryID == child.ChildCategoryID); foreach (var item in extraChildren) { MoreSubcategoryChildren.Add(item); //store all subcategory with children } } } } if (MoreSubcategoryChildren == null) { return(IncomeList); } var MoreSubcategoryChildren2 = MoreSubcategoryChildren; MoreSubcategoryChildren = null; foreach (var child2 in MoreSubcategoryChildren2) { GetIncomeChildren(child2.ChildCategoryID, bDate, eDate); //re-iterate subcategory with children } } else { var income = GetIncomeByCategory(categoryID, bDate, eDate); IncomeList.AddRange(income); } } return(IncomeList.OrderBy(e => e.subCategoryID).ThenBy(e => e.IncomeDate)); }
public IEnumerable <subcategoryitem> GetSubCategoryChildren(int subcategoryID) { IList <subcategoryitem> mylist; using (churchdatabaseEntities context = new churchdatabaseEntities()) { mylist = context.subcategoryitems.Where(e => e.ParentCategoryID == subcategoryID).ToList(); } return(mylist.ToList()); }
public IEnumerable <expense> GetExpenseByCategory(int categoryID, DateTime bDate, DateTime eDate) { IList <expense> mylist; using (churchdatabaseEntities context = new churchdatabaseEntities()) { mylist = myRecords.Where(e => e.subCategoryID == categoryID && e.ExpenseDate >= bDate.Date && e.ExpenseDate <= eDate.Date).ToList(); } return(mylist.ToList()); }
public void DeleteRecord(responsibility record) { using (churchdatabaseEntities context = new churchdatabaseEntities()) { // myRecords.Remove(record); responsibility aRecord = context.responsibilities.FirstOrDefault(e => e.responsibilityID == record.responsibilityID); context.responsibilities.Remove(aRecord); context.SaveChanges(); } }
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 void DeleteRecord(childparent record) { using (churchdatabaseEntities context = new churchdatabaseEntities()) { // myRecords.Remove(record); childparent aRecord = context.childparents.FirstOrDefault(e => e.ChildParentID == record.ChildParentID); context.childparents.Remove(aRecord); context.SaveChanges(); } }
public ActionResult UpdateVisitorProfile(int VisitorID = 0) { GetData(); visitor visitor; using (churchdatabaseEntities db = new churchdatabaseEntities()) { visitor = db.visitors.SingleOrDefault(e => e.visitorID == VisitorID); ViewBag.Heading = string.Format("Name: {0}", visitor.FullName); } return(PartialView(visitor)); }
private DateTime GetPayeeLastPayment(int subCategoryID) { var aDate = DateTime.Today; using (churchdatabaseEntities context = new churchdatabaseEntities()) { if (context.expenses.Where(e => e.subCategoryID == subCategoryID).Count() == 0) { return(aDate); } else { aDate = context.expenses.Where(e => e.subCategoryID == subCategoryID).OrderByDescending(e => e.ExpenseDate).Take(1).SingleOrDefault().ExpenseDate; } } return(aDate); }
public IEnumerable <member> GetChildParent(int childID) { using (churchdatabaseEntities context = new churchdatabaseEntities()) { var mylist = from p in context.members.Where(e => e.Status == "Active") join c in context.childparents.Where(e => e.ChildID == childID) on p.memberID equals c.ParentID select p; if (mylist.Any() == false) { return(null); } else { return(mylist); } } }
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()); }