public bool PersonUpdate(Person person)
{
return Execute<bool>(dal =>
{
Person personUpdate = dal.Person.Where(x => x.BusinessEntityID == person.BusinessEntityID).FirstOrDefault();
if (personUpdate != null)
{
personUpdate.BusinessEntityID = person.BusinessEntityID;
personUpdate.PersonType = person.PersonType;
personUpdate.NameStyle = person.NameStyle;
personUpdate.Title = person.Title;
personUpdate.FirstName = person.FirstName;
personUpdate.MiddleName = person.MiddleName;
personUpdate.LastName = person.LastName;
personUpdate.Suffix = person.Suffix;
personUpdate.EmailPromotion = person.EmailPromotion;
personUpdate.AdditionalContactInfo = person.AdditionalContactInfo;
personUpdate.Demographics = person.Demographics;
personUpdate.rowguid = person.rowguid;
personUpdate.ModifiedDate = person.ModifiedDate;
dal.SubmitChanges();
return true;
}
return false;
});
}
public bool PersonDelete(Person person)
{
return Execute<bool>(dal =>
{
Person personDelete = dal.Person.Where(x => x.BusinessEntityID == person.BusinessEntityID).FirstOrDefault();
if (personDelete != null)
{
dal.Person.DeleteOnSubmit(personDelete);
dal.SubmitChanges();
return true;
}
return false;
});
}
public bool PersonAdd(Person person)
{
return Execute<bool>(dal =>
{
Person personAdd = dal.Person.Where(x => x.BusinessEntityID == person.BusinessEntityID).FirstOrDefault();
if (personAdd == null)
{
var personToAdd = dal.Person.OrderByDescending(x => x.BusinessEntityID).FirstOrDefault();
person.BusinessEntityID = personToAdd.BusinessEntityID + 1;
person.rowguid = Guid.NewGuid();
person.Demographics = personToAdd.Demographics;
person.ModifiedDate = DateTime.Now;
dal.Person.InsertOnSubmit(person);
dal.SubmitChanges();
return true;
}
return false;
});
}
partial void DeletePerson(Person instance);
partial void UpdatePerson(Person instance);
partial void InsertPerson(Person instance);
public void PersonUpdate(Person person)
{
adventureWorks_BC.PersonUpdate(person);
}
public void PersonDelete(Person person)
{
adventureWorks_BC.PersonDelete(person);
}
public void PersonAdd(Person person)
{
adventureWorks_BC.PersonAdd(person);
}
