private void CalendarTimeRemove()
{
var time = DateTime.Now;
var db = SchumixBase.DManager.Query("SELECT Id, Name, Channel, Message, Loops, Year, Month, Day, Hour, Minute FROM calendar WHERE ServerName = '{0}'", _servername);
if (!db.IsNull())
{
foreach (DataRow row in db.Rows)
{
if (row["Loops"].ToBoolean())
{
string name0 = row["Name"].ToString();
string channel0 = row["Channel"].ToString();
string message0 = row["Message"].ToString();
int hour = row["Hour"].ToInt32();
if (time.Hour > hour)
{
continue;
}
else if (time.Hour < hour)
{
continue;
}
else
{
if (time.Hour == hour)
{
int minute = row["Minute"].ToInt32();
if (time.Minute > minute)
{
continue;
}
else if (time.Minute < minute)
{
continue;
}
else
{
if (time.Minute == minute)
{
sCalendarFunctions.Write(name0, channel0, message0);
}
}
}
}
continue;
}
int id = row["Id"].ToInt32();
string name = row["Name"].ToString();
string channel = row["Channel"].ToString();
string message = row["Message"].ToString();
int year = row["Year"].ToInt32();
if (time.Year > year)
{
sCalendarFunctions.Remove(id);
}
else if (time.Year < year)
{
continue;
}
else if (time.Year == year)
{
int month = row["Month"].ToInt32();
if (time.Month > month)
{
sCalendarFunctions.Remove(id);
}
else if (time.Month < month)
{
continue;
}
else
{
int day = row["Day"].ToInt32();
if (time.Month == month)
{
if (time.Day > day)
{
sCalendarFunctions.Remove(id);
}
else if (time.Day < day)
{
continue;
}
else
{
if (time.Day == day)
{
int hour = row["Hour"].ToInt32();
if (time.Hour > hour)
{
sCalendarFunctions.Remove(id);
}
else if (time.Hour < hour)
{
continue;
}
else
{
if (time.Hour == hour)
{
int minute = row["Minute"].ToInt32();
if (time.Minute > minute)
{
sCalendarFunctions.Remove(id);
}
else if (time.Minute < minute)
{
continue;
}
else
{
if (time.Minute == minute)
{
sCalendarFunctions.Write(name, channel, message);
}
}
}
}
}
}
}
}
}
}
}
}