public static void Save(decimal orderId, RemindStatus status, string carrier, Guid acceptor, string customNO = "")
{
var order = new RemindInfo()
{
Id = orderId,
Status = status,
Carrier = carrier,
Acceptor = acceptor,
CustomNO = customNO
};
var repository = Repository.Factory.CreateRemindRepository();
repository.Save(order);
}
public void Save(RemindInfo remindInfo)
{
var sql = "IF EXISTS(SELECT NULL FROM dbo.T_OrderRemind WHERE Id=@ID)" +
" UPDATE dbo.T_OrderRemind SET [Status]=@STATUS,Acceptor=@ACCEPTOR,CustomNO=@CustomNO WHERE Id=@ID" +
" ELSE" +
" INSERT INTO dbo.T_OrderRemind (Id,[Status],Carrier,Acceptor,CustomNO) VALUES (@ID,@STATUS,@CARRIER,@ACCEPTOR,@CustomNO)";
using (var dbOperator = new DbOperator(Provider, ConnectionString)) {
dbOperator.AddParameter("ID", remindInfo.Id);
dbOperator.AddParameter("STATUS", (byte)remindInfo.Status);
dbOperator.AddParameter("CARRIER", remindInfo.Carrier ?? string.Empty);
dbOperator.AddParameter("ACCEPTOR", remindInfo.Acceptor);
dbOperator.AddParameter("CustomNO", remindInfo.CustomNO);
dbOperator.ExecuteNonQuery(sql);
}
}
void Bot_OnMessage(Network network, Irc.IrcEventArgs e)
{
if (IsMatch("^reminder \\?$", e.Data.Message))
{
AnswerWithNotice(network, e, FormatBold("Use of Reminder plugin:"));
AnswerWithNotice(network, e, FormatItalic("remind me in <minutes> <message>") + " - Reminds you in <minutes> minutes.");
AnswerWithNotice(network, e, FormatItalic("remind me at <hours>:<minutes> <message>") + " - Reminds you at the given time.");
}
else if (IsMatch("^remind me in (?<minutes>\\d{1,3}) (?<message>.*)$", e.Data.Message))
{
List <RemindInfo> l = LoadFromFile <List <RemindInfo> >("Reminders");
RemindInfo i = new RemindInfo();
i.Network = network.Name;
i.Channel = e.Data.Channel;
i.User = e.Data.Nick;
i.Message = Matches["message"].ToString();
i.Date = DateTime.Now.AddMinutes(int.Parse(Matches["minutes"].ToString()));
i.IsPrivate = e.Data.Type == Irc.ReceiveType.QueryMessage;
l.Add(i);
SaveToFile <List <RemindInfo> >(l, "Reminders");
StartThread();
AnswerWithNotice(network, e, "You will be reminded.");
}
else if (IsMatch("^remind me at (?<hours>\\d{1,2}):(?<minutes>\\d{1,2}) (?<message>.*)$", e.Data.Message))
{
List <RemindInfo> l = LoadFromFile <List <RemindInfo> >("Reminders");
RemindInfo i = new RemindInfo();
i.Network = network.Name;
i.Channel = e.Data.Channel;
i.User = e.Data.Nick;
i.Message = Matches["message"].ToString();
i.Date = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day, int.Parse(Matches["hours"].ToString()), int.Parse(Matches["minutes"].ToString()), 0);
if (i.Date < DateTime.Now)
{
i.Date = i.Date.AddDays(1);
}
i.IsPrivate = e.Data.Type == Irc.ReceiveType.QueryMessage;
l.Add(i);
SaveToFile <List <RemindInfo> >(l, "Reminders");
StartThread();
AnswerWithNotice(network, e, "You will be reminded.");
}
}
void Bot_OnMessage(Network network, Irc.IrcEventArgs e)
{
if (IsMatch("^reminder \\?$", e.Data.Message)) {
AnswerWithNotice(network, e, FormatBold("Use of Reminder plugin:"));
AnswerWithNotice(network, e, FormatItalic("remind me in <minutes> <message>") + " - Reminds you in <minutes> minutes.");
AnswerWithNotice(network, e, FormatItalic("remind me at <hours>:<minutes> <message>") + " - Reminds you at the given time.");
}
else if (IsMatch("^remind me in (?<minutes>\\d{1,3}) (?<message>.*)$", e.Data.Message)) {
List<RemindInfo> l = LoadFromFile<List<RemindInfo>>("Reminders");
RemindInfo i = new RemindInfo();
i.Network = network.Name;
i.Channel = e.Data.Channel;
i.User = e.Data.Nick;
i.Message = Matches["message"].ToString();
i.Date = DateTime.Now.AddMinutes(int.Parse(Matches["minutes"].ToString()));
i.IsPrivate = e.Data.Type == Irc.ReceiveType.QueryMessage;
l.Add(i);
SaveToFile<List<RemindInfo>>(l, "Reminders");
StartThread();
AnswerWithNotice(network, e, "You will be reminded.");
}
else if (IsMatch("^remind me at (?<hours>\\d{1,2}):(?<minutes>\\d{1,2}) (?<message>.*)$",e.Data.Message)) {
List<RemindInfo> l = LoadFromFile<List<RemindInfo>>("Reminders");
RemindInfo i = new RemindInfo();
i.Network = network.Name;
i.Channel = e.Data.Channel;
i.User = e.Data.Nick;
i.Message = Matches["message"].ToString();
i.Date = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day, int.Parse(Matches["hours"].ToString()), int.Parse(Matches["minutes"].ToString()), 0);
if (i.Date < DateTime.Now)
i.Date = i.Date.AddDays(1);
i.IsPrivate = e.Data.Type == Irc.ReceiveType.QueryMessage;
l.Add(i);
SaveToFile<List<RemindInfo>>(l, "Reminders");
StartThread();
AnswerWithNotice(network, e, "You will be reminded.");
}
}
