public int PostPerson(VW_Person person)
{
BergerEntities userEntities = new BergerEntities();
userEntities.People.Add(GetPerson(person));
userEntities.SaveChanges();
return(person.BusinessEntityID);
}
/// <summary>
/// This method will return the all user in the system irrespective of the customer type.
/// </summary>
/// <returns>IEnumerable<VW_Person></returns>
public IEnumerable <VW_Person> GetPersonDetails()
{
BergerEntities ecommerceEntities = new BergerEntities();
var allUsers = from user in ecommerceEntities.VW_Person.AsEnumerable()
select user;
return(allUsers);
}
public int PostEmailAddress(VW_Person person)
{
BergerEntities userEntities = new BergerEntities();
userEntities.EmailAddresses.Add(GetEmailAddress(person));
userEntities.SaveChanges();
return(person.BusinessEntityID);
}
public BusinessEntity GetBusinessEntity(int businessEntityID)
{
BergerEntities userEntities = new BergerEntities();
BusinessEntity businessEntities = (from businessEntity in userEntities.BusinessEntities
where businessEntity.BusinessEntityID.Equals(businessEntityID)
select businessEntity).First();
return(businessEntities);
}
public int GetContactTypes(string contactTypeName)
{
BergerEntities userEntities = new BergerEntities();
int ContactTypeID = (from contactType in userEntities.ContactTypes
where contactType.Name.Equals(contactTypeName)
select contactType.ContactTypeID).First();
return(ContactTypeID);
}
/// <summary>
/// This method will return the user details based on Business Entity ID.
/// </summary>
/// <param name="BusinessEntityID">Business Entity ID</param>
/// <returns>IEnumerable<VW_Person></returns>
public IEnumerable <VW_Person> GetPersonDetails(int BusinessEntityID)
{
BergerEntities userEntities = new BergerEntities();
IEnumerable <VW_Person> person = (IEnumerable <VW_Person>)(from user in userEntities.VW_Person.AsEnumerable()
where user.BusinessEntityID.Equals(BusinessEntityID)
select user);
yield return(person.FirstOrDefault());
}
public int PostBusinessEntity(string contactTypeName)
{
BergerEntities userEntities = new BergerEntities();
BusinessEntity businessEntity = new BusinessEntity();
businessEntity.ContactTypeID = GetContactTypes(contactTypeName);
businessEntity.ModifiedDate = DateTime.Today;
businessEntity = userEntities.BusinessEntities.Add(businessEntity);
userEntities.SaveChanges();
return(businessEntity.BusinessEntityID);
}
