Schumix.CalendarAddon.CalendarFunctions.Add C# (CSharp) Method

        public string Add(string name, string channel, string message, DateTime time, bool Loop = false)
        {
            if(Loop)
            {
                var db = SchumixBase.DManager.QueryFirstRow("SELECT 1 FROM calendar WHERE Name = '{0}' AND Channel = '{1}' AND Year = '{2}' AND Month = '{3}' AND Day = '{4}' AND Hour = '{5}' AND Minute = '{6}' And ServerName = '{7}'", sUtilities.SqlEscape(name.ToLower()), sUtilities.SqlEscape(channel.ToLower()), 0, 0, 0, time.Hour, time.Minute, _servername);
                if(!db.IsNull())
                    return sLManager.GetWarningText("Calendar1", channel, _servername);

                SchumixBase.DManager.Insert("`calendar`(ServerId, ServerName, Name, Channel, Message, Loops, Year, Month, Day, Hour, Minute)", IRCConfig.List[_servername].ServerId, _servername, sUtilities.SqlEscape(name.ToLower()), sUtilities.SqlEscape(channel.ToLower()), sUtilities.SqlEscape(message), true, 0, 0, 0, time.Hour, time.Minute);
            }
            else
            {
                if(sUtilities.IsValueBiggerDateTimeNow(time.Year, time.Month, time.Day, time.Hour, time.Minute))
                    return sLManager.GetWarningText("GaveExpiredDateTime", channel, _servername);

                var db = SchumixBase.DManager.QueryFirstRow("SELECT 1 FROM calendar WHERE Name = '{0}' AND Channel = '{1}' AND Year = '{2}' AND Month = '{3}' AND Day = '{4}' AND Hour = '{5}' AND Minute = '{6}' And ServerName = '{7}'", sUtilities.SqlEscape(name.ToLower()), sUtilities.SqlEscape(channel.ToLower()), time.Year, time.Month, time.Day, time.Hour, time.Minute, _servername);
                if(!db.IsNull())
                    return sLManager.GetWarningText("Calendar1", channel, _servername);

                var unixtime = (time.ToUniversalTime() - sUtilities.GetUnixTimeStart()).TotalSeconds;
                SchumixBase.DManager.Insert("`calendar`(ServerId, ServerName, Name, Channel, Message, Year, Month, Day, Hour, Minute, UnixTime)", IRCConfig.List[_servername].ServerId, _servername, sUtilities.SqlEscape(name.ToLower()), sUtilities.SqlEscape(channel.ToLower()), sUtilities.SqlEscape(message), time.Year, time.Month, time.Day, time.Hour, time.Minute, unixtime);
            }

            return sLManager.GetWarningText("Calendar", channel, _servername);
        }