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);
}
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();
}
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);
}
}
public void Populate(FinancialAccount root)
{
this.Tree.Nodes.Clear();
FinancialAccounts accounts = root.GetTree();
accounts.Remove(root);
if (accounts.Count > 0)
{
Populate(accounts);
}
}
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);
}
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;
}
}
}
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
});
}
}
/*
* 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
}
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;
}
}
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();
}