How can I retreive a DNN ModuleSetting or TabSetting in a DoWork() method for the Scheduler?

Question

I have a DotNetNuke module with a View and Scheduler Class called CRMCheck.

I have setup my Scheduler Task to call my class every couple of minutes. (MyModule.Modules.CRM.CRMCheck)

I need to retrieve a Setting saved for Module or TabSettings. I am saving Module and ModuleTabSettings, by default DNN will use ModuleTabSettings when using Settings[] and saving both at the same time.

So my main issue is I want to fetch the Email Address which I saved in the settings section of the module which the Scheduler DoWork() method should use.

I am also having an issue whereby you can't get the portal ID when using the Scheduler and DNN states you that in this post: https://dnncommunity.org/forums/aft/191

This is the error:

This is the Scheduler Code just beneath my modules View Class:

    public class CRMCheck : SchedulerClient
{
    private readonly DaoCRM m_DaoCRM = new DaoCRM();


public CRMCheck(ScheduleHistoryItem oItem) : base()
    {
        this.ScheduleHistoryItem = oItem;
    }

    public Control LocalResourceFile { get; private set; }

    public override void DoWork()
    {
        try
        {
            //Perform required items for logging
            this.Progressing();

            //Your code goes here
            DateTime? TimeNow = DateTime.Now;
            var CRMItems = ShowCRMListDNN();
            foreach (var item in CRMItems)
            {
                DateTime? RegisteredDateINDatabase = item.DateRegistered;
                var TimeDifference = TimeNow - RegisteredDateINDatabase;
                var DidTheyPurchaseSomething = item.PurchasedSomething;
                if(TimeDifference.Value.TotalHours > 3 && DidTheyPurchaseSomething == false)
                {
                    //email and stuff
                    SendSuccessEmailToAdmin(item.FirstName, item.LastName, item.CompanyName, item.EmailAddress, item.Cellphone, item.ERPUserId, item.DateRegistered, item.PortalID, item.PurchasedSomething);
                }
            }


            //To log note
            this.ScheduleHistoryItem.AddLogNote("Item Executed");

            //Show success
            this.ScheduleHistoryItem.Succeeded = true;
        }
        catch (Exception ex)
        {
            this.ScheduleHistoryItem.Succeeded = false;
            //InsertLogNote("Exception= " + ex.ToString());
            this.Errored(ref ex);
            DotNetNuke.Services.Exceptions.Exceptions.LogException(ex);
        }
    }

    public List ShowCRMListDNN()
    {
        var result = new List();
        try
        {
            return result = m_DaoCRM.ShowCRMListNoPortalID();
        }
        catch (Exception ex)
        {
        EventLogController logController = new EventLogController();
        logController.AddLog("Problem fetching CRM List for Scheduled Job.", ex.ToString(), EventLogController.EventLogType.ADMIN_ALERT);
        return result;
      }
    }

    /// 
    /// Sends an email when the job runs
    /// 
    /// ZR - Added - 09/03/2018
    private void SendSuccessEmailToAdmin(string FirstName, string LastName, string CompanyName, string Email, string Cellphone, int ERPUserID, DateTime? DateRegistered, int Portal, bool PurchasedSomething)
    {
        if (Settings["CRMEmail"] != null && !string.IsNullOrWhiteSpace(Settings["CRMEmail"].ToString()))
        {
            System.Text.StringBuilder strAdminEmailMsg = new System.Text.StringBuilder();

            strAdminEmailMsg.AppendLine("

");
            strAdminEmailMsg.AppendLine("");
            strAdminEmailMsg.AppendLine("    ");
            strAdminEmailMsg.AppendLine("        ");
            strAdminEmailMsg.AppendLine("    ");
            strAdminEmailMsg.AppendLine("    ");
            strAdminEmailMsg.AppendLine("        New Customer Registration
");
            strAdminEmailMsg.AppendFormat("  ", DateTime.Now.ToLocalTime()).AppendLine();
            strAdminEmailMsg.AppendLine("Date: {0}");

            strAdminEmailMsg.AppendLine("");
            strAdminEmailMsg.AppendLine("    ");
            strAdminEmailMsg.AppendLine("        ");
            strAdminEmailMsg.AppendLine("    ");
            strAdminEmailMsg.AppendLine("    ");
            strAdminEmailMsg.AppendLine("        ");
            strAdminEmailMsg.AppendLine("    ");
            strAdminEmailMsg.AppendLine(" 
 ");
            //all changes in inner table
            strAdminEmailMsg.AppendLine("            ");
            strAdminEmailMsg.AppendLine("                ");
            strAdminEmailMsg.AppendFormat("                  ");
            strAdminEmailMsg.AppendFormat("                  ", FirstName);
            strAdminEmailMsg.AppendLine("                ");
            strAdminEmailMsg.AppendLine("                ");
            strAdminEmailMsg.AppendFormat("                  ");
            strAdminEmailMsg.AppendFormat("                  ", LastName);
            strAdminEmailMsg.AppendLine("                ");
            strAdminEmailMsg.AppendLine("                ");
            strAdminEmailMsg.AppendFormat("                  ");
            strAdminEmailMsg.AppendFormat("                  ", CompanyName);
            strAdminEmailMsg.AppendLine("                ");
            strAdminEmailMsg.AppendLine("                ");
            strAdminEmailMsg.AppendFormat("                  ");
            strAdminEmailMsg.AppendFormat("                  ", Email);
            strAdminEmailMsg.AppendLine("                ");
            strAdminEmailMsg.AppendLine("            FirstName {0}
Last Name {0}
Company Name {0}
Email {0}");
            strAdminEmailMsg.AppendLine("        ");

            SendEmail("System Job", strAdminEmailMsg.ToString(), Settings["CRMEmail"].ToString());
        }
    }

    /// 
    /// Send an email
    /// 
    /// 
    /// 
    /// 
    private void SendEmail(string MailSubject, string MailMessage, string RecipientEmail)
    {
        bool EmailSent = false;

        //EmailSent = webcall
        EmailSent = SessionManager.GSettings.Globalvars.ClHelper.eBusiness.SendEmail(-1, 2, RecipientEmail, MailSubject, MailMessage);

        //Show a message to the user if it was sent or not
        if (!EmailSent)
        {
            EventLogController logController = new EventLogController();
            logController.AddLog("Problem sending Job Email", "", EventLogController.EventLogType.ADMIN_ALERT);
        }

    }

}

How can I retreive a DNN ModuleSetting or TabSetting in a DoWork() method for the Scheduler?

Answers (1)

Related Questions