public void CreateMemberShip(int memberId) { var member = GetMemberById(memberId); if (member == null) return; using (SqlServerMembersDb Db = new SqlServerMembersDb(ConnectionString)) { var membership = new MemberShip(); Db.Memberships.Add(membership); Db.SaveChanges(); Db.Members.Attach(member); member.Membership = membership; Db.SaveChanges(); } }
public void SetMemberLocation(int memberId, decimal latitude, decimal longitude) { var member = GetMemberById(memberId); if (member == null) return; using (SqlServerMembersDb Db = new SqlServerMembersDb(ConnectionString)) { Db.Members.Attach(member); member.LastLongitude = longitude; member.LastLatitude = latitude; Db.Entry(member).Property("LastLongitude").IsModified = true; Db.Entry(member).Property("LastLatitude").IsModified = true; Db.SaveChanges(); } }
public int StoreMember(Member member) { using (SqlServerMembersDb Db = new SqlServerMembersDb(ConnectionString)) { Db.Members.Add(member); Db.SaveChanges(); } return member.MemberId; }