/// <summary> /// Gets all the members in the system /// </summary> public IList<Member> GetAllMembers(IWebsite website) { var db = new PetaPoco.Membership.Database("Portal"); List<Member> members = db.Fetch<Member, Profile, Member>(new MemberProfileRelator().MapIt, @"Select * From Membership.Members m Inner Join Membership.MemberWebsites w On m.MemberId = w.MemberId Inner Join Membership.Profiles p On m.ProfileId = p.ProfileId Where WebsiteId = @WebsiteId Order By Username", new { WebsiteId = website.Id }); return members; }
/// <summary> /// Get a specific member by there email /// </summary> /// <param name="email">the email of the member to return</param> public Member GetMemberByEmail(IWebsite website, string email) { var db = new PetaPoco.Membership.Database("Portal"); IList<Member> members = db.Fetch<Member, Profile, Member>(new MemberProfileRelator().MapIt, @"Select * From Membership.Members m Inner Join Membership.MemberWebsites w On m.MemberId = w.MemberId Inner Join Membership.Profiles p On m.ProfileId = p.ProfileId Where m.Email = @Email And WebsiteId = @WebsiteId", new { WebsiteId = website.Id, Email = email }); Member member = null; if (members.Count > 0) { member = members.First(); member.Roles = db.Fetch<Role>("Select * From Membership.Roles r Inner Join Membership.MemberRoles mr On r.RoleId = mr.RoleId Where mr.MemberId = @MemberId", new { MemberId = member.Id }); } return member; }
public Member SaveOrUpdate(Member member) { var db = new PetaPoco.Membership.Database("Portal"); if (member.Id == 0) { this.Save(member); } else { var memberObj = new { MemberId = member.Id, Email = member.Username, Password = member.PasswordHashed }; db.Save("Membership.Members", "MemberId", memberObj); var profile = new { FirstName = member.Profile.FirstName, LastName = member.Profile.LastName, Company = member.Profile.Company, Username = member.Profile.Email, Phone = member.Profile.Phone }; db.Save("Membership.Profiles", "ProfileId", profile); var delete = new { MemberId = member.Id }; db.Delete("Membership.MemberRoles", "MemberRoleId", delete); foreach (var role in member.Roles) { var roleObj = new { RoleId = role.Id, MemberId = member.Id }; db.Save("Membership.MemberRoles", "MemberRoleId", roleObj); } //db.Save("Membership.Members", "Id", member); } return member; }
public Member Save(Member member) { var db = new PetaPoco.Membership.Database("Portal"); db.Insert("Membership.Members", "MemberId", true, member); return member; }