private static bool PriorityAddBarcode(string msg, User user, out Int32 id)
        {
            string[] sd = msg.Replace("\0", "").Split(new Char[] { ';' });

            var bar = sd[0].Replace(" ", "");
            var turncount = sd[1].Replace(" ", "");
            var turnprice = sd[2].Replace(" ", "");

            var datetime = new DateTime();

            datetime = Convert.ToDateTime(sd[3]);

            var name = sd[4];

            try
            {
                using (MySqlConnection conn = new MySqlConnection(Connector.BarrierStringConnecting))
                {
                    conn.Open();

                    MySqlCommand cmd = new MySqlCommand(@"INSERT INTO `priority`(`id`,`bar`,`name`,`turn_price`,`count`,`sailed`,`status`,`status_text`,`current_price_ukm`,`date`) VALUES (
                                NULL,'" + bar + "','" + name + "','" + turnprice + "','" + turncount.Replace(",", ".") + "','0','0','','0','" + datetime.ToString("yyyy-MM-dd,HH:mm:ss") + "');SELECT LAST_INSERT_ID();", conn);

                    using (MySqlDataReader dr = cmd.ExecuteReader())
                    {
                        if (dr.Read())
                        {
                            id = dr.GetInt32(0);

                            Color.WriteLineColor("Штрихкод: " + bar + " в количестве: " + turncount + " поставлен в очередь.", ConsoleColor.Green);

                            Msg.SendUser(user.username, "PrioritySale", 2, "                Штрихкод: " + bar + " в количестве: " + turncount + " поставлен в очередь.");
                            return true;
                        }
                        else
                            throw new Exception();
                    }
                }
            }
            catch (Exception ex)
            {
                Color.WriteLineColor("[PriorityAddBarcode] " + ex.Message, ConsoleColor.Red);

                Color.WriteLineColor("Штрихкод: " + bar + " в количестве: " + turncount + " Отклонён!", ConsoleColor.Red);

                Log.Write("Штрихкод: " + bar + " в количестве: " + turncount + " Отклонён!", "[ADD]", "PRIORITY");

                Msg.SendUser(user.username, "PrioritySale", 3, "                                                                     Отклонено!");

                id = 0;

                return false;
            }
        }
        public static void parse(string p_id, int com, string msg, User user,System.Net.Sockets.Socket r_client)
        {
            switch (p_id)
            {
                case "LsTradeAgent":
                    switch (com)
                    {
                        case 0:
                            Color.WriteLineColor(msg, ConsoleColor.Blue);
                            Color.WriteLineColor("Модуль связи с LsTrade отключен!", ConsoleColor.Red);
                            Thread.Sleep(3000);
                            r_client.Disconnect(false);
                            r_client.Close();
                            Server.clients.Remove(r_client);
                            break;
                        case 1:
                            user.userid = 2;
                            Server.clients[r_client] = p_id;
                            Color.WriteLineColor("Модуль связи с LsTrade загружен!",ConsoleColor.Cyan);
                            Msg.SendUser("LsTradeAgent", "LS", 1, "Идентификация пройдена.");
                            break;
                    }
                    break;
                case "PrioritySale":

                    user.userid = 0;

                    switch (com)
                    {
                        case 0:
                            string[] split_data = msg.Replace("\0", "").Replace(" ", "").Split(new Char[] { ':' });

                            var username = split_data[0];
                            var hash = split_data[1];

                            using (MySqlConnection conn = new MySqlConnection(Connector.BarrierStringConnecting))
                            using (MySqlCommand cmd = new MySqlCommand("SELECT username,hash FROM users WHERE username = '******' AND hash = '" + hash + "'", conn))
                            using (MySqlDataReader dr = cmd.ExecuteReader())
                            {
                                try { conn.Open(); }
                                catch (MySqlException ex)
                                {
                                    Log.LogWriteDebug("[USERAUTH] [" + ex.Number + "] [" + ex.Message + "]");

                                    switch (ex.Number)
                                    {
                                        case 1042:
                                            Server.clients[r_client] = username;
                                            Msg.SendUser(username, "PrioritySale", 4, "         Mysql недоступен");
                                            break;
                                        default:
                                            Server.clients[r_client] = username;
                                            Msg.SendUser(username, "PrioritySale", 4, "         Код: " + ex.Number);
                                            break;
                                    }
                                }

                                if (dr == null)
                                {
                                    Log.Write("Запрос вернул null", "Exception", "Exception");
                                    Log.ExcWrite("[AUTH] Запрос вернул null");
                                    return;
                                }

                                if (dr.Read())
                                {
                                    Server.clients[r_client] = username;
                                    Color.WriteLineColor(username + " Добавлен!", ConsoleColor.Cyan);
                                    Msg.SendUser(username, "PrioritySale", 1, username);
                                    user.username = username;
                                    Packages.connector.ExecuteNonQuery("UPDATE `users` SET `online`='1',`ip`='" + IPAddress.Parse(((IPEndPoint)r_client.RemoteEndPoint).Address.ToString()) + "' WHERE `username`='" + username + "'");
                                    Log.Write(username, "[AUTH_S]", "AUTHLOG");

                                }
                                else
                                {
                                    Server.clients[r_client] = username;
                                    Msg.SendUser(username, "PrioritySale", 0, "Идентификация не пройдена.");
                                    Color.WriteLineColor(username + " авторизация неудачна", ConsoleColor.Red);
                                    Log.Write(username, "[AUTH_F]", "AUTHLOG");
                                }

                                Color.WriteLineColor(username + " " + hash, ConsoleColor.DarkGray);
                                break;
                            }
                        case 4:
                        case 5:
                            Int32 _LastId;

                            if (PriorityAddBarcode(msg, user, out _LastId))
                            {
                                Color.WriteLineColor("Присвоен уникальный номер " + _LastId, ConsoleColor.Green);

                                Thread th = new Thread(delegate() {
                                    CheckThisBar.GetSailAndPrice(_LastId);
                                }); ;
                                th.Name = "GetUkmSailParametrs";
                                th.Start();
                            }
                            break;
                        case 6:
                            Color.WriteLineColor("[" + user.username + "] "  + msg, ConsoleColor.DarkGreen);

                            if(msg.Contains("отказался"))
                                Log.Write("[" + user.username + "] " + msg, "[DECLINE]", "Decline");
                            else if (msg.Contains("выполнил"))
                                CheckStatusUpdate(msg);

                            foreach (DicEnt de in Server.clients)
                            {
                                Msg.SendUser((de.Value).ToString(), "PrioritySale", 9, Packages.StatusString + ";" + DateTime.Now);
                            }
                            break;
                        case 7:
                            Color.WriteLineColor("Есть новые сообщение на доске объявлений.Отправка уведомления...", ConsoleColor.Yellow);

                            foreach (DicEnt de in Server.clients)
                            {
                                Msg.SendUser((de.Value).ToString(), "PrioritySale", 6, "");
                            }
                            break;
                        case 8:
                            Color.WriteLineColor("Версия очередности обновлена у клиента " + user.username, ConsoleColor.Yellow);
                            break;
                        case 9:
                            if (msg == StatusString)
                                Color.WriteLineColor("Версия очередности у клиента " + user.username + " проверена успешно!", ConsoleColor.Green);
                            else
                            {
                                Color.WriteLineColor("Версия очередности устарела у клиента " + user.username + ".", ConsoleColor.DarkYellow);
                                Msg.SendUser(user.username, "PrioritySale", 9, Packages.StatusString + ";" + DateTime.Now);
                            }
                            break;
                    }
                    break;
                case "BalanceModule":
                    switch (com)
                    {
                        case 0:
                            user.userid = 1;
                            Server.clients[r_client] = "BalanceModule";
                            Color.WriteLineColor("Модуль проверки весов загружен!",ConsoleColor.Cyan);
                            Msg.SendUser("BalanceModule", "BS", 1, "Идентификация пройдена.");
                                break;
                        case 1:
                            Color.WriteLineColor(msg, ConsoleColor.Cyan);
                                break;
                        case 2:
                                user.userid = 1;
                                Server.clients[r_client] = "BalanceModule";
                                break;
                        case 9:
                            Color.WriteLineColor("Модуль проверки весов отключен!", ConsoleColor.Red);
                            Thread.Sleep(3000);
                            r_client.Disconnect(false);
                            r_client.Close();
                            Server.clients.Remove(r_client);
                                break;
                    }
                    break;
                case "User":
                    switch (com)
                    {
                        case 0000:
                            Color.WriteLineColor(Server.clients[r_client] + ": Завершение сеанса.", ConsoleColor.Red);
                            Packages.connector.ExecuteNonQuery("UPDATE `barrierserver`.`users` SET `online`='0' WHERE `username`='" + user.username + "'");
                            Thread.Sleep(3000);
                            r_client.Disconnect(false);
                            r_client.Close();
                            Server.clients.Remove(r_client);
                                break;
                    }
                        break;
            }
        }
        private static void MessageReceiver(Socket r_client)
        {
            var user = new User();

                while (isServerRunning)
                {
                    try
                    {
                        if (!r_client.Connected)
                            return;

                        user.ipaddress = IPAddress.Parse(((IPEndPoint)r_client.RemoteEndPoint).Address.ToString());
                        user.port = ((IPEndPoint)r_client.RemoteEndPoint).Port;

                        var bytes = new byte[4096];

                        r_client.Receive(bytes);

                        MSG packet = new MSG("0", 0, "null");

                        packet = Util.DeSerialization(bytes);

                        //add debug paramter
            #if DEBUG
                        Console.WriteLine("[" + DateTime.Now.ToLongTimeString() + "] " + "[DEBUG] " + packet.group + " " + packet.type + " " + packet.message);
            #endif
                        Packages.parse(packet.group, packet.type, packet.message, user, r_client);
                    }
                    catch (SocketException exc)
                    {
                        if (exc.ErrorCode == 10054)
                        {
                            Packages.connector.ExecuteNonQuery("UPDATE `barrierserver`.`users` SET `online`='0' WHERE `username`='" + user.username + "'");

                            Color.WriteLineColor("Клиент отключился: " + Server.clients[r_client], ConsoleColor.Cyan);

                            if (!r_client.Connected)
                                r_client.Disconnect(true);

                            clients.Remove(r_client);

                            if (!abort_thread(Thread.CurrentThread))
                            {
                                Color.WriteLineColor("Поток не завершен!", ConsoleColor.Red);
                            }

                            break;
                        }
                    }

                    catch(ThreadAbortException) { break; }

                    catch (Exception exc)
                    {
                        Console.WriteLine("[" + DateTime.Now.ToLongTimeString() + "] " + exc.Message);
                        Thread.Sleep(5000);
                    }
                }
        }