protected void Page_Load(object sender, EventArgs e) { if (Request["LedgerType"] == null) { Visible = false; return; } TextBox dateStart = BasePage.FindControlR<TextBox>("txbDateFrom"); TextBox dateEnd = BasePage.FindControlR<TextBox>("txbDateThrough"); Guid accountId = Guid.Empty; Guid.TryParse(Request["AccountId"], out accountId); if (accountId != Guid.Empty) { using (WeavverEntityContainer data = new WeavverEntityContainer()) { string ledgerType = Request["LedgerType"]; DateTime? startAt = null; DateTime startAt2; DateTime? endAt = null; DateTime endAt2; if (DateTime.TryParse(dateStart.Text, out startAt2)) startAt = startAt2; if (DateTime.TryParse(dateEnd.Text, out endAt2)) endAt = endAt2; string x = data.GetName(Guid.Empty); decimal credits = data.Total_ForLedger(BasePage.SelectedOrganization.Id, accountId, ledgerType, true, false, false, null, null); decimal debits = data.Total_ForLedger(BasePage.SelectedOrganization.Id, accountId, ledgerType, false, true, false, null, null); decimal balance = data.Total_ForLedger(BasePage.SelectedOrganization.Id, accountId, ledgerType, true, true, false, null, null); FundsIn.Text = String.Format("{0,10:C}", credits); FundsOut.Text = String.Format("{0,10:C}", debits); Balance.Text = String.Format("{0,10:C}", balance); AvailableBalance.Text = String.Format("{0,10:C}", data.Total_ForLedger(BasePage.SelectedOrganization.OrganizationId, accountId, ledgerType, true, true, true, null, null)); if (startAt != null || endAt != null) { FilteredTotals.Visible = true; decimal filteredStartingBalance = data.Total_ForLedger(BasePage.SelectedOrganization.Id, accountId, ledgerType, true, true, true, null, startAt); decimal filteredCredits = data.Total_ForLedger(BasePage.SelectedOrganization.Id, accountId, ledgerType, true, false, true, startAt, endAt); decimal filteredDebits = data.Total_ForLedger(BasePage.SelectedOrganization.Id, accountId, ledgerType, false, true, true, startAt, endAt); decimal filteredBalance = data.Total_ForLedger(BasePage.SelectedOrganization.Id, accountId, ledgerType, true, true, true, startAt, endAt); decimal filteredEndingBalance = data.Total_ForLedger(BasePage.SelectedOrganization.Id, accountId, ledgerType, true, true, true, null, endAt); VisibleStartingBalance.Text = String.Format("{0,10:C}", filteredStartingBalance); VisibleCredits.Text = String.Format("{0,10:C}", filteredCredits); VisibleDebits.Text = String.Format("{0,10:C}", filteredDebits); VisibleBalance.Text = String.Format("{0,10:C}", filteredBalance); VisibleEndingBalance.Text = String.Format("{0,10:C}", filteredEndingBalance); VisibleAvailableBalance.Text = String.Format("{0,10:C}", data.Total_ForLedger(BasePage.SelectedOrganization.Id, accountId, ledgerType, true, true, true, startAt, endAt)); } } } }
//------------------------------------------------------------------------------------------- public void UpdatePage() { using (WeavverEntityContainer data = new WeavverEntityContainer()) { decimal balance = data.Total_ForLedger(SelectedOrganization.Id, LoggedInUser.OrganizationId, LedgerType.Receivable.ToString(), true, true, false, null, null); // data.Total_ForLedger(LoggedInUser.OrganizationId); var cards = (from items in data.Accounting_CreditCards where items.OrganizationId == SelectedOrganization.Id select items); CreditCards.DataSource = cards; CreditCards.DataTextField = "CensoredAccountNumber"; CreditCards.DataValueField = "Id"; CreditCards.DataBind(); if (balance < 0) { decimal amount = balance * -1; MinimumPaymentDue.Text = "$" + amount.ToString(); Balance.Text = "$" + amount.ToString(); PayBalanceAmount.Text = "$" + amount.ToString(); } } }