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