// Add your own data access methods here.  If you wish to
        // expose your public method to a WCF service, marked them with
        // the attribute [NCPublish], and another T4 template will generate your service contract

        /// <summary>
        /// Get List of AssetManager
        /// </summary>
        /// <returns></returns>
        public List <R_AssetManager_IntroducingBroker_ClientAccount> GetAllAssetManager()
        {
            List <R_AssetManager_IntroducingBroker_ClientAccount> lstAm = new List <R_AssetManager_IntroducingBroker_ClientAccount>();

            try
            {
                using (var unitOfWork = new EFUnitOfWork())
                {
                    var assetRepo = new R_AssetManager_IntroducingBroker_ClientAccountRepository(new EFRepository <R_AssetManager_IntroducingBroker_ClientAccount>(), unitOfWork);

                    ObjectSet <R_AssetManager_IntroducingBroker_ClientAccount> amObj =
                        ((CurrentDeskClientsEntities)assetRepo.Repository.UnitOfWork.Context).R_AssetManager_IntroducingBroker_ClientAccount;

                    lstAm = amObj.Where(s => s.IsIntroducingBrokerAssetManger == true).ToList();
                }
            }
            catch (Exception ex)
            {
                CommonErrorLogger.CommonErrorLog(ex, System.Reflection.MethodBase.GetCurrentMethod().Name);
            }

            return(lstAm);
        }
        /// <summary>
        /// Get List of AssetManager
        /// With Client Detail
        /// </summary>
        /// <returns>List of R_AssetManager_IntroducingBroker_ClientAccount </returns>
        public List <R_AssetManager_IntroducingBroker_ClientAccount> GetAllBOAssetManager()
        {
            List <R_AssetManager_IntroducingBroker_ClientAccount> assetManagerList = new List <R_AssetManager_IntroducingBroker_ClientAccount>();

            try
            {
                using (var unitOfWork = new EFUnitOfWork())
                {
                    var assetRepo = new R_AssetManager_IntroducingBroker_ClientAccountRepository(new EFRepository <R_AssetManager_IntroducingBroker_ClientAccount>(), unitOfWork);

                    ObjectSet <R_AssetManager_IntroducingBroker_ClientAccount> assetManagerObj =
                        ((CurrentDeskClientsEntities)assetRepo.Repository.UnitOfWork.Context).R_AssetManager_IntroducingBroker_ClientAccount;
                    var res = assetManagerList = assetManagerObj.Include("IntroducingBroker").
                                                 Include("IntroducingBroker.Client_Account").
                                                 Where(x => x.IntroducingBroker.IsBOMAM == true).ToList();
                }
            }
            catch (Exception ex)
            {
                CommonErrorLogger.CommonErrorLog(ex, System.Reflection.MethodBase.GetCurrentMethod().Name);
            }

            return(assetManagerList);
        }