public JsonResult GetPiCategorie(int id) { var pi = _piRepository .GetAll() .Where(p => p.CategorieId == id) .ToList(); return(Json(pi)); }
public void AddPi() { if (_piRepository.GetAll().Any()) { return; } _logger.LogWarning("Adding PI"); /* var pi = new List<pointDinteret> * { * new pointDinteret {Id = 1, Name = "KFC Toulon Liberté", Descriptif="Place ou on vend de la nourriture", Categorie=_categorieRepository.Single("Restauration") , Adresse = _adresseRepository.Single(1)}, * new pointDinteret {Id=2, Name="Isen Toulon", Descriptif="Référence en terme de formation d'ingénieurs", Categorie=_categorieRepository.Single("Lieu Touristique"), Adresse = _adresseRepository.Single(2)} * }; * _piRepository.UpdateRange(pi); * _piRepository.Save(); * * _logger.LogWarning("Added PI");*/ string fileName = "PointDInteret.csv"; string path1 = @"SeedData"; string path; path = Path.GetFullPath(path1) + "\\" + fileName; using (var sr = new StreamReader(path)) { var reader = new CsvReader(sr); reader.Configuration.MissingFieldFound = null; reader.Configuration.RegisterClassMap <PiMap>(); reader.Read(); reader.ReadHeader(); IEnumerable <pointDinteret> points = reader.GetRecords <pointDinteret>(); _piRepository.UpdateRange(points); _piRepository.Save(); } List <pointDinteret> pi = new List <pointDinteret>(); _logger.LogWarning("Addeed Point d'Intérêt"); }