public int StoreMember(Member member) { using (SqlServerMembersDb Db = new SqlServerMembersDb(ConnectionString)) { Db.Members.Add(member); Db.SaveChanges(); } return member.MemberId; }
public Member GetMemberById(int memberId) { using (SqlServerMembersDb Db = new SqlServerMembersDb(ConnectionString)) { return Db.Members.Where(m => m.MemberId == memberId) .Include(m => m.Membership) .FirstOrDefault(); } }
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 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 SqlServerMembersData(String connectionString) { if (connectionString == null) throw new ArgumentNullException("connectionString"); ConnectionString = connectionString; using (SqlServerMembersDb Db = new SqlServerMembersDb(ConnectionString)) { if (!Db.Database.Exists() || !Db.Database.CompatibleWithModel(true)) { Db.Database.Delete(); Db.Database.Create(); } } }