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