public Member AddMember(Member member) { using (context = new DomainContext()) { context.Members.Add(member); context.SaveChanges(); } return member; }
public Member ConfirmRegistration(Member member) { using (context = new DomainContext()) { var memberIdVariable = "@memberId"; var tokenVariable = "@token"; var membershipDateVariable = "@membershipDate"; var command = string.Format("exec ConfirmRegistration {0}, {1}, {2}", memberIdVariable, tokenVariable, membershipDateVariable); var memberId = new SqlParameter(memberIdVariable, member.Id); var token = new SqlParameter(tokenVariable, member.Tokens.ElementAt(0).Token); var membershipDate = new SqlParameter(membershipDateVariable, member.MembershipDate); context.Database.ExecuteSqlCommand(command, memberId, token, membershipDate); } return member; }
public Member GetMember(string email) { Member member = null; using (context = new DomainContext()) { context.Configuration.LazyLoadingEnabled = false; var result = context.Members .Include("Security") .Include("Profile") .Where(m => string.Compare(m.Email, email, true) == 0) .FirstOrDefault(); if (result == null) { member = new Member(); member.Security = new MemberPassword(); } else { member = result; } } return member; }
public Member ReRegisterMember(Member member) { using (context = new DomainContext()) { var memberIdVariable = "@memberId"; var aliasVariable = "@alias"; var saltValueVariable = "@saltValue"; var passwordVariable = "@password"; var command = string.Format("exec ReRegisterMember {0}, {1}, {2}, {3}", memberIdVariable, aliasVariable, saltValueVariable, passwordVariable); var memberId = new SqlParameter(memberIdVariable, member.Id); var alias = new SqlParameter(aliasVariable, member.Profile.Alias); var saltValue = new SqlParameter(saltValueVariable, member.Security.SaltValue); var password = new SqlParameter(passwordVariable, member.Security.Password); context.Database.ExecuteSqlCommand(command, memberId, alias, saltValue, password); } return member; }
public Member GetMember(Guid token) { Member member = null; using (context = new DomainContext()) { context.Configuration.LazyLoadingEnabled = false; var result = context.MemberTokens .Include("Member") .Include("Profile") .Where(mt => mt.Token == token) .FirstOrDefault(); if (result == null) { member = new Member(); } else { member = result.Member; } } return member; }
public Member GetMember(int id) { Member member = null; using (context = new DomainContext()) { context.Configuration.LazyLoadingEnabled = false; var result = context.Members .Include("Security") .Include("Profile") .Where(m => m.Id == id) .FirstOrDefault(); if (result == null) { member = new Member(); } else { member = result; } } return member; }