public StoredBalanceSetDto CalculateBalanceSet(string accountsChartUID, string balanceSetUID)
{
StoredBalanceSet balanceSet = ParseBalanceSet(accountsChartUID, balanceSetUID);
balanceSet.Calculate();
return(StoredBalanceSetMapper.MapWithBalances(balanceSet));
}
static internal StoredBalanceSetDto MapWithBalances(StoredBalanceSet balanceSet)
{
var dto = Map(balanceSet);
dto.Balances = MapBalances(balanceSet.Balances);
return(dto);
}
static internal void DeleteBalances(StoredBalanceSet storedBalanceSet)
{
var sql = $"DELETE FROM COF_SALDOS " +
$"WHERE (ID_GRUPO_SALDOS = {storedBalanceSet.Id})";
var dataOperation = DataOperation.Parse(sql);
DataWriter.Execute(dataOperation);
}
public FixedList <StoredBalanceSetDto> BalanceSetsList(string accountsChartUID)
{
Assertion.AssertObject(accountsChartUID, "accountsChartUID");
var accountsChart = AccountsChart.Parse(accountsChartUID);
FixedList <StoredBalanceSet> list = StoredBalanceSet.GetList(accountsChart);
return(StoredBalanceSetMapper.Map(list));
}
static internal FixedList <StoredBalance> GetBalances(StoredBalanceSet balanceSet)
{
var sql = "SELECT * FROM VW_COF_SALDOS " +
$"WHERE ID_GRUPO_SALDOS = {balanceSet.Id} " +
$"ORDER BY ID_MAYOR, ID_MONEDA, NUMERO_CUENTA_ESTANDAR, " +
$"ID_SECTOR, NUMERO_CUENTA_AUXILIAR";
var op = DataOperation.Parse(sql);
return(DataReader.GetFixedList <StoredBalance>(op));
}
static internal StoredBalanceSetDto Map(StoredBalanceSet balanceSet)
{
return(new StoredBalanceSetDto {
UID = balanceSet.UID,
Name = balanceSet.Name,
AccountsChart = balanceSet.AccountsChart.MapToNamedEntity(),
BalancesDate = balanceSet.BalancesDate,
Calculated = balanceSet.Calculated,
CalculationTime = balanceSet.CalculationTime,
Protected = balanceSet.Protected
});
}
private StoredBalanceSet ParseBalanceSet(string accountsChartUID, string balanceSetUID)
{
Assertion.AssertObject(accountsChartUID, "accountsChartUID");
Assertion.AssertObject(balanceSetUID, "balanceSetUID");
var accountsChart = AccountsChart.Parse(accountsChartUID);
var balanceSet = StoredBalanceSet.Parse(balanceSetUID);
Assertion.Assert(balanceSet.AccountsChart.Equals(accountsChart),
"The requested balance set does not belong to the given accounts chart.");
return(balanceSet);
}
public StoredBalanceSetDto CreateOrGetBalanceSet(string accountsChartUID,
BalanceStorageCommand command)
{
Assertion.AssertObject(accountsChartUID, "accountsChartUID");
Assertion.AssertObject(command, "command");
var accountsChart = AccountsChart.Parse(accountsChartUID);
var storedBalanceSet = StoredBalanceSet.CreateOrGetBalanceSet(accountsChart, command.BalancesDate);
storedBalanceSet.Save();
return(StoredBalanceSetMapper.Map(storedBalanceSet));
}
internal TrialBalanceCommandData GetTrialBalanceCommandData(TrialBalanceCommandPeriod commandPeriod)
{
var commandData = new TrialBalanceCommandData();
var accountsChart = AccountsChart.Parse(_command.AccountsChartUID);
StoredBalanceSet balanceSet = StoredBalanceSet.GetBestBalanceSet(
accountsChart, commandPeriod.FromDate);
commandData.StoredInitialBalanceSet = balanceSet;
commandData.FromDate = commandPeriod.FromDate;
commandData.ToDate = commandPeriod.ToDate;
commandData.InitialFields = GetInitialFields();
commandData.Fields = GetOutputFields();
commandData.Filters = GetFilterString();
commandData.AccountFilters = GetAccountFilterString();
commandData.InitialGrouping = GetInitialGroupingClause();
commandData.Grouping = GetGroupingClause();
commandData.Having = GetHavingClause();
commandData.Ordering = GetOrderClause();
commandData.AccountsChart = accountsChart;
return(commandData);
}
