Life Documentation

Retrieve Worklist Item using Folio In K2 BlackPearl

2009-01-10T07:23:00.000-08:00

Sample code how to retrieve worklist item in K2 BlackPearl using Folio in WorkflowCriteria.

using System;

using System.Collections.Generic;

using System.Text;

using SourceCode.Hosting.Client;

using SourceCode.Workflow.Client;

namespace K2Samples

    public class WorkflowAccessingSample

        public void RetrieveWorklistOpenItemBasedOnFolio()

            // TODO: Replace these placeholder values with values for your environment

            Worklist worklist = null;

            WorklistItem worklistitem = null;

            string _serverName = "blackpearl";

            string _user = "K2Student";

            string _domain = "DENALLIX";

            string _password = "K2pass!";

            SourceCode.Hosting.Client.BaseAPI.SCConnectionStringBuilder connectionString =

                new SourceCode.Hosting.Client.BaseAPI.SCConnectionStringBuilder();

            connectionString.Authenticate = true;

            connectionString.Host = "localhost";

            connectionString.Integrated = true;

            connectionString.IsPrimaryLogin = true;

            connectionString.Port = 5252;

            connectionString.UserID = _user;

            connectionString.WindowsDomain = _domain;

            connectionString.Password = _password;

            connectionString.SecurityLabelName = "K2"; //the default label

            // open a K2 connection

            Connection connection = new Connection();

            connection.Open(_serverName, connectionString.ToString());

try

                WorklistCriteria wc = new WorklistCriteria();

                wc.AddFilterField(WCField.ProcessFolio, WCCompare.Equal, "NR - 1");

                // open the worklist item

                worklist = connection.OpenWorklist(wc);

                if (worklist.Count == 0)

                    Console.WriteLine("There has been a problem retrieving the K2 process
                      data. Please ensure that the account has rights to the K2
                      BlackPearl Workflow Item and that you are connecting to the
                      BlackPearl server.");

                else

                {
                    worklistitem = worklist[0];

                    // retrieve properties of worklist item

                    Console.WriteLine("Process Instance Name: " +
                    worklistitem.ProcessInstance.Name);

                    Console.WriteLine("Process Destination: " +
                    worklistitem.ActivityInstanceDestination.Name);

                    Console.WriteLine("Process Folio: " +
                    worklistitem.ProcessInstance.Folio);

                    // get the workflow actions

                    string workflowActions = "Workflow Actions: ";

                    foreach (Action action in worklistitem.Actions)

                        workflowActions += Environment.NewLine + action.Name;

                    // write actions to console

                    Console.WriteLine(workflowActions + Environment.NewLine);

                    Console.ReadLine();

            catch (Exception ex)

                // write error to console

                Console.WriteLine("Error: " + ex.Message);

                Console.ReadLine();

            finally

                // close the connection

                connection.Close();

Stored Procedure Paging in My Sql

2009-01-09T23:48:00.000-08:00

Sample code of stored procedure for paging in My Sql. The input parameter are DatabaseName, WhereClause, OrderBy, PageIndex, and PageSize. The output parameter is TotalRecords.

DELIMITER $$

CREATE PROCEDURE `GetPaged`(IN DatabaseName varchar(200), IN WhereClause varchar(200),

         IN OrderBy varchar(200), IN PageIndex int, IN PageSize int, OUT TotalRecords int)

BEGIN

    DECLARE _WhereClause VARCHAR(200);

    DECLARE _OrderBy VARCHAR(200);

    DECLARE _Limit VARCHAR(20);

    SET _Limit = ' LIMIT ?,?';

    IF LENGTH(WhereClause) > 0 THEN SET _WhereClause = CONCAT(' WHERE ', WhereClause);

       ELSE SET _WhereClause = '';

    END IF;

    IF LENGTH(OrderBy) > 0 THEN SET _OrderBy = CONCAT(' ORDER BY ', OrderBy);

       ELSE SET _OrderBy = '';

    END IF;

    SET @SQLStatement = CONCAT('SELECT * FROM ',DatabaseName, _WhereClause, _OrderBy, _Limit);

    SET @Count = CONCAT('SELECT COUNT(1) INTO @TotalRecords FROM ',DatabaseName, _WhereClause);

    SET @v_PageIndex = PageIndex;

    SET @v_PageSize = PageSize;

    PREPARE SQLStatement FROM @SQLStatement;

    EXECUTE SQLStatement using @v_PageIndex,@v_PageSize;

    DROP PREPARE SQLStatement;

    PREPARE COUNTStatement FROM @Count;

    EXECUTE COUNTStatement;

    DROP PREPARE COUNTStatement;

    SET TotalRecords = @TotalRecords;

END $$

DELIMITER ;

Get SharePoint Discussion Forum Replies Data

2009-01-01T22:11:00.001-08:00

This is a sample code how to get all discussion replies data in sharepoint discussion forum.

1:  SPWeb web = SPContext.Current.Web;

2:  SPList listForum = web.Lists["Forum"];

3:

4:       /* Get the Discussion Forum Data */

5:       SPQuery qry = new SPQuery();

6:       qry.Query = @"<OrderBy>

7:                         <FieldRef Name='DiscussionLastUpdated' Ascending='False' />

8:                    </OrderBy>";

9:       qry.RowLimit = 3;

10:

11:      SPListItemCollection itemsColl = listForum.GetItems(qry);

12:

13:      if (itemsColl.Count > 0)

14:      {

15:         foreach (SPListItem item in itemsColl)

16:         {

17:            Response.Write("ID: " + item.ID + "<BR>");

18:            Response.Write("Name: " + item.Name + "<BR><BR>");

19:

20:            /* Get all discussion replies */

21:            SPQuery qry2 = new SPQuery();

22:            qry2.Query = @"<OrderBy>

23:                              <FieldRef Name='DiscussionLastUpdated' Ascending='False' />

24:                           </OrderBy>";

25:

26:            qry2.Folder = item.Folder;

27:            SPListItemCollection itemsColl2 = listForum.GetItems(qry2);

28:

29:            if (itemsColl2.Count > 0)

30:            {

31:              foreach (SPListItem replayItem in itemsColl2)

32:              {

33:                Response.Write("Display Name: " + replayItem.DisplayName + "<BR>");

34:                Response.Write("List ID: " + replayItem.ID + "<BR>");

35:                Response.Write("List Folder ID: " +
                       replayItem["Parent Folder Id"].ToString() + "<BR>");

36:                Response.Write("Body: " + replayItem["Body"] + "<BR>");

37:                Response.Write("Last Replay By:" + replayItem["Author"].ToString().
                       Split(new string[] { ";#" }, StringSplitOptions.RemoveEmptyEntries)[1]
                       + "<BR><BR>");

38:              }

39:           }

40:           else

41:           {

42:               Response.Write("No Replay Data <BR><BR>");

43:           }

44:        }

45:     }

Disable SharePoint Single or Multiple File Upload using Javascript

2009-01-01T22:10:00.001-08:00

Nice article how to disable single file upload in sharepoint document library or picture library using javascript.
Check it here.

If you want to disable multiple file upload you can change the javascript code :
var o = GetElementByText("ie:menuitem","Upload Document");

is changed to

var o = GetElementByText("ie:menuitem","Upload Multiple Documents");

Set Permission List or Document Library SharePoint Using EventHandler

2008-11-04T08:58:00.000-08:00

Sample code to set permission using EventHandler when ItemAdded.

1: using System;

2: using System.Collections.Generic;

3: using System.Text;

4: using Microsoft.SharePoint;

5:

6: namespace EventHandler

7: {

8:  public class SetPermissionItemEventReceiver : SPItemEventReceiver

9:  {

10:   public override void ItemAdded(SPItemEventProperties properties)

11:   {

12:       SetPermission(properties);

13:   }

14:

15:   private void SetPermission(SPItemEventProperties properties)

16:   {

17:     string LoginName = properties.UserLoginName;

18:     SPSecurity.RunWithElevatedPrivileges(delegate()

19:     {

20:       using (SPSite site = new SPSite(properties.SiteId))

21:       {

22:         using (SPWeb web = site.OpenWeb(properties.RelativeWebUrl))

23:         {

24:            this.DisableEventFiring();

25:

26:            SPListItem item = web.Lists[properties.ListId].GetItemById(properties.ListItemId);

27:

28:            string ListName = item.ListItems.List.RootFolder.Name;

29:

30:            if (!item.HasUniqueRoleAssignments)

31:                 item.BreakRoleInheritance(false);

32:

33:            SPRoleDefinition ContributeRoleDefinition =
                                 item.Web.RoleDefinitions["Contribute"];

34:            SPRoleDefinition ApproveRoleDefinition =
                                 item.Web.RoleDefinitions["Approve"];

35:            SPRoleDefinition FullControlRoleDefinition =
                                 item.Web.RoleDefinitions["Full Control"];

36:

37:            SPRoleAssignment UserRoleAssignment = new SPRoleAssignment(LoginName, 
                                 string.Empty, string.Empty, string.Empty);

38:            UserRoleAssignment.RoleDefinitionBindings.Add(ContributeRoleDefinition);

39:            item.RoleAssignments.Add(UserRoleAssignment);

40:

41:            SPGroup OwnerGroup = item.Web.SiteGroups["Owners"];

42:            SPRoleAssignment OwnerRoleAssignment = new SPRoleAssignment(OwnerGroup);

43:            OwnerRoleAssignment.RoleDefinitionBindings.Add(FullControlRoleDefinition);

44:            item.RoleAssignments.Add(OwnerRoleAssignment);

45:

46:            SPGroup ApproversGroup = item.Web.SiteGroups[
                                  string.Format("{0}_Approvers", ListName)];

47:            SPRoleAssignment ApproversRoleAssignment = new SPRoleAssignment(ApproversGroup);

48:            ApproversRoleAssignment.RoleDefinitionBindings.Add(ApproveRoleDefinition);

49:            item.RoleAssignments.Add(ApproversRoleAssignment);

50:

51:            this.EnableEventFiring();

52:          }

53:        }

54:      });

55:     }

56:   }

57: }

SharePoint Web Part using ReportViewer(Reporting Services SharePoint Integration)

2008-10-29T22:46:00.000-07:00

If you want to create Web Part using ReportViewer and is consumed by your SharePoint site and the Reporting Services is configured to SharePoint Integration. First you must change ReportServerCredential.

If you use this code :

ReportViewer1.ServerReport.ReportServerCredentials.NetworkCredentials =
new NetworkCredential("administrator", "password", "domain");

You will get a message that the NetworkCredential is readonly. So you must create a custom ReportServerCredentials that implement Microsoft.Reporting.WebForms.IReportServerCredentials. Below is the code and make sure your custom ReportServerCredentials class must using [Serializable] :

1:[Serializable]

2:  public class ReportServerCredentials : Microsoft.Reporting.WebForms.IReportServerCredentials

3:  {

4:     private string _UserName;

5:     private string _Password;

6:     private string _DomainName;

7:     public ReportServerCredentials(string UserName, string Password,
                                        string DomainName)

8:     {

9:         _UserName = UserName;

10:        _Password = Password;

11:        _DomainName = DomainName;

12:     }

13:     public WindowsIdentity ImpersonationUser

14:     {

15:         get { return null; }

16:     }

17:

18:     public ICredentials NetworkCredentials

19:     {

20:         get

21:         {

22:             return new NetworkCredential(_UserName, _Password, _DomainName);

23:         }

24:     }

25:     public bool GetFormsCredentials(out Cookie authCookie, out string userName,
               out string password, out string authority)

26:     {

27:         authCookie = null;

28:         userName = null;

29:         password = null;

30:         authority = null;

31:         return false;

32:     }

33: }

The datasource of the report i use stored procedure. Where the parameter of the report @Status, @EmployeeId, @DeptName, @EmployeesListID and @ApprovedLeavePlanListID, i configured the parameter as a Hidden parameter because I do not want it to be displayed in the ReportViewer component. Below is the code

1:  CREATE PROCEDURE [dbo].[SP_LeaveBlockLeaveReport]

2:      @StartDate datetime,

3:      @EndDate datetime,

4:      @Status int,

5:      @EmployeeId int,

6:      @DeptName varchar(50),

7:      @EmployeesListID varchar(50),

8:      @ApprovedLeavePlanListID varchar(50)

9:  AS

10:  BEGIN

11:    SET NOCOUNT ON;

12:    DECLARE @Query varchar(1000)

13:

14:    SET @Query ='SELECT Employee.nvarchar4 as EmployeeName,
       ApprovedLeavePlan.StartLeave,

15:    ApprovedLeavePlan.EndLeave, ApprovedLeavePlan.LeaveType,
       Employee.float4 as LeaveBalance,

16:    Employee.float2 as LeaveWithPermission, Employee.float6 as BlockLeave,
       ApprovedLeavePlan.Amount

17:    FROM AllUserData as Employee

18:    LEFT JOIN (SELECT int1 as EmployeeID, nvarchar3 as LeaveType,
                  float1 as Amount, datetime1 as StartLeave, datetime2 as EndLeave

19:               FROM AllUserData

20:               WHERE tp_ListId='''+@ApprovedLeavePlanListID+'''

21:        AND tp_DeleteTransactionId = 0x) as ApprovedLeavePlan
           ON Employee.tp_ID=ApprovedLeavePlan.EmployeeID

22:        AND ApprovedLeavePlan.StartLeave >= ''' +
           CONVERT(nvarchar(30), @StartDate, 109) +'''

23:        AND ApprovedLeavePlan.EndLeave <= ''' + 
           CONVERT(nvarchar(30), @EndDate, 109)  +'''

24:    WHERE tp_ListId='''+@EmployeesListID+'''

25:    AND tp_DeleteTransactionId = 0x AND tp_RowOrdinal=0'

26:

27:    if @Status=0

28:        SET @Query = @Query + ' AND tp_ID=' + CAST(@EmployeeId as varchar(10))

29:    else if @Status=1

30:        SET @Query = @Query + ' AND nvarchar8=''' + @DeptName +''''

31:    else if @Status=2

32:        SET @Query =  @Query + ''

33:    else if @Status=3

34:        SET @Query =  @Query + ''

35:

36:    SET @Query =  @Query + ' ORDER BY EmployeeName'

37:    EXEC(@Query)

38:END

Below is the code to call the Reporting Services at Page_Load

1:  [Serializable]

2:  public partial class WebUserControl : System.Web.UI.UserControl

3:  {

4:    protected void Page_Load(object sender, EventArgs e)

5:    {

6:       if (!IsPostBack)

7:       {

8:          ReportViewer1.Visible = true;

9:          ReportViewer1.ProcessingMode = ProcessingMode.Remote;

10:         ReportViewer1.Width = new Unit(100, UnitType.Percentage);

11:         ReportViewer1.Height = new Unit(100, UnitType.Percentage);

12:         ReportViewer1.Style.Add("width", "100%");

13:         ReportViewer1.Style.Add("height", "100%");

14:         ReportViewer1.ZoomPercent = 100;

15:         ReportViewer1.AsyncRendering = false;

16:         ReportViewer1.ShowDocumentMapButton = true;

17:         ReportViewer1.DocumentMapCollapsed = false;

18:

19:         ReportViewer1.ServerReport.ReportServerCredentials = 
          new ReportServerCredentials("administrator", "password", "domain");

20:

21:         ReportViewer1.ServerReport.ReportServerUrl = 
          new Uri("http://localhost/ReportServer");

22:         ReportViewer1.ServerReport.ReportPath =
              "http://localhost:1234/Reports/ReportsLibrary/LeaveBlockLeave.rdl";

23:

24:         ReportParameter[] parameter = new ReportParameter[5];

25:         ReportParameter p = null;

26:         p = new ReportParameter("Status", "0");

27:         parameter[0] = p;

28:         p = new ReportParameter("EmployeeId", "22");

29:         parameter[1] = p;

30:         p = new ReportParameter("DeptName", "Information Technology");

31:         parameter[2] = p;

32:         p = new ReportParameter("EmployeesListID", 
                             "1319C369-3F19-42F8-87CA-8403AB940573");

33:         parameter[3] = p;

34:         p = new ReportParameter("ApprovedLeavePlanListID", 
                              "BB8AFBA9-FC27-4388-B4F6-76C1EB3DE9EF");

35:         parameter[4] = p;

36:         ReportViewer1.ServerReport.SetParameters(parameter);

37:      }

38:   }

39: }

Don’t forget to add this code to your web.config of your Share Point Site :

1. Add to <SafeControls> section.
<SafeControl Assembly="Microsoft.ReportViewer.WebForms, Version=8.0.0.0,
Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"
Namespace="Microsoft.Reporting.WebForms" TypeName="*" Safe="True" />

2. Add to <assemblies> section.
<add assembly="Microsoft.ReportViewer.WebForms, Version=8.0.0.0, Culture=neutral,
PublicKeyToken=b03f5f7f11d50a3a" />

3. And also change enableSessionState to true at <pages enableSessionState="false".

Below you can see the Report is displayed in your SharePoint site. Fill StartDate and EndDate parameter and "View Report" button is clicked.