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