public MemberEmailChange CreateEmailChange(MemberEmailChange memberEmailChange)
{
using (context = new DomainContext())
{
context.Configuration.LazyLoadingEnabled = false;
context.MemberEmailChanges.Add(memberEmailChange);
context.SaveChanges();
}
return memberEmailChange;
}
public MemberEmailChange UpdateEmailChange(MemberEmailChange memberEmailChange)
{
using (context = new DomainContext())
{
var memberIdVariable = "@memberId";
var emailVariable = "@email";
var command = string.Format("exec UpdateEmailChange {0}, {1}",
memberIdVariable,
emailVariable);
var memberId = new SqlParameter(memberIdVariable, memberEmailChange.MemberId);
var email = new SqlParameter(emailVariable, memberEmailChange.Email);
context.Database.ExecuteSqlCommand(command, memberId, email);
}
return memberEmailChange;
}
public MemberEmailChange GetMemberEmailChange(int memberId)
{
MemberEmailChange memberEmailChange;
using (context = new DomainContext())
{
var entity = context.MemberEmailChanges.SingleOrDefault(i => i.MemberId == memberId);
if (entity == null)
{
memberEmailChange = new MemberEmailChange();
}
else
{
memberEmailChange = entity;
}
}
return memberEmailChange;
}
