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());
}
