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