public void Insert(PersonStatus personStatus)
 {
     using (IDbConnection dbConnection = Connection)
     {
         dbConnection.Open();
         dbConnection.Execute(
             "insert into Person(FirstName, LastName, PersonStatusID) "
             + "values(@FirstName, @LastName, @PersonStatusID);"
             , new {
             FirstName      = personStatus.FirstName,
             LastName       = personStatus.LastName,
             PersonStatusID = personStatus.PersonStatusID
         }
             , commandType: CommandType.Text);
     }
 }
 public void Update(PersonStatus personStatus)
 {
     using (IDbConnection dbConnection = Connection)
     {
         dbConnection.Open();
         dbConnection.Execute(
             "update Person "
             + "set FirstName = @FirstName, LastName = @LastName, PersonStatusID = @PersonStatusID "
             + "where PersonID = @PersonID;"
             , new {
             PersonID       = personStatus.PersonID,
             FirstName      = personStatus.FirstName,
             LastName       = personStatus.LastName,
             PersonStatusID = personStatus.PersonStatusID
         }
             , commandType: CommandType.Text);
     }
 }