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();
}
}
}
