public void InsertPays(Pays unPays)
{
Dictionary <string, string> values = new Dictionary <string, string>();
values["id"] = unPays.Id.ToString();
values["nom"] = "'" + unPays.Nom.Replace("'", "\\'") + "'";
mydbal.Insert("pays", values);
}
public void InsertFromage(Fromage unFromage)
{
Dictionary <string, string> values = new Dictionary <string, string>();
values["id"] = unFromage.Id.ToString();
values["pays_origine_id"] = unFromage.Pays_origine_id.ToString();
values["nom"] = "'" + unFromage.Nom.Replace("'", "\\'") + "'";
values["creation"] = "'" + unFromage.Creation.ToString("yyyy'-'MM'-'dd") + "'";
values["image"] = "'" + unFromage.Image.Replace("'", "\\'") + "'";
mydbal.Insert("fromage", values);
}
public void Insert(Fromage Unfromage)
{
Console.WriteLine("INSERT INTO fromage (id,pays_origine_id,nom,creation,image) values (" + Unfromage.Id + ", " + Unfromage.Idpays.Id + ", '" + Unfromage.Nom + "', " + Unfromage.Creation + ", '" + Unfromage.Image + "') ;");
_mydbal.Insert("INSERT INTO fromage (id,pays_origine_id,nom,creation,image) values (" + Unfromage.Id + ", " + Unfromage.Idpays.Id + ", '" + Unfromage.Nom + "', '" + Unfromage.Creation + "', '" + Unfromage.Image + "') ;");
}
public void Insert(Pays Unpays) //insérer une ligne
{
Console.WriteLine("INSERT INTO pays (id,nom) values (" + Unpays.Id + ", '" + Unpays.Nom + "');");
_mydbal.Insert("INSERT INTO pays (id,nom) values (" + Unpays.Id + ", '" + Unpays.Nom.Replace("'", "''") + "');");
}
