using System;
using System.Collections;
using SourceCode.K2ROM;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;

namespace K2ROM
{
    /**//// <summary>
    /// Summary description for K2Helper.
    /// </summary>
    public class K2Helper
    {
        public K2Helper()
        {
            //
            // TODO: Add constructor logic here
            //
        }

        public static string GetConnectionString(string domain, string userName, string password)
        {
            return string.Format(@"[;];Authenication=Windows;Domain={0};User={1};Password={2}", domain, userName, "Dell1234");
        }

        /**//// <summary>
        /// Authenication
        /// </summary>
        public static string ConnectionString = "[;];Authenication=Windows;Domain=mstech;User=administrator;Password=Satyam123241";

        /**//// <summary>
        /// Getting the K2 server name.
        /// </summary>
        public static string ServerName = ConfigurationManager.AppSettings["K2Server"].ToString();

        /**//// <summary>
        /// Start a process instance in k2 server.
        /// </summary>
        /// <param name="processName">Process name</param>
        /// <param name="param">Process instance data,stored as a hashtable</param>
        /// <returns>Return process instance</returns>
        public static ProcessInstance StartProcessInstance(string processName, Hashtable param)
        {
            Connection con = new Connection();

            con.Open(ServerName);
            ProcessInstance instance = con.CreateProcessInstance(processName);
            IDictionaryEnumerator list = param.GetEnumerator();
            while (list.MoveNext())
                instance.DataFields[list.Key.ToString()].Value = list.Value;
            con.StartProcessInstance(instance);
            con.Close();
            return instance;

        }
        /**//// <summary>
        /// Submit the result to K2 server.
        /// </summary>
        /// <param name="item">WorklistItem</param>
        /// <param name="isSubmit">Stop or Finish</param>
        /// <returns></returns>
        public static bool UpdateWorkItem(WorklistItem item, bool isSubmit)
        {
            if (item == null)
                throw new NullReferenceException("WorklitItem item is null!");

            if (isSubmit)
                item.Finish();
            else
                item.Update();
            return true;
        }

        /**//// <summary>
        /// Redirect the work item to specified person.
        /// </summary>
        /// <param name="item"></param>
        /// <param name="userName"></param>
        /// <returns></returns>
        public static bool RedirectWorkItem(WorklistItem item, string userName)
        {
            if (item != null)
            {
                item.Redirect(userName);
                return true;
            }
            return false;
        }

        /**//// <summary>
        /// Get WorklistItem by serialnumber.
        /// </summary>
        /// <param name="serialNumber"></param>
        /// <returns></returns>
        public static WorklistItem GetWorkistItem(string serialNumber)
        {
            Connection con = new Connection();
            con.Open(ServerName);

            WorklistItem item = con.OpenWorklistItem(serialNumber, "ASP");
            return item;

        }

        /**//// <summary>
        /// Open a server item
        /// </summary>
        /// <param name="serialNumber"></param>
        /// <returns></returns>
        public static ServerItem GetServerItem(string serialNumber)
        {
            Connection con = new Connection();
            con.Open(ServerName);
            return con.OpenServerItem(serialNumber);
        }

        /**//// <summary>
        /// convert worklist to dataset
        /// </summary>
        /// <param name="list"></param>
        /// <returns></returns>
        public static DataTable GetWorklistDataTable(Worklist list)
        {
            if (list == null || list.Count == 0)
                return null;
            DataTable dt = CreatWorkListTable();
            foreach (WorklistItem item in list)
            {
                DataRow dr = dt.NewRow();
                dr["ProcInstID"] = item.ProcessInstance.ID;
                dr["StartDate"] = item.ProcessInstance.StartDate;
                dr["SerialNumber"] = item.SerialNumber;
                //The id implement alternant opration between K2 DB and Location DB.
                dr["WorkItemID"] = item.ProcessInstance.DataFields["WorkItemID"].Value.ToString();
                dt.Rows.Add(dr);

            }
            return dt;
        }

        /**//// <summary>
        /// Creat a datatable to store WorkList.
        /// </summary>
        /// <returns></returns>
        public static DataTable CreatWorkListTable()
        {
            DataTable dt = new DataTable();
            dt.Columns.Add("ProcInstID");
            dt.Columns.Add("StartDate");
            dt.Columns.Add("SerialNumber");
            dt.Columns.Add("WorkItemID");
            return dt;
        }

        /**//// <summary>
        /// Get Worklist by criteria.
        /// </summary>
        /// <param name="criteria"></param>
        /// <returns></returns>
        public static Worklist GetWorklist(WorklistCriteria criteria)
        {
            Connection con = new Connection();
            con.Open(ServerName);
            return con.OpenWorklist(criteria);
        }

        /**//// <summary>
        /// Get Worklist by process name.
        /// </summary>
        /// <param name="processName"></param>
        /// <returns></returns>
        public static Worklist GetWorklist(string processName)
        {
            WorklistCriteria criteria = new WorklistCriteria();
            criteria.AddFilterField(WCField.ProcessName, WCCompare.Equal, processName);
            return GetWorklist(criteria);
        }

        /**//// <summary>
        /// Get Worklist by process name and activity name.
        /// </summary>
        /// <param name="processName"></param>
        /// <param name="activityName"></param>
        /// <returns></returns>
        public static Worklist GetWorklist(string processName, string activityName)
        {

            WorklistCriteria criteria = new WorklistCriteria();
            criteria.AddFilterField(WCField.ProcessName, WCCompare.Equal, processName);
            criteria.AddFilterField(WCField.ActivityName, WCCompare.Equal, activityName);
            return GetWorklist(criteria);
        }

        /**//// <summary>
        /// Stop a process instance by process ID.
        /// </summary>
        /// <param name="ProcessID"></param>
        /// <returns></returns>
        public static bool StopProcessInstance(int ProcessID)
        {
            SourceCode.K2Mng.K2Manager mgr = K2Helper.GetK2Manager();
            bool flag = mgr.StopProcessInstances(ProcessID);
            mgr.Logout();
            return flag;
        }

        /**//// <summary>
        /// Access K2 service as admin.
        /// </summary>
        /// <returns></returns>
        public static SourceCode.K2Mng.K2Manager GetK2Manager()
        {
            SourceCode.K2Mng.K2Manager mgr = new SourceCode.K2Mng.K2Manager();
            try
            {
                mgr.Login(ConfigurationManager.AppSettings["K2Server"], int.Parse(ConfigurationManager.AppSettings["K2AdminPort"]), ConfigurationManager.AppSettings["K2AdminConnectionString"]);
            }
            catch (Exception ex)
            {
                throw new Exception("Access to K2 Server denied!", ex);
            }
            return mgr;
        }
    }
}

This code i got from this link http://www.cnblogs.com/lovemyth/archive/2007/07/13/817318.html

Share this post: | | | |

Just some small tips here to help boost the performance of the Host Server.

In the following config files in C:\Program Files\K2 blackpearl\Host Server\Bin

• DependancyService.config
•  SourceCode.Categories.Runtime.config
• SourceCode.EventBus.ClientRecorder.dll.config
• SourceCode.Workflow.Runtime.Management.config
• SourceCode.Workspace.Runtime.config

Look for a ConnectionString key value. This stores the SQL connection string to the database. In the connection string, change the pooling value from False to True. It would also be a good idea to make a backup of the config files if you don't really know what you are doing. :)

Restart your Host Server to get the changes to take effect. And presto! you should see a faster Host Server. Note that this should be already fixed in the new 0803 build that should be released soon (plus a whole host of other fixes and performance enhancements).

For detail about this information you can click on this link http://www.k2underground.com/blogs/johnny/archive/2008/04/15/host-server-performance-tweaks-for-k2-blackpearl-sp1-and-earlier.aspx

Share this post: | | | |

How to create a RichTextBox on WSS 3.0 / Moss. Ho ho... is so easy you don't have to used other control or third party to implement this.

I will give you a example and code how to implement RichTextBox on the WSS 3.0.

<textarea name="txtTextArea1" rows="6" cols="20" id="txtTextArea1" title="Body123" class="ms-long" ></textarea>
<script language="javascript" type="text/javascript">

RTE_ConvertTextAreaToRichEdit("txtTextArea1", true, false, "", "1033", null, null, null, null, null,"FullHtml", "\u002f",null,null,null,null);   

</script>

and then in your page you will get this:

Note : make sure that your page is included with this javascript :

<script type="text/javascript" language="javascript" src="/_layouts/1033/form.js"></script>

Share this post: | | | |

 Hari ini 28 Mei 2008 tepatnya jam17.30 sore sampai ke tempat salah satu client perusahaan saya bekerja. Client kami ini sudah kami lewati masa installasi di semua cabang untuk melakukan transaksi dengan aplikasi kami di pusat dengan server dummy kami dan sekarang sudah untuk masuk fase go live. 

Untuk dapat menjaga jaga kejadian bahwa nanti installasi WSS 3.0 dan segala aplikasi gagal, client mengharuskan bahwa WSS 2.0 dan aplikasi eksisting harus masih ada.

Hal-hal yang perlu di lakukan untuk install WSS 3.0 dan WSS 2.0 di satu mesin adalah :

1. Install Windows 2003 SP1/SP2.

2. Install .net 2.0 dan .Net 3.0

3. Install WSS 2.0 SP2

4. Install WSS 3.0

Semoga hari ini berhasil install semua dengan mulus 

Share this post: | | | |

 Check this out : http://community.bamboosolutions.com/blogs/bambooteamblog/archive/2008/05/21/how-to-install-windows-sharepoint-services-3-0-sp1-on-vista-x64-x86.aspx.

Share this post: | | | |

I got this link from this link http://www.codeproject.com/KB/system/everythingInAD.aspx#42 and i decide it to post to my blog for remind me about this article.

Hope it can used later.

Share this post: | | | |

 This is the list of the Visual Studio Add-ins, most of which are open source or free. I hope this list will help you to code more faster and effective. If there is not your favorite add-in in the below list, do not hesitate to add it as a comment.

• TestDriven.NET - makes it easy to run unit tests with a single click, anywhere in your Visual Studio solutions. It supports all versions of Microsoft Visual Studio .NET and it integrates with the best .NET development tools including NCover, NCoverExplorer, Reflector, TypeMock, dotTrace, NUnit, MbUnit, ZaneBug, MSBee & Team System.
• AnkhSVN - is a Visual Studio .NET addin for the Subversion version control system. It allows you to perform the most common version control operations directly from inside the VS.NET IDE. Not all the functionality provided by SVN is (yet) supported, but the majority of operations that support the daily workflow are implemented.
• C# Refactory - performs a large number of refactorings, allowing you to re-shape your c-sharp code as needs arise. Refactoring is an essential part of the extreme programming development approach. C# refactory enables you to automate many refactorings thus increasing the reliability and speed with which you can refactor your c-sharp code.
• GhostDoc - is a free add-in for Visual Studio that automatically generates XML
  documentation comments for C#. Either by using existing documentation inherited
  from base classes or implemented interfaces, or by deducing comments from
  name and type of e.g. methods, properties or parameters.
• SharpTools is an extensible add-in to the Microsoft Visual Studio.NET development environment, and a software development kit (SDK) supporting the rapid development of further extensions which will run within SharpTools.
• Google Plugin - Search Google from Visual Studio .NET
• Resource Refactoring Tool - provides developers an easy way to extract hard coded strings from the code to resource files.
• BIDS Helper - A set of VS.Net add-ins that extend and enhance the functionality of the SQL Server BI Development Studio.
• Power Toys for Visual Studio - are small tools that provide aid to developer pain-points or assist in diagnosing development-related issues. In addition to providing support, the power toys are released as Microsoft Shared Source to provide sample code to real-world solutions and allow for collaborative-development.
• Koders IDE - enable software developers to perform Koders searches directly from within the Eclipse or Visual Studio development environments by extending the reach of the Koders.com open source code index to the desktop.
• Codekeep - Once you've downloaded and installed a CodeKeep add-in, you can manage your code snippets and search for other code snippets without ever having to leave Visual Studio.
• CodeShare - Add-in is a Visual Studio.NET plugin for sharing code snippets in an enterprise. It provides menu options within the IDE to contribute and find code snippets from a central repository.
• RSS Blog Reader - open source add-in and a full-featured RSS / Blog aggregator which integrates into the familiar dockable panes of the Visual Studio.NET IDE.
  
• csUnit is a free and open source unit testing tool for the .NET Framework. csUnit works with all .NET languages including C#, Visual Basic .NET, J#, and managed C++. It comes with a choice of command line, graphical user interface, and an addin for Visual Studio.
  
• Oracle Developer Tools for Visual Studio .NET - The Oracle Developer Tools for Visual Studio .NET (ODT) is a tightly integrated Add-in for Microsoft Visual Studio. Features are generate SQL scripts for Oracle schema, generate ASP.NET web applications with very little coding required, drag and drop and automatically generate .NET code, seamlessly step from your .NET code into your PL/SQL stored procedure code and back out again, etc...
• WSCF - A Free Visual Studio Add-In and Command Line Tool for ImprovedSchema-Based Contract-First Web Services Design and Programming
• ZipStudio - provides a means of zipping up complete or partial Visual Studio solutions and projects and associated files, directly from in Visual Studio itself.
• MySQL Developer Tools is a powerful add-in designed to simplify the MySQL database application development process. It integrates into Visual Studio and Delphi, making all database development and administration tasks available from your favorite IDE. It provides an easier way to explore and maintain existing databases, design compound SQL statements, query and manipulate data in different ways.
• Comment Reflower - is an Add-in for Visual Studio 2003 and 2005 to reflow the text in comments in source files to have even word wrapping. It does more than simply just wrapping all text in comment blocks.
• VSCmdShell - provides users with a shell window inside the Visual Studio IDE that can be used for Visual Studio commands as well. Current version allows user to use either Windows Command Shell (cmd.exe) or Windows PowerShell.
• IBM Database Add-ins - development Add-In and managed provider for the Microsoft .NET platform includes RAD features, DB2 database project, scripting wizards, and CLR stored procedures to simplify building DB2 applications using Visual Studio .NET.
  
• VSdocman is a tool for commenting and the quick automatic generation of class documentation from your C# and VB .NET source code files. It is ideal tool for you if you create .NET component, control, application, smart device or web site (ASP .NET) projects
  
• CopySourceAsHtml - An add-in for Microsoft Visual Studio 2005 that allows you to copy source code, syntax highlighting, and line numbers as HTML. CSAH uses Visual Studio's syntax highlighting and font and color settings automatically.
• Codexchange - is an Visual Studio.NET add-in providing you with instant integrated access to an online repository of ready to use .NET code snippets
• ADO.NET Express - is an add-in for Visual Studio 2003 that automates common tasks of writing repetitive data access code. ADO.NET Express generates class methods for calling stored procedures and executing common types of SQL statements.
• VSTypeFinderAddin - for Visual Studio 2005 provides the possibility to search for all classes, structs, enums and delegates in a solution.
• AopDotNetAddIn - is a Visual Studio AddIn that provides the aspect oriented capabilities to the .Net languages (C#,VB.Net,J#), this AddIn was developed as a graduation project
• Reflector is the class browser, explorer, analyzer and documentation viewer for .NET. Reflector allows to easily view, navigate, search, decompile and analyze .NET assemblies in C#, Visual Basic and IL.

Share this post: | | | |

 Bila kita mempunyai suau SPListItem dimana item kita tersebut mempunyai field dengan type person / group untuk mendapatkan user tersebut kita bisa lakukan dengan 2 cara yaitu :

public void GetUser()

{

    SPUser user;

    string s;

    string [] split'

   using (SPSite site = new SPSite("http://portal"))

    {

                using (SPWeb web = site.OpenWeb())

                {

                    SPList list = web.Lists["Example For Users"];

                    SPListItem item = list.Items[0];

                     s =   item["User Name"];

                     split = s.split(';');

                     user = web.Users.GetByID(Convert.ToInt32(split[0]));

                }

     }

}

atau dengan cara ini :

public void GetUser()

{

using (SPSite site = new SPSite("http://portal"))

            {

                using (SPWeb web = site.OpenWeb())

                {

                    SPList list = web.Lists["Example For Users"];

                    SPListItem item = list.Items[0];

                    SPFieldUserValue userValue = new SPFieldUserValue(web, item["User Name"].ToString());

                    if (userValue!=null)

                    {

                        user = userValue.user;

                    }

                }

            }

 }

Share this post: | | | |

Tadi malam ngobrol ama client dan ada request untuk tidak bisa menghapus document yang di buat tetapi user tersebut punya hak akses untuk create document / upload document.

Daripada pikir panjang untuk menghapus link delete item di context menunya akhirnya saya langsung memberikan solusi bila user tersebut delete item tersebut akan di berikan notifikasi "You don't have authorized to delete this item".

Setelah client setuju akhirnya saya membuat event dan coding untuk handle event tersebut. 

Coding sbb :

using System;
using System.Security.Permissions;
using System.Runtime.InteropServices;
using Microsoft.SharePoint;
using Microsoft.SharePoint.Security;
using System.Diagnostics;
using System.IO;
using System.Configuration;

namespace Agusto.Dms.SpEvent
{
    [CLSCompliant(false)]
    public class MyItemEvent : SPItemEventReceiver
    {
        private SPWeb spWeb = null;
              
        /// <summary>
        /// Initializes a new instance of the Microsoft.SharePoint.SPItemEventReceiver class.
        /// </summary>
        public MyItemEvent ()
        {
        }
            

        /// <summary>
        /// Synchronous before event that occurs before an existing item is completely deleted.
        /// </summary>
        /// <param name="properties">
        /// A Microsoft.SharePoint.SPItemEventProperties object that represents properties of the event handler.
        /// </param>
        [SharePointPermission(SecurityAction.LinkDemand, ObjectModel = true)]
        public override void ItemDeleting(SPItemEventProperties properties)
        {
            string LoginName = properties.UserLoginName;
            if (!LoginName.ToLower().Equals(@"sharepoint\system"))
            {
                try
                {
                    using (spWeb = new SPSite(properties.SiteId).OpenWeb())
                    {
                        SPUser user = spWeb.Users[LoginName];
                        if (!user.IsSiteAdmin)
                        {
                            properties.ErrorMessage = @"You don't have authorized to delete this item";
                            properties.Cancel = true;
                        }
                    }
                }
                catch (Exception ex)
                {
                    properties.ErrorMessage = ex.Message + "," + ex.Source;
                    properties.Cancel = true;
                }
            }       
        }

       }
    }
}

Dengan code ini akhirnya user yang punya hak akses read/contributor tidak bisa delete item, tetapi system account dan account yang di set sebagi full control dari site akan bisa hapus item tersebut.

Share this post: | | | |

This is a good article how about to create a new workflow on moss/wss. For detail this info you can click this link http://aaronweiker.com/post/2008/03/Hello-World!-from-SharePoint-and-Windows-Workflow.aspx

Share this post: | | | |

This section provides code snippets that show general SharePoint centric code, such as that used in webparts or applications that tap into the object model (22 Snippets)

Access SharePoint User Information - This piece of code shows you how to access the current SharePoint Users information.

Create SharePoint Query - This is a small piece of code that shows you how to create a SharePoint query.

Creating A WebPart Menu Item - This snippet demonstrates a method that will allow you to specify a link in the webpart menu box (the context menu that you get with webparts). It is helpful when creating custom menu items for webparts, although appears to be deprecated in 3.0.

Determine If List Column Exists - This method is helpful if you need to determine whether a column in a list exists or not by passing in the column name as a string value. It is a helpful method when working with SharePoint field existence.

Determine if there are files and folders - This example shows you how to determine whether there are files or folders in a SharePoint asset. This is an asset existence method and can be used to prevent the overriding of other content.

Display A Users Role Collection - This snippet shows you how to display a particular users set of roles based on the user name parameter.

Display Site Collection Information - This method shows you how you can in a webpart display various pieces of information about a SharePoint site collection.

Example XSL Transformation - If you have an XSL document that you wish to apply to you webpart returns, you need a method to apply the XSL transformation.

Get a SharePoint Field By Its Name - This piece of code demonstrates how you could return a SharePoint field by passing in the name parameter.

Get A SharePoint List - This is a simple method that will add you in getting a SharePoint list from a site.

Get A Web Based On List Existence - This code sample demonstrates how to get a specific web based on a SharePoint list, returning the specific web. It also includes several layers of exception handling and various properties that can be set.

Get An XSL Filepath For WebParts - This method allows you to get an XSL File Path that you can use in your webparts. I find it useful if I am applying formatting to things that are generated out of the object model.

Get List View Items - This code sample provides method that will get the list items that are present in a SharePoint view.

Get the WebPart Qualifier - This method gets the webpart qualifier.

Getting A SharePoint Site Name - This piece of code shows you how to retrieve a SharePoint Site name after using the OpenWeb() method.

Insert Values Into The URL - This method will help you when you need to insert parameters into the URL string.

Load Lists Into Drop Down Control - This example shows how you could load all the lists in a web into a drop down control, for use in a toolpane or otherwise.

Open Up A Web Conditionally - This method shows you how you can open up a web conditionally based on pre-existing text, such as whether it exists in a text box in this specific example.

Progamatically Move List - This example shows you how to move a list within an arbitrary number of webs in SharePoint.

Redirect Users To Sites - This code snippet will allow you to redirect users to various sites based on their login.

Return Boolean If Flat Folder Structure - This example shows you how to return a boolean value if there is a flat folder structure present.

Show Whether A SharePoint Field Contains Metainformation - This is a small code sample that will show you how to determine whether a SharePoint field contains meta information.

for detail more snipset you can et on this link  http://weblogs.mysharepoint.de/mgreth/archive/2007/05/02/sharepoint-code-snippets.aspx

Share this post: | | | |

SDKs and development tools

Development helpers and add-ins for WSS and MOSS 2007

Tools for WSS and MOSS 2007 (object browsers, CAML tools)

Add-ons to site settings and central administration

WCM tools and add-ons

Site templates

SharePoint Designer 2007 tools and resources

to more detail you can click this link http://www.katriendg.com/aboutdotnet/Resources-wss3-moss.aspx