Esempio n. 1
0
        /// <summary>
        /// Subscrube a follower to a specified system
        /// </summary>
        /// <param name="followerID">followers ID</param>
        /// <param name="systemID">systems ID</param>
        public void Subscribe(String followerID, Int32 systemID)
        {
            FollowerPropereties followerProps;
            //Перевірити чи існує такий користувач
            TradingClass follower = Program.GetFollowerById(followerID);
            if (follower == null)
            {
                lock (_syncFollowerList)
                {
                    IEnumerable<FollowerPropereties> followerToStart = from f in _notInitializedFollowers
                                                                       where f.FollowerID == followerID
                                                                       select f;
                    if (followerToStart.Count() == 0)
                        throw new Exception("Cannot find follower by id '" + followerID + "' at list of followers");
                    if (followerToStart.Count() != 0)
                        throw new Exception("There are more than 1 follower (" + followerToStart.Count());
                    //Створити фоловера
                    followerProps = followerToStart.ElementAt(0);
                    _notInitializedFollowers.Remove(followerProps);
                }
                follower = new TradingClass(followerProps.FollowerID, followerProps.FollowerBrokerLogin, followerProps.FollowerBrokerLogin,
                    url, followerProps.FollowerEmail, Program.dbHandler, followerProps.FollowerSynchMode);
            }
            //Перевірити чи користувач вже не підписаний на цю систему
            List<TradingClass> listOfFollowers;
            lock (Program.usersLock)
            {
                try
                {
                    listOfFollowers = Program.idUsers[systemID];
                }
                catch (KeyNotFoundException)
                {
                    listOfFollowers = new List<TradingClass>();
                }
                IEnumerable<TradingClass> finded = from searchedFollower in listOfFollowers
                                     where searchedFollower.FollowerID == followerID
                                     select searchedFollower;

                if (finded.Count() != 0) throw new Exception("follower '"+followerID+"' allready subscribe to system "+systemID);
                // Підписати фоловера
                listOfFollowers.Add(follower);
            }
        }
Esempio n. 2
0
        /// <summary>
        /// This method create a dictionary. The kay in the dictionary is the user listened systemID, the values of the Dictionary 
        /// is a list of users TradingClass that represents the current user account, that listen the current key SystemID
        /// </summary>
        /// <returns>a dictionary : key - user listened SystemID, value - a list of users thet listening current SystemID(key)</returns>
        public Dictionary<Int32, List<TradingClass>> getConnectedUsers(ErrorDbHandler mainDBhandler, ErrorHandler errorHandler)
        {
            Dictionary<Int32, List<TradingClass>> initializedFollowers = new Dictionary<Int32, List<TradingClass>>();
            List<CompleteFollower> followers = new List<CompleteFollower>();
            SqlDataReader reader = null;
            SqlCommand sqlCmd = null;
            StringBuilder sqlStrBuilder = new StringBuilder();

            //Отримати користувачів
            sqlStrBuilder.Append("SELECT TEMP.AccountId_,    TEMP.AccountType_,    TEMP.SubscriptionType_,\n")
                .Append("TEMP.BrockerName_,  TEMP.BrockerLogin_ ,  TEMP.BrockerPassswd_,\n")
                .Append("TEMP.SyncMethod_,   [USERS].[dbo].[aspnet_Membership].[Email]\n")
                .Append("FROM  [USERS].[dbo].[aspnet_Membership],\n")
                .Append("( SELECT [USERS].[dbo].[USERBROKERS].[AccountId] AS AccountId_,\n")
                .Append("[USERS].[dbo].[USERBROKERS].[UserId]			AS UserId_,\n")
                .Append("[USERS].[dbo].[USERBROKERS].[BrokerLogin]      AS BrockerLogin_,\n")
                .Append("[USERS].[dbo].[USERBROKERS].[BrokerName]		AS BrockerName_,\n")
                .Append("[USERS].[dbo].[USERBROKERS].[BrokerPassword]   AS BrockerPassswd_,\n")
                .Append("[USERS].[dbo].[USERBROKERS].[SubscriptionType] AS SubscriptionType_,\n")
                .Append("[USERS].[dbo].[USERBROKERS].[AccountType]	    AS AccountType_,\n")
                .Append("[USERS].[dbo].[USERBROKERS].[SyncMethod]       AS SyncMethod_\n")
                .Append(" FROM [USERS].[dbo].[USERBROKERS]\n")
                .Append("WHERE [USERS].[dbo].[USERBROKERS].[BrokerName] = '").Append(PLATFORM).Append("'\n")
                .Append("AND [USERS].[dbo].[USERBROKERS].[SubscriptionType] = 'Signal receiver'\n")
                .Append(") AS TEMP\n")
                .Append("WHERE [USERS].[dbo].[aspnet_Membership].[UserId] = TEMP.UserId_");

            sqlCmd = new SqlCommand(sqlStrBuilder.ToString(), conn);

            lock (sqlQueryLock)
            {
                try
                {
                    reader = sqlCmd.ExecuteReader();
                    while (reader.Read())
                    {
                        followers.Add(new CompleteFollower(reader, fieldsMatching));
                    }
                    sqlCmd.Dispose();
                    reader.Close();
                }
                catch (Exception e0)
                {
                    String errorStr = "Exception in DatabaseClass while try to get registered users/account from db";
                    Program.log.Error(errorStr);
                    Program.log.Debug("SQL command is " + sqlCmd.CommandText);
                    Program.log.Debug(e0.Message);
                    Program.log.Debug(e0.StackTrace);
                    Program.WriteError(errorStr + "\n" + e0.Message);
                }
                if (followers.Count == 0) return initializedFollowers;

                //Отримати список провайдерів на які підписані отримані користувачі
                sqlStrBuilder.Clear();
                sqlStrBuilder.Append("SELECT [USERS].[DBO].[AccountIdToSystemId].[AccountId],\n")
                    .Append("[USERS].[DBO].[AccountIdToSystemId].[SystemId]\n")
                    .Append("FROM [USERS].[dbo].[AccountIdToSystemId]\n")
                    .Append("WHERE [USERS].[DBO].[AccountIdToSystemId].[AccountId] = '").Append(followers[0].AccountId).Append("'\n");

                for (int i = 1; i < followers.Count; ++i)
                {
                    sqlStrBuilder.Append("OR [USERS].[DBO].[AccountIdToSystemId].[AccountId] = '").Append(followers[i].AccountId).Append("'\n");
                }
                sqlCmd = new SqlCommand(sqlStrBuilder.ToString(), conn);
                reader = sqlCmd.ExecuteReader();

                Dictionary<String, List<Int32>> readedMathing = new Dictionary<string, List<int>>();
                List<Int32> systems = new List<int>();
                String readedAccountId;

                while (reader.Read())
                {
                    readedAccountId = Convert.ToString(reader["AccountId"]);
                    try
                    {
                        systems = readedMathing[readedAccountId];
                    }
                    catch (KeyNotFoundException)
                    {
                        systems = new List<int>();
                    }
                    systems.Add(Convert.ToInt32(reader["SystemId"].ToString().GetHashCode()));
                    readedMathing[readedAccountId] = systems;
                }
                sqlCmd.Dispose();
                reader.Close();

                for (int i = 0; i < followers.Count; ++i)
                {
                    //Можлива ситуація що фоловер ще не підписаний ні наякі системи
                    try { followers[i].AddListenedSystems(readedMathing[followers[i].AccountId]); }
                    catch (KeyNotFoundException) { followers.RemoveAt(i--); }
                }
                //Ініціалізувати кожного фоловера (створити для них обєкти їх АРІ)
                TradingClass initializedFollower;
                List<TradingClass> initializedFollowersList;

                foreach (CompleteFollower follower in followers)
                {
                    initializedFollower = new TradingClass(
                         follower.AccountId, follower.BrokerLogin, follower.BrokerPassword,
                         "https://testapi.lmaxtrader.com/", follower.Email, mainDBhandler,
                         Presets.GetSyncMode(follower.SynchronizationType)
                         );
                    initializedFollower.Login();

                    foreach (Int32 system in follower.ListenedSystems)
                    {
                        try
                        {
                            initializedFollowersList = initializedFollowers[system];
                        }
                        catch (KeyNotFoundException)
                        {
                            initializedFollowersList = new List<TradingClass>();
                        }
                        initializedFollowersList.Add(initializedFollower);
                        initializedFollowers[system] = initializedFollowersList;
                    }
                }
                return initializedFollowers;
            }
        }