public PersonPosition Create(PersonPosition item)
{
try
{
using (var con = new SqlConnection(_connectionString))
{
con.Open();
return(con.QuerySingleOrDefault <PersonPosition>($@"INSERT INTO [PersonPosition] ([PersonId], [PositionId])
VALUES (@{nameof(PersonPosition.PersonId)}, @{nameof(PersonPosition.PositionId)})", item));
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public bool Update(PersonPosition item)
{
try
{
using (var con = new SqlConnection(_connectionString))
{
con.Open();
int rowAffected = con.Execute($@"UPDATE [PersonPosition]
SET [Position] = @{nameof(PersonPosition.PositionId)}", item);
return(rowAffected > 0);
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}