public override void RemoveLink(object link)
{
using (var db = new NgContext())
{
db.Remove(link);
db.SaveChanges();
}
}
public override void Add(T entity)
{
using (var db = new NgContext())
{
var _dbSet = db.Set <T>();
_dbSet.Add(entity);
db.SaveChanges();
}
}
public override void Save(T entity)
{
using (var db = new NgContext())
{
var dbSet = db.Set <T>();
db.Update(entity);
db.SaveChanges();
}
}
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 override void Delete(IdT id)
{
using (var db = new NgContext())
{
var dbSet = db.Set <T>();
dbSet.Remove(new T()
{
Id = id
});
db.SaveChanges();
}
}
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(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 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 async Task <IEnumerable <Categorie> > Get()
{
Newtonsoft.Json.JsonSerializer jsonSer = new Newtonsoft.Json.JsonSerializer();
#region Users
List <User> users;
using (var str = new System.IO.FileStream("Json/communaute.json", System.IO.FileMode.Open))
{
var sr = new System.IO.StreamReader(str);
var reader = new Newtonsoft.Json.JsonTextReader(sr);
users = jsonSer.Deserialize <List <User> >(reader);
foreach (var user in users)
{
user.JsonId = user.Id;
user.Id = default(int);
if (!_context.Users.Any(u => u.Email == user.Email))
{
user.UserName = user.Email;
var result = await _userManager.CreateAsync(user, user.Password);
}
}
}
_context.SaveChanges();
#endregion
#region categories
using (var str = new System.IO.FileStream("Json/categories.json", System.IO.FileMode.Open))
{
var sr = new System.IO.StreamReader(str);
var reader = new Newtonsoft.Json.JsonTextReader(sr);
List <Categorie> categories = jsonSer.Deserialize <List <Categorie> >(reader);
foreach (var cat in categories)
{
if (!_context.Categories.Any(c => c.Id == cat.Id))
{
_context.Categories.Add(cat);
}
}
}
_context.SaveChanges();
#endregion
#region Ingredients
using (var str = new System.IO.FileStream("Json/ingredients.json", System.IO.FileMode.Open))
{
var sr = new System.IO.StreamReader(str);
var reader = new Newtonsoft.Json.JsonTextReader(sr);
List <Ingredient> ingredients = jsonSer.Deserialize <List <Ingredient> >(reader);
foreach (var ingredient in ingredients)
{
if (!_context.Categories.Any(c => c.Id == ingredient.CategoryId))
{
_context.Categories.Add(new Categorie {
Id = ingredient.CategoryId.ToLower(), NameToDisplay = ingredient.CategoryId
});
}
if (!_context.Ingredients.Any(ig => ig.Id == ingredient.Id))
{
_context.Ingredients.Add(ingredient);
}
}
}
_context.SaveChanges();
#endregion
#region Recettes
using (var str = new System.IO.FileStream("Json/recettes.json", System.IO.FileMode.Open))
{
var sr = new System.IO.StreamReader(str);
var reader = new Newtonsoft.Json.JsonTextReader(sr);
List <Recette> recettes = jsonSer.Deserialize <List <Recette> >(reader);
foreach (var recette in recettes)
{
if (!_context.Recettes.Any(r => r.Id == recette.Id))
{
User creator = users.Where(u => u.JsonId == recette.CreatorId).FirstOrDefault();
recette.CreatorId = creator.Id;
_context.Recettes.Add(recette);
}
foreach (String ingredientId in recette.Ingredients)
{
if (!_context.Ingredients.Any(ig => ig.Id == ingredientId))
{
_context.Ingredients.Add(new Ingredient {
Calories = 100, Id = ingredientId, IsAvailable = true, Name = ingredientId, Picture = "pomme-de-terre.jpg", CategoryId = "vegetable"
});
}
if (!_context.IngredientsRecettes.Any(igr => igr.IngredientId == ingredientId && igr.RecetteId == recette.Id))
{
_context.IngredientsRecettes.Add(new IngredientRecette {
IngredientId = ingredientId, RecetteId = recette.Id
});
}
}
if (recette.Commentaires != null)
{
foreach (Commentaire comment in recette.Commentaires)
{
User creator = users.Where(u => u.JsonId == comment.UserId).FirstOrDefault();
comment.UserId = creator.Id;
if (!_context.Commentaires.Any(c => c.UserId == comment.UserId && c.RecetteId == recette.Id))
{
comment.RecetteId = recette.Id;
_context.Commentaires.Add(comment);
}
}
}
}
}
_context.SaveChanges();
#endregion
return(_context.Ingredients.Select <Ingredient, Categorie>(i => i.Category));
}
