public override Project FindById(int id)
{
using (var db = new NgContext())
{
db.ChangeTracker.QueryTrackingBehavior = QueryTrackingBehavior.NoTracking;
var model = db.Projects
//.AsNoTracking()
//.Include(t => t.News)
////.AsNoTracking()
//.Include(t => t.Workers)
////.AsNoTracking()
//.Include(t => t.User)
////.AsNoTracking()
// .ThenInclude(t => t.Image)
////.AsNoTracking()
//.Include(t => t.ProjectImage)
////.AsNoTracking()
//.Include(t => t.Subscribers)
//.AsNoTracking()
//.Include(t => t.MainProjectImage)
//.AsNoTracking()
.FirstOrDefault(t => t.Id == id);
return(model);
}
}
public override User Find(Func <User, bool> expression)
{
using (var db = new NgContext())
{
db.ChangeTracker.QueryTrackingBehavior = QueryTrackingBehavior.NoTracking;
Type project = typeof(Project);
object tttd = GetEx();
var user = db.Users
//.AsNoTracking()
//.Include(t => t.Email)
//.AsNoTracking()
//.Include(t => t.Worker)
////.AsNoTracking()
// .ThenInclude(t => t.Projects)
////.AsNoTracking()
//.Include(t => t.Worker)
// .ThenInclude(t => t.Skills)
////.AsNoTracking()
//.Include(t => t.Subscriber)
////.AsNoTracking()
// .ThenInclude(t => t.Projects)
////.AsNoTracking()
//.Include(t => t.Projects)
//.AsNoTracking()
//.Include(t => t.Image)
//.AsNoTracking()
.FirstOrDefault(expression);
return(user);
}
}
public List <Worker> FindAll(Expression <Func <Worker, object> > expEntity)
{
using (var db = new NgContext())
{
dynamic model = db.Participants.Select(expEntity).ToList();
return(model);
}
}
public override void Edit(T entity)
{
using (var db = new NgContext())
{
var dbSet = db.Set <T>();
dbSet.Update(entity);
}
}
public override T Find(Func <T, bool> expression)
{
using (var db = new NgContext())
{
var _dbSet = db.Set <T>();
return(_dbSet.FirstOrDefault(expression));
}
}
public override ICollection <T> FindAll()
{
using (var db = new NgContext())
{
var _dbSet = db.Set <T>();
return(_dbSet.ToList());
}
}
public override T FindById(IdT id)
{
using (var db = new NgContext())
{
var _dbSet = db.Set <T>();
return(_dbSet.Find(id));
}
}
public override void RemoveLink(object link)
{
using (var db = new NgContext())
{
db.Remove(link);
db.SaveChanges();
}
}
public override T Find(Expression <Func <T, object> > expression, Func <object, bool> func)
{
using (var db = new NgContext())
{
var _dbSet = db.Set <T>().Select(expression).AsEnumerable().FirstOrDefault(func);
return((T)_dbSet);
}
}
public override T Find(Expression <Func <T, object> > expression, int id)
{
using (var db = new NgContext())
{
var _dbSet = db.Set <T>().Select(expression).ToList().FirstOrDefault(t => (t as T).Id == id);
return((T)_dbSet);
}
}
public override void Save(T entity)
{
using (var db = new NgContext())
{
var dbSet = db.Set <T>();
db.Update(entity);
db.SaveChanges();
}
}
public override ICollection <T> FindAll(Func <T, bool> expression)
{
using (var db = new NgContext())
{
db.ChangeTracker.QueryTrackingBehavior = QueryTrackingBehavior.NoTracking;
var _dbSet = db.Set <T>();
return(_dbSet.ToList().Where(expression).ToList());
}
}
public override void Add(T entity)
{
using (var db = new NgContext())
{
var _dbSet = db.Set <T>();
_dbSet.Add(entity);
db.SaveChanges();
}
}
public override ICollection <T> FindAll(Expression <Func <T, object> > expression)
{
using (var db = new NgContext())
{
db.ChangeTracker.QueryTrackingBehavior = QueryTrackingBehavior.NoTracking;
var _dbSet = db.Set <T>().Select(expression).AsNoTracking().ToList();
return(_dbSet.Cast <T>().ToList());
}
}
public override ICollection <T> FindAll()
{
using (var db = new NgContext())
{
db.ChangeTracker.QueryTrackingBehavior = QueryTrackingBehavior.NoTracking;
var _dbSet = db.Set <T>();
return(_dbSet.ToList());
}
}
public override T FindById(int id)
{
using (var db = new NgContext())
{
db.ChangeTracker.QueryTrackingBehavior = QueryTrackingBehavior.NoTracking;
var _dbSet = db.Set <T>();
return(_dbSet.Find(id));
}
}
public override int Add(T entity)
{
using (var db = new NgContext())
{
var _dbSet = db.Set <T>();
var item = _dbSet.Add(entity);
db.SaveChanges();
return(item.Entity.Id);
}
}
public List <Skill> FindAllByParticipantId(int participantId)
{
using (var db = new NgContext())
{
//db.ChangeTracker.QueryTrackingBehavior = QueryTrackingBehavior.NoTracking;
//var allSkiillsParticipant = db.Skills
// .Where(t => t.ParticipantId == participantId).Select(t => t.Skill).ToList();
//return allSkiillsParticipant;
return(null);
}
}
public override ICollection <Worker> FindAll()
{
using (var db = new NgContext())
{
db.ChangeTracker.QueryTrackingBehavior = QueryTrackingBehavior.NoTracking;
var model = db.Participants.Select(t => new Worker {
User = t.User
}).ToList();
return(model);
}
}
public void AddParticipant(int projectId, int workerId)
{
using (var db = new NgContext())
{
var model = db.Projects
.Include(t => t.Workers)
.FirstOrDefault(t => t.Id == projectId);
var worker = db.Participants.Find(workerId);
model.Workers.Add(worker);
db.SaveChanges();
}
}
public override void Delete(IdT id)
{
using (var db = new NgContext())
{
var dbSet = db.Set <T>();
dbSet.Remove(new T()
{
Id = id
});
db.SaveChanges();
}
}
public override void Delete(int id)
{
using (var db = new NgContext())
{
db.ChangeTracker.QueryTrackingBehavior = QueryTrackingBehavior.NoTracking;
var dbSet = db.Set <T>();
dbSet.Remove(new T()
{
Id = id
});
db.SaveChanges();
}
}
public override Skill FindById(int id)
{
using (var db = new NgContext())
{
db.ChangeTracker.QueryTrackingBehavior = QueryTrackingBehavior.NoTracking;
var model = db.Skills
//.AsNoTracking()
//.Include(t => t.Participant)
//.AsNoTracking()
.FirstOrDefault(t => t.Id == id);
return(model);
}
}
public void AddSubscriber(int projectId, int subscriberId)
{
using (var db = new NgContext())
{
var model = db.Projects
.Include(t => t.ProjectSubscribers)
.FirstOrDefault(t => t.Id == projectId);
var subscriber = db.Subscribers.Find(subscriberId);
model.ProjectSubscribers.Add(new ProjectSubscriber()
{
ProjectsId = projectId, SubscribersId = subscriberId
});
db.SaveChanges();
}
}
public override ICollection <T> FindAll(EntityExpression <T> entityExpression, Func <T, bool> func = null)
{
using (var db = new NgContext())
{
var _dbSet = db.Set <T>().Include(entityExpression.ExpressionList.First());
foreach (var exp in entityExpression.ExpressionList)
{
_dbSet = _dbSet.Include(exp);
}
if (func != null)
{
return(_dbSet.Where(func).ToList());
}
return(_dbSet.ToList());
}
}
public override ICollection <Worker> FindAll(Func <Worker, bool> func)
{
using (var db = new NgContext())
{
db.ChangeTracker.QueryTrackingBehavior = QueryTrackingBehavior.NoTracking;
var model = db.Participants
.AsNoTracking()
.Include(t => t.Skills)
.AsNoTracking()
.Include(t => t.User)
.AsNoTracking()
.Where(func)
.ToList();
return(model);
}
}
private void LoadDatabase()
{
// Initialisation de la bas de données
var configurationBuilder = new ConfigurationBuilder();
IConfigurationRoot configuration = configurationBuilder.Build();
NgContext ngContext = new NgContext(configuration);
// Récupération des utilisateurs
CommunityController communityController = new CommunityController(new CommunityRepository(ngContext));
communityController.Get();
// Récupération des recettes
IHostingEnvironment appEnvironment = null;
RecettesController recettesController = new RecettesController(new RecetteRepository(ngContext), new IngredientRepository(ngContext), appEnvironment);
recettesController.Get(null);
}
public override ICollection <Project> FindAll(Func <Project, bool> expression)
{
using (var db = new NgContext())
{
db.ChangeTracker.QueryTrackingBehavior = QueryTrackingBehavior.NoTracking;
var model = db.Projects
//.AsNoTracking()
//.Include(t => t.User)
//.AsNoTracking()
//.Include(t => t.MainProjectImage)
//.AsNoTracking()
//.Include(t => t.ProjectImage)
//.AsNoTracking()
//.Include(t => t.Workers)
//.AsNoTracking()
.Where(expression)
.ToList();
return(model);
}
}
public override ICollection <Project> FindAll()
{
using (var db = new NgContext())
{
//db.ChangeTracker.QueryTrackingBehavior = QueryTrackingBehavior.NoTracking;
var model = db.Projects
//.AsNoTracking()
//.Include(t => t.User)
// .ThenInclude(t => t.Image)
////.AsNoTracking()
//.Include(t => t.Workers)
////.AsNoTracking()
////.AsNoTracking()
//.Include(t => t.MainProjectImage)
////.AsNoTracking()
//.Include(t=> t.ProjectImage)
//.AsNoTracking()
.ToList();
return(model);
}
}
public ImportController(NgContext context, UserManager <User> userManager)
{
_context = context;
_userManager = userManager;
}
