public IList <ACBankStatement_CustomEntity> GetPagedData(Int32 startRowIndex, Int32 pageSize, String sortExpression, String filterExpression) { IList <ACBankStatement_CustomEntity> aCBankStatement_CustomEntityList = new List <ACBankStatement_CustomEntity>(); try { if (String.IsNullOrEmpty(sortExpression)) { sortExpression = "JournalID"; } Int32 currentPage = Convert.ToInt32(startRowIndex / pageSize) + 1; //startRowIndex = Convert.ToInt32( startRowIndex / pageSize) + 1; if (pageSize == -1) { pageSize = 1000000000; } aCBankStatement_CustomEntityList = FCCACBankStatement_Custom.GetFacadeCreate().GetIL(pageSize, currentPage, sortExpression, filterExpression); if (aCBankStatement_CustomEntityList != null && aCBankStatement_CustomEntityList.Count > 0) { totalRowCount = aCBankStatement_CustomEntityList[0].TotalRowCount; } } catch (Exception ex) { } return(aCBankStatement_CustomEntityList ?? new List <ACBankStatement_CustomEntity>()); }
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"; } }