public IList <ACBankAccountTransferEntity> GetPagedData(Int32 startRowIndex, Int32 pageSize, String sortExpression)
        {
            IList <ACBankAccountTransferEntity> aCBankAccountTransferEntityList = new List <ACBankAccountTransferEntity>();

            try
            {
                if (pageSize == -1)
                {
                    pageSize = 1000000000;
                }

                if (String.IsNullOrEmpty(sortExpression))
                {
                    sortExpression = ACBankAccountTransferEntity.FLD_NAME_BankAccountTransferID + " " + SQLConstants.SORT_ORDER_DESCENDING;
                }

                startRowIndex = Convert.ToInt32(startRowIndex / pageSize) + 1;

                aCBankAccountTransferEntityList = FCCACBankAccountTransfer.GetFacadeCreate().GetIL(startRowIndex, pageSize, sortExpression, null, DatabaseOperationType.LoadPagedWithSortExpression);

                if (aCBankAccountTransferEntityList != null && aCBankAccountTransferEntityList.Count > 0)
                {
                    totalRowCount = aCBankAccountTransferEntityList[0].TotalRowCount;
                }
            }
            catch (Exception ex)
            {
            }

            return(aCBankAccountTransferEntityList ?? new List <ACBankAccountTransferEntity>());
        }
Exemple #2
0
        private void SaveACBankAccountTransferEntity()
        {
            if (IsValid)
            {
                try
                {
                    ACBankAccountTransferEntity aCBankAccountTransferEntity = BuildACBankAccountTransferEntity();

                    Int64 result = -1;

                    if (aCBankAccountTransferEntity.IsNew)
                    {
                        result = FCCACBankAccountTransfer.GetFacadeCreate().Add(aCBankAccountTransferEntity, DatabaseOperationType.Add, TransactionRequired.No);
                    }
                    else
                    {
                        String filterExpression = SqlExpressionBuilder.PrepareFilterExpression(ACBankAccountTransferEntity.FLD_NAME_BankAccountTransferID, aCBankAccountTransferEntity.BankAccountTransferID.ToString(), SQLMatchType.Equal);
                        result = FCCACBankAccountTransfer.GetFacadeCreate().Update(aCBankAccountTransferEntity, filterExpression, DatabaseOperationType.Update, TransactionRequired.No);
                    }

                    if (result > 0)
                    {
                        //_BankAccountTransferID = 0;
                        //_ACBankAccountTransferEntity = new ACBankAccountTransferEntity();
                        //PrepareInitialView();
                        //BindACBankAccountTransferList();

                        if (aCBankAccountTransferEntity.IsNew)
                        {
                            MiscUtil.ShowMessage(lblMessage, "Bank Account Transfer Information has been added successfully.", false);
                        }
                        else
                        {
                            MiscUtil.ShowMessage(lblMessage, "Bank Account Transfer Information has been updated successfully.", false);
                        }
                    }
                    else
                    {
                        if (aCBankAccountTransferEntity.IsNew)
                        {
                            MiscUtil.ShowMessage(lblMessage, "Failed to add Bank Account Transfer Information.", false);
                        }
                        else
                        {
                            MiscUtil.ShowMessage(lblMessage, "Failed to update Bank Account Transfer Information.", false);
                        }
                    }
                }
                catch (Exception ex)
                {
                    MiscUtil.ShowMessage(lblMessage, ex.Message, true);
                }
            }
        }
Exemple #3
0
        protected void lvACBankAccountTransfer_ItemCommand(object sender, ListViewCommandEventArgs e)
        {
            Int64 BankAccountTransferID;

            Int64.TryParse(e.CommandArgument.ToString(), out BankAccountTransferID);

            if (BankAccountTransferID > 0)
            {
                if (string.Equals(e.CommandName, "EditItem"))
                {
                    _BankAccountTransferID = BankAccountTransferID;

                    PrepareEditView();
                }
                else if (string.Equals(e.CommandName, "DeleteItem"))
                {
                    try
                    {
                        Int64 result = -1;

                        String fe = SqlExpressionBuilder.PrepareFilterExpression(ACBankAccountTransferEntity.FLD_NAME_BankAccountTransferID, BankAccountTransferID.ToString(), SQLMatchType.Equal);

                        ACBankAccountTransferEntity aCBankAccountTransferEntity = new ACBankAccountTransferEntity();


                        result = FCCACBankAccountTransfer.GetFacadeCreate().Delete(aCBankAccountTransferEntity, fe, DatabaseOperationType.Delete, TransactionRequired.No);

                        if (result == 0)
                        {
                            _BankAccountTransferID       = 0;
                            _ACBankAccountTransferEntity = new ACBankAccountTransferEntity();
                            PrepareInitialView();
                            BindACBankAccountTransferList();

                            MiscUtil.ShowMessage(lblMessage, "A CBank Account Transfer has been successfully deleted.", true);
                        }
                        else
                        {
                            MiscUtil.ShowMessage(lblMessage, "Failed to delete A CBank Account Transfer.", true);
                        }
                    }
                    catch (Exception ex)
                    {
                        MiscUtil.ShowMessage(lblMessage, ex.Message, true);
                    }
                }
            }
        }
        public IList <ACBankAccountTransferEntity> GetData()
        {
            IList <ACBankAccountTransferEntity> aCBankAccountTransferEntityList = new List <ACBankAccountTransferEntity>();

            try
            {
                aCBankAccountTransferEntityList = FCCACBankAccountTransfer.GetFacadeCreate().GetIL(null, null, null, null, DatabaseOperationType.Load);

                if (aCBankAccountTransferEntityList != null && aCBankAccountTransferEntityList.Count > 0)
                {
                    totalRowCount = aCBankAccountTransferEntityList[0].TotalRowCount;
                }
            }
            catch (Exception ex)
            {
            }

            return(aCBankAccountTransferEntityList ?? new List <ACBankAccountTransferEntity>());
        }
Exemple #5
0
        private void SaveACBankAccountTransferEntity()
        {
            if (IsValid)
            {
                try
                {
                    ACBankAccountTransferEntity aCBankAccountTransferEntity = BuildACBankAccountTransferEntity();

                    Int64 result = -1;

                    if (aCBankAccountTransferEntity.IsNew)
                    {
                        result = FCCACBankAccountTransfer.GetFacadeCreate().Add(aCBankAccountTransferEntity, DatabaseOperationType.Add, TransactionRequired.No);
                    }
                    else
                    {
                        String filterExpression = SqlExpressionBuilder.PrepareFilterExpression(ACBankAccountTransferEntity.FLD_NAME_BankAccountTransferID, aCBankAccountTransferEntity.BankAccountTransferID.ToString(), SQLMatchType.Equal);
                        result = FCCACBankAccountTransfer.GetFacadeCreate().Update(aCBankAccountTransferEntity, filterExpression, DatabaseOperationType.Update, TransactionRequired.No);
                    }

                    if (result > 0)
                    {
                        #region Approval Process

                        Boolean apResult = APRobot.CreateApprovalProcessForNewBankAccountTransfer(result, Int64.Parse(ddlAPPanelID.SelectedValue));

                        if (apResult == true)
                        {
                            MiscUtil.ShowMessage(lblMessage, "Approval Process Submited successfully.", UIConstants.MessageType.GREEN);
                        }
                        else
                        {
                            MiscUtil.ShowMessage(lblMessage, "Failed to Submit Approval Process.", UIConstants.MessageType.RED);
                        }

                        #endregion


                        //try
                        //{
                        //    #region Journal Entry

                        //    //Bank To Bank Tranfer amount
                        //    //Normal Trnasaction without Charge
                        //    //===================================
                        //    //    From Current amount to pretty cash
                        //    //    Current Accont (-) Credit
                        //    //    Petty Cash Account(+) Debit
                        //    //====================================

                        //    //Transaction with Charge
                        //    //===================================
                        //    //    From Current amount to pretty cash
                        //    //    sum of amount transfer + Charge	Current Accont (-) Credit
                        //    //    Petty Cash Account(+) Debit
                        //    //    Charge also (+) Debit but different account Head {Interest and Bank Charges}

                        //    ACBankAccountTransferEntity acBankAccountTransferEntity = FCCACBankAccountTransfer.GetFacadeCreate().GetByID(result);

                        //    if (acBankAccountTransferEntity != null && acBankAccountTransferEntity.BankAccountTransferID > 0)
                        //    {
                        //        Decimal amount, charge, totalAmount;
                        //        Decimal.TryParse(acBankAccountTransferEntity.Amount.ToString(), out amount);
                        //        Decimal.TryParse(acBankAccountTransferEntity.BankCharge.ToString(), out charge);

                        //        totalAmount = amount + charge;

                        //        if (amount > 0)
                        //        {
                        //            #region From Account(Credit Entry)

                        //            ACJournalEntity acJournalEntity = new ACJournalEntity();


                        //            String fe_account = SqlExpressionBuilder.PrepareFilterExpression("ACBankAccount." + ACAccountsHelper_CustomEntity.FLD_NAME_BankAccountID, acBankAccountTransferEntity.FromBankAccountID.ToString(), SQLMatchType.Equal);
                        //            IList<ACAccountsHelper_CustomEntity> lst = FCCACAccountsHelper_Custom.GetFacadeCreate().GetIL(1000, 1, fe_account);

                        //            if (lst != null && lst.Count > 0)
                        //            {
                        //                acJournalEntity.AccountID = lst[0].AccountID;
                        //                acJournalEntity.AccountGroupID = lst[0].AccountGroupID;
                        //                acJournalEntity.ClassID = lst[0].ClassID;
                        //                acJournalEntity.ClassTypeID = lst[0].ClassTypeID;
                        //            }

                        //            String fe_fiscalYear = SqlExpressionBuilder.PrepareFilterExpression(ACFiscalYearEntity.FLD_NAME_IsClosed, "0", SQLMatchType.Equal);
                        //            IList<ACFiscalYearEntity> lstFiscalYear = FCCACFiscalYear.GetFacadeCreate().GetIL(null, null, String.Empty, fe_fiscalYear, DatabaseOperationType.LoadWithFilterExpression);

                        //            if (lstFiscalYear != null && lstFiscalYear.Count > 0)
                        //            {
                        //                acJournalEntity.FiscalYearID = lstFiscalYear[0].FiscalYearID;
                        //            }

                        //            acJournalEntity.TransactionDateTime = acBankAccountTransferEntity.TransferDate;
                        //            acJournalEntity.Amount = totalAmount;
                        //            acJournalEntity.EnteredByEmployeeID = MiscUtil.GetCurrentEmployeeByMemberID(CurrentMember);
                        //            acJournalEntity.ReferenceOrMemoOrID = acBankAccountTransferEntity.Memo;
                        //            acJournalEntity.Note = acBankAccountTransferEntity.Remarks;
                        //            acJournalEntity.MDDebitCreditID = MasterDataConstants.MDDebitCredit.CREDIT;
                        //            acJournalEntity.DimensionID = null;
                        //            acJournalEntity.ProjectID = null;
                        //            acJournalEntity.IsReverseTransaction = false;

                        //            FCCACJournal.GetFacadeCreate().Add(acJournalEntity, DatabaseOperationType.Add, TransactionRequired.No);

                        //            #endregion

                        //            #region To Account(Debit Entry)

                        //            String fe_TobankAccount = SqlExpressionBuilder.PrepareFilterExpression("ACBankAccount." + ACAccountsHelper_CustomEntity.FLD_NAME_BankAccountID, acBankAccountTransferEntity.ToBankAccountID.ToString(), SQLMatchType.Equal);
                        //            IList<ACAccountsHelper_CustomEntity> lstTobankAccount = FCCACAccountsHelper_Custom.GetFacadeCreate().GetIL(10000, 1, fe_TobankAccount);

                        //            if (lstTobankAccount != null && lstTobankAccount.Count > 0)
                        //            {
                        //                acJournalEntity.AccountID = lstTobankAccount[0].AccountID;
                        //                acJournalEntity.AccountGroupID = lstTobankAccount[0].AccountGroupID;
                        //                acJournalEntity.ClassID = lstTobankAccount[0].ClassID;
                        //                acJournalEntity.ClassTypeID = lstTobankAccount[0].ClassTypeID;
                        //            }

                        //            acJournalEntity.TransactionDateTime = acBankAccountTransferEntity.TransferDate;
                        //            acJournalEntity.Amount = amount;
                        //            acJournalEntity.EnteredByEmployeeID = MiscUtil.GetCurrentEmployeeByMemberID(CurrentMember);
                        //            acJournalEntity.ReferenceOrMemoOrID = acBankAccountTransferEntity.Memo;
                        //            acJournalEntity.Note = acBankAccountTransferEntity.Remarks;
                        //            acJournalEntity.MDDebitCreditID = MasterDataConstants.MDDebitCredit.DEBIT;
                        //            acJournalEntity.DimensionID = null;
                        //            acJournalEntity.ProjectID = null;
                        //            acJournalEntity.IsReverseTransaction = false;

                        //            FCCACJournal.GetFacadeCreate().Add(acJournalEntity, DatabaseOperationType.Add, TransactionRequired.No);

                        //            if (charge > 0)
                        //            {
                        //                acJournalEntity.Amount = charge;
                        //                acJournalEntity.AccountID = 23;//Should Change Here For Intrest and Loan

                        //                String fe_ChargeAccount = SqlExpressionBuilder.PrepareFilterExpression("ACAccount." + ACAccountsHelper_CustomEntity.FLD_NAME_AccountID, "23".ToString(), SQLMatchType.Equal);
                        //                IList<ACAccountsHelper_CustomEntity> lstChargeAccount = FCCACAccountsHelper_Custom.GetFacadeCreate().GetIL(10000, 1, fe_ChargeAccount);

                        //                if (lstTobankAccount != null && lstTobankAccount.Count > 0)
                        //                {
                        //                    acJournalEntity.AccountID = 23;
                        //                    acJournalEntity.AccountGroupID = lstChargeAccount[0].AccountGroupID;
                        //                    acJournalEntity.ClassID = lstChargeAccount[0].ClassID;
                        //                    acJournalEntity.ClassTypeID = lstChargeAccount[0].ClassTypeID;
                        //                }
                        //                acJournalEntity.MDDebitCreditID = MasterDataConstants.MDDebitCredit.DEBIT;
                        //                FCCACJournal.GetFacadeCreate().Add(acJournalEntity, DatabaseOperationType.Add, TransactionRequired.No);
                        //            }

                        //            #endregion

                        //            acJournalEntity = new ACJournalEntity();
                        //        }
                        //    }

                        //    #endregion
                        //}
                        //catch (Exception ex)
                        //{
                        //    MiscUtil.ShowMessage(lblMessage, "Some Error Occured To Save in Journal Entry", true);
                        //}

                        _BankAccountTransferID       = 0;
                        _ACBankAccountTransferEntity = new ACBankAccountTransferEntity();
                        PrepareInitialView();
                        BindACBankAccountTransferList();

                        if (aCBankAccountTransferEntity.IsNew)
                        {
                            MiscUtil.ShowMessage(lblMessage, "Bank Account Transfer Information has been added successfully.", false);
                        }
                        else
                        {
                            MiscUtil.ShowMessage(lblMessage, "Bank Account Transfer Information has been updated successfully.", false);
                        }
                    }
                    else
                    {
                        if (aCBankAccountTransferEntity.IsNew)
                        {
                            MiscUtil.ShowMessage(lblMessage, "Failed to add Bank Account Transfer Information.", false);
                        }
                        else
                        {
                            MiscUtil.ShowMessage(lblMessage, "Failed to update Bank Account Transfer Information.", false);
                        }
                    }
                }
                catch (Exception ex)
                {
                    MiscUtil.ShowMessage(lblMessage, ex.Message, true);
                }
            }
        }