public static bool CreateDonnees(string filePath, string NomVague) { var extension = Path.GetExtension(filePath); var stream = File.Open(filePath, FileMode.Open, FileAccess.Read); var excelReader = extension == ".xlsx" ? ExcelReaderFactory.CreateOpenXmlReader(stream) : ExcelReaderFactory.CreateBinaryReader(stream); excelReader.IsFirstRowAsColumnNames = true; var collectionBase = excelReader.AsDataSet().Tables[0].AsEnumerable(); var Vide = collectionBase.Where(p => (string) p["annee"] == "2012"); //Assert.AreEqual(extension, ".xlsx"); var distincts = collectionBase.Select(p => p["Matricule"]).Distinct(); foreach (var distinct in distincts) { var ind = new Individu(); var convdistinct = int.Parse(distinct.ToString()); var individuRepository = new IndividuRepository(); var indivCriterion = new Criterion("IdQuest",convdistinct.ToString(),CriteriaOperator.Equal); var indivQuery = new Query(); indivQuery.Add(indivCriterion); if (individuRepository.FindBy(indivQuery).Any())continue ; ind.IdQuest = int.Parse(distinct.ToString()); ind.Sexe = (int)((collectionBase.First(d => d["Matricule"] == ind.IdQuest.ToString()))["Sexe"]); } return default(Boolean); }
public static bool CreateDonnees(string filePath, string NomVague) { var extension = Path.GetExtension(filePath); var stream = File.Open(filePath, FileMode.Open, FileAccess.Read); var excelReader = extension == ".xlsx" ? ExcelReaderFactory.CreateOpenXmlReader(stream) : ExcelReaderFactory.CreateBinaryReader(stream); excelReader.IsFirstRowAsColumnNames = true; var collectionBase = excelReader.AsDataSet().Tables[0].AsEnumerable(); var Vide = collectionBase.Where(p => (string)p["annee"] == "2012"); //Assert.AreEqual(extension, ".xlsx"); var distincts = collectionBase.Select(p => p["Matricule"]).Distinct(); foreach (var distinct in distincts) { var ind = new Individu(); var convdistinct = int.Parse(distinct.ToString()); var individuRepository = new IndividuRepository(); var indivCriterion = new Criterion("IdQuest", convdistinct.ToString(), CriteriaOperator.Equal); var indivQuery = new Query(); indivQuery.Add(indivCriterion); if (individuRepository.FindBy(indivQuery).Any()) { continue; } ind.IdQuest = int.Parse(distinct.ToString()); ind.Sexe = (int)((collectionBase.First(d => d["Matricule"] == ind.IdQuest.ToString()))["Sexe"]); } return(default(Boolean)); }