Sharepoint Timer 2007

Sharepoint 2007 Timer Job

Create Timer job solution File.

1.Create C# project Library
2.Create Timer.CS, TimerInstaller.CS, Feature.xml, manifest.xml files
3.Copy existing code and past it in the proper files
4.Set strong name
5.Build DLL
6.Copy DLL id in the feature file
7.Build WSP and following deploying procedures.

Deployment Timer Jobs:

1. C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\TEMPLATE\FEATURES 1.1 Create a folder " KarNet.TimerJob " 1.2 Copy the files "Feature.xml" & "Manifest.xml"
2. Run the install.bat file to deploy the Solution file. 2.2 before that edit the file to point to correct SharePoint site, by changing the "TargetUrl".
2.3 stsadm -o installfeature -name KarNet.TimerJob -force
3. Copy the KarNet.TimerJob.DLL to GAC.
4. Activate the Site Collection feature to enable the custom Timer
5. Restart the Timer Service in services.
6. Create a Folder in C:\ as "KarNetLog"
7. Share the folder and allow "everyone" full access.

Activate Feature manually

C:\Program Files\Common Files\Microsoft Shared\web serverextensions\12\BIN>stsa dm -o deactivatefeature -name KarNet.TimerJob -url "http://KarNet-46b4a490b"
C:\Program Files\Common Files\Microsoft Shared\web serverextensions\12\BIN>stsa dm -o uninstallfeature -name "KarNet.TimerJob"
C:\Program Files\Common Files\Microsoft Shared\web serverextensions\12\BIN>stsa dm -o installfeature -name KarNet.TimerJob -force
C:\Program Files\Common Files\Microsoft Shared\web serverextensions\12\BIN>stsa dm -o activatefeature -name "KarNet.TimerJob" -url "http://KarNet-46b4a490b
"

Timer .cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Microsoft.SharePoint;
using Microsoft.SharePoint.Administration;
using System.Diagnostics;
using Microsoft.SharePoint.Workflow;
using System.IO;
using Microsoft.SharePoint.Utilities;
using System.Collections.Specialized;

using System.Text.RegularExpressions;

namespace HRction.TimerJob
{
    public class Timer : SPJobDefinition
    {
        public Timer()
            : base() { }

[Persisted]
        private string siteToPerformJob;

public Timer(string jobName, SPService service, SPServer server, SPJobLockType targetType)
            : base(jobName, service, server, targetType)
        {
        }

public Timer(string jobName, SPWebApplication webApplication, SPSite site)
            : base(jobName, webApplication, null, SPJobLockType.Job)
        {
            this.Title = "HR.TimerJob";
            this.siteToPerformJob = site.Url;
        }

public override void Execute(Guid contentDbId)
        {
            try
            {

//System.Diagnostics.Debugger.Break();

//System.Diagnostics.Debug.Assert(false);
                //System.Diagnostics.Debug.WriteLine(SPContext.Current.Site.WebApplication.Name);

// get a reference to the current site collection's content database
                SPWebApplication webApplication = this.Parent as SPWebApplication;
                //LogMessage("Welcome " + webApplication.Name, EventLogEntryType.Information);
                //SPContentDatabase contentDb = webApplication.ContentDatabases[contentDbId];

//SPList taskList = contentDb.Sites["FEDemo"].RootWeb.Lists["Tasks"];

// create a new task, set the Title to the current day/time, and update the item
                //SPListItem newTask = taskList.Items.Add();
                //newTask["Title"] = DateTime.Now.ToString();
                //newTask.Update();

//int ID = 0;

DateTime ActionDate;

string IsError = "";
                string strWFStatus = "";

string strActionDate = "";

string strItemID = "";
                string strDivAction = "";
                string strAction = "";                
                string strWfStarted = "";

string siteURL = "";

string CC = "";
                string Body = "";
                string TO = "";

string HRction_Mail_Group = "";
                string GetHRctionEmail = "";

StringDictionary headers = new StringDictionary();
                headers.Add("content-type", "text/html");

if (this.siteToPerformJob != null)
                {
                    ////siteURL = this.siteToPerformJob + "/wss"; //need to enable for client deployment
                    siteURL = this.siteToPerformJob + "/"; //need to enable for client deployment
                    using (SPSite currentSite = new SPSite(siteURL))
                    {
                        //LogMessage("SPSite - " + currentSite.Url, EventLogEntryType.Information);
                        currentSite.AllowUnsafeUpdates = true;
                        currentSite.CatchAccessDeniedException = false;
                        using (SPWeb AnetWeb = currentSite.OpenWeb())
                        {
                            AnetWeb.AllowUnsafeUpdates = true;
                            //LogMessage("AnetWeb - " + AnetWeb.Url, EventLogEntryType.Information);
                            ////SPList BGOperatorReminder = AnetWeb.Lists["BGOperatorReminder"];
                            SPList ActionList = AnetWeb.Lists["HRList"]; //- for Production

foreach (SPListItem item in ActionList.Items)
                            {

strItemID = item["ID"].ToString();
                                LogMessage("Item ID " + item["ID"].ToString(), EventLogEntryType.Information);
                                strActionDate = item["ReminderDate"].ToString().Replace("datetime;#", ""); // For Production
                                ////LogMessage("strActionDate " + strActionDate, EventLogEntryType.Information);
                                ActionDate = Convert.ToDateTime(strActionDate, System.Threading.Thread.CurrentThread.CurrentCulture.DateTimeFormat);
                                //LogMessage("ActionDate " + ActionDate.ToString(), EventLogEntryType.Information);
                                LogMessage("Reminder Date " + ActionDate.AddDays(-1).Date, EventLogEntryType.Information);
                                
                                strDivAction = item["Action"].ToString();
                                ////LogMessage("strDivAction " + strDivAction, EventLogEntryType.Information);
                                strAction = Regex.Replace(strDivAction, "<[^>]*>", string.Empty);

strWFStatus = item["WFStatus"].ToString();
                                strWfStarted = item["WFStarted"].ToString();
                                //LogMessage("strAction " + strAction, EventLogEntryType.Information);
                                //LogMessage("Reminder " + item["Reminder"], EventLogEntryType.Information);
                                //LogMessage("Added By " + item["AddedBy"], EventLogEntryType.Information);
                                //LogMessage("WF Status " + item["WFStatus"], EventLogEntryType.Information);
                                //LogMessage("WFStarted " + item["WFStarted"], EventLogEntryType.Information);

if (item["Reminder"].ToString() == "True")
                                {
                                    if (ActionDate.AddDays(-1).Date == DateTime.Today.Date && item["WFStatus"].ToString() == "Pending") // for Production  (&& InFavourOf != "The Controller of Immigration")
                                    {
                                        if (item["WFStarted"].ToString() == "No")
                                        {

using (SPSite site = new SPSite(siteURL))
                                            {
                                                using (SPWeb web = site.OpenWeb())
                                                {

SPGroup gp = web.Groups["HRAction"];
                                                    if (gp != null)
                                                    {
                                                        foreach (SPUser usr in gp.Users)
                                                        {
                                                            if (usr.Name != "System Account")
                                                            {
                                                                if (HRAction_Mail_Group == "")
                                                                    HRAction_Mail_Group += usr.Name;
                                                                else
                                                                    HRAction_Mail_Group += ", " + usr.Name;

if (GetHRActionEmail == "")
                                                                    GetHRActionEmail += usr.Email;
                                                                else
                                                                    GetHRCActionEmail += "," + usr.Email;
                                                            }
                                                        }
                                                    }

}
                                            }

TO = GetHRActionEmail;
                                            if (TO.Length > 0)
                                            {

headers.Add("from", item["FromEmail"].ToString());
                                                
                                                Body = Body + "<table dir='ltr' cellspacing='0' designtimesp=23183> <tr designtimesp=23184><td designtimesp=23185> </td></tr>";
                                                                                                Body = Body + "<tr designtimesp=23186><td designtimesp=23187> The HR Competitor Action status as follows:</td></tr>";
                                                Body = Body + "<tr designtimesp=23188><td designtimesp=23189> </td></tr><tr designtimesp=23190><td designtimesp=23191> </td></tr>";
                                                Body = Body + "<table  dir='ltr' cellspacing='1' cellspacing='1' border='1' designtimesp=23192><tr designtimesp=23193><th designtimesp=23194> Name</th><th designtimesp=23195> Name</th><th designtimesp=23196> Name </th><th designtimesp=23197>Action</th></tr>";
                                                Body = Body + "<tr designtimesp=23198><td designtimesp=23199><p align='Center' designtimesp=23200>" + item["PropertyName"].ToString() + "</p></td><td designtimesp=23201><p align='Center' designtimesp=23202>" + item["Name"].ToString() + "</p></td><td designtimesp=23203><p align='Center' designtimesp=23204>" + item["AssociateName"].ToString() + "</p></td><td designtimesp=23205><p align='Center' designtimesp=23206>" + strAction + "</p></td></tr></table></td></tr>";
                                                Body = Body + "<tr designtimesp=23207><td designtimesp=23208> </td></tr>";
                                                Body = Body + "<tr designtimesp=23209><td designtimesp=23210> </td></tr><tr designtimesp=23211><td designtimesp=23212> </td></tr><tr designtimesp=23213><td designtimesp=23214>Best regards,</td></tr><tr designtimesp=23215><td designtimesp=23216> Admin Team</td></tr></table>";

//headers.Add("cc", CC);
                                                headers.Add("to", item["ToEmail"].ToString());
                                                headers.Add("subject", "HR Status  : " + item["AssociateName"].ToString());

SPUtility.SendEmail(AnetWeb, headers, Body);

headers.Clear();

item["WFStatus"] = "Completed";
                                                item["WFStarted"] = "Yes";
                                                item.SystemUpdate();

CC = "";
                                                Body = "";
                                                TO = "";

HRAction_Mail_Group = "";
                                                GetHRActionEmail = "";

}

}
                            // INITIEAL FOR LOOP CLOSED

}
                        // SP WEB IF LOOP CLOSED

// item.SystemUpdate();

/// # endregion

}
                    // SP SITE URL LOOP CLOSED

}

// SP TIMER JOB IF LOOP CLOSED

//LogMessage("Updated", EventLogEntryType.Information);
            }

// TRY LOOP CLOSED

catch (Exception ex)
            {
                LogMessage(" Error " + ex.Message + " Trace " + ex.StackTrace, EventLogEntryType.Error);
            }
        }

// EXCECUTE DB ID LOOP CLOSED

protected static string StartWorkflow(SPListItem wfListItem, string workflowName, string SiteURL)
        {
            SPWorkflowAssociationCollection wfAssocs = wfListItem.ParentList.WorkflowAssociations;
            SPWorkflowAssociation activeWorkflowAssoc = null;
            string errorMessage = string.Empty;

foreach (SPWorkflowAssociation wfAssoc in wfAssocs)
            {
                if (wfAssoc.Name.Equals(workflowName))
                {
                    activeWorkflowAssoc = wfAssoc;
                    break;
                }
            }

// if the workflow exists, start the workflow 
            SPWorkflow activeWorkflow = null;
            if (activeWorkflowAssoc != null)
            {
                try
                {
                    using (SPSite currentSite = new SPSite(SiteURL))
                    {
                        activeWorkflow = currentSite.WorkflowManager.StartWorkflow(
                        wfListItem,
                        activeWorkflowAssoc,
                        "<Data DESIGNTIMESP=23217></Data>");
                    }
                }
                catch (Exception ex)
                {
                    errorMessage = "error " + ex.Message;
                }
            }
            else
            {
                errorMessage = "error No WF Found";
            }
            return errorMessage;
        }

//kcline
        private static void Log(String logMessage, string LogType, TextWriter w)
        {
            w.Write("\r\nLog Type :{0} ", LogType);
            w.WriteLine("\r\n{0} {1}", DateTime.Now.ToLongTimeString(),
                DateTime.Now.ToLongDateString());
            //w.WriteLine("  :");
            w.WriteLine("   - {0}", logMessage);
            w.WriteLine("-------------------------------");
            // Update the underlying file.
            w.Flush();
        }

//kcline
        private void LogMessage(string message, EventLogEntryType type)
        {
            string FilePath = "C:\\HR Log"; //SPDiagnosticsService.Local.LogLocation.ToString();
            string FileName = "";
            bool EndSlash = false;
            if (FilePath.EndsWith("\\"))
                EndSlash = true;

if (Directory.Exists(FilePath))
            {
                if (EndSlash == false)
                    FileName = FilePath + "\\" + " HR-Timer.log";
                else
                    FileName = FilePath + "HR-Timer.log";

string LogType = "";
                using (StreamWriter w = File.AppendText(FileName))
                {
                    LogType = type.ToString();
                    Log(message, LogType, w);
                    //ka line// Close the writer and underlying file.
                    w.Close();
                }
            }
        }

}
}

TimerInstaller.cs

using System;
using Microsoft.SharePoint;
using Microsoft.SharePoint.Administration;

namespace HRction.TimerJob
{
    class TimerInstaller : SPFeatureReceiver
    {
        const string JOB_NAME = "HRAction.Timer";

/// <summary>
        /// Occurs after a Feature is installed.
        /// </summary>
        /// <param name="properties">An <see cref="T:Microsoft.SharePoint.SPFeatureReceiverProperties"></see> object that represents the properties of the event.</param>
        public override void FeatureInstalled(SPFeatureReceiverProperties properties)
        {
        }

/// <summary>
        /// Occurs when a Feature is uninstalled.
        /// </summary>
        /// <param name="properties">An <see cref="T:Microsoft.SharePoint.SPFeatureReceiverProperties"></see> object that represents the properties of the event.</param>
        public override void FeatureUninstalling(SPFeatureReceiverProperties properties)
        {
        }

/// <summary>
        /// Occurs after a Feature is activated.
        /// </summary>
        /// <param name="properties">An <see cref="T:Microsoft.SharePoint.SPFeatureReceiverProperties"></see> object that represents the properties of the event.</param>
        public override void FeatureActivated(SPFeatureReceiverProperties properties)
        {
            // register the the current web
            SPSite site = properties.Feature.Parent as SPSite;

// make sure the job isn't already registered
            foreach (SPJobDefinition job in site.WebApplication.JobDefinitions)
            {
                if (job.Name == JOB_NAME)
                    job.Delete();
            }

// install the job
            Timer AnetTimerFBG = new Timer(JOB_NAME, site.WebApplication, site);

SPMinuteSchedule schedule = new SPMinuteSchedule();
            schedule.BeginSecond = 0;
            schedule.EndSecond = 59;
            schedule.Interval = 5;
            AnetTimerFBG.Schedule = schedule;

//schedule.BeginHour = 12;
            //schedule.BeginMinute = 30;
            //AnetTimerFBG.Schedule = schedule;
            //AnetTimerFBG.Update();

AnetTimerFBG.Update();
        }

/// <summary>
        /// Occurs when a Feature is deactivated.
        /// </summary>
        /// <param name="properties">An <see cref="T:Microsoft.SharePoint.SPFeatureReceiverProperties"></see> object that represents the properties of the event.</param>
        public override void FeatureDeactivating(SPFeatureReceiverProperties properties)
        {
            SPSite site = properties.Feature.Parent as SPSite;

// delete the job
            foreach (SPJobDefinition job in site.WebApplication.JobDefinitions)
            {
                if (job.Name == JOB_NAME)
                    job.Delete();
            }
        }
    }
}

Sharepoints Solutions

Pages

Wednesday, September 12, 2012

How to set email or name in the Sharepoint List of the People or Group field

Tuesday, August 7, 2012

How to load sharepoint List data values in to the User control Dropdown box via Sharepoint Object Model

How to retrieve People Picker AD id and Display name to store in the SQlL Server Databases

Wednesday, July 18, 2012

Convert Infopath Default date to DD-MM-YYYY HH:MM:SS

Friday, June 29, 2012

MS SQL Server Connection String

Sharepoint Event receiver for SP List

Friday, May 25, 2012