public void Create(UserTeam userTeam) { userTeam.Created = DateTime.Now; userTeam.Modified = DateTime.Now; //using (var db = new DocumentStore() { Url = ConfigurationManager.AppSettings["dbUrl"], DefaultDatabase = ConfigurationManager.AppSettings["defaultDb"] }) //{ // db.Initialize(); // using (var session = db.OpenSession()) // { // session.Store(userTeam); // session.SaveChanges(); // } //} using (var db = new Pb.Dal.EfEntities()) { var insertme = new Pb.Dal.UserTeam() { Id = userTeam.Id == Guid.Empty ? Guid.NewGuid() : userTeam.Id, UserId = userTeam.UserId, TeamId = userTeam.TeamId, Created = userTeam.Created, Modified = userTeam.Modified, Deleted = userTeam.Deleted, Default = userTeam.Default }; db.UserTeams.Add(insertme); db.SaveChanges(); } }
public void Delete(Guid userId, Guid teamId) { var id = IdByUserAndTeam(userId, teamId); var efUserTeam = new Pb.Dal.UserTeam() { Id = id, Deleted = true }; using (var db = new Pb.Dal.EfEntities()) { db.UserTeams.Attach(efUserTeam); db.Entry(efUserTeam).Property(x => x.Deleted).IsModified = true; db.SaveChanges(); } }
public void DeleteByUserTeamId(Guid userTeamId) { using (var db = new Pb.Dal.EfEntities()) { var efUserTeam = new Pb.Dal.UserTeam() { Id = userTeamId, Deleted = true, Modified = DateTime.Now }; db.UserTeams.Attach(efUserTeam); db.Entry(efUserTeam).Property(x => x.Deleted).IsModified = true; db.Entry(efUserTeam).Property(x => x.Modified).IsModified = true; db.SaveChanges(); } }
public void SetDefault(Guid userId, Guid teamId) { var id = IdByUserAndTeam(userId, teamId); var efUserTeam = new Pb.Dal.UserTeam() { Id = id, Default = true }; using (var db = new Pb.Dal.EfEntities()) { // Set all of our current relationsips to false if they are true db.UserTeams.Where(x => x.UserId == userId && x.Deleted == false && x.Default == true).Update(y=> new Pb.Dal.UserTeam() {Default = false}); db.UserTeams.Attach(efUserTeam); db.Entry(efUserTeam).Property(x => x.Default).IsModified = true; db.SaveChanges(); } }