private int AddRow(IXLWorksheet worksheet, int rowIdx, PortfolioPositionModel transaction)
{
var colIdx = 1;
worksheet.Cell(rowIdx, colIdx++).Value = transaction.PortfolioId;
worksheet.Cell(rowIdx, colIdx++).Value = transaction.Isin;
worksheet.Cell(rowIdx, colIdx++).Value = transaction.Name;
worksheet.Cell(rowIdx, colIdx++).Value = transaction.Amount;
worksheet.Cell(rowIdx, colIdx++).Value = transaction.DateTime;
worksheet.Cell(rowIdx, colIdx++).Value = transaction.CurrentValue;
worksheet.Cell(rowIdx, colIdx++).Value = transaction.CurrentValueCurrencyIso;
worksheet.Cell(rowIdx, colIdx++).FormulaR1C1 = $"R{rowIdx}C4*R{rowIdx}C6";
worksheet.Cell(rowIdx, colIdx++).Value = transaction.OriginalValue;
worksheet.Cell(rowIdx, colIdx++).Value = transaction.OriginalValueCurrencyIso;
worksheet.Cell(rowIdx, colIdx++).FormulaR1C1 = $"R{rowIdx}C4*R{rowIdx}C9";
return(colIdx);
}
public PortfolioPositionModel CreatePortfolioSalePosition(PortfolioPositionModel model)
{
var portfolio = PortfolioRepository.GetById(model.PortfolioId);
var otherPosOfIsin =
PortfolioPositionRepository
.Query()
.First(positionEntity => positionEntity.Isin == model.Isin && positionEntity.Name != null);
var entity = new SalePositionEntity
{
Amount = 0,
DateTime = model.DateTime,
Isin = model.Isin,
Name = otherPosOfIsin.Name,
CurrentValueCurrencyIso = otherPosOfIsin.CurrentValueCurrencyIso,
OriginalValueCurrencyIso = otherPosOfIsin.OriginalValueCurrencyIso,
Portfolio = portfolio
};
var insertedEntity = PortfolioPositionRepository.Insert(entity);
PortfolioPositionRepository.Save();
return(Mapper.Map <PortfolioPositionModel>(insertedEntity));
}
public IActionResult CreatePortfolioSalePosition([FromBody] PortfolioPositionModel model)
{
return(Json(TransactionService.CreatePortfolioSalePosition(model)));
}
