public BalanceItems GetItems(int clientId)
{
var itemsDao = _dbContext.BalanceReport.Where(c => c.ClientId.Equals(clientId)).OrderBy(c => c.RowId).ToList();
var items = Converter.ConvertList<BalanceReportItemDao, BalanceReportItem>(itemsDao);
var result = new BalanceItems
{
Actives = items.Where(c => c.Type.ToUpper().Equals("AKTYWA")).ToList(),
Passives = items.Where(c => c.Type.ToUpper().Equals("PASYWA")).ToList()
};
return result;
}
public void SaveItems(int clientId, BalanceItems items)
{
var flatenedItems = new List<BalanceReportItem>();
flatenedItems.AddRange(items.Actives);
flatenedItems.AddRange(items.Passives);
var result = _dbContext.BalanceReport.Where(c => c.ClientId.Equals(clientId)).ToList();
foreach (var row in result)
{
var newItem = flatenedItems.FirstOrDefault(c => c.Id.Equals(row.Id));
if (newItem != null)
row.Formula = newItem.Formula;
_dbContext.BalanceReport.AddOrUpdate(row);
}
_dbContext.SaveChanges();
}
public ActionResult SaveBalanceItems(int clientId, BalanceItems items)
{
_factory.GetBalanceService().SaveItems(clientId, items);
return new JsonResult { Data = true };
}
