public int CreateIPOBidOrderDetails(int adviserId, int userId, DataTable dtIPOBidList, OnlineIPOOrderVo onlineIPOOrderVo, int agentId, string agentCode, int EmpId)
        {
            int orderId = 0;
            OfflineIPOOrderDao OfflineIPOOrderDao = new OfflineIPOOrderDao();

            try
            {
                orderId = OfflineIPOOrderDao.CreateIPOBidOrderDetails(adviserId, userId, dtIPOBidList, onlineIPOOrderVo, agentId, agentCode, EmpId);
            }
            catch (BaseApplicationException Ex)
            {
                throw Ex;
            }
            catch (Exception Ex)
            {
                BaseApplicationException exBase       = new BaseApplicationException(Ex.Message, Ex);
                NameValueCollection      FunctionInfo = new NameValueCollection();
                FunctionInfo.Add("Method", "BoOnlineOrderManagement.cs:CreateIPOBidOrderDetails(int adviserId, int userId, DataTable dtIPOBidList)");
                object[] objects = new object[2];
                objects[0]   = adviserId;
                objects[1]   = userId;
                FunctionInfo = exBase.AddObject(FunctionInfo, objects);
                exBase.AdditionalInformation = FunctionInfo;
                ExceptionManager.Publish(exBase);
                throw exBase;
            }
            return(orderId);
        }
        public DataTable GetIssueCategory(int issueId)
        {
            OfflineIPOOrderDao OfflineIPOOrderDao = new OfflineIPOOrderDao();
            DataTable          dt = OfflineIPOOrderDao.GetIssueCategory(issueId);

            return(dt);
        }
        public DataTable GetIPOIssueList(int adviserId, int issueId, int type, int customerSubTypeId)
        {
            DataTable          dtIPOIssueList;
            OfflineIPOOrderDao offlineIPOOrderDao = new OfflineIPOOrderDao();

            try
            {
                dtIPOIssueList = offlineIPOOrderDao.GetIPOIssueList(adviserId, issueId, type, customerSubTypeId);
            }
            catch (BaseApplicationException Ex)
            {
                throw Ex;
            }
            catch (Exception Ex)
            {
                BaseApplicationException exBase       = new BaseApplicationException(Ex.Message, Ex);
                NameValueCollection      FunctionInfo = new NameValueCollection();
                FunctionInfo.Add("Method", "BoOfflineOrderManagement.cs:GetIPOIssueList(int adviserId)");
                object[] objects = new object[1];
                objects[0]   = adviserId;
                FunctionInfo = exBase.AddObject(FunctionInfo, objects);
                exBase.AdditionalInformation = FunctionInfo;
                ExceptionManager.Publish(exBase);
                throw exBase;
            }
            return(dtIPOIssueList);
        }
        public bool OrderedDuplicateCheck(int orderId)
        {
            bool bResult = false;
            OfflineIPOOrderDao OfflineIPOOrderDao = new OfflineIPOOrderDao();

            try
            {
                bResult = OfflineIPOOrderDao.OrderedDuplicateCheck(orderId);
            }
            catch (BaseApplicationException Ex)
            {
                throw Ex;
            }
            catch (Exception Ex)
            {
                BaseApplicationException exBase       = new BaseApplicationException(Ex.Message, Ex);
                NameValueCollection      FunctionInfo = new NameValueCollection();
                FunctionInfo.Add("Method", "OfflineIPOOrderDao.cs:PANNumberDuplicateCheck()");
                object[] objects = new object[2];
                objects[0]   = orderId;
                FunctionInfo = exBase.AddObject(FunctionInfo, objects);
                exBase.AdditionalInformation = FunctionInfo;
                ExceptionManager.Publish(exBase);
                throw exBase;
            }
            return(bResult);
        }
        public bool UpdateIPOBidOrderDetails(DataTable dtIPOBidTransactionDettails, int orderNo, string benificialAcc, string brokerCode, int userId, OnlineIPOOrderVo onlineIPOOrderVo, int EmpId)
        {
            bool bResult = false;
            OfflineIPOOrderDao OfflineIPOOrderDao = new OfflineIPOOrderDao();

            try
            {
                bResult = OfflineIPOOrderDao.UpdateIPOBidOrderDetails(dtIPOBidTransactionDettails, orderNo, benificialAcc, brokerCode, userId, onlineIPOOrderVo, EmpId);
            }
            catch (BaseApplicationException Ex)
            {
                throw Ex;
            }
            return(bResult);
        }
        public DataSet GetIPOIssueOrderDetails(int orderId)
        {
            DataSet            dsGetIPOIssueOrderDetails;
            OfflineIPOOrderDao OfflineIPOOrderDao = new OfflineIPOOrderDao();

            try
            {
                dsGetIPOIssueOrderDetails = OfflineIPOOrderDao.GetIPOIssueOrderDetails(orderId);
            }
            catch (BaseApplicationException Ex)
            {
                throw Ex;
            }
            return(dsGetIPOIssueOrderDetails);
        }