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