private void GetParentCategories()
        {
            List <BalanceAccount> allCategories = BalanceAccounts.GetAll();
            BalanceAccount        parent        = new BalanceAccount();
            BalanceAccount        mainParent    = new BalanceAccount();

            foreach (BalanceAccountResultDetailItem item in ActiveAccountDetailedList)
            {
                if (item.ParentId != 0)
                {
                    parent = allCategories.Single(x => x.BalanceAccountId == item.ParentId);
                    item.Sub1CategoryName = parent.Name;
                    if (parent.ParentId != 0)
                    {
                        mainParent            = allCategories.Single(x => x.BalanceAccountId == parent.ParentId);
                        item.MainCategoryName = mainParent.Name;
                    }
                }
            }

            foreach (BalanceAccountResultDetailItem item in PassiveAccountDetailedList)
            {
                if (item.ParentId != 0)
                {
                    parent = allCategories.Single(x => x.BalanceAccountId == item.ParentId);
                    item.Sub1CategoryName = parent.Name;
                    if (parent.ParentId != 0)
                    {
                        mainParent            = allCategories.Single(x => x.BalanceAccountId == parent.ParentId);
                        item.MainCategoryName = mainParent.Name;
                    }
                }
            }
        }
        public void GetAndCalculateData(DateTime StartDate, DateTime EndDate)
        {
            DateTime newEndDate = new DateTime(EndDate.Year, EndDate.Month, EndDate.Day, 23, 59, 59);

            ActiveAccountList         = BalanceAccounts.GetActiveAccounts(StartDate, newEndDate).ToSvenTechCollection();
            ActiveAccountDetailedList = BalanceAccounts.GetActiveAccountsDetailed(StartDate, newEndDate).ToSvenTechCollection();
            PassiveAccountList        = BalanceAccounts.GetPassiveAccounts(StartDate, newEndDate).ToSvenTechCollection();
            //PassiveAccountDetailedList = BalanceAccounts.GetPassiveAccountsDetailed(StartDate, newEndDate).ToSvenTechCollection();

            // CalculateSums();
            CalculateCompensation();
            //GetParentCategories();

            RaisePropertyChanged("SumActiveAccounts");
            RaisePropertyChanged("SumPassiveAccounts");
            //RaisePropertyChanged("ActiveAccountDetailedList");
            //RaisePropertyChanged("PassiveAccountDetailedList");
        }