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)); }