public bool Validate(string email, string password)
{
email = email.Trim();
var hashedPassword = _encryptor.Encrypt(password);
//using (var db = new DocumentStore() { Url = ConfigurationManager.AppSettings["dbUrl"], DefaultDatabase = ConfigurationManager.AppSettings["defaultDb"] })
//{
// db.Initialize();
// using (var session = db.OpenSession())
// {
// var query = from u in session.Query<User>()
// where
// u.Deleted == false
// && u.Email.Equals(email, StringComparison.InvariantCultureIgnoreCase)
// && u.Password == hashedPassword
// select u;
// return query.Any();
// }
//}
using (var db = new Pb.Dal.EfEntities())
{
var query = from u in db.Users
where
u.Deleted == false
&& u.Email == email
&& u.Password == hashedPassword
select u;
return query.Any();
}
}
public void Create(Marker marker)
{
using (var db = new Pb.Dal.EfEntities())
{
db.Markers.Add(new Pb.Dal.Marker()
{
Created = DateTime.Now,
Id = marker.Id,
ImageUrl = marker.ImageUrl,
Deleted = false,
Manufacturer = marker.Manufacturer,
Name = marker.Name,
PlayerId = marker.PlayerId
});
try
{
db.SaveChanges();
}
catch (DbEntityValidationException e)
{
Console.WriteLine(e);
}
}
}
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 DeleteByUserId(Guid userId)
{
using (var db = new Pb.Dal.EfEntities())
{
db.UserRanks.Where(x => x.UserId == userId && x.Deleted == false).Update(y => new Pb.Dal.UserRank() { Deleted = true, Modified = DateTime.Now});
db.SaveChanges();
}
}
public void DeleteAll()
{
using (var db = new Pb.Dal.EfEntities())
{
db.Notifications.Where(x => x.Deleted == false).Update(y => new Pb.Dal.Notification() {Deleted = true});
db.SaveChanges();
}
}
public void DeleteAll()
{
using (var db = new Pb.Dal.EfEntities())
{
db.UserTeams.Where(x => x.Deleted == false).Update(y => new Pb.Dal.UserTeam() {Deleted = true,Modified = DateTime.Now});
db.SaveChanges();
}
}
public void Delete(Guid id)
{
using (var db = new Pb.Dal.EfEntities())
{
db.Gears.Where(x => x.Id == id).Update(y => new Pb.Dal.Gear() {Deleted = true, Modified = DateTime.Now});
db.SaveChanges();
}
}
public void UpdateName(Guid id, string name)
{
using (var db = new Pb.Dal.EfEntities())
{
db.Loadouts.Where(x => x.Id == id).Update(y => new Pb.Dal.Loadout() {Name = name, Modified = DateTime.Now});
db.SaveChanges();
}
}
public void UpdateImageUrl(Guid id, string url)
{
using (var db = new Pb.Dal.EfEntities())
{
db.Loadouts.Where(x => x.Id == id).Update(y => new Pb.Dal.Loadout() {ImageUrl = url, Modified = DateTime.Now});
db.SaveChanges();
}
}
public void Delete(Guid id)
{
using (var db = new Pb.Dal.EfEntities())
{
db.Markers.Where(x => x.Id == id).Update(y => new Pb.Dal.Marker()
{
Deleted = true
});
db.SaveChanges();
}
}
public Loadout ById(Guid id)
{
using (var db = new Pb.Dal.EfEntities())
{
var query = from x in db.Loadouts
where
x.Deleted == false
&& x.Id == id
select x;
var efLoadout = query.AsNoTracking().FirstOrDefault();
return AutoMapper.Mapper.Map<Loadout>(efLoadout);
}
}
public Marker ById(Guid id)
{
using (var db = new Pb.Dal.EfEntities())
{
var query = from x in db.Markers
where
x.Deleted == false
&& x.Id == id
select x;
var efMarker = query.AsNoTracking().FirstOrDefault();
return AutoMapper.Mapper.Map<Marker>(efMarker);
}
}
public Domain.Gear ById(Guid id)
{
using (var db = new Pb.Dal.EfEntities())
{
var query = from x in db.Gears
where
x.Deleted == false
&& x.Id == id
select x;
var efGear = query.AsNoTracking().FirstOrDefault();
var gear = Mapper.Map<Domain.Gear>(efGear);
return gear;
}
}
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 Create(Loadout loadout)
{
using (var db = new Pb.Dal.EfEntities())
{
db.Loadouts.Add(new Pb.Dal.Loadout()
{
Created = DateTime.Now,
Deleted = false,
Id = loadout.Id,
ImageUrl = loadout.ImageUrl,
Modified = DateTime.Now,
Name = loadout.Name,
PlayerId = loadout.PlayerId
});
db.SaveChanges();
}
}
public void Update(Domain.Gear gear)
{
using (var db = new Pb.Dal.EfEntities())
{
db.Gears.Where(x => x.Id == gear.Id).Update(y => new Pb.Dal.Gear()
{
//Created = gear.Created,
Deleted = gear.Deleted,
LoadoutId = gear.LoadoutId,
Manufacturer = gear.Manufacturer,
Modified = DateTime.Now,
Name = gear.Name,
Section = gear.Section.GetHashCode(),
Quantity = gear.Quantity,
ImageUrl = gear.ImageUrl
});
db.SaveChanges();
}
}
public void Create(Notification notification)
{
var efNotification = new Pb.Dal.Notification()
{
Created = DateTime.Now,
Deleted = false,
Description = notification.Description,
Id = notification.Id,
Modified = DateTime.Now,
Scope = notification.Scope.GetHashCode(),
Title = notification.Title,
Type = notification.Type.GetHashCode()
};
using (var db = new Pb.Dal.EfEntities())
{
db.Notifications.Add(efNotification);
db.SaveChanges();
}
}
public void Update(Marker marker)
{
using (var db = new Pb.Dal.EfEntities())
{
bool sameVersion = db.Markers.AsNoTracking().Any(x => x.Id == marker.Id && x.Version == marker.Version);
if (!sameVersion)
throw new StaleDataException();
db.Markers.Where(y => y.Id == marker.Id).Update(x => new Pb.Dal.Marker()
{
Deleted = marker.Deleted,
ImageUrl = marker.ImageUrl,
Manufacturer = marker.Manufacturer,
Name = marker.Name
});
db.SaveChanges();
}
}
public void Create(Domain.Gear gear)
{
using (var db = new Pb.Dal.EfEntities())
{
db.Gears.Add(new Pb.Dal.Gear()
{
Id = gear.Id == Guid.Empty ? Guid.NewGuid() : gear.Id,
Created = DateTime.Now,
Deleted = gear.Deleted,
LoadoutId = gear.LoadoutId,
Manufacturer = gear.Manufacturer,
Modified = DateTime.Now,
Name = gear.Name,
Section = gear.Section.GetHashCode(),
Quantity = gear.Quantity,
ImageUrl = gear.ImageUrl
});
db.SaveChanges();
}
}
public TeamModel ById(string externalId, Guid id)
{
using (var db = new Pb.Dal.EfEntities())
{
var query = from x in db.Teams
where
x.Deleted == false
&& x.Id == id
orderby x.Name
select x;
var efTeam = query.FirstOrDefault();
var team = Mapper.Map<TeamModel>(efTeam);
List<RankModel> ranks = _rankRepository.ByTeamId(id, externalId);
List<UserModel> users = _userRepository.ByTeamId(id);
team.Ranks = ranks;
team.Users = users;
return team;
}
}
public List<TeamModel> Get(string externalId)
{
using (var db = new Pb.Dal.EfEntities())
{
db.Database.Log += delegate(string s)
{
if (_logger != null)
_logger.Verbose(s);
};
// Find userid
Guid userId = db.Users.Where(x => x.ExternalId == externalId && x.Deleted == false).Select(y => y.Id).FirstOrDefault();
if (userId == default(Guid))
throw new Exception("userid not found for externalid: " + externalId);
var query = from x in db.Teams
where
x.Deleted == false
orderby x.Name
select x;
var efTeams = query.ToList();
var teams = efTeams.Select(x => Mapper.Map<TeamModel>(x)).ToList();
var query2 = from x in db.UserTeams
where
x.Deleted == false
&& x.UserId == userId
select new {x.TeamId, x.Default};
var teamIds = query2.ToList();
foreach (TeamModel teamModel in teams)
{
if (teamIds.Any(x => x.TeamId == teamModel.Id))
{
teamModel.IsUserInTeam = true;
teamModel.IsDefault = teamIds.First(x => x.TeamId == teamModel.Id).Default;
}
}
var res= from x in db.Teams
join a in db.UserTeams
on x.Id equals a.TeamId
//group a by a.Id into g
where
a.Deleted == false
group x by x.Id into g
select new
{
teamId = g.Key,
total = g.Count()
};
var results = res.ToList();
foreach (var team in teams)
{
if (results.Any(x => x.teamId == team.Id))
{
team.UserCount = results.First(x => x.teamId == team.Id).total;
}
else
{
team.UserCount = 0;
}
}
var res2= from x in db.Teams
join a in db.Ranks
on x.Id equals a.TeamId
where
a.Deleted == false
group x by x.Id into g
select new
{
teamId = g.Key,
total = g.Count()
};
var results2 = res2.ToList();
foreach (TeamModel team in teams)
{
if (results2.Any(x => x.teamId == team.Id))
{
team.RankCount = results2.First(x => x.teamId == team.Id).total;
}
}
return teams;
}
}
public void GetWithIncludes()
{
//var id = new Guid("61EF6631-7703-4A65-8BAA-9E2AAAB2BDEB");
var id = new Guid("0ECF0F89-866B-4CF5-AEBB-16152D5FCCCF");
using (var db = new Pb.Dal.EfEntities())
{
//var query = from u in db.Users
// where
// u.Id == id
// select u;
//query.Incl
var idk = db.Users
.Include("UserTeams.Team")
.Include("UserRanks.Rank")
//.Includex => x.Ranks)
.Where(x => x.Id == id)
.ToList();
}
}
public Guid UpsertFromExternal(string id, string email, string username)
{
using (var db = new Pb.Dal.EfEntities())
{
var exists = db.Users.Any(u => u.Deleted == false && u.ExternalId == id);
if (!exists)
{
var newId = Guid.NewGuid();
db.Users.Add(new Pb.Dal.User()
{
Id = newId,
ExternalId = id,
Email = email,
Password = "",
FirstName = username,
Created = DateTime.Now,
Modified = DateTime.Now
});
try
{
db.SaveChanges();
}
catch (DbEntityValidationException ex)
{
throw;
}
_logger.Information("User created, id: {id}, email: {email}", newId, email);
return newId;
}
return db.Users.Where(u => u.Deleted == false && u.ExternalId == id).Select(x => x.Id).First();
}
}
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 bool Exists(Guid userId, Guid teamId)
{
using (var db = new Pb.Dal.EfEntities())
{
var query = from x in db.UserTeams
where
x.Deleted == false
&& x.UserId == userId
&& x.TeamId == teamId
select x;
return query.AsNoTracking().Any();
}
}
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();
}
}
public Guid IdByUserAndTeam(Guid userId, Guid teamId)
{
using (var db = new Pb.Dal.EfEntities())
{
var query = from x in db.UserTeams.AsNoTracking()
where
x.Deleted == false
&& x.UserId == userId
&& x.TeamId == teamId
select x.Id;
return query.FirstOrDefault();
}
}
public UserModel ById(Guid id)
{
using (var db = new Pb.Dal.EfEntities())
{
//var data = from u in db.Users
// where
// u.Deleted == false
// && u.Id == id
// select u;
//data.includ
var data = db.Users
.Include("UserTeams.Team")
.Include("UserRanks.Rank")
.Where(u => u.Deleted == false && u.Id ==id)
.AsNoTracking()
.FirstOrDefault();
if (data == null)
return null;
var user = new UserModel(){
Id = data.Id,
FirstName = data.FirstName,
LastName = data.LastName,
Callsign = data.Callsign,
Email = data.Email,
Created = data.Created,
Modified = data.Modified,
Teams = new List<UserTeamModel>()
};
foreach (var userTeam in data.UserTeams.Where(x => x.Deleted == false))
{
var team = new UserTeamModel(){
TeamImageUrl = userTeam.Team.ImageUrl,
IsDefaultTeam = userTeam.Default,
TeamName = userTeam.Team.Name,
TeamId = userTeam.TeamId,
UserTeamId = userTeam.Id,
};
// Ranks
var rank = data.UserRanks.FirstOrDefault(x => x.TeamId == userTeam.TeamId && x.Deleted == false);
if (rank != null)
{
team.HasRank = true;
team.RankName = rank.Rank.Name;
team.RankImageUrl = rank.Rank.ImageUrl;
}
else
{
team.HasRank = false;
}
user.Teams.Add(team);
}
return user;
}
}
public List<TeamModel> Get(Guid userId)
{
using (var db = new Pb.Dal.EfEntities())
{
var query = from x in db.Teams
where
x.Deleted == false
orderby x.Name
select x;
var efTeams = query.ToList();
var teams = efTeams.Select(x => Mapper.Map<TeamModel>(x)).ToList();
var query2 = from x in db.UserTeams
where
x.Deleted == false
&& x.UserId == userId
select new {x.TeamId, x.Default};
var teamIds = query2.ToList();
foreach (TeamModel teamModel in teams)
{
if (teamIds.Any(x => x.TeamId == teamModel.Id))
{
teamModel.IsUserInTeam = true;
teamModel.IsDefault = teamIds.First(x => x.TeamId == teamModel.Id).Default;
}
}
var res= from x in db.Teams
join a in db.UserTeams
on x.Id equals a.TeamId
//group a by a.Id into g
where
a.Deleted == false
group x by x.Id into g
select new
{
teamId = g.Key,
total = g.Count()
};
var results = res.ToList();
foreach (var team in teams)
{
if (results.Any(x => x.teamId == team.Id))
{
team.UserCount = results.First(x => x.teamId == team.Id).total;
}
else
{
team.UserCount = 0;
}
}
var res2= from x in db.Teams
join a in db.Ranks
on x.Id equals a.TeamId
where
a.Deleted == false
group x by x.Id into g
select new
{
teamId = g.Key,
total = g.Count()
};
var results2 = res2.ToList();
foreach (TeamModel team in teams)
{
if (results2.Any(x => x.teamId == team.Id))
{
team.RankCount = results2.First(x => x.teamId == team.Id).total;
}
}
return teams;
}
}
