public ActionResult <Ride_Passenger> Post([FromBody] Ride_Passenger data) { try { return(Ok(_repo.Create(data))); } catch (Exception e) { return(BadRequest(e)); } }
public Ride_Passenger GetById(int id) { string query = "SELECT * FROM ride_passengers WHERE id = @Id"; Ride_Passenger data = _db.QueryFirstOrDefault <Ride_Passenger>(query, new { id }); if (data == null) { throw new Exception("Invalid ID"); } return(data); }
public ActionResult <Ride_Passenger> Put(int id, [FromBody] Ride_Passenger data) { try { data.Id = id; return(Ok(_repo.Update(data))); } catch (Exception e) { return(BadRequest(e)); } }
public Ride_Passenger Create(Ride_Passenger data) { string query = @" INSERT INTO ride_passengers (rideId, passengerId) VALUES (@RideId, @PassengerId); SELECT LAST_INSERT_ID(); "; int id = _db.ExecuteScalar <int>(query, data); data.Id = id; return(data); }
public Ride_Passenger Update(Ride_Passenger data) { string query = @" UPDATE ride_passengers SET passengerId = @PassengerId, rideId = @RideId, WHERE id = @Id ; SELECT * FROM ride_passengers WHERE id = @Id ; "; return(_db.QueryFirstOrDefault <Ride_Passenger>(query, data)); }