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" }