public void Insert(Placement_Obstacle thePlacement_Obstacle)
{
string query = "Placement_obstacle(num_placement, reservation, obstacle) VALUES ("
+ thePlacement_Obstacle.Num_placement + ","
+ thePlacement_Obstacle.Reservation.id + ","
+ thePlacement_Obstacle.Obstacle.Id + ")";
this.thedbal.Insert(query);
}
public void Update(Placement_Obstacle myPlacement_Obs, Reservation myReservation, Obstacle myObstacle)
{
string query = " Placement_obstacle Set num_placement=" + myPlacement_Obs.Num_placement
+ ", reservation = " + myReservation.Id
+ ", obstacle = " + myObstacle.Id
+ "WHERE num_placement =" + myPlacement_Obs.Num_placement;
this.thedbal.Update(query);
}
public void InsertFromCSV(string filename)
{
using (var reader = new StreamReader(filename))
using (var csv = new CsvReader(reader, CultureInfo.InvariantCulture))
{
csv.Configuration.Delimiter = ";";
csv.Configuration.PrepareHeaderForMatch = (string header, int index) => header.ToLower();
var record = new Placement_Obstacle();
var records = csv.EnumerateRecords(record);
foreach (Placement_Obstacle r in records)
{
Console.WriteLine(r.Num_placement + "-" + r.Reservation.id + "-" + r.Obstacle.Id);
this.Insert(record);
}
}
public void Delete(Placement_Obstacle unPlacement_obs)
{
string query = "Placement_obstacle where id= " + unPlacement_obs.Num_placement + ";";
this.thedbal.Delete(query);
}
public void Update(Placement_Obstacle myPlacement_Obstacle)
{
string query = "Placement_ob"
}
