public Acc_BankLinkToChartOfAccount GetAcc_BankLinkToChartOfAccountByIID(long currentMapID)
        {
            Acc_BankLinkToChartOfAccount blCOA = Database.Acc_BankLinkToChartOfAccounts.Where(b => b.IID == currentMapID && b.IsRemoved == 0 && b.Status == 1).FirstOrDefault();

            if (blCOA != null)
            {
                blCOA.Acc_BankAccount = blCOA.Acc_BankAccount;
            }
            blCOA.Acc_ChartOfAccount = blCOA.Acc_ChartOfAccount;
            blCOA.Branch             = blCOA.Acc_BankAccount.Acc_BankBranch;
            blCOA.Bank = blCOA.Acc_BankAccount.Acc_BankBranch.Acc_Bank;

            blCOA.COABranch = Database.Acc_ChartOfAccounts.Where(c => c.IID == blCOA.Acc_ChartOfAccount.ParentID).FirstOrDefault();
            if (blCOA.COABranch != null)
            {
                blCOA.COABank = Database.Acc_ChartOfAccounts.Where(c => c.IID == blCOA.COABranch.ParentID).FirstOrDefault();
            }

            return(blCOA);
        }
        public Acc_BankLinkToChartOfAccount GetAcc_BankLinkToChartOfAccountOnlyByIID(long currentMapID)
        {
            Acc_BankLinkToChartOfAccount blCOA = Database.Acc_BankLinkToChartOfAccounts.Where(b => b.IID == currentMapID && b.IsRemoved == 0 && b.Status == 1).FirstOrDefault();

            return(blCOA);
        }