private void MainProg()
{
FoeServerLog.Add(_processName, FoeServerLog.LogType.Message, "Processor started.");
// The process will keep running until shutdown is requested
while (!_isShutdownRequested)
{
try
{
// Do registration work
DoRssUpdate();
}
catch (Exception except)
{
try
{
// log error message
FoeServerLog.Add(_processName, FoeServerLog.LogType.Error, "Error:\r\n" + except.ToString());
}
catch (Exception epicExcept)
{
// Wow, this is epic! Write to System Event Logs
EventLog.WriteEntry(_processName + " epic failure.\r\n" + except + "\r\n" + epicExcept, EventLogEntryType.Error);
// We should just terminate the process
_isShutdownRequested = true;
}
}
// Sleep for "_runInterval" seconds before checking email again.
FoeServerScheduler.Sleep(WakeupCall, _runInterval);
}
FoeServerLog.Add(_processName, FoeServerLog.LogType.Message, "Processor stopped.");
}
protected override void OnShutdown()
{
base.OnShutdown();
_isShutdownRequested = true;
FoeServerLog.Add(_processName, FoeServerLog.LogType.Message, "OnShutdown() called. Shutdown requested.");
}
private void DoAutoSubscription()
{
// Connect to DB and prepare command
SqlConnection conn = FoeServerDb.OpenDb();
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "select * from AutoSubscriptions where DtSubscribed>=@oldestTime";
cmd.Parameters.Add("@oldestTime", System.Data.SqlDbType.DateTime);
cmd.Prepare();
// Calculate the oldest time that we will support
DateTime oldest = DateTime.Now.Subtract(new TimeSpan(2, 0, 0));
// Run query
cmd.Parameters["@oldestTime"].Value = oldest;
SqlDataReader reader = cmd.ExecuteReader();
// Get subscribers
FoeServerAutoSubscriber sub = null;
while ((sub = FoeServerAutoSubscribe.GetNextAutoSubscriberFromSqlReader(reader)) != null)
{
// Compare the dates to see if last updated is newer than the RSS cache
FoeServerRssFeed feed = FoeServerCatalog.GetRssFeedCache(sub.CatalogCode);
if ((feed != null) && (feed.DtLastUpdated > sub.DtLastUpdated))
{
try
{
// we need to send the latest news to user
FoeServerCatalog.SendRssCache(sub.CatalogCode, sub.UserEmail, sub.RequestId, true);
FoeServerLog.Add(_processName, FoeServerLog.LogType.Message,
"Sent updated RSS feed to " + sub.UserEmail);
}
catch (Exception except)
{
FoeServerLog.Add(_processName, FoeServerLog.LogType.Error,
"Error sending updated RSS feed to " + sub.UserEmail + ":\r\n" + except.ToString());
}
}
else
{
// User already has the latest feed.
}
}
reader.Close();
conn.Close();
}
private void DoRssUpdate()
{
// Get all RSS items
List <CatalogItem> items = FoeServerCatalog.GetCatalog();
foreach (CatalogItem item in items)
{
// check if it's RSS content type
if (item.ContentType.ToUpper() != "RSS")
{
// not RSS, skip it
continue;
}
// fetch the RSS feed from remote RSS server
WebClient client = new WebClient();
byte[] rssBytes = client.DownloadData(item.Location);
//change rss's encoding to utf8
string rss = Encoding.UTF8.GetString(rssBytes).TrimStart();
//string feed = Encoding.UTF8.GetString(feedBytes);
// Compare md5 value to see if RSS needs to be updated
//if (CheckIfNewer(item.Code, feed))
//0 old, 1 new, 2 newer
int result = CheckIfNewer(item.Code, rss);
if (result == 1)
{
FoeServerCatalog.AddRssCache(item.Code, rss);
FoeServerLog.Add(_processName, FoeServerLog.LogType.Message, "Add RSS feed " + item.Code);
}
else if (result == 2)
{
// MD5 sums are different, we need to update our RSS cache
// FoeServerCatalog.UpdateRssCache(item.Code, feed64);
FoeServerCatalog.UpdateRssCache(item.Code, rss);
//FoeDebug.Print(item.Code + " updated.");
FoeServerLog.Add(_processName, FoeServerLog.LogType.Message, "Updated RSS feed " + item.Code);
}
else
{
// no update
//FoeDebug.Print("No update found for " + item.Code + ".");
}
}
}
private void DoFeedAdd()
{
//FoeDebug.Print("Loading requests...");
bool hasError = false;
string message = "";
// Load content requests
FoeRequester req = null;
FoeServerRequest requestManager = new FoeServerRequest(RequestType.Feed, FoeServerRegistry.Get("ProcessorEmail"));
while ((req = requestManager.GetNextRequest()) != null)
{
//FoeDebug.Print("Processing request from " + req.UserEmail + " with request ID " + req.RequestId);
// Check what contents are requested
// Get user info
FoeUser user = FoeServerUser.GetUser(req.UserEmail);
if (user == null)
{
//FoeDebug.Print("User not registered. Skip this request.");
//FoeDebug.Print("---------------------------------------");
// User is not registered, mark this request as "E" (Error) and skip to the next one
requestManager.UpdateRequestStatus(req, "E");
FoeServerLog.Add(_processName, FoeServerLog.LogType.Warning, "User " + user.Email + " not registered. Discard content request.");
continue;
}
//FoeDebug.Print("User verified.");
// Process request
List <CatalogItem> catalogs = FoeServerCatalog.GetCatalog(); // get all the catalogs on server
if (catalogs != null)
{
//FoeDebug.Print("Generated Foe Message.");
foreach (CatalogItem catalog in catalogs)
{
message += catalog.Code + ",";
}
// Send reply to user
try
{
FoeServerMessage.SendMessage(
FoeServerMessage.GetDefaultSmtpServer(),
FoeServerRegistry.Get("ProcessorEmail"),
req.UserEmail,
SubjectGenerator.ReplySubject(RequestType.Catalog, req.RequestId, FoeServerUser.GetUser(req.UserEmail).UserId),
message);
//FoeDebug.Print("Sent reply to user.");
}
catch (Exception except)
{
//FoeDebug.Print("Error sending email.");
//FoeDebug.Print(except.ToString());
hasError = true;
FoeServerLog.Add(_processName, FoeServerLog.LogType.Error, "Error delivering content to " + user.Email + "\r\n" + except.ToString());
}
}
// If there is no error, then we'll mark the request as 'C' (Completed).
// Otherwise, we'll leave it as 'P' (Pending).
if (!hasError)
{
// mark request as "C" (Completed)
requestManager.UpdateRequestStatus(req, "C");
FoeServerLog.Add(_processName, FoeServerLog.LogType.Message, "Sent " + message + "to " + user.Email + " and added user to AutoSubscription.");
//FoeDebug.Print("Marked request as 'C' (Completed).");
//FoeDebug.Print("----------------------------------");
}
else
{
//FoeDebug.Print("Leave request as 'P' (Pending).");
//FoeDebug.Print("-------------------------------");
FoeServerLog.Add(_processName, FoeServerLog.LogType.Error,
"Error delivering content but error is likely caused by temporary email downtime. " +
"Leave status as 'P' (Pending) so process can try again later.");
}
}
// Close all requestManager connections
requestManager.Close();
}
private void DoRegistration()
{
SqlConnection conn = FoeServerDb.OpenDb();
SqlConnection completeConn = FoeServerDb.OpenDb();
// Query that gets all pending requests.
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "select * from Requests where Status='P' and ProcessorEmail=@processorEmail and RequestType=@requestType";
cmd.Parameters.Add("@processorEmail", System.Data.SqlDbType.NVarChar, 256);
cmd.Parameters.Add("@requestType", System.Data.SqlDbType.NVarChar, 10);
cmd.Prepare();
// Query that marks request as "C" (Completed)
SqlCommand completeCmd = completeConn.CreateCommand();
completeCmd.CommandText = "update Requests set DtProcessed=@dtProcessed, Status='C' where id=@id";
completeCmd.Parameters.Add("@dtProcessed", System.Data.SqlDbType.DateTime);
completeCmd.Parameters.Add("@id", System.Data.SqlDbType.Int);
completeCmd.Prepare();
//FoeDebug.Print("Getting pending requests.");
// Get all pending requests
cmd.Parameters["@processorEmail"].Value = FoeServerRegistry.Get("ProcessorEmail");
cmd.Parameters["@requestType"].Value = FoeServerRequest.RequestTypeToString(RequestType.Registration);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
int id = (int)FoeServerDb.GetInt32(reader, "Id");
string userEmail = FoeServerDb.GetString(reader, "UserEmail");
string requestId = FoeServerDb.GetString(reader, "RequestId");
//FoeDebug.Print("Processing " + userEmail);
// Create new user account
FoeUser user = FoeServerUser.RegisterUser(userEmail);
// Mark request as "C" (Completed)
completeCmd.Parameters["@dtProcessed"].Value = DateTime.Now;
completeCmd.Parameters["@id"].Value = id;
completeCmd.ExecuteNonQuery();
// Send response back to user
SmtpServer server = FoeServerMessage.GetDefaultSmtpServer();
string subject = "Re: Register " + requestId + " by Newbie";
FoeServerMessage.SendMessage(server, FoeServerRegistry.Get("ProcessorEmail"), user.Email, subject, user.UserId);
FoeServerLog.Add(_processName, FoeServerLog.LogType.Message, "Completed registration for " + userEmail);
//FoeDebug.Print("Sent reply to " + userEmail);
//FoeDebug.Print("");
}
reader.Close();
// Close connections
conn.Close();
completeConn.Close();
}
