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