public ServerSessionResponseHandler(Socket acceptedSocket, PackageAdapter adapter, GameLogger logger)
 {
     Logger         = logger;
     AcceptedSocket = acceptedSocket;
     Adapter        = adapter;
     Connected      = false;
     Error          = false;
     ErrorMessage   = "";
 }
Exemple #2
0
 public string Delete(string Json)
 {
     try
     {
         string        TableName = JsonAdapter.TableNameFromJson(Json);
         List <Packet> packets   = PackageAdapter.PacketsFromJson(Json);
         string        Condition = FilterAdapter.GetCondition(TableName, packets.ToArray());
         string        sql       = $"DELETE FROM \"{TableName}\" WHERE {Condition}";
         return(JsonAdapter.ResultToJson(NpgController.InvokeQuery(sql)));
     }
     catch (Exception ex)
     {
         return(new JObject().AddStatus(ex).ToString());
     }
 }
Exemple #3
0
        public string Update(string Json)
        {
            try
            {
                string TableName = JsonAdapter.TableNameFromJson(Json);

                List <Packet> packets   = PackageAdapter.PacketsFromJson(Json);
                string        Condition = FilterAdapter.GetCondition(TableName, packets.ToArray());

                List <UpdatePacket> updatePackets = SetConverter.FromJson(Json);
                string Sets = RowCollector.Set(updatePackets);

                string Sql = $"UPDATE \"{TableName}\" {Sets} WHERE {Condition}";
                return(JsonAdapter.ResultToJson(NpgController.InvokeQuery(Sql)));
            }
            catch (Exception ex)
            {
                return(new JObject().AddStatus(ex).ToString());
            }
        }
Exemple #4
0
        public string Adapt(string Json)
        {
            string        MainTable = JsonAdapter.TableNameFromJson(Json);
            string        TableName = "";
            List <Packet> packets   = PackageAdapter.PacketsONFromJson(Json);

            PackageAdapter.Normalize(ref packets);
            packets = SetTableName(MainTable, packets.ToArray());
            try
            {
                TableName = $"{GetTableNameFromPackets(packets.ToArray())}";
            }
            catch (Exception ex)
            {
                throw ex;
            }
            string condition = new FilterAdapter().GetOnCondition(TableName, packets.ToArray());
            string Sql       = $"INNER JOIN {TableName} ON {condition}";

            return(Sql);
        }
Exemple #5
0
        public string Where(string Json)
        {
            Validators.CheckPackets check = new Validators.CheckPackets();
            try
            {
                LimitPacket limitPacket = GetLimit(ref Json);
                string      limit       = limitPacket == null ? "" : $" {LimitAdapter.AdaptToSql(limitPacket)}";

                OrderByPacket orderByPacket = GetOrderBy(ref Json);
                string        OrderBy       = orderByPacket == null ? "" : $" {OrderByAdapter.ToSql(orderByPacket)}";

                if (check.CheckJoin(Json))
                {
                    string Condition            = "";
                    Joining.JoinAdapter adapter = new Joining.JoinAdapter();
                    string TableName            = JsonAdapter.TableNameFromJson(Json);
                    if (check.CheckPacket(Json))
                    {
                        List <Packet> packets = PackageAdapter.PacketsFromJson(Json);
                        PackageAdapter.Normalize(ref packets);
                        Condition = $"WHERE {FilterAdapter.GetCondition(TableName, packets.ToArray())}";
                    }
                    string JoinCondition = adapter.Adapt(Json);
                    string sql           = $"SELECT * FROM \"{TableName}\" {JoinCondition} {Condition}{OrderBy}{limit}";
                    return(JsonAdapter.ResultToJson(NpgController.InvokeQuery(sql)));
                }
                else
                {
                    string        TableName = JsonAdapter.TableNameFromJson(Json);
                    List <Packet> packets   = PackageAdapter.PacketsFromJson(Json);
                    string        Condition = FilterAdapter.GetCondition(TableName, packets.ToArray());
                    string        sql       = $"SELECT * FROM \"{TableName}\" WHERE {Condition}{OrderBy}{limit}";
                    return(JsonAdapter.ResultToJson(NpgController.InvokeQuery(sql)));
                }
            }
            catch (Exception ex)
            {
                return(new JObject().AddStatus(ex).ToString());
            }
        }
        public NetworkConnection(TCPPacketConnection tcpConnection, ResponseRequest responseRequest, PackageAdapter adapter)
        {
            Adapter = adapter;

            TcpPackages     = new SafeStack <PackageInterface>();
            m_openResponses = new SafeList <ResponseRequest>();

            if (responseRequest != null)
            {
                m_openResponses.Add(responseRequest);
            }

            ClientSession = null;

            TcpConnection  = tcpConnection;
            RemoteEndPoint = tcpConnection.Remote;
            OnDisconnect   = TcpConnection.OnDisconnect.CreateRelay(this);

            TcpConnection.DataReceivedEvent  += ReceiveTCP;
            TcpConnection.OnDisconnect.Event += HandleDisconnect;
            TcpConnection.InitializeReceiving();
        }