public static void InsertReport(int reasonid, ReportReason reason, string ip, int postID, DbConnection con)
{
using (DbCommand dc = DatabaseEngine.GenerateDbCommand(con))
{
dc.CommandText = "INSERT INTO reports (postID, reporterIP, time, comment, reasonID) " +
" VALUES (@id, @ip, @time, @comment, @reasonID)";
dc.Parameters.Add(DatabaseEngine.MakeParameter("@id", postID, DbType.Int32));
dc.Parameters.Add(DatabaseEngine.MakeParameter("@ip", ip, DbType.String));
dc.Parameters.Add(DatabaseEngine.MakeParameter("@time", DateTime.UtcNow, DbType.DateTime));
dc.Parameters.Add(DatabaseEngine.MakeParameter("@comment", reason.Description, DbType.String));
dc.Parameters.Add(DatabaseEngine.MakeParameter("@reasonID", reasonid, DbType.Int32));
dc.ExecuteNonQuery();
}
}
private static void SaveData(ReportReason[] data)
{
File.WriteAllText(Paths.ReportReasonsFile, JsonConvert.SerializeObject(data, Formatting.Indented));
}
