private void BuildLabel() { String fe = MergeAllString(); IList <ACBankStatement_CustomEntity> lst = FCCACBankStatement_Custom.GetFacadeCreate().GetIL(1000000, 1, String.Empty, fe); if (lst != null && lst.Count > 0) { var resultDebit = (from s in lst where s.MDDebitCreditID == MasterDataConstants.MDDebitCredit.DEBIT select s.Amount).Sum(val => val); var resultCredit = (from s in lst where s.MDDebitCreditID == MasterDataConstants.MDDebitCredit.CREDIT select s.Amount).Sum(val => val); //lbltotalDebitAmount.Text = Math.Round(resultDebit, 2).ToString(); //lbltotalCreditAmount.Text = Math.Round(resultCredit, 2).ToString(); lbltotalBalance.Text = Math.Round((resultDebit - resultCredit), 2).ToString(); } else { lbltotalBalance.Text = "0.00"; } Int64 accountID = 0, activefiscalYearID = 0; DateTime fromDate, ToDate; if (ddlBankAccountID.Items.Count > 0) { String fe_account = SqlExpressionBuilder.PrepareFilterExpression("ACBankAccount." + ACAccountsHelper_CustomEntity.FLD_NAME_BankAccountID, ddlBankAccountID.SelectedValue.ToString(), SQLMatchType.Equal); IList <ACAccountsHelper_CustomEntity> lstAccountHelper = FCCACAccountsHelper_Custom.GetFacadeCreate().GetIL(1000, 1, fe_account); if (lstAccountHelper != null && lstAccountHelper.Count > 0) { accountID = lstAccountHelper[0].AccountID; } } activefiscalYearID = MiscUtil.GetActiveFiscalYear(); fromDate = MiscUtil.ParseToDateTime(txtTransactionFromDate.Text.ToString()); ToDate = MiscUtil.ParseToDateTime(txtTransactionToDate.Text.ToString()); IList <ACAccountOpenCloseBalance_CustomEntity> lstOpenClose = FCCACAccountOpenCloseBalance_Custom.GetFacadeCreate().GetIL(accountID, activefiscalYearID, fromDate, ToDate); if (lstOpenClose != null && lstOpenClose.Count > 0) { lblOpeningBalance.Text = Math.Round(lstOpenClose[0].OpenBalance, 2).ToString(); } else { lblOpeningBalance.Text = "0.00"; } }
private void BuildLabel() { String fe = MergeAllString(); IList <ACBankStatement_CustomEntity> lst = FCCACBankStatement_Custom.GetFacadeCreate().GetIL(1000000, 1, String.Empty, fe); if (lst != null && lst.Count > 0) { var resultDebit = (from s in lst where s.MDDebitCreditID == MasterDataConstants.MDDebitCredit.DEBIT select s.Amount).Sum(val => val); var resultCredit = (from s in lst where s.MDDebitCreditID == MasterDataConstants.MDDebitCredit.CREDIT select s.Amount).Sum(val => val); //lbltotalDebitAmount.Text = Math.Round(resultDebit, 2).ToString(); //lbltotalCreditAmount.Text = Math.Round(resultCredit, 2).ToString(); lbltotalBalance.Text = Math.Round((resultDebit - resultCredit), 2).ToString(); //lbltotalBalance.Text = MiscUtil.NumericCommaSeperatedFormat((resultDebit - resultCredit)); } else { lbltotalBalance.Text = "0.00"; } Int64 accountID = 0, activefiscalYearID = 0; DateTime fromDate, ToDate; if (hdEmpID.Value != "0") { accountID = Int64.Parse(hdEmpID.Value.ToString()); } activefiscalYearID = MiscUtil.GetActiveFiscalYear(); fromDate = MiscUtil.ParseToDateTime(txtTransactionFromDate.Text.ToString()); ToDate = MiscUtil.ParseToDateTime(txtTransactionToDate.Text.ToString()); IList <ACAccountOpenCloseBalance_CustomEntity> lstOpenClose = FCCACAccountOpenCloseBalance_Custom.GetFacadeCreate().GetIL(accountID, activefiscalYearID, fromDate, ToDate); if (lstOpenClose != null && lstOpenClose.Count > 0) { lblOpeningBalance.Text = Math.Round(lstOpenClose[0].OpenBalance, 2).ToString(); //lblOpeningBalance.Text = MiscUtil.NumericCommaSeperatedFormat(lstOpenClose[0].OpenBalance); } else { lblOpeningBalance.Text = "0.00"; } }