public bool UpdatePersonStatus(PersonReport personDetails)
{
bool isUpdated = false;
try
{
using (EVO_PersonDBEntities context = new EVO_PersonDBEntities())
{
Person person = (from P in context.Person
where P.ID == personDetails.PersonID
select P).FirstOrDefault();
if (person != null)
{
person.IsActive = personDetails.IsActive;
context.SaveChanges();
isUpdated = true;
}
}
}
catch (Exception ex)
{
throw;
}
return(isUpdated);
}
public bool UpdatePersonContact(PersonContact contact)
{
bool isUpdated = false;
try
{
using (EVO_PersonDBEntities context = new EVO_PersonDBEntities())
{
PersonContact personContact = (from PC in context.PersonContacts
where PC.PersonID == contact.PersonID
select PC).FirstOrDefault();
if (personContact != null)
{
personContact.EmailAddress = contact.EmailAddress;
personContact.PrimaryContactNo = contact.PrimaryContactNo;
context.SaveChanges();
isUpdated = true;
}
}
}
catch (Exception ex)
{
throw;
}
return(isUpdated);
}
public bool AddPersonContact(PersonContact contactDetails)
{
bool isAdded = false;
PersonContact personContact = null;
try
{
using (EVO_PersonDBEntities context = new EVO_PersonDBEntities())
{
personContact = new PersonContact();
personContact.PersonID = contactDetails.PersonID;
personContact.EmailAddress = contactDetails.EmailAddress;
personContact.PrimaryContactNo = contactDetails.PrimaryContactNo;
personContact.CreatedBy = 0;
personContact.ModifiedBy = 0;
personContact.CreatedDate = DateTime.UtcNow;
personContact.ModifiedDate = DateTime.UtcNow;
context.PersonContacts.Add(personContact);
context.SaveChanges();
isAdded = true;
}
}
catch (Exception ex)
{
throw;
}
return(isAdded);
}
public bool UpdatePerson(PersonReport personDetails)
{
bool isUpdated = false;
PersonContact personContact = null;
try
{
using (EVO_PersonDBEntities context = new EVO_PersonDBEntities())
{
Person person = (from P in context.Person
where P.ID == personDetails.PersonID
select P).FirstOrDefault();
if (person != null)
{
person.FirstName = personDetails.FirstName;
person.LastName = personDetails.LastName;
person.Gender = personDetails.Gender;
// person.DateOfBirth = personDetails.DateOfBirth;
personDetails.IsActive = personDetails.IsActive;
context.SaveChanges();
personContact = new PersonContact();
personContact.PersonID = person.ID;
personContact.EmailAddress = personDetails.EmailAddress;
personContact.PrimaryContactNo = personDetails.PhoneNumber;
UpdatePersonContact(personContact);
isUpdated = true;
}
}
}
catch (Exception ex)
{
throw;
}
return(isUpdated);
}
public bool AddPerson(PersonReport personDetails)
{
bool isAdded = false;
Person person = null;
PersonContact personContact = null;
try
{
using (EVO_PersonDBEntities context = new EVO_PersonDBEntities())
{
person = new Person();
person.FirstName = personDetails.FirstName;
person.LastName = personDetails.LastName;
person.Gender = personDetails.Gender;
// person.DateOfBirth = personDetails.DateOfBirth;
person.IsActive = personDetails.IsActive;
person.CreatedBy = 0;
person.ModifiedBy = 0;
person.CreatedDate = DateTime.UtcNow;
person.ModifiedDate = DateTime.UtcNow;
context.Person.Add(person);
context.SaveChanges();
personContact = new PersonContact();
personContact.PersonID = person.ID;
personContact.EmailAddress = personDetails.EmailAddress;
personContact.PrimaryContactNo = personDetails.PhoneNumber;
AddPersonContact(personContact);
isAdded = true;
}
}
catch (Exception ex)
{
throw;
}
return(isAdded);
}
public JObject ListPerson(Criteria criteria)
{
JObject listPerson = null;
try
{
listPerson = new JObject();
using (EVO_PersonDBEntities context = new EVO_PersonDBEntities())
{
var list = (from P in context.Person
join C in context.PersonContacts on P.ID equals C.PersonID
where ((criteria.PersonID == 0) || (criteria.PersonID > 0 && P.ID == criteria.PersonID))
//where ((Helper.IsNullOrEmpty(criteria.EmailAddress) == true) || (C.EmailAddress.Contains(criteria.EmailAddress)))
//where ((Helper.IsNullOrEmpty(criteria.PhoneNumber) == true) || (C.PrimaryContactNo.Contains(criteria.PhoneNumber)))
//where ((Helper.IsNullOrEmpty(Convert.ToString(criteria.Status)) == true) || (P.IsActive == criteria.Status))
select new
{
PersonID = P.ID,
FirstName = P.FirstName,
LastName = P.LastName,
Gender = P.Gender,
// DateOfBirth = P.DateOfBirth,
EmailAddress = C.EmailAddress,
PhoneNumber = C.PrimaryContactNo,
IsActive = P.IsActive
}).ToList();
listPerson.Add("Person", JArray.FromObject(list));
}
}
catch (Exception ex)
{
throw;
}
return(listPerson);
}
