public void update(avis unavis) { string AvisUpdate; AvisUpdate = ("avis set idAvis ='" + unavis.IdAvis + "', idClient = '" + unavis.LeClient + "', idSalle ='" + unavis.IdSalle + "', avis = '" + unavis.Avis.Replace("'", "''") + "'"); _dbal.Update(AvisUpdate); }
public void delete(avis unavis) { string AvisDelete; AvisDelete = ("avis where id ='" + unavis.IdAvis + "'"); _dbal.Delete(AvisDelete); }
public void insert(avis unavis) { string AvisInsert; AvisInsert = ("avis (idAvis, idClient, idSalle, avis) values (" + unavis.IdAvis + "," + unavis.LeClient + "," + unavis.IdSalle + ",'" + unavis.Avis.Replace("'", "''") + "')"); _dbal.Insert(AvisInsert); }
public void insert(avis unavis, Clients unClient, salles uneSalle) { string AvisInsert; AvisInsert = ("avis (idAvis, idClient, idSalle, avis) values (" + unavis.IdAvis + "," + unClient.getIdClient() + "," + uneSalle.IdSalle + ",'" + unavis.Avis.Replace("'", "''") + "')"); _dbal.Insert(AvisInsert); }
public void InsertFromCSV(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 avis(); IEnumerable <avis> records = csv.EnumerateRecords(record); foreach (avis avis in records) { insert(avis); } } }