コード例 #1
0
        public List <mastertrader> GetNewMastertrader(string oldmd5)
        {
            List <mastertrader> result = new List <mastertrader>();

            ConnectDB();
            string       sql = "SELECT * FROM mastertrader";
            MySqlCommand cmd = new MySqlCommand(sql, conn);

            try
            {
                using (MySqlDataReader reader = cmd.ExecuteReader())
                {
                    while (reader.Read())
                    {
                        string md5hash = reader.GetString("md5");
                        if (oldmd5.Contains(md5hash) == false)
                        {
                            mastertrader tam = new mastertrader();
                            tam.id           = reader.GetInt16("id");
                            tam.sourcedata   = reader.GetString("sourcedata");
                            tam.username     = reader.GetString("username");
                            tam.symbol       = reader.GetString("symbol");
                            tam.typeorder    = reader.GetInt16("typeorder");
                            tam.size         = reader.GetDouble("size");
                            tam.datetime     = reader.GetString("datetime");
                            tam.openprice    = reader.GetDouble("openprice");
                            tam.currentprice = reader.GetDouble("currentprice");
                            tam.stoploss     = reader.GetDouble("stoploss");
                            tam.takeprofit   = reader.GetDouble("takeprofit");
                            tam.profit       = reader.GetDouble("profit");
                            tam.md5          = reader.GetString("md5");
                            result.Add(tam);
                        }
                    }
                }
                error_mes = null;
            }
            catch (MySqlException error)
            {
                error_mes = "Getnewmastertrader: " + error.Message;
            }
            return(result);
        }
コード例 #2
0
        public string InsertMastertrader(mastertrader newmastertrader, string sourcedata, string username)
        {
            string sql = "INSERT INTO mastertrader (sourcedata,username,symbol,typeorder,size,datetime,openprice,currentprice,stoploss,takeprofit,profit,md5)"
                         + " VALUES (@sourcedata,@username,@symbol,@typeorder,@size,@datetime,@openprice,@currentprice,@stoploss,@takeprofit,@profit,@md5)";
            MySqlCommand cmd = new MySqlCommand(sql, conn);

            cmd.Parameters.AddWithValue("@sourcedata", sourcedata);
            cmd.Parameters.AddWithValue("@username", username);
            cmd.Parameters.AddWithValue("@symbol", newmastertrader.symbol);
            cmd.Parameters.AddWithValue("@size", newmastertrader.size);
            cmd.Parameters.AddWithValue("@datetime", newmastertrader.datetime);
            cmd.Parameters.AddWithValue("@openprice", newmastertrader.openprice);
            cmd.Parameters.AddWithValue("@currentprice", newmastertrader.currentprice);
            cmd.Parameters.AddWithValue("@stoploss", newmastertrader.stoploss);
            cmd.Parameters.AddWithValue("@takeprofit", newmastertrader.takeprofit);
            cmd.Parameters.AddWithValue("@profit", newmastertrader.profit);
            cmd.Parameters.AddWithValue("@typeorder", newmastertrader.typeorder);

            string str_hashmd5 = newmastertrader.datetime + username + sourcedata;
            string hashmd5     = Util.MD5(str_hashmd5);

            cmd.Parameters.AddWithValue("@md5", hashmd5);
            if (CheckExistMastertrader(hashmd5))
            {
                return("duplicate");
            }
            ConnectDB();
            try
            {
                cmd.ExecuteNonQuery();
                CloseDB();
                error_mes = null;
                return("success");
            }
            catch (MySqlException error)
            {
                CloseDB();
                error_mes = "Insertmastertrader: " + error.Message;
                return("error");
            }
        }
コード例 #3
0
        public List <mastertrader> GetMastertraderByUsername(string username)
        {
            List <mastertrader> result = new List <mastertrader>();

            ConnectDB();
            string       sql = "SELECT * FROM mastertrader WHERE username=@username";
            MySqlCommand cmd = new MySqlCommand(sql, conn);

            cmd.Parameters.AddWithValue("@username", username);
            try
            {
                using (MySqlDataReader reader = cmd.ExecuteReader())
                {
                    while (reader.Read())
                    {
                        mastertrader tam = new mastertrader();
                        tam.id           = reader.GetInt16("id");
                        tam.sourcedata   = reader.GetString("sourcedata");
                        tam.username     = reader.GetString("username");
                        tam.symbol       = reader.GetString("symbol");
                        tam.typeorder    = reader.GetInt16("typeorder");
                        tam.size         = reader.GetDouble("size");
                        tam.datetime     = reader.GetString("datetime");
                        tam.openprice    = reader.GetDouble("openprice");
                        tam.currentprice = reader.GetDouble("currentprice");
                        tam.stoploss     = reader.GetDouble("stoploss");
                        tam.takeprofit   = reader.GetDouble("takeprofit");
                        tam.profit       = reader.GetDouble("profit");
                        tam.md5          = reader.GetString("md5");
                        result.Add(tam);
                    }
                }
                error_mes = null;
            }
            catch (MySqlException error)
            {
                error_mes = "GetMastertraderByUsername: " + error.Message;
            }
            CloseDB();
            return(result);
        }
コード例 #4
0
        public string SendOrderToTrade(mastertrader newmastertrader, string namemt4, string mode = "absolute")
        {
            string result    = "";//buy sb xauusd size 0.01 price 0 pricesl 1500 pricetp 1400 comment mastertrader mt4 l
            string typeorder = "typewrong";

            if (newmastertrader.typeorder == 0)
            {
                typeorder = "buy";
            }
            else if (newmastertrader.typeorder == 1)
            {
                typeorder = "sell";
            }
            else if (newmastertrader.typeorder == 2)
            {
                typeorder = "buylimit";
            }
            else if (newmastertrader.typeorder == 3)
            {
                typeorder = "selllimit";
            }
            else if (newmastertrader.typeorder == 4)
            {
                typeorder = "buystop";
            }
            else if (newmastertrader.typeorder == 5)
            {
                typeorder = "sellstop";
            }
            if (mode == "absolute")
            {
                result += typeorder + " " + newmastertrader.symbol + " " + newmastertrader.size + " " + newmastertrader.openprice + " " + newmastertrader.stoploss + " " + newmastertrader.takeprofit + " idmastertrader=" + newmastertrader.id + " " + namemt4;
            }
            else if (mode == "scalping")
            {
                result += typeorder + " " + newmastertrader.symbol + " " + newmastertrader.size + " " + newmastertrader.openprice + " -1 -1 " + " idmastertrader=" + newmastertrader.id + " " + namemt4;
            }
            return(result);
        }
コード例 #5
0
ファイル: Program.cs プロジェクト: ogzcnr/web
        //Kudji,458257
        static void Main(string[] args)
        {
            Bot = new TelegramBotClient(token);

            Thread SendOrderToTrade;

            SendOrderToTrade = new Thread(delegate()
            {
                Thread.Sleep(1000 * 60);
                string OldMD5 = db_SendOrderToTrade.GetOldMD5();
                try
                {
                    while (true)
                    {
                        List <mastertrader> newmastertraders = db_SendOrderToTrade.GetNewMastertrader(OldMD5);
                        if (newmastertraders.Count == 0)
                        {
                            continue;
                        }
                        foreach (mastertrader newmastertrader in newmastertraders)
                        {
                            if (newmastertrader.username == "Alexngo_vn" || newmastertrader.username == "Happytrader" || newmastertrader.username == "RUBI")
                            {
                                nonlive orderopen  = new nonlive();
                                orderopen.chatid   = 635860813;
                                orderopen.username = "******";
                                string command     = db_SendOrderToTrade.SendOrderToTrade(newmastertrader, "thong250485@aifu");
                                OldMD5            += newmastertrader.md5 + "|";
                                string keyword     = command.Split(' ')[0];
                                orderopen.keyword  = keyword;
                                orderopen.name_mt4 = "thong250485@aifu";
                                orderopen.command  = command;
                                orderopen.datetime = DateTime.Now.ToString();
                                db_SendOrderToTrade.InsertNonLive(orderopen);
                            }
                        }
                        Thread.Sleep(500);
                    }
                }
                catch (Exception ex)
                {
                    Console.WriteLine("SendOrderToTrade: " + ex.StackTrace);
                }
            });
            SendOrderToTrade.Start();

            Thread Kudji;
            bool   runKudji = true;

            Kudji = new Thread(delegate()
            {
                while (true)
                {
                    string str_hashmd5     = "";
                    var client             = new RestClient("https://my.liteforex.com");
                    var request            = new RestRequest("vi/traders/trades?id=458257", Method.GET);//@Kudji
                    IRestResponse response = client.Execute(request);
                    string html            = response.Content;
                    if (html.Contains("Nhà giao dịch không có giao dịch mở hiện tại"))
                    {
                        continue;
                    }
                    try
                    {
                        HtmlNodeCollection div_content_rows = Util.HtmlGetNodeCollection(html, "//div[@class='content_row']");
                        if (div_content_rows.Count == 0)
                        {
                            continue;
                        }
                        List <mastertrader> newmastertraders = new List <mastertrader>();
                        foreach (HtmlNode div_content_row in div_content_rows)
                        {
                            string html_div_content_row         = div_content_row.InnerHtml;
                            HtmlNodeCollection div_content_cols = Util.HtmlGetNodeCollection(html_div_content_row, "//div[@class='content_col']");
                            mastertrader newmastertrader        = new mastertrader();
                            newmastertrader.symbol       = div_content_cols[0].InnerText.Replace(" ", "").Replace("\n", "");
                            string typeorder             = div_content_cols[1].InnerText.Replace(" ", "").Replace("\n", "");
                            newmastertrader.size         = double.Parse(div_content_cols[2].InnerText.Replace(" ", "").Replace("\n", ""));
                            newmastertrader.datetime     = div_content_cols[3].InnerText.Replace(" ", "").Replace("\n", "");
                            double openprice             = double.Parse(div_content_cols[4].InnerText.Replace(" ", "").Replace("\n", ""));
                            newmastertrader.openprice    = openprice;
                            double currentprice          = double.Parse(div_content_cols[5].InnerText.Replace(" ", "").Replace("\n", ""));
                            newmastertrader.currentprice = currentprice;
                            if (typeorder == "Mua")
                            {
                                newmastertrader.typeorder = 0;
                            }
                            else if (typeorder == "Bán")
                            {
                                newmastertrader.typeorder = 1;
                            }
                            else if (typeorder == "Muatại" && openprice < currentprice)
                            {
                                newmastertrader.typeorder = 2;
                            }
                            else if (typeorder == "Bántại" && openprice > currentprice)
                            {
                                newmastertrader.typeorder = 3;
                            }
                            else if (typeorder == "Muatại" && openprice > currentprice)
                            {
                                newmastertrader.typeorder = 4;
                            }
                            else if (typeorder == "Bántại" && openprice < currentprice)
                            {
                                newmastertrader.typeorder = 5;
                            }
                            else
                            {
                                newmastertrader.typeorder = 6;
                            }
                            newmastertrader.stoploss   = double.Parse(div_content_cols[6].InnerText.Replace(" ", "").Replace("\n", ""));
                            newmastertrader.takeprofit = double.Parse(div_content_cols[7].InnerText.Replace(" ", "").Replace("\n", ""));
                            newmastertrader.profit     = double.Parse(div_content_cols[8].InnerText.Replace(" ", "").Replace("\n", "").Replace("Lợinhuận", "").Replace("USD", ""));
                            newmastertraders.Add(newmastertrader);

                            str_hashmd5 += Util.MD5(newmastertrader.datetime + "Kudji" + "Lite") + ",";
                        }
                        foreach (mastertrader newmastertrader in newmastertraders)
                        {
                            string info_InsertOrder = db_Kudji.InsertMastertrader(newmastertrader, "Lite", "Kudji");
                            if (info_InsertOrder == "error")
                            {
                                Console.WriteLine("Lite@Kudji");
                                return;
                            }
                        }
                        List <mastertrader> MastertraderKudjis = db_Kudji.GetMastertraderByUsername("Kudji");
                        foreach (mastertrader MastertraderKudji in MastertraderKudjis)
                        {
                            if (db_Kudji.DeleteClosemastertrader(MastertraderKudji.md5, str_hashmd5))
                            {
                                string commentdel           = "idmastertrader=" + MastertraderKudji.id;
                                List <copytrade> CopyTrades = db_Kudji.GetCopytradeDelByComment(commentdel);
                                foreach (copytrade CopyTrade in CopyTrades)
                                {
                                    nonlive orderclose  = new nonlive();
                                    orderclose.chatid   = 635860813;
                                    orderclose.username = CopyTrade.namemt4.Split('@')[0];

                                    int ticketclose     = CopyTrade.ticket;
                                    string namemt4close = CopyTrade.namemt4;
                                    int typeorder       = CopyTrade.typeorder;
                                    string command      = db_Kudji.SendOrderToClose(ticketclose, namemt4close, typeorder);
                                    string keyword      = command.Split(' ')[0];
                                    orderclose.keyword  = keyword;
                                    orderclose.name_mt4 = CopyTrade.namemt4;
                                    orderclose.command  = command;
                                    orderclose.datetime = DateTime.Now.ToString();
                                    db_Kudji.InsertNonLive(orderclose);
                                }
                            }
                        }
                    }
                    catch (Exception ex)
                    {
                        Bot.SendTextMessageAsync(635860813, "Lite@Kudji: " + ex.StackTrace);
                        runKudji = false;
                    }
                    Thread.Sleep(500);
                }
            });
            //Kudji.Start();
            if (runKudji == false)
            {
                Kudji.Abort();
            }

            Thread RUBI;
            bool   runRUBI = true;

            RUBI = new Thread(delegate()
            {
                while (true)
                {
                    string str_hashmd5     = "";
                    var client             = new RestClient("https://my.liteforex.com");
                    var request            = new RestRequest("vi/traders/trades?id=793606", Method.GET);//@RUBI
                    IRestResponse response = client.Execute(request);
                    string html            = response.Content;
                    if (html.Contains("Nhà giao dịch không có giao dịch mở hiện tại"))
                    {
                        continue;
                    }
                    try
                    {
                        HtmlNodeCollection div_content_rows = Util.HtmlGetNodeCollection(html, "//div[@class='content_row']");
                        if (div_content_rows.Count == 0)
                        {
                            continue;
                        }
                        List <mastertrader> newmastertraders = new List <mastertrader>();
                        foreach (HtmlNode div_content_row in div_content_rows)
                        {
                            string html_div_content_row         = div_content_row.InnerHtml;
                            HtmlNodeCollection div_content_cols = Util.HtmlGetNodeCollection(html_div_content_row, "//div[@class='content_col']");
                            mastertrader newmastertrader        = new mastertrader();
                            newmastertrader.symbol       = div_content_cols[0].InnerText.Replace(" ", "").Replace("\n", "");
                            string typeorder             = div_content_cols[1].InnerText.Replace(" ", "").Replace("\n", "");
                            newmastertrader.size         = double.Parse(div_content_cols[2].InnerText.Replace(" ", "").Replace("\n", ""));
                            newmastertrader.datetime     = div_content_cols[3].InnerText.Replace(" ", "").Replace("\n", "");
                            double openprice             = double.Parse(div_content_cols[4].InnerText.Replace(" ", "").Replace("\n", ""));
                            newmastertrader.openprice    = openprice;
                            double currentprice          = double.Parse(div_content_cols[5].InnerText.Replace(" ", "").Replace("\n", ""));
                            newmastertrader.currentprice = currentprice;
                            if (typeorder == "Mua")
                            {
                                newmastertrader.typeorder = 0;
                            }
                            else if (typeorder == "Bán")
                            {
                                newmastertrader.typeorder = 1;
                            }
                            else if (typeorder == "Muatại" && openprice < currentprice)
                            {
                                newmastertrader.typeorder = 2;
                            }
                            else if (typeorder == "Bántại" && openprice > currentprice)
                            {
                                newmastertrader.typeorder = 3;
                            }
                            else if (typeorder == "Muatại" && openprice > currentprice)
                            {
                                newmastertrader.typeorder = 4;
                            }
                            else if (typeorder == "Bántại" && openprice < currentprice)
                            {
                                newmastertrader.typeorder = 5;
                            }
                            else
                            {
                                newmastertrader.typeorder = 6;
                            }
                            newmastertrader.stoploss   = double.Parse(div_content_cols[6].InnerText.Replace(" ", "").Replace("\n", ""));
                            newmastertrader.takeprofit = double.Parse(div_content_cols[7].InnerText.Replace(" ", "").Replace("\n", ""));
                            newmastertrader.profit     = double.Parse(div_content_cols[8].InnerText.Replace(" ", "").Replace("\n", "").Replace("Lợinhuận", "").Replace("USD", ""));
                            newmastertraders.Add(newmastertrader);
                            string info_InsertOrder = db_RUBI.InsertMastertrader(newmastertraders[0], "Lite", "RUBI");

                            str_hashmd5 += Util.MD5(newmastertrader.datetime + "RUBI" + "Lite") + ",";

                            if (info_InsertOrder == "error")
                            {
                                Console.WriteLine("Lite@RUBI");
                                runRUBI = false;
                                break;
                            }
                        }
                        List <mastertrader> MastertraderRUBIs = db_RUBI.GetMastertraderByUsername("RUBI");
                        foreach (mastertrader MastertraderRUBI in MastertraderRUBIs)
                        {
                            if (db_RUBI.DeleteClosemastertrader(MastertraderRUBI.md5, str_hashmd5))
                            {
                                string commentdel           = "idmastertrader=" + MastertraderRUBI.id;
                                List <copytrade> CopyTrades = db_RUBI.GetCopytradeDelByComment(commentdel);
                                foreach (copytrade CopyTrade in CopyTrades)
                                {
                                    nonlive orderclose  = new nonlive();
                                    orderclose.chatid   = 635860813;
                                    orderclose.username = CopyTrade.namemt4.Split('@')[0];

                                    int ticketclose     = CopyTrade.ticket;
                                    string namemt4close = CopyTrade.namemt4;
                                    int typeorder       = CopyTrade.typeorder;
                                    string command      = db_RUBI.SendOrderToClose(ticketclose, namemt4close, typeorder);
                                    string keyword      = command.Split(' ')[0];
                                    orderclose.keyword  = keyword;
                                    orderclose.name_mt4 = CopyTrade.namemt4;
                                    orderclose.command  = command;
                                    orderclose.datetime = DateTime.Now.ToString();
                                    db_RUBI.InsertNonLive(orderclose);
                                }
                            }
                        }
                    }
                    catch (Exception ex)
                    {
                        Bot.SendTextMessageAsync(635860813, "Lite@RUBI: " + ex.StackTrace);
                        runRUBI = false;
                    }
                    Thread.Sleep(500);
                }
            });
            RUBI.Start();
            if (runRUBI == false)
            {
                RUBI.Abort();
            }


            Thread StevenHulk;
            bool   runStevenHulk = true;

            StevenHulk = new Thread(delegate()
            {
                while (true)
                {
                    var client             = new RestClient("https://my.liteforex.com");
                    var request            = new RestRequest("vi/traders/trades?id=852158", Method.GET);//@Happytrader
                    IRestResponse response = client.Execute(request);
                    string html            = response.Content;
                    string str_hashmd5     = "";
                    try
                    {
                        if (html.Contains("Nhà giao dịch không có giao dịch mở hiện tại") == false)
                        {
                            HtmlNodeCollection div_content_rows = Util.HtmlGetNodeCollection(html, "//div[@class='content_row']");
                            if (div_content_rows.Count == 0)
                            {
                                continue;
                            }
                            List <mastertrader> newmastertraders = new List <mastertrader>();
                            foreach (HtmlNode div_content_row in div_content_rows)
                            {
                                string html_div_content_row         = div_content_row.InnerHtml;
                                HtmlNodeCollection div_content_cols = Util.HtmlGetNodeCollection(html_div_content_row, "//div[@class='content_col']");
                                mastertrader newmastertrader        = new mastertrader();
                                newmastertrader.symbol       = div_content_cols[0].InnerText.Replace(" ", "").Replace("\n", "");
                                string typeorder             = div_content_cols[1].InnerText.Replace(" ", "").Replace("\n", "");
                                newmastertrader.size         = double.Parse(div_content_cols[2].InnerText.Replace(" ", "").Replace("\n", ""));
                                newmastertrader.datetime     = div_content_cols[3].InnerText.Replace(" ", "").Replace("\n", "");
                                double openprice             = double.Parse(div_content_cols[4].InnerText.Replace(" ", "").Replace("\n", ""));
                                newmastertrader.openprice    = openprice;
                                double currentprice          = double.Parse(div_content_cols[5].InnerText.Replace(" ", "").Replace("\n", ""));
                                newmastertrader.currentprice = currentprice;
                                if (typeorder == "Mua")
                                {
                                    newmastertrader.typeorder = 0;
                                }
                                else if (typeorder == "Bán")
                                {
                                    newmastertrader.typeorder = 1;
                                }
                                else if (typeorder == "Muatại" && openprice < currentprice)
                                {
                                    newmastertrader.typeorder = 2;
                                }
                                else if (typeorder == "Bántại" && openprice > currentprice)
                                {
                                    newmastertrader.typeorder = 3;
                                }
                                else if (typeorder == "Muatại" && openprice > currentprice)
                                {
                                    newmastertrader.typeorder = 4;
                                }
                                else if (typeorder == "Bántại" && openprice < currentprice)
                                {
                                    newmastertrader.typeorder = 5;
                                }
                                else
                                {
                                    newmastertrader.typeorder = 6;
                                }
                                newmastertrader.stoploss   = double.Parse(div_content_cols[6].InnerText.Replace(" ", "").Replace("\n", ""));
                                newmastertrader.takeprofit = double.Parse(div_content_cols[7].InnerText.Replace(" ", "").Replace("\n", ""));
                                newmastertrader.profit     = double.Parse(div_content_cols[8].InnerText.Replace(" ", "").Replace("\n", "").Replace("Lợinhuận", "").Replace("USD", ""));
                                newmastertraders.Add(newmastertrader);

                                str_hashmd5 += Util.MD5(newmastertrader.datetime + "StevenHulk" + "Lite") + ",";
                            }
                            foreach (mastertrader newmastertrader in newmastertraders)
                            {
                                string info_InsertOrder = db_StevenHulk.InsertMastertrader(newmastertrader, "Lite", "StevenHulk");
                                if (info_InsertOrder == "error")
                                {
                                    Console.WriteLine("Lite@StevenHulk");
                                    return;
                                }
                            }
                        }
                        List <mastertrader> MastertraderStevenHulks = db_StevenHulk.GetMastertraderByUsername("StevenHulk");
                        foreach (mastertrader MastertraderStevenHulk in MastertraderStevenHulks)
                        {
                            if (db_StevenHulk.DeleteClosemastertrader(MastertraderStevenHulk.md5, str_hashmd5))
                            {
                                string commentdel           = "idmastertrader=" + MastertraderStevenHulk.id;
                                List <copytrade> CopyTrades = db_StevenHulk.GetCopytradeDelByComment(commentdel);
                                foreach (copytrade CopyTrade in CopyTrades)
                                {
                                    nonlive orderclose  = new nonlive();
                                    orderclose.chatid   = 635860813;
                                    orderclose.username = CopyTrade.namemt4.Split('@')[0];

                                    int ticketclose     = CopyTrade.ticket;
                                    string namemt4close = CopyTrade.namemt4;
                                    int typeorder       = CopyTrade.typeorder;
                                    string command      = db_StevenHulk.SendOrderToClose(ticketclose, namemt4close, typeorder);
                                    string keyword      = command.Split(' ')[0];
                                    orderclose.keyword  = keyword;
                                    orderclose.name_mt4 = CopyTrade.namemt4;
                                    orderclose.command  = command;
                                    orderclose.datetime = DateTime.Now.ToString();
                                    db_StevenHulk.InsertNonLive(orderclose);
                                }
                            }
                        }
                    }
                    catch (Exception ex)
                    {
                        Bot.SendTextMessageAsync(635860813, "Lite@StevenHulk: " + ex.StackTrace);
                        Bot.SendTextMessageAsync(635860813, "Lite@StevenHulk: " + ex.Message);
                        runStevenHulk = false;
                    }
                    Thread.Sleep(500);
                }
            });
            //StevenHulk.Start();
            if (runStevenHulk == false)
            {
                StevenHulk.Abort();
            }

            Thread Alexngo_vn;
            bool   runAlexngo_vn = true;

            Alexngo_vn = new Thread(delegate()
            {
                while (true)
                {
                    var client             = new RestClient("https://my.liteforex.com");
                    var request            = new RestRequest("vi/traders/trades?id=805126", Method.GET);//@Anthony_Khai
                    IRestResponse response = client.Execute(request);
                    string html            = response.Content;
                    string str_hashmd5     = "";
                    if (html.Contains("Nhà giao dịch không có giao dịch mở hiện tại"))
                    {
                        continue;
                    }
                    try
                    {
                        HtmlNodeCollection div_content_rows = Util.HtmlGetNodeCollection(html, "//div[@class='content_row']");
                        if (div_content_rows.Count == 0)
                        {
                            continue;
                        }
                        List <mastertrader> newmastertraders = new List <mastertrader>();
                        foreach (HtmlNode div_content_row in div_content_rows)
                        {
                            string html_div_content_row         = div_content_row.InnerHtml;
                            HtmlNodeCollection div_content_cols = Util.HtmlGetNodeCollection(html_div_content_row, "//div[@class='content_col']");
                            mastertrader newmastertrader        = new mastertrader();
                            newmastertrader.symbol       = div_content_cols[0].InnerText.Replace(" ", "").Replace("\n", "");
                            string typeorder             = div_content_cols[1].InnerText.Replace(" ", "").Replace("\n", "");
                            newmastertrader.size         = double.Parse(div_content_cols[2].InnerText.Replace(" ", "").Replace("\n", ""));
                            newmastertrader.datetime     = div_content_cols[3].InnerText.Replace(" ", "").Replace("\n", "");
                            double openprice             = double.Parse(div_content_cols[4].InnerText.Replace(" ", "").Replace("\n", ""));
                            newmastertrader.openprice    = openprice;
                            double currentprice          = double.Parse(div_content_cols[5].InnerText.Replace(" ", "").Replace("\n", ""));
                            newmastertrader.currentprice = currentprice;
                            if (typeorder == "Mua")
                            {
                                newmastertrader.typeorder = 0;
                            }
                            else if (typeorder == "Bán")
                            {
                                newmastertrader.typeorder = 1;
                            }
                            else if (typeorder == "Muatại" && openprice < currentprice)
                            {
                                newmastertrader.typeorder = 2;
                            }
                            else if (typeorder == "Bántại" && openprice > currentprice)
                            {
                                newmastertrader.typeorder = 3;
                            }
                            else if (typeorder == "Muatại" && openprice > currentprice)
                            {
                                newmastertrader.typeorder = 4;
                            }
                            else if (typeorder == "Bántại" && openprice < currentprice)
                            {
                                newmastertrader.typeorder = 5;
                            }
                            else
                            {
                                newmastertrader.typeorder = 6;
                            }
                            newmastertrader.stoploss   = double.Parse(div_content_cols[6].InnerText.Replace(" ", "").Replace("\n", ""));
                            newmastertrader.takeprofit = double.Parse(div_content_cols[7].InnerText.Replace(" ", "").Replace("\n", ""));
                            newmastertrader.profit     = double.Parse(div_content_cols[8].InnerText.Replace(" ", "").Replace("\n", "").Replace("Lợinhuận", "").Replace("USD", ""));
                            newmastertraders.Add(newmastertrader);
                            string info_InsertOrder = db_Alexngo_vn.InsertMastertrader(newmastertraders[0], "Lite", "Alexngo_vn");

                            str_hashmd5 += Util.MD5(newmastertrader.datetime + "Alexngo_vn" + "Lite") + ",";

                            if (info_InsertOrder == "error")
                            {
                                Console.WriteLine("Lite@Alexngo_vn");
                                runAlexngo_vn = false;
                                break;
                            }
                        }
                        List <mastertrader> MastertraderAlexngo_vns = db_Alexngo_vn.GetMastertraderByUsername("Alexngo_vn");
                        foreach (mastertrader MastertraderAlexngo_vn in MastertraderAlexngo_vns)
                        {
                            if (db_Alexngo_vn.DeleteClosemastertrader(MastertraderAlexngo_vn.md5, str_hashmd5))
                            {
                                string commentdel           = "idmastertrader=" + MastertraderAlexngo_vn.id;
                                List <copytrade> CopyTrades = db_Alexngo_vn.GetCopytradeDelByComment(commentdel);
                                foreach (copytrade CopyTrade in CopyTrades)
                                {
                                    nonlive orderclose  = new nonlive();
                                    orderclose.chatid   = 635860813;
                                    orderclose.username = CopyTrade.namemt4.Split('@')[0];

                                    int ticketclose     = CopyTrade.ticket;
                                    string namemt4close = CopyTrade.namemt4;
                                    int typeorder       = CopyTrade.typeorder;
                                    string command      = db_Alexngo_vn.SendOrderToClose(ticketclose, namemt4close, typeorder);
                                    string keyword      = command.Split(' ')[0];
                                    orderclose.keyword  = keyword;
                                    orderclose.name_mt4 = CopyTrade.namemt4;
                                    orderclose.command  = command;
                                    orderclose.datetime = DateTime.Now.ToString();
                                    db_Alexngo_vn.InsertNonLive(orderclose);
                                }
                            }
                        }
                    }
                    catch (Exception ex)
                    {
                        Bot.SendTextMessageAsync(635860813, "Lite@Alexngo_vn: " + ex.StackTrace);
                        runAlexngo_vn = false;
                    }
                    Thread.Sleep(500);
                }
            });
            Alexngo_vn.Start();
            if (runAlexngo_vn == false)
            {
                Alexngo_vn.Abort();
            }

            Thread Happytrader;
            bool   runHappytrader = true;

            Happytrader = new Thread(delegate()
            {
                while (true)
                {
                    var client             = new RestClient("https://my.liteforex.com");
                    var request            = new RestRequest("vi/traders/trades?id=743781", Method.GET);//@Happytrader
                    IRestResponse response = client.Execute(request);
                    string html            = response.Content;
                    string str_hashmd5     = "";
                    if (html.Contains("Nhà giao dịch không có giao dịch mở hiện tại"))
                    {
                        continue;
                    }
                    try
                    {
                        HtmlNodeCollection div_content_rows = Util.HtmlGetNodeCollection(html, "//div[@class='content_row']");
                        if (div_content_rows.Count == 0)
                        {
                            continue;
                        }
                        List <mastertrader> newmastertraders = new List <mastertrader>();
                        foreach (HtmlNode div_content_row in div_content_rows)
                        {
                            string html_div_content_row         = div_content_row.InnerHtml;
                            HtmlNodeCollection div_content_cols = Util.HtmlGetNodeCollection(html_div_content_row, "//div[@class='content_col']");
                            mastertrader newmastertrader        = new mastertrader();
                            newmastertrader.symbol       = div_content_cols[0].InnerText.Replace(" ", "").Replace("\n", "");
                            string typeorder             = div_content_cols[1].InnerText.Replace(" ", "").Replace("\n", "");
                            newmastertrader.size         = double.Parse(div_content_cols[2].InnerText.Replace(" ", "").Replace("\n", ""));
                            newmastertrader.datetime     = div_content_cols[3].InnerText.Replace(" ", "").Replace("\n", "");
                            double openprice             = double.Parse(div_content_cols[4].InnerText.Replace(" ", "").Replace("\n", ""));
                            newmastertrader.openprice    = openprice;
                            double currentprice          = double.Parse(div_content_cols[5].InnerText.Replace(" ", "").Replace("\n", ""));
                            newmastertrader.currentprice = currentprice;
                            if (typeorder == "Mua")
                            {
                                newmastertrader.typeorder = 0;
                            }
                            else if (typeorder == "Bán")
                            {
                                newmastertrader.typeorder = 1;
                            }
                            else if (typeorder == "Muatại" && openprice < currentprice)
                            {
                                newmastertrader.typeorder = 2;
                            }
                            else if (typeorder == "Bántại" && openprice > currentprice)
                            {
                                newmastertrader.typeorder = 3;
                            }
                            else if (typeorder == "Muatại" && openprice > currentprice)
                            {
                                newmastertrader.typeorder = 4;
                            }
                            else if (typeorder == "Bántại" && openprice < currentprice)
                            {
                                newmastertrader.typeorder = 5;
                            }
                            else
                            {
                                newmastertrader.typeorder = 6;
                            }
                            newmastertrader.stoploss   = double.Parse(div_content_cols[6].InnerText.Replace(" ", "").Replace("\n", ""));
                            newmastertrader.takeprofit = double.Parse(div_content_cols[7].InnerText.Replace(" ", "").Replace("\n", ""));
                            newmastertrader.profit     = double.Parse(div_content_cols[8].InnerText.Replace(" ", "").Replace("\n", "").Replace("Lợinhuận", "").Replace("USD", ""));
                            newmastertraders.Add(newmastertrader);
                            string info_InsertOrder = db_Happytrader.InsertMastertrader(newmastertraders[0], "Lite", "Happytrader");

                            str_hashmd5 += Util.MD5(newmastertrader.datetime + "Happytrader" + "Lite") + ",";

                            if (info_InsertOrder == "error")
                            {
                                Console.WriteLine("Lite@Happytrader");
                                runHappytrader = false;
                                break;
                            }
                        }
                        List <mastertrader> MastertraderHappytraders = db_Happytrader.GetMastertraderByUsername("Happytrader");
                        foreach (mastertrader MastertraderHappytrader in MastertraderHappytraders)
                        {
                            if (db_Happytrader.DeleteClosemastertrader(MastertraderHappytrader.md5, str_hashmd5))
                            {
                                string commentdel           = "idmastertrader=" + MastertraderHappytrader.id;
                                List <copytrade> CopyTrades = db_Happytrader.GetCopytradeDelByComment(commentdel);
                                foreach (copytrade CopyTrade in CopyTrades)
                                {
                                    nonlive orderclose  = new nonlive();
                                    orderclose.chatid   = 635860813;
                                    orderclose.username = CopyTrade.namemt4.Split('@')[0];

                                    int ticketclose     = CopyTrade.ticket;
                                    string namemt4close = CopyTrade.namemt4;
                                    int typeorder       = CopyTrade.typeorder;
                                    string command      = db_Happytrader.SendOrderToClose(ticketclose, namemt4close, typeorder);
                                    string keyword      = command.Split(' ')[0];
                                    orderclose.keyword  = keyword;
                                    orderclose.name_mt4 = CopyTrade.namemt4;
                                    orderclose.command  = command;
                                    orderclose.datetime = DateTime.Now.ToString();
                                    db_Happytrader.InsertNonLive(orderclose);
                                }
                            }
                        }
                    }
                    catch (Exception ex)
                    {
                        Bot.SendTextMessageAsync(635860813, "Lite@Happytrader: " + ex.StackTrace);
                        runHappytrader = false;
                    }
                    Thread.Sleep(500);
                }
            });
            Happytrader.Start();
            if (runHappytrader == false)
            {
                Happytrader.Abort();
            }

            Thread HerryDuc;
            bool   runHerryDuc = true;

            HerryDuc = new Thread(delegate()
            {
                while (true)
                {
                    var client             = new RestClient("https://my.liteforex.com");
                    var request            = new RestRequest("vi/traders/trades?id=758051", Method.GET);//@HerryDuc
                    IRestResponse response = client.Execute(request);
                    string html            = response.Content;
                    string str_hashmd5     = "";
                    if (html.Contains("Nhà giao dịch không có giao dịch mở hiện tại"))
                    {
                        continue;
                    }
                    try
                    {
                        HtmlNodeCollection div_content_rows = Util.HtmlGetNodeCollection(html, "//div[@class='content_row']");
                        if (div_content_rows.Count == 0)
                        {
                            continue;
                        }
                        List <mastertrader> newmastertraders = new List <mastertrader>();
                        foreach (HtmlNode div_content_row in div_content_rows)
                        {
                            string html_div_content_row         = div_content_row.InnerHtml;
                            HtmlNodeCollection div_content_cols = Util.HtmlGetNodeCollection(html_div_content_row, "//div[@class='content_col']");
                            mastertrader newmastertrader        = new mastertrader();
                            newmastertrader.symbol       = div_content_cols[0].InnerText.Replace(" ", "").Replace("\n", "");
                            string typeorder             = div_content_cols[1].InnerText.Replace(" ", "").Replace("\n", "");
                            newmastertrader.size         = double.Parse(div_content_cols[2].InnerText.Replace(" ", "").Replace("\n", ""));
                            newmastertrader.datetime     = div_content_cols[3].InnerText.Replace(" ", "").Replace("\n", "");
                            double openprice             = double.Parse(div_content_cols[4].InnerText.Replace(" ", "").Replace("\n", ""));
                            newmastertrader.openprice    = openprice;
                            double currentprice          = double.Parse(div_content_cols[5].InnerText.Replace(" ", "").Replace("\n", ""));
                            newmastertrader.currentprice = currentprice;
                            if (typeorder == "Mua")
                            {
                                newmastertrader.typeorder = 0;
                            }
                            else if (typeorder == "Bán")
                            {
                                newmastertrader.typeorder = 1;
                            }
                            else if (typeorder == "Muatại" && openprice < currentprice)
                            {
                                newmastertrader.typeorder = 2;
                            }
                            else if (typeorder == "Bántại" && openprice > currentprice)
                            {
                                newmastertrader.typeorder = 3;
                            }
                            else if (typeorder == "Muatại" && openprice > currentprice)
                            {
                                newmastertrader.typeorder = 4;
                            }
                            else if (typeorder == "Bántại" && openprice < currentprice)
                            {
                                newmastertrader.typeorder = 5;
                            }
                            else
                            {
                                newmastertrader.typeorder = 6;
                            }
                            newmastertrader.stoploss   = double.Parse(div_content_cols[6].InnerText.Replace(" ", "").Replace("\n", ""));
                            newmastertrader.takeprofit = double.Parse(div_content_cols[7].InnerText.Replace(" ", "").Replace("\n", ""));
                            newmastertrader.profit     = double.Parse(div_content_cols[8].InnerText.Replace(" ", "").Replace("\n", "").Replace("Lợinhuận", "").Replace("USD", ""));
                            newmastertraders.Add(newmastertrader);
                            string info_InsertOrder = db_HerryDuc.InsertMastertrader(newmastertraders[0], "Lite", "");

                            str_hashmd5 += Util.MD5(newmastertrader.datetime + "HerryDuc" + "Lite") + ",";

                            if (info_InsertOrder == "error")
                            {
                                Console.WriteLine("Lite@HerryDuc");
                                runHerryDuc = false;
                                break;
                            }
                        }
                        List <mastertrader> MastertraderHerryDucs = db_HerryDuc.GetMastertraderByUsername("HerryDuc");
                        foreach (mastertrader MastertraderHerryDuc in MastertraderHerryDucs)
                        {
                            if (db_HerryDuc.DeleteClosemastertrader(MastertraderHerryDuc.md5, str_hashmd5))
                            {
                                string commentdel           = "idmastertrader=" + MastertraderHerryDuc.id;
                                List <copytrade> CopyTrades = db_HerryDuc.GetCopytradeDelByComment(commentdel);
                                foreach (copytrade CopyTrade in CopyTrades)
                                {
                                    nonlive orderclose  = new nonlive();
                                    orderclose.chatid   = 635860813;
                                    orderclose.username = CopyTrade.namemt4.Split('@')[0];

                                    int ticketclose     = CopyTrade.ticket;
                                    string namemt4close = CopyTrade.namemt4;
                                    int typeorder       = CopyTrade.typeorder;
                                    string command      = db_HerryDuc.SendOrderToClose(ticketclose, namemt4close, typeorder);
                                    string keyword      = command.Split(' ')[0];
                                    orderclose.keyword  = keyword;
                                    orderclose.name_mt4 = CopyTrade.namemt4;
                                    orderclose.command  = command;
                                    orderclose.datetime = DateTime.Now.ToString();
                                    db_HerryDuc.InsertNonLive(orderclose);
                                }
                            }
                        }
                    }
                    catch (Exception ex)
                    {
                        Console.WriteLine("HerryDuc: " + ex.Message);
                    }
                    Thread.Sleep(500);
                }
            });
            //HerryDuc.Start();
            if (runHerryDuc == false)
            {
                HerryDuc.Abort();
            }
        }