示例#1
0
        public bool InsertNonLive(nonlive NewNonlive)
        {
            ConnectDB();
            string       sql = "INSERT INTO nonlive (chatid,username,keyword,command,name_mt4,datetime)" + " VALUES (@chatid,@username,@keyword,@command,@name_mt4,@datetime)";
            MySqlCommand cmd = new MySqlCommand(sql, conn);

            cmd.Parameters.AddWithValue("@chatid", NewNonlive.chatid);
            cmd.Parameters.AddWithValue("@username", NewNonlive.username);
            cmd.Parameters.AddWithValue("@keyword", NewNonlive.keyword);
            cmd.Parameters.AddWithValue("@command", NewNonlive.command);
            cmd.Parameters.AddWithValue("@name_mt4", NewNonlive.name_mt4);
            cmd.Parameters.AddWithValue("@datetime", NewNonlive.datetime);

            try
            {
                cmd.ExecuteNonQuery();
                CloseDB();
                error_mes = null;
            }
            catch (MySqlException error)
            {
                CloseDB();
                error_mes = "InsertNonLive: " + error.Message;
                return(false);
            }
            return(true);
        }
示例#2
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();
            }
        }