public void Insert(TimeTravelLog timeTravelLog)
{
using (IDbConnection dbConnection = Connection)
{
dbConnection.Open();
dbConnection.Execute(
"insert into timetravellog(TravelToYear, TravelDate, TimeTravelerId) "
+ "values(@TravelToYear, @TravelDate, @TimeTravelerId);"
, new {
TravelToYear = timeTravelLog.TravelToYear,
TravelDate = timeTravelLog.TravelDate,
TimeTravelerId = timeTravelLog.TimeTravelerId
}
, commandType: CommandType.Text);
}
}
public void Update(TimeTravelLog timeTravelLog)
{
using (IDbConnection dbConnection = Connection)
{
dbConnection.Open();
dbConnection.Execute(
"update timetravellog "
+ "set TravelToYear = @TravelToYear, TravelDate = @TravelDate, TimeTravelerId = @TimeTravelerId "
+ "where TimeTravelLogId = @TimeTravelLogId;"
, new {
TimeTravelLogId = timeTravelLog.TimeTravelLogId,
TravelToYear = timeTravelLog.TravelToYear,
TravelDate = timeTravelLog.TravelDate,
TimeTravelerId = timeTravelLog.TimeTravelerId
}
, commandType: CommandType.Text);
}
}
