summaryrefslogtreecommitdiff
path: root/Pages/Report.cshtml.cs
blob: 365041f9cd5384d7368a53bf396c2f15c7b30392 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
// download - the admin console and reports
// Copyright (C) 2024 Ian Cowburn <ianc@noddybox.co.uk>
// 
// This program is free software: you can redistribute it and/or modify
// it under the terms of the GNU General Public License as published by
// the Free Software Foundation, either version 3 of the License, or
// (at your option) any later version.
// 
// This program is distributed in the hope that it will be useful,
// but WITHOUT ANY WARRANTY; without even the implied warranty of
// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
// GNU General Public License for more details.
// 
// You should have received a copy of the GNU General Public License
// along with this program.  If not, see <http://www.gnu.org/licenses/>.
//
using Microsoft.AspNetCore.Mvc;
using Microsoft.AspNetCore.Mvc.RazorPages;
using Npgsql;
using System.Collections.Generic;
using download_admin;

namespace download_admin.Pages;

public class ReportModel : PageModel
{
    public void OnGet()
    {
        ViewData["Title"] = "Download Repsoitory Report";

        try
        {
            Rows = new List<Download>();

            using var conn = new NpgsqlConnection(Config.Settings["ConnectionStrings:download"]);

            conn.Open();

            using var cmd = new NpgsqlCommand("SELECT key, ip_address, user_agent, time FROM download ORDER BY time", conn);
            using var reader = cmd.ExecuteReader();
            
            while(reader.Read())
            {
                string key = (string)reader["key"];
                string ip_address = (string)reader["ip_address"];
                string user_agent = (string)reader["user_agent"];
                DateTime time = (DateTime)reader["time"];

                Rows.Add(new Download(key, ip_address, user_agent, time));
            }
        }
        catch(Exception e)
        {
            SetError(e.Message);
        }
    }

    private void SetError(string error_text)
    {
        HasError = true;
        ErrorText = error_text;
    }

    public List<string> Keys
    {
        get
        {
            var keys = new List<String>();

            try
            {
                using var conn = new NpgsqlConnection(Config.Settings["ConnectionStrings:download"]);

                conn.Open();

                using var cmd = new NpgsqlCommand("SELECT key FROM file_object ORDER BY key", conn);
                using var reader = cmd.ExecuteReader();
                
                while(reader.Read())
                {
                    string key = (string)reader["key"];
                    keys.Add(key);
                }
            }
            catch(Exception e)
            {
                SetError(e.Message);
            }

            return keys;
        }

    }

    public long GetCount(string key)
    {
        try
        {
            using var conn = new NpgsqlConnection(Config.Settings["ConnectionStrings:download"]);

            conn.Open();

            using var cmd = new NpgsqlCommand("SELECT count(*) FROM download where key = @key", conn);
            cmd.Parameters.AddWithValue("key", NpgsqlTypes.NpgsqlDbType.Varchar, key);

            object? scalar = cmd.ExecuteScalar();

            if (scalar != null)
            {
                return (long)scalar;
            }
        }
        catch(Exception e)
        {
            SetError(e.Message);
        }

        return 0;
    }

    public List<Download>? Rows {get;private set;}

    public bool HasError {get; private set;}

    public string? ErrorText {get; private set;}

}