public void update(salles unesalle, theme untheme)
{
string SalleUpdate;
SalleUpdate = ("salles set id ='" + unesalle.IdSalle + "' , nom = '" + unesalle.Ville.Replace("'", "''") + untheme.IdTheme + "'");
_dbal.Update(SalleUpdate);
}
public void delete(salles unesalle)
{
string SalleDelete;
SalleDelete = ("salle where id ='" + unesalle.IdSalle + "'");
_dbal.Delete(SalleDelete);
}
public void insert(salles unesalle, theme untheme)
{
string SalleInsert;
SalleInsert = ("salle (idSalle, ville, idTheme) values (" + unesalle.IdSalle + ",'" + unesalle.Ville.Replace("'", "''") + "'," + untheme.IdTheme + ")");
_dbal.Insert(SalleInsert);
}
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 salles();
IEnumerable <salles> records = csv.EnumerateRecords(record);
foreach (salles salle in records)
{
insert(salle);
}
}
}
