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