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