using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Ion.Storage;

namespace Holo.Managers
{
    /// <summary>
    /// Provides management for CFH and moderacy tasks for staff.
    /// </summary>
    public static class staffManager
    {
        /// <summary>
        /// Adds a staff message to the system_stafflog table, regarding one of the actions that a MOD/other staff member performed. Details in the message: type action, ID of the user (staffmember) that performed the action, the target user ID/room ID and the message + staff note.
        /// </summary>
        /// <param name="Action">The action performed. [alert, kick, ban, ralert, rkick]</param>
        /// <param name="userID">The ID of the staffmember that performed the action.</param>
        /// <param name="targetID">The ID of the target user/target room.</param>
        /// <param name="Message">The message that went with the action.</param>
        /// <param name="Note">A staff-only note for Housekeeping. [optional]</param>
        public static void addStaffMessage(string Action, int userID, int targetID, string Message, string Note)
        {
            using (DatabaseClient dbClient = Eucalypt.dbManager.GetClient())
            {
                dbClient.AddParamWithValue("action", Action);
                dbClient.AddParamWithValue("userid", userID);
                dbClient.AddParamWithValue("targetid", targetID);
                dbClient.AddParamWithValue("message", Message);
                dbClient.AddParamWithValue("time", DateTime.Now.ToString());
                dbClient.runQuery("INSERT INTO system_stafflog (action,userid,targetid,message,note,timestamp) VALUES (@action, @userid, @targetid, @message, @note, @time)");
            }
        }
    }
}