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";
}
}
