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();
}
