public List <dynamic> getAllZoneHomecellAttFeedback() { ReviveCommunicationsDBEntities3 db = new ReviveCommunicationsDBEntities3(); // create database connection db.Configuration.ProxyCreationEnabled = false; // configure proxy to eliminate overload of memory return(getZoneHomecellAtt(db.Zone_Homecell_Attendance_Feedback.ToList())); // return called method }
//Group type list - Izaan public List <dynamic> getAllGroupTypesReturnList(List <Group_Type> allGroupTypes) { //Database connection ReviveCommunicationsDBEntities3 db = new ReviveCommunicationsDBEntities3(); //Configure proxy to eliminate memory overload db.Configuration.ProxyCreationEnabled = false; //Creating dynamic list List <dynamic> dynamicGroupTypes = new List <dynamic>(); try { foreach (Group_Type gType in allGroupTypes) { //Creating dynmaic object dynamic dynamicGroupType = new ExpandoObject(); dynamicGroupType.GroupTypeID = gType.GroupTypeID; dynamicGroupType.GroupTypeName = gType.GroupTypeName; //Adding dynamic object to dynamic lits dynamicGroupTypes.Add(dynamicGroupType); } } catch (Exception) { } return(dynamicGroupTypes); }
public void delAnnouncement([FromBody] dynamic announcement) { ReviveCommunicationsDBEntities3 db = new ReviveCommunicationsDBEntities3(); db.Configuration.ProxyCreationEnabled = false; int id = announcement.ann.AnnouncementID; List <Person_Announcement> thisAnn = db.Person_Announcement.Where(x => x.AnnouncementID == id).ToList(); try { foreach (Person_Announcement a in thisAnn) { db.Person_Announcement.Remove(a); } Announcement x = db.Announcements.Where(d => d.AnnouncementID == id).FirstOrDefault(); db.Announcements.Remove(x); Audit_Trail auditLog = new Audit_Trail(); auditLog.PersonID = announcement.PersonID; auditLog.EventDescription = "Removed announcement with ID: " + id; auditLog.EventDateTime = DateTime.Now; db.Audit_Trail.Add(auditLog); db.SaveChanges(); } catch (Exception e) { } }
public List <dynamic> GetCounsellingRequest() { ReviveCommunicationsDBEntities3 db = new ReviveCommunicationsDBEntities3(); db.Configuration.ProxyCreationEnabled = false; return(GetCounsellingRequestList(db.Counselling_Request.ToList())); }
public List <dynamic> getDiscipleshipList(List <Discipleship> allDiscipleships) { ReviveCommunicationsDBEntities3 db = new ReviveCommunicationsDBEntities3(); db.Configuration.ProxyCreationEnabled = false; List <dynamic> dynamicDiscipleships = new List <dynamic>(); //get dynamic object list try { foreach (Discipleship thisDiscipleship in allDiscipleships) { dynamic dynamicDiscipleship = new ExpandoObject(); dynamicDiscipleship.DiscipleshipID = thisDiscipleship.DiscipleshipID; dynamicDiscipleship.DiscipleshipDescription = thisDiscipleship.DiscipleshipDescription; dynamicDiscipleships.Add(dynamicDiscipleship); } } catch (Exception e) { } return(dynamicDiscipleships); }
public dynamic delDiscipleship([FromBody] dynamic currentDiscipleship) { ReviveCommunicationsDBEntities3 db = new ReviveCommunicationsDBEntities3(); db.Configuration.ProxyCreationEnabled = false; int id = currentDiscipleship.discipleship.DiscipleshipID; try { //retrieve selected Discipleship thisDiscipleship = db.Discipleships.Where(x => x.DiscipleshipID == id).FirstOrDefault(); Audit_Trail auditLog = new Audit_Trail(); auditLog.PersonID = currentDiscipleship.userID; auditLog.EventDescription = "Deleted a Discipleship with ID: " + thisDiscipleship.DiscipleshipID + " and Name: " + thisDiscipleship.DiscipleshipDescription; auditLog.EventDateTime = DateTime.Now; db.Audit_Trail.Add(auditLog); //remove from db db.Discipleships.Remove(thisDiscipleship); //save db.SaveChanges(); return(getAllDiscipleships()); } catch (Exception e) { //else error dynamic toReturn = new ExpandoObject(); toReturn.Error = e.Message; return(toReturn); } }
public dynamic removeHomecellNotes(dynamic HomecellNotesName) //get string parameter { ReviveCommunicationsDBEntities3 db = new ReviveCommunicationsDBEntities3(); //establish database connection db.Configuration.ProxyCreationEnabled = false; //configure proxy to eliminate overload of data try { string file = HomecellNotesName.FileName; //retrieve Homecell notes to remove based on selected Homecell notes Homecell_Notes HCNotes = db.Homecell_Notes.Where(z => z.HomecellNotes == file).FirstOrDefault(); db.Homecell_Notes.Remove(HCNotes); //Add to Audit trail entity Audit_Trail auditLog = new Audit_Trail(); auditLog.PersonID = HomecellNotesName.PersonID; auditLog.EventDescription = "Removed Homecell Notes with with ID: " + HCNotes.HCNID; auditLog.EventDateTime = DateTime.Now; db.Audit_Trail.Add(auditLog); db.SaveChanges(); } catch (Exception) { return(null); } return(getHomecellNotes()); }
public List <dynamic> getAllRequestsReturnList(List <Person> allrequests) { //Database conncection ReviveCommunicationsDBEntities3 db = new ReviveCommunicationsDBEntities3(); db.Configuration.ProxyCreationEnabled = false; List <dynamic> dynamicRequests = new List <dynamic>(); try { foreach (Person requests in personList) { dynamic dynamicPerson = new ExpandoObject(); dynamicPerson.Name = requests.Name; dynamicPerson.Surname = requests.Surname; dynamicPerson.PersonID = requests.PersonID; dynamicPerson.Activation_Status_ID = requests.Activation_Status_ID; dynamicRequests.Add(personList); } } catch (Exception e) { } return(dynamicRequests); }
public dynamic delOrgIndivPos([FromBody] dynamic currentOrgIndivPos) { ReviveCommunicationsDBEntities3 db = new ReviveCommunicationsDBEntities3(); db.Configuration.ProxyCreationEnabled = false; int id = currentOrgIndivPos.form.OrgIndivPosID; //retrieve selected object Organisational_Individual_Position thisOrgIndivPos = db.Organisational_Individual_Position.Where(x => x.OrgIndivPosID == id).FirstOrDefault(); //remove object db.Organisational_Individual_Position.Remove(thisOrgIndivPos); try { Audit_Trail auditLog = new Audit_Trail(); auditLog.PersonID = currentOrgIndivPos.PersonID; auditLog.EventDescription = "Removed Organisational Individual Structure Position with ID: " + id; auditLog.EventDateTime = DateTime.Now; db.Audit_Trail.Add(auditLog); db.SaveChanges(); //save return(getAllOrgIndivPos()); //return all } catch (Exception e) { //else return error dynamic toReturn = new ExpandoObject(); toReturn.Error = e.Message + e.InnerException; return(toReturn); } }
public List <dynamic> getAllOrgIndivPosList(List <Organisational_Individual_Position> allOrgIndivPos) { ReviveCommunicationsDBEntities3 db = new ReviveCommunicationsDBEntities3(); db.Configuration.ProxyCreationEnabled = false; List <dynamic> dynamicOrgIndivPosList = new List <dynamic>(); foreach (Organisational_Individual_Position thisOrgIndivPos in allOrgIndivPos) { dynamic dynamicOrgIndivPos = new ExpandoObject(); //create a dynamic object that contains all relevent attributes of OrgIndivPos dynamicOrgIndivPos.OrgIndivPosID = thisOrgIndivPos.OrgIndivPosID; dynamicOrgIndivPos.Decription = thisOrgIndivPos.Decription; dynamicOrgIndivPos.Goal_Access = db.Organisational_Individual_Position.Select(x => x.Goal_Access); dynamicOrgIndivPos.Use_Cases = db.Organisational_Individual_Position.Select(x => x.Use_Cases); dynamicOrgIndivPosList.Add(dynamicOrgIndivPos); // add dynamic object to list } return(dynamicOrgIndivPosList); //send back ot get All method }
public List <dynamic> getAuditTrail() { ReviveCommunicationsDBEntities3 db = new ReviveCommunicationsDBEntities3(); db.Configuration.ProxyCreationEnabled = false; // configure proxy to eliminate overload of memory List <dynamic> auditTrailList = new List <dynamic>(); foreach (Audit_Trail a in db.Audit_Trail.OrderByDescending(x => x.AuditTrailID)) { //get person details and Audit trail details dynamic AT = new ExpandoObject(); var person = db.People.Where(x => x.PersonID == a.PersonID).FirstOrDefault(); AT.Person = "[ID: " + person.PersonID + "] " + person.Name + " " + person.Surname; AT.EventDateTime = a.EventDateTime.ToString("yyyy-MM-dd HH:mm:ss"); AT.EventDescription = a.EventDescription; auditTrailList.Add(AT); } return(auditTrailList); }
//Sububrb List - Izaan public List <dynamic> getAllSuburbsList(List <Suburb> suburbList) { ReviveCommunicationsDBEntities3 db = new ReviveCommunicationsDBEntities3(); db.Configuration.ProxyCreationEnabled = false; List <dynamic> dynamicSuburbs = new List <dynamic>(); try { foreach (Suburb s in suburbList) { dynamic dynamicSuburb = new ExpandoObject(); dynamicSuburb.SuburbID = s.SuburbID; dynamicSuburb.SuburbName = s.SuburbName; dynamicSuburb.CityID = s.CityID; dynamicSuburbs.Add(dynamicSuburb); } } catch (Exception e) { } return(dynamicSuburbs); }
//Groups list - Izaan public List <dynamic> getAllGroupsReturnList(List <Organisational_Group> allGroups) { //Database connection ReviveCommunicationsDBEntities3 db = new ReviveCommunicationsDBEntities3(); db.Configuration.ProxyCreationEnabled = false; List <dynamic> dynamicGroups = new List <dynamic>(); try { foreach (Organisational_Group thisGroup in allGroups) { dynamic dynamicGroup = new ExpandoObject(); dynamicGroup.OrgGroupID = thisGroup.OrgGroupID; dynamicGroup.GroupTypeID = thisGroup.GroupTypeID; dynamicGroup.Description = thisGroup.Description; dynamicGroup.Size = thisGroup.Size; dynamicGroup.Address = thisGroup.Address; dynamicGroup.SuburbID = thisGroup.SuburbID; dynamicGroups.Add(dynamicGroup); } } catch (Exception e) { } return(dynamicGroups); }
public List <dynamic> getsignOutChildRequestConfirm() { //Database connection ReviveCommunicationsDBEntities3 db = new ReviveCommunicationsDBEntities3(); //Configure proxy to eliminate overload of data db.Configuration.ProxyCreationEnabled = false; List <dynamic> returnList = new List <dynamic>(); foreach (int request in signOutRequestList) { Person_Children personChild = db.Person_Children.Include(x => x.KidsChurch).Include(y => y.Child).Include(z => z.Person).Where(c => c.ChildID == request).FirstOrDefault(); returnList.Add(personChild); } if (returnList.Count() != 0) { return(getChildConfirmation(returnList)); } else { return(null); } }
public IHttpActionResult UpdatePerson(Person psn) { ReviveCommunicationsDBEntities3 db = new ReviveCommunicationsDBEntities3(); db.Configuration.ProxyCreationEnabled = false; if (!ModelState.IsValid) { return(BadRequest(ModelState)); } try { Person objEmp = new Person(); objEmp = db.People.Find(psn.PersonID); if (objEmp != null) { objEmp.Name = psn.Name; objEmp.Surname = psn.Surname; objEmp.Address = psn.Address; objEmp.Suburb = psn.Suburb; objEmp.City = psn.City; objEmp.Number = psn.Number; objEmp.Email = psn.Email; } db.SaveChanges(); } catch (Exception e) { toReturn.Error = e.Message; return(toReturn); } return(Ok(psn)); }
public List <dynamic> getAllChildrenReturnList(List <Child> allChildren) { //Database connection ReviveCommunicationsDBEntities3 db = new ReviveCommunicationsDBEntities3(); //Configure proxy to eliminatate memory overload db.Configuration.ProxyCreationEnabled = false; //Create dynamic list to be returned with all the children in the list in JSON format List <dynamic> dynamicChildren = new List <dynamic>(); try { //Loop through each child in the list foreach (Child thisChild in allChildren) { //create dynamic objecct to be added to the dynamic list to be returned dynamic dynamicChild = new ExpandoObject(); dynamicChild.ChildID = thisChild.ChildID; dynamicChild.Name = thisChild.Name; dynamicChild.Surname = thisChild.Surname; dynamicChild.DateOfBirth = thisChild.DateOfBirth; dynamicChildren.Add(dynamicChild); } } catch (Exception e) { } return(dynamicChildren); }
public List <dynamic> getAllChildren() { //Database connection ReviveCommunicationsDBEntities3 db = new ReviveCommunicationsDBEntities3(); //Configure proxy to eliminatate memory overload db.Configuration.ProxyCreationEnabled = false; // !!--User Management--!! //string sessionId = Request.Headers.Authorization.ToString(); //var user = db.Where(o => o.SessionID == sessionId).FirstOrDefault(); //if(user != null) try { //Return list of all children return(getAllChildrenReturnList(db.Children.ToList())); } catch (Exception e) { //Creating dynamic object to be returned with error message dynamic toReturn = new ExpandoObject(); toReturn.Error = e; return(toReturn); } }
public dynamic getChildByID(int ID) { ReviveCommunicationsDBEntities3 db = new ReviveCommunicationsDBEntities3(); db.Configuration.ProxyCreationEnabled = false; if (ID == null) { return(null); } else { Child thisChild = db.Children.Where(x => x.ChildID == ID).FirstOrDefault(); Person_Children pc = db.Person_Children.Where(x => x.ChildID == thisChild.ChildID).FirstOrDefault(); dynamic child = new ExpandoObject(); child.Name = thisChild.Name; child.Surname = thisChild.Surname; child.DateOfBirth = thisChild.DateOfBirth; child.KidsChurchID = pc.KidsChurch.KidsChurchID; return(child); } }
public List<dynamic> getAllMembersReturnList(List<Person> allPeople) { //Database conncection ReviveCommunicationsDBEntities3 db = new ReviveCommunicationsDBEntities3(); //Configure proxy to eliminate overload of data db.Configuration.ProxyCreationEnabled = false; List<dynamic> dynamicPeople = new List<dynamic>(); try { foreach (Person person in allPeople) { dynamic dynamicPerson = new ExpandoObject(); dynamicPerson.PersonID = person.PersonID; dynamicPerson.Name = person.Name; dynamicPerson.Surname = person.Surname; dynamicPerson.DateOfBirth = person.DateOfBirth; dynamicPerson.Number = person.Number; dynamicPerson.Email = person.Email; dynamicPerson.Address = person.Address; dynamicPerson.Activation_Status = person.Activation_Status_ID; dynamicPeople.Add(dynamicPerson); } } catch (Exception e) { } return dynamicPeople; }
private List <dynamic> getAllPersonChildren(Child child) { ReviveCommunicationsDBEntities3 db = new ReviveCommunicationsDBEntities3(); db.Configuration.ProxyCreationEnabled = false; List <dynamic> dynamicChildren = new List <dynamic>(); try { foreach (Person_Children personChild in child.Person_Children) { dynamic dynamicPersonChild = new ExpandoObject(); dynamicPersonChild.KidsChurchID = personChild.KidsChurchID; dynamicPersonChild.KidsChurchName = db.KidsChurches.Where(x => x.KidsChurchID == personChild.KidsChurchID).Select(o => o.KidsChurchName).FirstOrDefault(); dynamicPersonChild.PersonID = personChild.PersonID; dynamicPersonChild.ChildID = personChild.ChildID; dynamicPersonChild.KCVolunteerConfirmation = personChild.KCVolunteerConfirmation; dynamicPersonChild.CheckIn = personChild.CheckIn; dynamicPersonChild.ChekcInDateTime = personChild.CheckInDateTime; dynamicPersonChild.SignOut = personChild.SignOut; dynamicPersonChild.SignOutDateTime = personChild.SignOutDateTime; dynamicChildren.Add(dynamicPersonChild); } } catch (Exception e) { } return(dynamicChildren); }
public List<dynamic> MemberList(List<Person> person) { //Database connection ReviveCommunicationsDBEntities3 db = new ReviveCommunicationsDBEntities3(); //Configure proxy to eliminate memory overload db.Configuration.ProxyCreationEnabled = false; List<dynamic> dynamicMember = new List<dynamic>(); try { foreach (Person mem in person) { dynamic dynamicOrgPosition = new ExpandoObject(); dynamicOrgPosition.OrgStructID = mem.OrgStructID; dynamicOrgPosition.AssignLeader = mem.AssignLeader; dynamicOrgPosition.PersonID = mem.PersonID; dynamicOrgPosition.Name = mem.Name; dynamicOrgPosition.Surname = mem.Surname; dynamicMember.Add(dynamicOrgPosition); } } catch (Exception e) { } return dynamicMember; }
public List<dynamic> getUnassignedLeaderList(List<Person> structPosition) { //Database connection ReviveCommunicationsDBEntities3 db = new ReviveCommunicationsDBEntities3(); //Configure proxy to eliminate memory overload db.Configuration.ProxyCreationEnabled = false; List<dynamic> dynamicOrgStructurePositions = new List<dynamic>(); try { foreach (Person structpos in structPosition) { Organisational_Structure_Position orgStruct = db.Organisational_Structure_Position.Include(x => x.Organisational_Individual_Position).Where(z => z.OrgStructID == structpos.OrgStructID).FirstOrDefault(); dynamic dynamicOrgPos = new ExpandoObject(); dynamicOrgPos.OrgStructID = structpos.OrgStructID; dynamicOrgPos.Description = orgStruct.Organisational_Individual_Position.Decription; dynamicOrgPos.PersonID = structpos.PersonID; dynamicOrgPos.Name = structpos.Name; dynamicOrgPos.Surname = structpos.Surname; dynamicOrgStructurePositions.Add(dynamicOrgPos); } } catch (Exception e) { } return dynamicOrgStructurePositions; }
public List <dynamic> GetGroupTypes() { ReviveCommunicationsDBEntities3 db = new ReviveCommunicationsDBEntities3(); db.Configuration.ProxyCreationEnabled = false; return(GetGroupTypeList(db.Group_Type.ToList())); }
public dynamic getApprovalProgress() { //Database connection ReviveCommunicationsDBEntities3 db = new ReviveCommunicationsDBEntities3(); //Configure proxy to eliminate overload of data db.Configuration.ProxyCreationEnabled = false; //Create dynamic object dynamic ApprovalProgress = new ExpandoObject(); try { List<Person> RemainingApprovals = db.People.Where(z => z.Activation_Status_ID == 4).ToList(); List<Person> CompletedApprovals = db.People.Where(z => z.Activation_Status_ID == 1).ToList(); //Count database records int remaining = RemainingApprovals.Count; int completed = CompletedApprovals.Count; //Add list and perform remaining calculations ApprovalProgress.Remaining = remaining; ApprovalProgress.Completed = completed; } catch (Exception e) { return e; } return ApprovalProgress; }
public List <dynamic> PersonGroup(List <Organisational_Structure_Position> allgroups) { //Database conncection ReviveCommunicationsDBEntities3 db = new ReviveCommunicationsDBEntities3(); db.Configuration.ProxyCreationEnabled = false; List <dynamic> dynamicPersonGroups = new List <dynamic>(); try { foreach (Organisational_Structure_Position stuctureposition in allgroups) { dynamic dynamicPersonGroup = new ExpandoObject(); dynamicPersonGroup.OrgStructID = stuctureposition.OrgStructID; dynamicPersonGroup.OrgStructLevel = stuctureposition.OrgStructLevel; dynamicPersonGroup.Description = stuctureposition.Description; dynamicPersonGroup.OrgStructTypeID = stuctureposition.OrgStructTypeID; dynamicPersonGroup.OrgIndivPosId = stuctureposition.OrgIndivPosID; dynamicPersonGroup.OrgStructIDReportsTo = stuctureposition.OrgStructIDReportsTo; dynamicPersonGroups.Add(dynamicPersonGroup); } } catch (Exception e) { } return(dynamicPersonGroups); }
public List <dynamic> MemberByID(int personId) { ReviveCommunicationsDBEntities3 db = new ReviveCommunicationsDBEntities3(); //establish database connection db.Configuration.ProxyCreationEnabled = false; //configure proxy to eliminate overload of data return(getUnassignedMemberList(db.People.Where(z => z.PersonID == personId).ToList())); // return called method }
public List <dynamic> MemberGroups(int personId) { //Database connection ReviveCommunicationsDBEntities3 db = new ReviveCommunicationsDBEntities3(); db.Configuration.ProxyCreationEnabled = false; List <dynamic> dynamicMemberGroupList = new List <dynamic>(); //Group_Type getHomecellTypeID = db.Group_Type.Where(z => z.GroupTypeName == "Homecell").FirstOrDefault(); List <Persons_Group> memberGroup = db.Persons_Group.Include(z => z.Organisational_Group).Where(z => z.PersonID == personId).ToList(); foreach (Persons_Group group in memberGroup) { dynamic dynamicMemberGroups = new ExpandoObject(); dynamicMemberGroups.PersonGroup = group.PersonGroupID; dynamicMemberGroups.Group = group.ServeGroups; dynamicMemberGroups.GroupName = group.Organisational_Group.Description; dynamicMemberGroupList.Add(dynamicMemberGroups); } if (dynamicMemberGroupList.Count != 0) { return(dynamicMemberGroupList); } else { return(null); } }
public List <dynamic> getChurchesReturnList(List <Church_Banking_Details> allChurches) { //Connection to database ReviveCommunicationsDBEntities3 db = new ReviveCommunicationsDBEntities3(); db.Configuration.ProxyCreationEnabled = false; //Creating a dynamic list of the churches List <dynamic> dynamicChurches = new List <dynamic>(); foreach (Church_Banking_Details thisChurch in allChurches) { //creating a dynamic object of the churches dynamic dynamicChurch = new ExpandoObject(); //Retrieve all the church information from the Church_Banking_Details table and saving the info as a dynamic object dynamicChurch.ChurchBankID = thisChurch.ChurchBankID; dynamicChurch.ChurchName = thisChurch.ChurchName; /*dynamicChurch.Bank = thisChurch.Bank; * dynamicChurch.AccountName = thisChurch.AccountName; * dynamicChurch.AccountNumber = thisChurch.AccountNumber; * dynamicChurch.BranchCode = thisChurch.BranchCode; * dynamicChurch.Reference = thisChurch.Reference;*/ //Adding the dynmic object to the dynamic list to be returned dynamicChurches.Add(dynamicChurch); } return(dynamicChurches); }
public List <dynamic> checkInChild([FromBody] dynamic confirmationCheckIn) //get JSON parameter { //validate that there is no null values if (confirmationCheckIn != null) { ReviveCommunicationsDBEntities3 db = new ReviveCommunicationsDBEntities3(); //establish database connection db.Configuration.ProxyCreationEnabled = false; //configure proxy to eliminate overload of data try { foreach (var child in confirmationCheckIn.child) { int id = child; Person_Children childCheckIn = db.Person_Children.Include(x => x.Person).Include(z => z.Child).Where(x => x.ChildID == id).FirstOrDefault(); childCheckIn.KCVolunteerConfirmation = true; childCheckIn.CheckIn = true; childCheckIn.SignOut = false; childCheckIn.CheckInDateTime = DateTime.Now; Audit_Trail auditLog = new Audit_Trail(); auditLog.PersonID = confirmationCheckIn.PersonID; auditLog.EventDescription = "Checked in child with ID: " + id; auditLog.EventDateTime = DateTime.Now; db.Audit_Trail.Add(auditLog); db.SaveChanges(); //Save nchanges and Add new position // return called method childrenList += childCheckIn.Child.Name + " " + childCheckIn.Child.Surname + ", "; toName = childCheckIn.Person.Name; toMember = childCheckIn.Person.Email; } message = childrenList + " Has been successfully checked-in of Kids Church at Christian Revival Church (CRC) Main."; Emailsubject = "Kids Church Sign-out @ CRC"; sendEmail(); foreach (var child in confirmationCheckIn.child) { checkInRequestsList.Remove(child); } if (checkInRequestsList.Count() == 0) { return(getChilConfirmation(checkInRequestsList)); } else { return(null); } } catch (Exception) { return(null); } } else { return(null); } }
public List <dynamic> getAllCountries() { ReviveCommunicationsDBEntities3 db = new ReviveCommunicationsDBEntities3(); db.Configuration.ProxyCreationEnabled = false; return(getAllCountries(db.Countries.ToList())); }