Repository navigation
Expand file tree
/
Copy pathHit.cs
More file actions
221 lines (196 loc) · 6.21 KB
/
Copy pathHit.cs
File metadata and controls
221 lines (196 loc) · 6.21 KB
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
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
using System;
using System.Collections.Generic;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using System.Web.Configuration;
/// <summary>
/// Represents a hit to a webapge.
/// </summary>
public class Hit
{
private Hit()
{
}
/// <summary>
/// Records a hit on the site. Sanitizes input.
/// </summary>
/// <param name="brow"></param>
/// <param name="pageName"></param>
public static void RecordHit(IEveBrowser brow, string pageName)
{
if (!(brow.IsIGB && brow.IsTrusted))
return;
long? allianceId;
string allianceName;
try
{
allianceId = brow.AllianceID;
allianceName = brow.AllianceName;
}
catch
{
allianceId = null;
allianceName = null;
}
try
{
recordHitImpel(pageName,
brow.CharacterID,
Utilities.CleanString(brow.CharacterName, 20),
brow.CorporationID,
Utilities.CleanString(brow.CorporationName, 50),
allianceId,
Utilities.CleanString(allianceName, 50),
Utilities.CleanString(brow.SolarSystemName, 20),
Utilities.CleanString(brow.NearestLocation, 30));
}
catch (SqlException ex)
{
throw;
}
catch (Exception ex)
{
//Eat exceptions that are caused by bad input
}
}
/// <summary>
/// Actually adds record to the database, does not check input.
/// </summary>
private static void recordHitImpel(string pageName, long characterId, string characterName, long corpId, string corpName, long? allianceId, string allianceName, string solarSystem, string nearestLocation)
{
using (SqlConnection conn = new SqlConnection(Utilities.ConnStr))
{
conn.Open();
using (SqlCommand cmd = new SqlCommand("RecordHit", conn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@corpId", corpId);
cmd.Parameters.AddWithValue("@corpName", corpName);
cmd.Parameters.AddWithValue("@AllianceID", allianceId);
cmd.Parameters.AddWithValue("@AllianceName", allianceName);
cmd.Parameters.AddWithValue("@SolarSystem", solarSystem);
cmd.Parameters.AddWithValue("@NearestLocation", nearestLocation);
cmd.Parameters.AddWithValue("@CharacterID", characterId);
cmd.Parameters.AddWithValue("@CharacterName", characterName);
cmd.Parameters.AddWithValue("@PageName", pageName);
cmd.ExecuteNonQuery();
}
}
}
/// <summary>
/// Get the hits.
/// </summary>
/// <returns></returns>
public static List<Hit> GetHits()
{
using (SqlConnection conn = new SqlConnection(Utilities.ConnStr))
{
conn.Open();
using (SqlCommand cmd = new SqlCommand("GetHits", conn))
{
cmd.CommandType = CommandType.StoredProcedure;
using (SqlDataReader reader = cmd.ExecuteReader())
{
List<Hit> hits = new List<Hit>();
while (reader.Read())
{
Hit h = new Hit();
h.id = reader.GetGuid(0);
h.time = reader.GetDateTime(1);
h.corpId = reader.GetInt64(2);
h.corpName = reader.GetString(3);
h.allianceId = reader.IsDBNull(4) ? new Nullable<long>() : reader.GetInt64(4);
h.allianceName = reader.IsDBNull(5) ? null : reader.GetString(5);
h.solarSystem = reader.GetString(6);
h.nearestLocation = reader.GetString(7);
h.characterId = reader.GetInt64(8);
h.characterName = reader.GetString(9);
h.pageName = reader.GetString(10);
hits.Add(h);
}
return hits;
}
}
}
}
/// <summary>
/// Delete hits recorded more than a month ago.
/// </summary>
public static void DeleteOldHits()
{
using (SqlConnection conn = new SqlConnection(Utilities.ConnStr))
{
conn.Open();
using (SqlCommand cmd = new SqlCommand("DeleteOldHits", conn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@before", SqlDbType.DateTime).Value = DateTime.UtcNow.Subtract(new TimeSpan(31, 0, 0, 0));
cmd.ExecuteNonQuery();
}
}
}
#region Data
private Guid id;
public Guid ID
{
get { return id; }
}
private DateTime time;
public DateTime Time
{
get { return time; }
}
private long corpId;
public long CorpId
{
get { return corpId; }
}
private string corpName;
public string CorpName
{
get { return corpName; }
}
private long? allianceId;
public long? AllianceId
{
get { return allianceId; }
}
private string allianceName;
public string AllianceName
{
get { return allianceName; }
}
private string solarSystem;
public string SolarSystem
{
get { return solarSystem; }
}
private string nearestLocation;
public string NearestLocation
{
get { return nearestLocation; }
}
private long characterId;
public long CharacterId
{
get { return characterId; }
}
private string characterName;
public string CharacterName
{
get { return characterName; }
}
private string pageName;
public string PageName
{
get { return pageName; }
}
#endregion
}