public PersonPhone GetPersonPhoneById(int PhoneNumberTypeID, string PhoneNumber, int BusinessEntityID)
{
using (var dbcontext = new WebContextDB())
{
return(dbcontext.PersonPhones.FirstOrDefault(u => u.PhoneNumberTypeID == PhoneNumberTypeID && u.PhoneNumber == PhoneNumber && u.BusinessEntityID == BusinessEntityID));
}
}
public List <PersonPhone> GetPersonPhoneByPersonId(int id)
{
using (var dbcontext = new WebContextDB())
{
return(dbcontext.PersonPhones.Where(u => u.BusinessEntityID == id).ToList());
}
}
public Person GetPersonById(int id)
{
using (var dbcontext = new WebContextDB())
{
return(dbcontext.Persons.FirstOrDefault(u => u.BusinessEntityID == id));
}
}
public PhoneNumberType GetPhoneNumberTypeById(int id)
{
using (var dbcontext = new WebContextDB())
{
return(dbcontext.PhoneNumberTypes.FirstOrDefault(u => u.PhoneNumberTypeID == id));
}
}
public List <T> GetList()
{
using (var dbContext = new WebContextDB())
{
return(dbContext.Set <T>().ToList());
}
}
public Password GetPasswordById(int id)
{
using (var dbcontext = new WebContextDB())
{
return(dbcontext.Passwords.FirstOrDefault(u => u.BusinessEntityID == id));
}
}
public List <EmailAddress> GetEmailAddressByPersonId(int id)
{
using (var dbcontext = new WebContextDB())
{
return(dbcontext.EmailAddresses.Where(u => u.BusinessEntityID == id).ToList());
}
}
public EmailAddress GetEmailAddressById(int id)
{
using (var dbcontext = new WebContextDB())
{
return(dbcontext.EmailAddresses.FirstOrDefault(u => u.EmailAddressID == id));
}
}
public BusinessEntity GetBusinessEntityById(int id)
{
using (var dbcontext = new WebContextDB())
{
return(dbcontext.BusinessEntitys.FirstOrDefault(u => u.BusinessEntityID == id));
}
}
public int Add(T entity)
{
using (var dbContext = new WebContextDB())
{
dbContext.Entry(entity).State = EntityState.Added;
return(dbContext.SaveChanges());
}
}
public int AddBusinessentity(BusinessEntity entity)
{
int id;
using (var dbContext = new WebContextDB())
{
dbContext.Entry(entity).State = EntityState.Added;
dbContext.SaveChanges();
dbContext.Entry(entity).GetDatabaseValues();
return(id = entity.BusinessEntityID);
}
}
