public void UpdateFruitsUnitCost(IDbConnection connection, DecreaseFruitsUnitCost decreaseFruitsUnitCost, IDbTransaction transaction = null) { IEnumerable <Product> products = this.productRepository.SelectAllFruits(connection); foreach (Product product in products) { product.UnitCost.Value = decreaseFruitsUnitCost.Percent.Content * product.UnitCost.Value; this.productRepository.Update(connection, product, transaction); } }
public void DecreaseUnitcostFruits(DecreaseFruitsUnitCostDto decreaseFruitsUnitCostDto) { using (NpgsqlConnection connection = this.databaseConnectionFactory.Instance.Create()) { connection.Open(); using (var transaction = connection.BeginTransaction()) { try { DecreaseFruitsUnitCost decreaseFruitsUnitCost = this.dtoToEntityMapper.Map <DecreaseFruitsUnitCostDto, DecreaseFruitsUnitCost>(decreaseFruitsUnitCostDto); this.productService.UpdateFruitsUnitCost(connection, decreaseFruitsUnitCost, transaction); } catch (Exception ex) { transaction.Rollback(); Console.Write(ex.Message); } } } }