public void BulkInsert(List <TEntity> entities)
{
using (var db = new NewPlayDbContext()){
db.AddRange(entities);
db.SaveChanges();
};
}
public void Remove(TEntity entity)
{
using (var db = new NewPlayDbContext()){
db.Remove(entity);
db.SaveChanges();
};
}
public List <Game> GetGamesByUserId(string userId)
{
using (var db = new NewPlayDbContext()){
var games = (from _games in db.Game
join gameGenre in db.GameGenre on _games.Id equals gameGenre.GameId
join gamePlatf in db.GamePlatform on _games.Id equals gamePlatf.GameId
join userGenre in db.UserGenre on gameGenre.GenreId equals userGenre.GenreId
join userPlatf in db.UserPlatform on gamePlatf.PlatformId equals userPlatf.PlatformId
where userPlatf.UserId == userId && userGenre.UserId == userId &&
db.UserGame.Where(ug => ug.GameId == _games.Id).First() == null
select _games).ToList();
return(games);
}
}
public object FilterBy(string id, DateTime?startDate,
DateTime?finishDate, bool?active, string accessType)
{
using (var db = new NewPlayDbContext()){
var users = db.User.ToList();
Predicate <User> match = null;
if (!string.IsNullOrEmpty(id))
{
match = (u => u.Id == id);
}
if (!string.IsNullOrEmpty(accessType))
{
match = (u => u.Role == accessType);
}
if (startDate != null && finishDate != null)
{
finishDate = Convert.ToDateTime(finishDate)
.AddHours(23).AddMinutes(59).AddSeconds(59);
match = (u => u.CreationDate >= startDate &&
u.CreationDate <= finishDate);
}
if (active != null)
{
if (active == true)
{
match = (u => u.DisableDate == null);
}
else
{
match = (u => u.DisableDate != null);
}
}
return(users.FindAll(match));
}
}
public object GetAssociatedGamesPlatformAndGenres(string id)
{
using (var db = new NewPlayDbContext()){
var user = (from users in db.User
// join userGame in db.UserGame on users.Id equals userGame.UserId
// join games in db.Game on userGame.GameId equals games.Id
join userGenre in db.UserGenre on users.Id equals userGenre.UserId
join genres in db.Genre on userGenre.GenreId equals genres.Id
join userPlatform in db.UserPlatform on users.Id equals userPlatform.UserId
join platform in db.Platform on userPlatform.PlatformId equals platform.Id
where users.Id == id
select users).FirstOrDefault();
var _games = (from userGame in db.UserGame
join games in db.Game on userGame.GameId equals games.Id
where userGame.UserId == user.Id
select games).ToList();
var _genres = (from userGenre in db.UserGenre
join genres in db.Genre on userGenre.GenreId equals genres.Id
where userGenre.UserId == user.Id
select genres).ToList();
var _platforms = (from userPlatform in db.UserPlatform
join platform in db.Platform on userPlatform.PlatformId equals platform.Id
where userPlatform.UserId == user.Id
select platform).ToList();
return(new {
user.Nickname,
user.Email,
user.Avatar,
user.CreationDate,
user.Description,
_games,
_genres,
_platforms
});
}
}
public object FilterBy(string id, DateTime?startDate,
DateTime?finishDate, bool?active)
{
using (var db = new NewPlayDbContext()){
var games = db.Game.ToList();
Predicate <Game> match = null;
if (!string.IsNullOrEmpty(id))
{
match = (e => e.Id == id);
}
if (startDate != null && finishDate != null)
{
finishDate = Convert.ToDateTime(finishDate)
.AddHours(23).AddMinutes(59).AddSeconds(59);
match = (e => e.CreationDate >= startDate &&
e.CreationDate <= finishDate);
}
if (active != null)
{
if (active == true)
{
match = (e => e.DisableDate == null);
}
else
{
match = (e => e.DisableDate != null);
}
}
return(games.FindAll(match));
}
}
public object FilterBy(int?id, DateTime?startDate,
DateTime?finishDate, bool?active)
{
using (var db = new NewPlayDbContext()){
var developers = db.Developer.ToList();
Predicate <Developer> match = null;
if (id != null)
{
match = (e => e.Id == id);
}
if (startDate != null && finishDate != null)
{
finishDate = Convert.ToDateTime(finishDate)
.AddHours(23).AddMinutes(59).AddSeconds(59);
match = (e => e.CreationDate >= startDate &&
e.CreationDate <= finishDate);
}
if (active != null)
{
if (active == true)
{
match = (e => e.DisableDate == null);
}
else
{
match = (e => e.DisableDate != null);
}
}
return(developers.FindAll(match));
}
}
// public object FilterBy(string key, object value){
// using(var db = new NewPlayDbContext()){
// //Type type = db.Set<TEntity>().GetType();
// //var prop = db.Set<TEntity>().GetType().GetProperty(key).GetValue(db.Set<TEntity>().GetType());
// //var _value = prop.GetValue(db.Set<TEntity>());
// // return db.Set<typeof(TEntity)>().ToList()
// // .FindAll(e =>
// // e.GetType()
// // .get(key)
// // .GetValue(e)
// // == value);
// };
// return null;
// }
public IEnumerable <TEntity> GetAll()
{
using (var db = new NewPlayDbContext()){
return(db.Set <TEntity>().ToList());
};
}
public TEntity GetById(params object[] key)
{
using (var db = new NewPlayDbContext()){
return(db.Set <TEntity>().Find(key));
};
}