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