static void Main(string[] args) { Console.WriteLine("Hello World!"); mydbal = new Dbal("club_fromage"); myPays = new Pays(); myDaoPays = new DaoPays(mydbal); //myDaoPays.Insert(myPays); //myDaoPays.InsertFromCSV("C:\\Users\\SIO2\\source\\repos\\ClubFromageTemplate\\ModelLayer\\import files\\pays.csv"); //myFromage = new Fromage(2,"Reblochon",default,myPays,default); myDaoFromage = new DaoFromage(mydbal, myDaoPays); //myDaoFromage.Insert(myFromage); myDaoFromage.InsertFromCSV("C:\\Users\\SIO2\\source\\repos\\ClubFromageTemplate\\ModelLayer\\import files\\tableauNomDep.csv"); //List<Fromage> myFromages = myDaoFromage.SelectAll(); //foreach (Fromage f in myFromages) //{ // Console.WriteLine(f.Name); //} //List <Pays> listPays = myDaoPays.SelectAll(); //foreach (Pays p in listPays) //{ // Console.WriteLine(p.Name); //} //string fromton = "Abondance"; //Fromage myFromage = myDaoFromage.SelectByName(fromton); ////myFromage.Name = "Reblochon"; ////myDaoFromage.Update(myFromage); //Console.WriteLine("L'ID du " + fromton + ": " + myFromage.Id); }
public void InsertByFile(string Chemin) { using (var reader = new StreamReader(Chemin)) using (var csv = new CsvReader(reader, CultureInfo.InvariantCulture)) { var record = new Pays(); var records = csv.EnumerateRecords(record); foreach (Pays p in records) { Insert(p); } } }
public void InsertByFile(string Chemin) { using (var reader = new StreamReader(Chemin)) using (var csv = new CsvReader(reader, CultureInfo.InvariantCulture)) { csv.Configuration.Delimiter = ";"; csv.Configuration.PrepareHeaderForMatch = (string header, int index) => header.ToLower(); var record = new Pays(); var records = csv.EnumerateRecords(record); foreach (Pays pays in records) { Insert(pays); } } }
static void Main(string[] args) { Console.WriteLine("Hello World!"); mydbal = new Dbal("clubfromage"); myPays = new Pays(); myDaoPays = new DaoPays(mydbal); //myDaoPays.Insert(myPays); //myDaoPays.InsertFromCSV("C:\\Users\\ÉtienneBuffet\\Source\\Repos\\ClubFromage\\coucheModel\\pays.csv"); //myFromage = new Fromage(2,"Reblochon",default,myPays,default); myDaoFromage = new DaoFromage(mydbal, myDaoPays); //myDaoPays.InsertFromCSV("D:\\Project Antoine Girard\\SLAM5\\ClubFromageFinal\\ModelLayer\\import files\\pays.csv"); myDaoFromage.InsertFromCSV("D:\\Project Antoine Girard\\SLAM5\\ClubFromageFinal\\ModelLayer\\import files\\tableauNomDep.csv"); //myDaoFromage.Insert(myFromage); //myDaoFromage.InsertFromCSV("C:\\Users\\ÉtienneBuffet\\Source\\Repos\\ClubFromage\\coucheModel\\tableauNomDep.csv"); //List<Fromage> myFromages = myDaoFromage.SelectAll(); //foreach (Fromage f in myFromages) //{ // Console.WriteLine(f.Name); //} /* List <Pays> listPays = myDaoPays.SelectAll(); * foreach (Pays p in listPays) * { * Console.WriteLine(p.Name); * } * //string fromton = "Abondance"; * //Fromage myFromage = myDaoFromage.SelectByName(fromton); * ////myFromage.Name = "Reblochon"; * ////myDaoFromage.Update(myFromage); * //Console.WriteLine("L'ID du " + fromton + ": " + myFromage.Id); * */ }
static void Main(string[] args) { DBAL clubfromage = new DBAL(); string requetesql; //clubfromage.Insert(requetesql); requetesql = "SELECT * FROM Pays;"; //clubfromage.Select(requetesql); requetesql = " Pays SET nom = 'Brezil' WHERE id=1 ;"; //clubfromage.Update(requetesql); requetesql = " Pays WHERE idPays = 1;"; //clubfromage.Delete(requetesql); requetesql = " Pays VALUES (1,'France');"; requetesql = "SELECT * FROM Pays;"; requetesql = " Pays SET nom = 'Brezil' WHERE idPays=1 ;"; requetesql = " Pays WHERE idPays = 1;"; //clubfromage.Delete(reque Pays unPays = new Pays(4, "Belgique"); daoPays undaoPays = new daoPays(clubfromage); daoFromage undaofromage = new daoFromage(clubfromage, undaoPays); //undaoPays.Insert(unPays); //DateTime unedate = new DateTime(0 , 0 , 0,15,0,0); //DateTime uneautredate = new DateTime(2000, 5, 25); //Console.WriteLine(unedate); ///DateTime DureeAffinage = new DateTime(0, 0, 0, 15, 0, 0); ///DateTime DateCreation = new DateTime(2000, 5, 25); ///Fromage camenbert = new Fromage(15, 4, "camenbert", DureeAffinage,DateCreation, "le lait ...", "un laitier ..."); //undaoPays.Delete(unPays); unPays.setNom("France"); undaoPays.Update(unPays); ///undaofromage.Insert(camenbert); undaoPays.InsertByFile("D:\\Axel_Groussaud\\Projets.Exercices_visual_studio\\ClubFromage\\ClubFromage\\bin\\Debug\\pays.csv"); }
public void Delete(Pays unPays) { string query = "Pays WHERE idPays = " + unPays.getIdPays() + ";"; this._DBAL.Delete(query); }
public void Update(Pays unPays) { string query = "Pays SET idPays = " + unPays.getIdPays() + ", nom = '" + unPays.getNom().Replace("'", "''") + "' WHERE idPays = " + unPays.getIdPays() + " ;"; this._DBAL.Update(query); }
public void Insert(Pays unPays) { string query = " Pays VALUES " + "(" + unPays.getIdPays() + ",'" + unPays.nom.Replace("'", "''") + "');"; this._DBAL.Insert(query); }
public void Delete(Pays unPays) { string query = "Pays WHERE ID = " + unPays.getIdPays() + ";"; this._dbal.Delete(query); }
public void Update(Pays unPays) { string query = "Pays SET ID = " + unPays.getIdPays() + ", nomPays = '" + unPays.getNom().Replace("'", "''") + "' WHERE ID = " + unPays.getIdPays() + " ;"; this._dbal.Update(query); }
public void Insert(Pays unPays) { string query = "Pays VALUES " + "(" + unPays.getIdPays() + ",'" + unPays.getNom() + "');"; this._DBAL.Insert(query); }