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);
}
