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