private String MergeAllString() { String fe = String.Empty; if (ddlBankAccountID.Items.Count > 0) { String fe_account = SqlExpressionBuilder.PrepareFilterExpression("ACBankAccount." + ACAccountsHelper_CustomEntity.FLD_NAME_BankAccountID, ddlBankAccountID.SelectedValue.ToString(), SQLMatchType.Equal); IList <ACAccountsHelper_CustomEntity> lst = FCCACAccountsHelper_Custom.GetFacadeCreate().GetIL(1000, 1, fe_account); if (lst != null && lst.Count > 0) { fe = SqlExpressionBuilder.PrepareFilterExpression(ACBankStatement_CustomEntity.FLD_NAME_AccountID, lst[0].AccountID.ToString(), SQLMatchType.Equal); } } if (!String.IsNullOrWhiteSpace(txtTransactionFromDate.Text.Trim())) { if (!String.IsNullOrWhiteSpace(txtTransactionToDate.Text.Trim())) { String fe1 = "TransactionDateTime between '" + MiscUtil.ParseToDateTime(txtTransactionFromDate.Text) + "' and '" + MiscUtil.ParseToDateTime(txtTransactionToDate.Text) + "'"; fe = SqlExpressionBuilder.PrepareFilterExpression(fe, SQLJoinType.AND, fe1); } } Int64 activeFiscalYearID = MiscUtil.GetActiveFiscalYear(); //if (activeFiscalYearID > 0) //{ // String fe2 = SqlExpressionBuilder.PrepareFilterExpression("ACFiscalYear", activeFiscalYearID.ToString(), SQLMatchType.Equal); // fe = SqlExpressionBuilder.PrepareFilterExpression(fe, SQLJoinType.AND, fe2); //} return(fe); }
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"; } }