public void CreateOfflineCustomerOrderAssociation(DataTable OrderAssociates, int userId, int orderId)
        {
            OfflineBondOrderDao OfflineBondOrderDao = new OfflineBondOrderDao();

            try
            {
                OfflineBondOrderDao.CreateOfflineCustomerOrderAssociation(OrderAssociates, userId, orderId);
            }
            catch (BaseApplicationException Ex)
            {
                throw Ex;
            }
            catch (Exception Ex)
            {
                BaseApplicationException exBase       = new BaseApplicationException(Ex.Message, Ex);
                NameValueCollection      FunctionInfo = new NameValueCollection();
                FunctionInfo.Add("Method", "CreateOfflineCustomerOrderAssociation(OrderAssociates, userId, orderId);");
                object[] objects = new object[1];
                objects[0]   = OrderAssociates;
                FunctionInfo = exBase.AddObject(FunctionInfo, objects);
                exBase.AdditionalInformation = FunctionInfo;
                ExceptionManager.Publish(exBase);
                throw exBase;
            }
        }
        public IDictionary <string, string> OfflineBOndtransact(DataTable OnlineBondOrder, int adviserId, OnlineBondOrderVo OnlineBondVo, int agentId, string agentCode, int userId, int EmpId)
        {
            IDictionary <string, string> OrderIds       = new Dictionary <string, string>();
            OfflineBondOrderDao          offlineBondDao = new OfflineBondOrderDao();

            //bool result = false;
            //int orderIds = 0;
            try
            {
                OrderIds = offlineBondDao.CreateOfflineBondTransact(OnlineBondOrder, adviserId, OnlineBondVo, agentId, agentCode, userId, EmpId);
            }
            catch (BaseApplicationException Ex)
            {
                throw Ex;
            }
            catch (Exception Ex)
            {
                BaseApplicationException exBase       = new BaseApplicationException(Ex.Message, Ex);
                NameValueCollection      FunctionInfo = new NameValueCollection();
                FunctionInfo.Add("Method", "OnlineBondOrderBo.cs:onlineBOndtransact(OnlineBondOrderVo OnlineBondOrder)");
                object[] objects = new object[1];
                objects[0]   = OnlineBondOrder;
                FunctionInfo = exBase.AddObject(FunctionInfo, objects);
                exBase.AdditionalInformation = FunctionInfo;
                ExceptionManager.Publish(exBase);
                throw exBase;
            }
            return(OrderIds);
        }
        public DataSet GetIntrestFrequency(int detailsId)
        {
            OfflineBondOrderDao offlineBondDao = new OfflineBondOrderDao();
            DataSet             ds             = offlineBondDao.GetIntrestFrequency(detailsId);

            return(ds);
        }
        public DataSet GetOfflineLiveBondTransaction(int SeriesId, int orderId, int category)
        {
            OfflineBondOrderDao offlineBondDao             = new OfflineBondOrderDao();
            DataSet             dsCommissionStructureRules = new DataSet();

            try
            {
                dsCommissionStructureRules = offlineBondDao.GetOfflineLiveBondTransaction(SeriesId, orderId, category);
            }
            catch (BaseApplicationException Ex)
            {
                throw Ex;
            }
            catch (Exception Ex)
            {
                BaseApplicationException exBase       = new BaseApplicationException(Ex.Message, Ex);
                NameValueCollection      FunctionInfo = new NameValueCollection();
                FunctionInfo.Add("Method", "OnlineBondOrderBo.cs:GetOfflineLiveBondTransaction(int SeriesId, int customerId, int customerSubType)");
                object[] objects = new object[1];
                FunctionInfo = exBase.AddObject(FunctionInfo, objects);
                exBase.AdditionalInformation = FunctionInfo;
                ExceptionManager.Publish(exBase);
                throw exBase;
            }
            return(dsCommissionStructureRules);
        }
        public DataSet GetCustomerAllotedDetailData(int customerId)
        {
            OfflineBondOrderDao offlineBondDao = new OfflineBondOrderDao();
            DataSet             ds             = offlineBondDao.GetCustomerAllotedDetailData(customerId);

            return(ds);
        }
        public DataSet GetOfflineAdviserIssuerList(int adviserId, int issueId, int type, int category)
        {
            OfflineBondOrderDao offlineBondDao             = new OfflineBondOrderDao();
            DataSet             dsCommissionStructureRules = new DataSet();

            try
            {
                dsCommissionStructureRules = offlineBondDao.GetOfflineAdviserIssuerList(adviserId, issueId, type, 0);
            }
            catch (BaseApplicationException Ex)
            {
                throw Ex;
            }
            catch (Exception Ex)
            {
                BaseApplicationException exBase       = new BaseApplicationException(Ex.Message, Ex);
                NameValueCollection      FunctionInfo = new NameValueCollection();
                FunctionInfo.Add("Method", "OnlineBondOrderBo.cs:GetOfflineAdviserIssuerList(adviserId, issueId, type, custmerId,customerSubtype)");
                object[] objects = new object[1];
                objects[0]   = adviserId;
                FunctionInfo = exBase.AddObject(FunctionInfo, objects);
                exBase.AdditionalInformation = FunctionInfo;
                ExceptionManager.Publish(exBase);
                throw exBase;
            }
            return(dsCommissionStructureRules);
        }
        public bool CancelBondsFDBookOrder(int orderId, string remarks, int userId, bool IsAuthenticated)
        {
            bool bResult = false;
            OfflineBondOrderDao offlineBondDao = new OfflineBondOrderDao();

            try
            {
                bResult = offlineBondDao.CancelBondsFDBookOrder(orderId, remarks, userId, IsAuthenticated);
            }
            catch (BaseApplicationException Ex)
            {
                throw Ex;
            }
            catch (Exception Ex)
            {
                BaseApplicationException exBase       = new BaseApplicationException(Ex.Message, Ex);
                NameValueCollection      FunctionInfo = new NameValueCollection();
                FunctionInfo.Add("Method", "OnlineBondOrderBo.cs:cancelBondsBookOrder(string id)");
                object[] objects = new object[1];
                objects[0]   = orderId;
                FunctionInfo = exBase.AddObject(FunctionInfo, objects);
                exBase.AdditionalInformation = FunctionInfo;
                ExceptionManager.Publish(exBase);
                throw exBase;
            }
            return(bResult);
        }
        public bool UpdateAllotmentDetails(int userid, DataTable dtOrderAllotmentDetails, int coadId)
        {
            bool result = false;
            OfflineBondOrderDao offlineBondDao = new OfflineBondOrderDao();

            result = offlineBondDao.UpdateAllotmentDetails(userid, dtOrderAllotmentDetails, coadId);
            return(result);
        }
        public int GetAdviserIssueDetailsId(int IssueCategory)
        {
            int IssueCategoryid = 0;
            OfflineBondOrderDao offlineBondDao = new OfflineBondOrderDao();

            IssueCategoryid = offlineBondDao.GetAdviserIssueDetailsId(IssueCategory);
            return(IssueCategoryid);
        }
        public bool CreateAllotmentDetails(int userid, DataTable dtOrderAllotmentDetails)
        {
            bool result = false;
            OfflineBondOrderDao offlineBondDao = new OfflineBondOrderDao();

            result = offlineBondDao.CreateAllotmentDetails(userid, dtOrderAllotmentDetails);
            return(result);
        }
        public void GetCustomerCat(int issueId, int adviserId, int customerSubType, double amt, ref string catName, ref int issueDetId, ref int categoryId, ref string Description)
        {
            // bool result = false;
            OfflineBondOrderDao offlineBondDao = new OfflineBondOrderDao();

            try
            {
                offlineBondDao.GetCustomerCat(issueId, adviserId, customerSubType, amt, ref catName, ref issueDetId, ref categoryId, ref Description);
            }
            catch (BaseApplicationException Ex)
            {
                throw (Ex);
            }
        }
        public DataTable GetFD54IssueOrder(int adviserId, DateTime fromDate, DateTime toDate, string status, int issueId, string userType, string AgentCode, string category, int AuthenticateStatus, int orderNo, int userId)
        {
            DataTable           dt;
            OfflineBondOrderDao offlineBondDao = new OfflineBondOrderDao();

            try
            {
                dt = offlineBondDao.GetFD54IssueOrder(adviserId, fromDate, toDate, status, issueId, userType, AgentCode, category, AuthenticateStatus, orderNo, userId);
            }
            catch (BaseApplicationException Ex)
            {
                throw Ex;
            }
            return(dt);
        }
        public DataTable GetFDIddueList(string Category)
        {
            DataTable           dt;
            OfflineBondOrderDao offlineBondDao = new OfflineBondOrderDao();

            try
            {
                dt = offlineBondDao.GetFDIddueList(Category);
            }
            catch (BaseApplicationException Ex)
            {
                throw Ex;
            }
            return(dt);
        }