Ejemplo n.º 1
0
        private BudgetData GetBudgetData(int budgetId, int year)
        {
            FinancialAccount account     = FinancialAccount.FromIdentity(budgetId);
            double           budget      = -account.GetBudget(year);
            Int64            actualCents = account.GetDeltaCents(new DateTime(year, 1, 1), new DateTime(year + 1, 1, 1));
            double           actual      = actualCents / 100.0;

            // Get suballocated

            FinancialAccounts accountTree = account.GetTree();

            double budgetTotal     = -accountTree.GetBudgetSum(year);
            Int64  deltaTotalCents = accountTree.GetDeltaCents(new DateTime(year, 1, 1), new DateTime(year + 1, 1, 1));
            double deltaTotal      = deltaTotalCents / 100.0;

            BudgetData result = new BudgetData();

            result.AccountName = account.Name;

            if (budgetTotal > 0.0)
            {
                result.PercentActual           = actual / budgetTotal * 100.0;
                result.PercentSuballocated     = (budgetTotal - budget) / budgetTotal * 100.0;
                result.PercentSuballocatedUsed = (deltaTotal - actual) / budgetTotal * 100.0;
            }

            return(result);
        }
Ejemplo n.º 2
0
    protected void ButtonSetBudgets_Click(object sender, EventArgs e)
    {
        foreach (RepeaterItem repeaterItem in this.RepeaterAccountBudgets.Items)
        {
            HiddenField      hiddenAccountId = (HiddenField)repeaterItem.FindControl("HiddenAccountId");
            TextBox          textBudget      = (TextBox)repeaterItem.FindControl("TextBudget");
            FinancialAccount account         = FinancialAccount.FromIdentity(Int32.Parse(hiddenAccountId.Value));

            // TODO: Possible race condition here, fix with HiddenField

            Int64 newBudgetAmount = Int64.Parse(textBudget.Text.Replace(",", "").Replace(" ", ""), Thread.CurrentThread.CurrentCulture);  // TODO: May throw -- catch and send error message

            Int64 currentBudgetAmount = account.GetTree().GetBudgetSumCents(_year) / 100;

            // Set the new amount to the difference between the single budget of this account and the intended amount

            if (newBudgetAmount != currentBudgetAmount)
            {
                account.SetBudgetCents(_year,
                                       account.GetBudgetCents(_year) + (newBudgetAmount - currentBudgetAmount) * 100);
            }
        }

        // After updating budgets, rebind repeater

        FinancialAccounts accounts = GetRootLevelResultAccounts();

        UpdateYearlyResult(accounts);

        this.RepeaterAccountBudgets.DataSource = accounts;
        this.RepeaterAccountBudgets.DataBind();
    }
Ejemplo n.º 3
0
        public static JsonAccountData GetAccountData(int accountId)
        {
            AuthenticationData authData = GetAuthenticationDataAndCulture();

            FinancialAccount account = FinancialAccount.FromIdentity(accountId);

            if (account.OrganizationId != authData.CurrentOrganization.Identity)
            {
                throw new UnauthorizedAccessException("A million nopes");
            }

            FinancialAccounts accountTree = account.GetTree();
            int year = DateTime.Today.Year;

            JsonAccountData result = new JsonAccountData();

            result.AccountName       = account.Name;
            result.ParentAccountId   = account.ParentIdentity;
            result.ParentAccountName = account.ParentFinancialAccountId == 0
                ? Global.ResourceManager.GetString("Financial_" +
                                                   account.AccountType)
                : account.Parent.Name;
            result.Expensable            = account.Expensable;
            result.Administrative        = account.Administrative;
            result.Active                = account.Active;
            result.Open                  = account.Open;
            result.AccountOwnerName      = account.OwnerPersonId != 0 ? account.Owner.Name : Global.Global_NoOwner;
            result.AccountOwnerAvatarUrl = account.OwnerPersonId != 0
                ? account.Owner.GetSecureAvatarLink(24)
                : "/Images/Icons/iconshock-warning-24px.png";
            result.Budget = (accountTree.GetBudgetSumCents(year) / 100L).ToString("N0", CultureInfo.CurrentCulture);

            if (account.AccountType == FinancialAccountType.Asset || account.AccountType == FinancialAccountType.Debt)
            {
                result.Balance =
                    (accountTree.GetDeltaCents(new DateTime(1900, 1, 1), new DateTime(year + 1, 1, 1)) / 100L).ToString
                    (
                        "N0");
                result.InitialBalance =
                    ((accountTree.GetDeltaCents(new DateTime(1900, 1, 1),
                                                new DateTime(authData.CurrentOrganization.FirstFiscalYear, 1, 1)) / 100.0).ToString("N2"));
            }
            else
            {
                result.Balance =
                    (-accountTree.GetDeltaCents(new DateTime(year, 1, 1), new DateTime(year + 1, 1, 1)) / 100L)
                    .ToString(
                        "N0");
                result.InitialBalance = "N/A"; // unused
            }
            result.CurrencyCode = account.Organization.Currency.DisplayCode;

            return(result);
        }
    public void Populate(FinancialAccount root)
    {
        this.Tree.Nodes.Clear();
        FinancialAccounts accounts = root.GetTree();
        accounts.Remove(root);

        if (accounts.Count > 0)
        {
            Populate(accounts);
        }
    }
Ejemplo n.º 5
0
    public void Populate(FinancialAccount root)
    {
        this.Tree.Nodes.Clear();
        FinancialAccounts accounts = root.GetTree();

        accounts.Remove(root);

        if (accounts.Count > 0)
        {
            Populate(accounts);
        }
    }
Ejemplo n.º 6
0
    protected void RepeaterAccountBudgets_ItemDataBound(object sender, RepeaterItemEventArgs e)
    {
        RepeaterItem item = e.Item;

        if (item.DataItem == null)
        {
            return;
        }

        FinancialAccount account = (FinancialAccount)item.DataItem;

        TextBox textBudget = (TextBox)e.Item.FindControl("TextBudget");

        if (this._year > 0) // called from after viewstate parsed
        {
            textBudget.Text = String.Format("{0:N0}", account.GetTree().GetBudgetSumCents(this._year) / 100);
            textBudget.Style[HtmlTextWriterStyle.TextAlign] = "right";
            textBudget.Style[HtmlTextWriterStyle.Width]     = "80px";
        }

        Label  labelOwnerName = (Label)e.Item.FindControl("LabelBudgetOwner");
        Person accountOwner   = account.Owner;

        if (accountOwner == null)
        {
            labelOwnerName.Text = Global.Global_NoOwner;
        }
        else
        {
            labelOwnerName.Text = accountOwner.Formal;
        }

        // RadToolTip toolTip = (RadToolTip)e.Item.FindControl("ToolTip");

        // Swarmops.Controls.Swarm.PersonDetailPopup personDetail = (PersonDetailPopup)toolTip.FindControl("PersonDetail");
        // personDetail.PersonChanged += new PersonChangedEventHandler(PersonDetail_PersonChanged);

        if (!Page.IsPostBack && CurrentAuthority != null)
        {
/*
 *          personDetail.Person = accountOwner;
 *          personDetail.Cookie = account;*/
        }

        HiddenField hiddenAccountId = (HiddenField)e.Item.FindControl("HiddenAccountId");

        hiddenAccountId.Value = account.Identity.ToString();

        // this.TooltipManager.TargetControls.Add(labelBudgetOwner.ClientID, line.AccountIdentity.ToString(), true);
    }
Ejemplo n.º 7
0
    protected void DropBudgets_SelectedIndexChanged(object sender, EventArgs e)
    {
        if (this.DropBudgets.SelectedValue != "0")
        {
            FinancialAccount selectedBudget = FinancialAccount.FromIdentity(Int32.Parse(this.DropBudgets.SelectedValue));

            if (selectedBudget.GetTree().Count > 1)
            {
                this.DropSubBudget.Populate(selectedBudget);
                this.DropMethod.Items[4].Enabled = true;
            }
            else
            {
                this.DropMethod.Items[4].Enabled = false;
            }
        }
    }
Ejemplo n.º 8
0
        public static ChangeAccountDataResult SetAccountBudget(int accountId, string budget)
        {
            AuthenticationData authData = GetAuthenticationDataAndCulture();
            FinancialAccount   account  = FinancialAccount.FromIdentity(accountId);

            if (!PrepareAccountChange(account, authData, false))
            {
                return(new ChangeAccountDataResult
                {
                    Result = ChangeAccountDataOperationsResult.NoPermission
                });
            }

            Int64 newTreeBudget;

            budget = budget.Replace("%A0", "%20"); // some very weird browser space-to-otherspace translation weirds out number parsing
            budget = HttpContext.Current.Server.UrlDecode(budget);

            if (budget.Trim().Length > 0 && Int64.TryParse(budget, NumberStyles.Currency, CultureInfo.CurrentCulture, out newTreeBudget))
            {
                newTreeBudget *= 100; // convert to cents

                int year = DateTime.Today.Year;
                FinancialAccounts accountTree         = account.GetTree();
                Int64             currentTreeBudget   = accountTree.GetBudgetSumCents(year);
                Int64             currentSingleBudget = account.GetBudgetCents(year);
                Int64             suballocatedBudget  = currentTreeBudget - currentSingleBudget;

                Int64 newSingleBudget = newTreeBudget - suballocatedBudget;

                account.SetBudgetCents(DateTime.Today.Year, newSingleBudget);
                return(new ChangeAccountDataResult
                {
                    Result = ChangeAccountDataOperationsResult.Changed,
                    NewData = (newTreeBudget / 100).ToString("N0", CultureInfo.CurrentCulture)
                });
            }
            else
            {
                return(new ChangeAccountDataResult
                {
                    Result = ChangeAccountDataOperationsResult.Invalid
                });
            }
        }
Ejemplo n.º 9
0
    /*
     * protected void RebindTooltips()
     * {
     *  foreach (RepeaterItem repeaterItem in this.RepeaterAccountBudgets.Items)
     *  {
     *      HiddenField hiddenAccountId = (HiddenField)repeaterItem.FindControl("HiddenAccountId");
     *      FinancialAccount child = FinancialAccount.FromIdentity(Int32.Parse(hiddenAccountId.Value));
     *      RadToolTip toolTip = (RadToolTip)repeaterItem.FindControl("ToolTip");
     *
     *      PersonDetailPopup personDetail = (PersonDetailPopup)toolTip.FindControl("PersonDetail");
     *
     *      FinancialAccount account = FinancialAccount.FromIdentity(Int32.Parse(hiddenAccountId.Value));
     *      personDetail.Person = account.Owner;
     *      personDetail.Cookie = child;
     *  }
     * }*/

    protected void RepeaterAccountActuals_ItemDataBound(object sender, RepeaterItemEventArgs e)
    {
        RepeaterItem item = e.Item;

        if (item.DataItem == null)
        {
            return;
        }

        FinancialAccount account = (FinancialAccount)item.DataItem;

        Label labelActuals = (Label)e.Item.FindControl("LabelAccountActuals");

        Int64 actuals = (account.GetTree().GetDeltaCents(new DateTime(_year, 1, 1), new DateTime(_year + 1, 1, 1)) + 50) /
                        100;

        labelActuals.Text = String.Format("{0:N0}", -actuals);  // negative as results accounts are sign reversed
    }
Ejemplo n.º 10
0
        public static ChangeAccountDataResult SetAccountBudget(int accountId, string budget)
        {
            try
            {
                AuthenticationData authData = GetAuthenticationDataAndCulture();
                FinancialAccount   account  = FinancialAccount.FromIdentity(accountId);

                if (!PrepareAccountChange(account, authData, false))
                {
                    return(new ChangeAccountDataResult
                    {
                        Result = ChangeAccountDataOperationsResult.NoPermission
                    });
                }

                Int64 newTreeBudget;
                budget = budget.Replace("%A0", "%20");
                // some very weird browser space-to-otherspace translation weirds out number parsing
                budget = HttpContext.Current.Server.UrlDecode(budget);

                if (budget.Trim().Length > 0 &&
                    Int64.TryParse(budget, NumberStyles.Currency, CultureInfo.CurrentCulture, out newTreeBudget))
                {
                    newTreeBudget *= 100; // convert to cents

                    int year = DateTime.Today.Year;
                    FinancialAccounts accountTree         = account.GetTree();
                    Int64             currentTreeBudget   = accountTree.GetBudgetSumCents(year);
                    Int64             currentSingleBudget = account.GetBudgetCents(year);
                    Int64             suballocatedBudget  = currentTreeBudget - currentSingleBudget;

                    Int64 newSingleBudget = newTreeBudget - suballocatedBudget;

                    account.SetBudgetCents(DateTime.Today.Year, newSingleBudget);

                    // Once we've set the budget, also update the "yearly result" budget.
                    // The "yearly result" budget isn't shown in the account plan, but is
                    // abstracted to "projected loss" or "projected gain" pseudobudgets.

                    int thisYear = DateTime.UtcNow.Year;
                    FinancialAccounts allProfitLossAccounts   = FinancialAccounts.ForOrganization(authData.CurrentOrganization);
                    Int64             newProfitLossProjection = allProfitLossAccounts.Where(queryAccount => queryAccount.Identity != authData.CurrentOrganization.FinancialAccounts.CostsYearlyResult.Identity).Sum(queryAccount => queryAccount.GetBudgetCents(thisYear));

                    authData.CurrentOrganization.FinancialAccounts.CostsYearlyResult.SetBudgetCents(thisYear, -newProfitLossProjection);

                    return(new ChangeAccountDataResult
                    {
                        Result = ChangeAccountDataOperationsResult.Changed,
                        NewData = (newTreeBudget / 100).ToString("N0", CultureInfo.CurrentCulture)
                    });
                }

                return(new ChangeAccountDataResult
                {
                    Result = ChangeAccountDataOperationsResult.Invalid
                });
            }
            catch (Exception weirdException)
            {
                // Exceptions are happening here in deployment ONLY. We're logging it to find which one and why.
                // TODO: This really needs to be in Logic. DO NOT DO NOT DO NOT call Database layer directly from Site layer.

                SwarmDb.GetDatabaseForWriting()
                .CreateExceptionLogEntry(DateTime.UtcNow, "AccountPlan-SetBudget", weirdException);

                throw;
            }
        }
Ejemplo n.º 11
0
    protected void ButtonReallocate_Click(object sender, EventArgs e)
    {
        FinancialAccounts children = _account.Children;

        double deltaTotal = 0.0;
        int    budgetAttempt;
        int    budgetTotal = 0;

        // In a first round, verify that all numbers are parsable

        foreach (RepeaterItem repeaterItem in this.RepeaterBudgetTextBoxes.Items)
        {
            HiddenField      hiddenAccountId = (HiddenField)repeaterItem.FindControl("HiddenAccountId");
            FinancialAccount child           = FinancialAccount.FromIdentity(Int32.Parse(hiddenAccountId.Value));

            TextBox box     = (TextBox)repeaterItem.FindControl("TextChildBudget");
            string  boxText = box.Text;
            if (!Int32.TryParse(boxText, NumberStyles.Number, new CultureInfo("sv-SE"), out budgetAttempt))
            {
                ScriptManager.RegisterStartupScript(this, Page.GetType(), "error",
                                                    "alert('The budget for the account \"" + Server.HtmlEncode(child.Name).Replace("'", "''") + "\" does not appear to be a valid number. Please correct this and try again.');",
                                                    true);
                return;
            }

            budgetTotal += budgetAttempt;
        }

        // Verify that the budget is not overrun by suballocations

        if (Math.Abs(budgetTotal) > Math.Abs(_account.GetTree().GetBudgetSum(_year)))
        {
            ScriptManager.RegisterStartupScript(this, Page.GetType(), "error",
                                                "alert('You are trying to overallocate the budget. Please correct this and try again.');",
                                                true);
            return;
        }

        // Then, move on to actually mod the budgets

        foreach (RepeaterItem repeaterItem in this.RepeaterBudgetTextBoxes.Items)
        {
            HiddenField      hiddenAccountId = (HiddenField)repeaterItem.FindControl("HiddenAccountId");
            FinancialAccount child           = FinancialAccount.FromIdentity(Int32.Parse(hiddenAccountId.Value));

            TextBox box       = (TextBox)repeaterItem.FindControl("TextChildBudget");
            string  boxText   = box.Text;
            double  newBudget = (double)Int32.Parse(boxText, NumberStyles.Number, new CultureInfo("sv-SE"));
            double  curBudget = child.GetTree().GetBudgetSum(_year);

            // since we don't know here how much has been suballocated in turn, we need to produce a delta from the child's tree budget total and apply it to the child node

            double delta = newBudget - curBudget;
            child.SetBudget(_year, child.GetBudget(_year) + delta);

            deltaTotal += delta;
        }

        // Last, apply the total delta to the master account

        _account.SetBudget(_year, _account.GetBudget(_year) - deltaTotal);

        // Rewrite controls

        PopulateBudgetData();
    }