private async void InsertGroupAccountSumRows()
{
List <BalanceSheetModel> list = _filterDataGrid.Cast <BalanceSheetModel>().ToList();
BalanceList = new ObservableCollection <BalanceSheetModel>();
var accounts = await _bookAccountsEndpoint.GetAll();
for (int i = 0; i < 10; i++)
{
string par = i.ToString();
decimal potrazna = list.Where(x => x.Konto.StartsWith(par)).Sum(y => y.Potrazna);
decimal dugovna = list.Where(x => x.Konto.StartsWith(par)).Sum(y => y.Dugovna);
decimal stanje = list.Where(x => x.Konto.StartsWith(par)).Sum(y => y.Stanje);
if (dugovna == 0 && potrazna == 0 && stanje == 0)
{
continue;
}
else
{
BalanceList.Add(new BalanceSheetModel
{
Konto = i.ToString(),
Dugovna = dugovna,
Potrazna = potrazna,
Stanje = stanje,
Opis = accounts.FirstOrDefault(x => x.Konto == par).Opis
});
}
for (int j = 0; j < 10; j++)
{
for (int k = 0; k < 10; k++)
{
string param = i.ToString() + j.ToString() + k.ToString();
potrazna = list.Where(x => x.Konto.StartsWith(param)).Sum(y => y.Potrazna);
dugovna = list.Where(x => x.Konto.StartsWith(param)).Sum(y => y.Dugovna);
stanje = list.Where(x => x.Konto.StartsWith(param)).Sum(y => y.Stanje);
BalanceList.AddRange(list.Where(x => x.Konto.StartsWith(param) && x.Konto.Length > 3));
if (dugovna == 0 && potrazna == 0)
{
continue;
}
else
{
BalanceList.Add(new BalanceSheetModel
{
Konto = param,
Dugovna = dugovna,
Potrazna = potrazna,
Stanje = stanje,
Opis = accounts.FirstOrDefault(x => x.Konto == param).Opis
});
}
}
}
}
FilterDataGridView();
}
public async void LoadAccounts()
{
var list = await _bookAccountsEndpoint.GetAll();
Accounts = new ObservableCollection <BookAccountModel>(list);
_filterView = CollectionViewSource.GetDefaultView(Accounts);
_filterView.Filter = o => string.IsNullOrEmpty(FilterKonto) ?
true : (((BookAccountModel)o).Konto.Contains(FilterKonto) || ((BookAccountModel)o).Opis.ToLower().Contains(FilterKonto.ToLower()));
}
private async void LoadAccounts()
{
StatusMessage = "Učitavam kontni plan...";
var list = await _bookAccountsEndpoint.GetAll();
StatusMessage = null;
Accounts = new ObservableCollection <BookAccountModel>(list);
_filterView = CollectionViewSource.GetDefaultView(Accounts);
_filterView.Filter = o => string.IsNullOrEmpty(FilterKonto) ?
true : (((BookAccountModel)o).Konto.Contains(FilterKonto) || ((BookAccountModel)o).Opis.ToLower().Contains(FilterKonto.ToLower()));
}
