public void DeleteMember(BusinessObjects.Member member)
{
var entity = Mapper.Map <BusinessObjects.Member, Member>(member);
using (var context = DataContextFactory.CreateContext())
{
context.Members.Attach(entity, false);
context.Members.DeleteOnSubmit(entity);
context.SubmitChanges();
}
}
public void InsertMember(BusinessObjects.Member member)
{
var entity = Mapper.Map <BusinessObjects.Member, Member>(member);
using (var context = DataContextFactory.CreateContext())
{
context.Members.InsertOnSubmit(entity);
context.SubmitChanges();
// update business object with new id
member.MemberId = entity.MemberId;
}
}
public void UpdateMember(BusinessObjects.Member member)
{
var entity = Mapper.Map <BusinessObjects.Member, Member>(member);
using (var context = DataContextFactory.CreateContext())
{
var original = context.Members.SingleOrDefault(m => m.MemberId == member.MemberId);
original.Email = member.Email;
original.CompanyName = member.CompanyName;
original.Country = member.Country;
original.City = member.City;
context.SubmitChanges();
}
}
