public async Task <int> UpdatePerson(PersonModel person)
{
string query = "update people set FirstName=@FirstName,LastName=@LastName,City=@City,Email=@Email where Id=@Id";
IDataParameter[] parameters =
{
_dBManager.CreateParameter("FirstName", person.FirstName, DbType.String),
_dBManager.CreateParameter("LastName", person.LastName, DbType.String),
_dBManager.CreateParameter("City", person.City.Id, DbType.String),
_dBManager.CreateParameter("Email", person.Email, DbType.String),
_dBManager.CreateParameter("Id", person.Id, DbType.Int32)
};
return(await _dBManager.ExecuteNonQueryAsync(query, CommandType.Text, parameters));
}
public async Task <int> ExecuteNonQueryAsync(string query, CancellationToken cancellation = default)
{
return(await manager.ExecuteNonQueryAsync(query, cancellation));
}
