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 object PersonDetails(dynamic sess)
{
string SessionID = sess.SessionID;
Person person = db.People.Where(zz => zz.SessionID == SessionID).FirstOrDefault();
if (person != null)
{
Organisational_Structure_Position orgStruct = db.Organisational_Structure_Position.Include(x => x.Organisational_Individual_Position).Where(z => z.OrgStructID == person.OrgStructID).FirstOrDefault();
dynamic Person = new ExpandoObject();
Person.PersonID = person.PersonID;
Person.Name = person.Name;
Person.Surname = person.Surname;
Person.DateOfBirth = person.DateOfBirth;
Person.Number = person.Number;
Person.Email = person.Email;
Person.Address = person.Address;
Person.City = person.City;
Person.Suburb = person.Suburb;
Person.OrgIndivPosID = orgStruct.Organisational_Individual_Position.OrgIndivPosID;
Person.OrgIndivPos = orgStruct.Organisational_Individual_Position.Decription;
Person.OrgStructID = person.OrgStructID;
Person.Assignleader = person.AssignLeader;
person.Password = "******";
return(Person);
}
else
{
dynamic toReturn = new ExpandoObject();
toReturn.Error = "Invalid token!";
return(toReturn);
}
}
public List <dynamic> getUnassignedMemberList(List <Person> memberList)
{
//Database connection
ReviveCommunicationsDBEntities3 db = new ReviveCommunicationsDBEntities3();
//Configure proxy to eliminate memory overload
db.Configuration.ProxyCreationEnabled = false;
List <dynamic> dynamicUnassignedMemberList = new List <dynamic>();
try
{
if (memberList.Count > 0)
{
foreach (Person member in memberList)
{
dynamic dynamicMember = new ExpandoObject();
dynamicMember.PersonID = member.PersonID;
dynamicMember.Name = member.Name;
dynamicMember.Surname = member.Surname;
dynamicMember.Address = member.Address;
dynamicMember.Suburb = member.Suburb;
dynamicMember.City = member.City;
dynamicMember.OrgStructID = member.OrgStructID;
if (member.OrgStructID == null)
{
dynamicMember.OrgStructPosition = "None";
}
else
{
Organisational_Structure_Position personPosition = db.Organisational_Structure_Position.Where(z => z.OrgStructID == member.OrgStructID).FirstOrDefault();
dynamicMember.OrgStructPosition = personPosition.Description;
}
dynamicUnassignedMemberList.Add(dynamicMember);
}
}
else
{
return(null);
}
}
catch (Exception)
{
return(null);
}
return(dynamicUnassignedMemberList);
}
