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

Sharepoint Object Mode

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

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

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

You can display custom infopath Date Time from Infopath Default date Time.

The IP Fx formula is:

concat(substring(TestDate, 9, 2), "-", substring(TestDate, 6, 2), "-", substring(TestDate, 1, 4), " ", substring(TestDate, 12, 8))

MS SQL Server Connection String

SQl Server Connection String

Sharepoint Event receiver for SP List

Sharepoint Event Viewer and Receiver

Sharepoint 2007 Timer Job Development and Deployment Steps

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(); } } } } Feature.xml <?xml version="1.0" encoding="utf-8" ?> <Feature xmlns="http://schemas.microsoft.com/sharepoint/" Id="2FAE7079-FD53-4371-81DF-E7A206884AA8" Title="HRction.TimerJob" Description="HR Action TimerJob ." Scope="Site" Hidden="FALSE" Version="1.0.0.0" ReceiverAssembly="HRAction.TimerJob, Version=1.0.0.0, Culture=neutral, PublicKeyToken=52505fa26f9ec918" ReceiverClass="HRction.TimerJob.TimerInstaller"> </Feature> manifest.xml <?xml version="1.0" encoding="utf-8" ?> <!-- Solution created by WSPBuilder. 5/25/2011 8:13:46 PM --> <Solution xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" SolutionId="932AE855-EBA7-4c4c-A54A-7FD36415DCF7" ResetWebServer="True" xmlns="http://schemas.microsoft.com/sharepoint/"> <Assemblies> <Assembly Location="HRAction.TimerJob.dll" DeploymentTarget="GlobalAssemblyCache" /> </Assemblies> </Solution>

 

ASP.Net Server side POP UP message box displayed

The below code is working in the server side of the ASP.Net code, You have to modify only the panel name based on you form
System.Web.UI.ScriptManager.RegisterClientScriptBlock(panel1, Page.GetType(), "strscript", "alert('Record Successfully Updated.')", true);