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