Method to check if any Attachment in Sharepoint Document Set is checked out

public string IsAttachmentCheckedOut(int itemID, int myListID)

        {

            string ErrorMsg = string.Empty;

            Guid lguid = new Guid(myListID);

            SPList mlist = SPContext.Current.Web.Lists[lguid];

            SPFolder mfolder = mlist.GetItemById(itemID).Folder;

            foreach (SPFile file in mfolder.Files)

            {

                if (file.CheckOutType != SPFile.SPCheckOutType.None)

                {

                    string currentUser = SPContext.Current.Web.CurrentUser.Name;

                    if (file.CheckedOutByUser.Name.ToLower().Equals(currentUser.ToLower()))

                    {

                        ErrorMsg += "The Attachment, '" + file.Name + "' is Checked Out by You.\\r\\n";

                    }

                    else

                    {

                        ErrorMsg += "The Attachment, '" + file.Name + "' is Checked Out by the User, '" + file.CheckedOutByUser.Name.ToUpper() + "'.\\r\\n";

                    }

                }

            }

            return ErrorMsg;

        }

C# Code to get First Working Day of the Month and Year excluding holidays and weekends

public DateTime GetFirstWorkingDay(int year, int month)

        {          

            DateTime FirstBusinessDay = default(DateTime);

            FirstBusinessDay = new DateTime(year, month, 1);

            while (IsHoliday(FirstBusinessDay) || IsWeekEnd(FirstBusinessDay))

            {

                FirstBusinessDay = FirstBusinessDay.AddDays(1);

            }

            return FirstBusinessDay;

        }

        private bool IsHoliday(DateTime date)

        {

            bool isHoliday = false;

            //Jan 1st -- Holiday

            if (date.Month == 1 && date.Day == 1)

                isHoliday = true;

            //July 4th -- Independence Day

            if (date.Month == 7 && date.Day == 4)

                isHoliday = true;

            //LABOR DAY -- 1st Monday in September

            DateTime laborDay = new DateTime(date.Year, 9, 1);

            DayOfWeek dayOfWeek = laborDay.DayOfWeek;

            while (dayOfWeek != DayOfWeek.Monday)

            {

                laborDay = laborDay.AddDays(1);

                dayOfWeek = laborDay.DayOfWeek;

            }

            if (date == laborDay.Date)

                isHoliday = true;

            return isHoliday;

        }

        private bool IsWeekEnd(DateTime date)

        {

            return date.DayOfWeek == DayOfWeek.Saturday

                || date.DayOfWeek == DayOfWeek.Sunday;

        }

Export SharePoint List View to Excel

using Microsoft.SharePoint;
using System.Data;
using System.IO;
using System.Drawing;
using System.Text.RegularExpressions;
using System.Text;            



//Create a Table

               Table tblListView = new Table();

                tblListView.ID = "_tblListView";

                tblListView.BorderStyle = BorderStyle.Solid;

                tblListView.BorderWidth = Unit.Pixel(1);

                tblListView.BorderColor = Color.Silver;

                //tblListView.GridLines = GridLines.Both;              

               

                using (SPSite site = new SPSite(SPContext.Current.Web.Url.Trim()))

                {

                    using (SPWeb web = site.OpenWeb())

                    {
                        //Get the List

                        SPList list = web.Lists[ListNameToBeExported.Trim()];

                        //Get the Sharepoint View

                        SPView wpView = list.Views[ViewNameToBeExported.Trim()];

                        wpView.RowLimit = 2147483647;

                        SPQuery query = new SPQuery(wpView);
                     
                         //Get the Listitems for the Sharepoint View

                        SPListItemCollection items = list.GetItems(query);

           

                        if (items != null && items.Count > 0)

                        {

                            DataTable tbListViewData = items.GetDataTable();

                            DataView dvListViewData = tbListViewData.DefaultView;

                            if (dvListViewData != null && dvListViewData.Count > 0)

                            {

                                tblListView.Rows.Add(new TableRow());

                                tblListView.Rows[0].Font.Bold = true;

                             

                                for (int i = 0; i < wpView.ViewFields.Count; i++)

                                {

                                    tblListView.Rows[0].Cells.Add(new TableCell());                          

                                    tblListView.Rows[0].Cells[i].Text = list.Fields.GetFieldByInternalName(wpView.ViewFields[i].ToString()).Title;

                                    tblListView.Rows[0].Cells[i].BackColor = Color.DodgerBlue;

                                    tblListView.Rows[0].Cells[i].Style.Add(HtmlTextWriterStyle.TextAlign, "Center");

                                }

                                int k = 0; //variable to color alternate rows in table

                                for (int i = 0; i < dvListViewData.Count; i++)

                                {

                                    tblListView.Rows.Add(new TableRow());

                                    if (k == 0)

                                        k = 1;

                                    else

                                        k = 0;                        

                                   

                                    for (int j = 0; j < wpView.ViewFields.Count; j++)

                                    {

                                        tblListView.Rows[i + 1].Cells.Add(new TableCell());

                                       

                                        if (tbListViewData.Columns.Contains(wpView.ViewFields[j].ToString()))

                                        {

                                            //tblListView.Rows[i + 1].Cells[j].Text = dvListViewData[i][wpView.ViewFields[j].ToString()].ToString();

                                            string HTMLCode = dvListViewData[i][wpView.ViewFields[j].ToString()].ToString();

                                         

                                            //To remove line breaks

                                            HTMLCode = HTMLCode.Replace("

", " ");

                                            HTMLCode = HTMLCode.Replace("\r\n", " ");

                                            HTMLCode = HTMLCode.Replace("\r", " ");

                                            HTMLCode = HTMLCode.Replace("\n", " ");

                                            //to remove list numbers so that line breaks won't appear in th espreadsheet

                                            HTMLCode = HTMLCode.Replace("

", " ");

                                            HTMLCode = HTMLCode.Replace("

", " ");

                                            HTMLCode = HTMLCode.Replace("

", " ");                                            HTMLCode = HTMLCode.Replace("

", " ");                                            HTMLCode = HTMLCode.Replace("

", " ");

                                            HTMLCode = HTMLCode.Replace("

", " ");

                                            tblListView.Rows[i + 1].Cells[j].Text = HTMLCode;                                          

                                            if (k == 0)

                                                tblListView.Rows[i + 1].Cells[j].BackColor = Color.LightSteelBlue;

                                            else

                                                tblListView.Rows[i + 1].Cells[j].BackColor = Color.AliceBlue;

                                        }

                                    }

                                   

                                }

                            }

                        }

                    }

                }

                try

                {

                    Response.ContentType = "application/vnd.ms-excel 8.0";

                    Response.Charset = "";

                    Response.ContentEncoding = System.Text.Encoding.Default;

                    this.EnableViewState = false;

                    System.IO.StringWriter ObjWriter = new System.IO.StringWriter();

                    System.Web.UI.HtmlTextWriter ObjHtmlTextWriter = new System.Web.UI.HtmlTextWriter(ObjWriter);

                    tblListView.RenderControl(ObjHtmlTextWriter);

                    Response.Write(ObjWriter.ToString());

                    string strhtml = ObjHtmlTextWriter.ToString();

                    //get File name from View name and current DateTime

                    string currentDtaeTime = DateTime.Now.ToString("MM-dd-yyyy-hh-mm-ss");

                    string FileName = ViewNameToBeExported + "_" + currentDtaeTime;

                    string FilenameWithExtension = FileName + ".xls";

                    Response.AppendHeader("content-disposition", "attachment;filename=" + FilenameWithExtension);

                    Response.Flush();

                    Response.End();

                }

                catch (System.Exception ex)

                {

                    string strMsg = ex.Message;

                }

Filter SharePoint List View to display items that are due in 6(X) months from Today

Requirement: Filter SharePoint View to display items with Due Date in 6 months from Today.

Solution:

1)  Create a calculated column,"DueDateFor6Months" of type Date and Time, with the following Formula:

=DATE(YEAR([Due Date]),MONTH([Due Date])-6,DAY([Due Date]))

2) Edit the SharePoint View and apply the following Filter:

Show the Items when column,

 "DueDateFor6Months" is less than or equal to "[Today]".

Emails in a K2 workflow stopped working after deploying new workflow version.

The workflow fails while trying to send a notification with the error "SourceCode.Workflow.Common.EWS: The e-mail address does not have ‘send on behalf of’ permissions on Exchange".

1. Check if SMTP server, Exchange server connection strings are correct in “ConnectionStringEditor.exe”
2. Open Connection String editor from "C:\Program Files (x86)\K2 blackpearl\Host Server\Bin" as Administrator.

3. Check if Email "From Address" field value is a valid email in Environment Fields/String Table and same as the email displayed in the connection String editor.
4. Restart IIS, MSMQ and K2 services.

Get Emails for Multiple Destination Users in K2 Workflow

In Workflows, sometime we may need to get emails for dynamic destination users (one or more destination users separated by semi-colon ’;’).

To achieve this, we need to do as follows:

1. Add two Process Data Fields, one for storing User IDs and another for getting User emails.

1. MultiUserIDs – Process field to store semi-colon(;) separated list of User IDs

Ex: k2:denallix\administrator;k2:denallix\bob.

Note: you can also pass  data without K2 label,

Ex: denallix\administrator;denallix\bob

2. MultiUserEmails – Process field to fetch and store semi-colon(;) separated list of User Email Ids for the input User IDs.

2. Add a default Activity. Configure the destination rules as follows:

1. Run the Destination Wizard in “Advanced Mode”

2. Select “All at Once”

3. Select “Create a slot for each destination” and “Resolve all roles and groups to users”
   

4. In the Destination Sets, Add New Destination with Split function as follows:

5. Click on “Finish” button

3. Add the event, “Default Server Event(Code)” to the above activity.

4. Go to the code event by,

5. Add the following Code for the code event. This code will loop through the destination users and get emails for the multiple destination users and concatenate them with semi-colon(;).

6. That’s it. After that, you can add an email event with “MultiDestEmails” as “To field’ to send emails to all destination Users.

7. Once you run this, you will get the Output as follows:

Exception Logging in K2

public class K2ExceptionHandler

    {

            System.Net.Mail.MailMessage expMail = null;

            System.Net.Mail.SmtpClient smtpClient = null;

            System.Net.Mail.MailAddress mailAddressFrom = null;

            Exception ex = null;

            object exContext = null;             

            string emailBody = string.Empty;

            bool bFlag = true;

            public void SendExceptionEmail(SourceCode.KO.ExceptionContext K2)

            {

            try

            {

                smtpClient = new System.Net.Mail.SmtpClient();

                expMail = new System.Net.Mail.MailMessage();

                //Mail To Address

                string mailTO = System.Configuration.ConfigurationManager.AppSettings["ExceptionEmailTo"]; // Get it from K2HostServer.exe.config file, located at "C:\Program Files (x86)\K2 blackpearl\Host Server\Bin"

                expMail.To.Add(mailTO);

                //Email From Address - Get it from String tabble

                string fromAddress = K2.StringTable["From Address"];

                mailAddressFrom = new System.Net.Mail.MailAddress(fromAddress);

                expMail.From = mailAddressFrom;

                //Email Subject

                expMail.Subject = "K2 Error: ProcessID " + K2.ProcessInstance.ID.ToString() + " for the Process, '" + K2.ProcessInstance.Process.FullName + "' is in error state";

                //Send HTML Email

                expMail.IsBodyHtml = true;

                expMail.Priority = System.Net.Mail.MailPriority.High;

                // Basic Message

                emailBody += "";

                emailBody += "";

                emailBody += "";

                emailBody += "";

                emailBody += "";

                emailBody += "

";

                emailBody += "";

                emailBody += "" ;

                emailBody += "
Dear Administrator,
";

                emailBody += "

";

                emailBody += "
"
+ " Error occurred in the K2 workflow, '" + K2.ProcessInstance.Process.FullName + "

' for the Process Intstance ID, '" + K2.ProcessInstance.ID.ToString() + "'. Below is a detailed extraction of the error and the process instance.";

                emailBody += "

";

                #region Process Instance Details

                emailBody += "
Process Intstance Details
";

                              

                emailBody += " " ;

                emailBody += "
"
;

                emailBody += "" ;

                emailBody += " " ;

                emailBody += "
ID:
";

                emailBody += "
"
+ K2.ProcessInstance.ID.ToString() + "

";

                emailBody += "

";

                emailBody += " " ;

                emailBody += "
Process Name:
";

                emailBody += "
"
+ K2.ProcessInstance.Process.FullName + "

";

                emailBody += "

";

               

                emailBody += " " ;

                emailBody += "
Folio:
";

                emailBody += "
"
+ K2.ProcessInstance.Folio + "

";

                emailBody += "

";

              

                emailBody += " " ;

                emailBody += "
Originator:
";

                emailBody += "
"
+ K2.ProcessInstance.Originator.DisplayName + "

";

                emailBody += "

";

                emailBody += " " ;

                emailBody += "
Start Date:
";

                emailBody += "
"
+ K2.ProcessInstance.StartDate.ToString() + "

";

                emailBody += "

";

                emailBody += "

";

                emailBody += "

";

                emailBody += "

";

                emailBody += "

";

                #endregion

                #region Process Data Fields

                emailBody += "
Data Field Values
";

                emailBody += " " ;

                emailBody += "
"
;

                emailBody += "" ;

                foreach (SourceCode.KO.DataField _dataField in K2.ProcessInstance.DataFields)

                {

                    emailBody += " " ;

                    emailBody += "
"
+ _dataField.Name + " [" + _dataField.FieldType.ToString() + "]

";

                    emailBody += "
"
+ _dataField.Value.ToString() + "

";

                    emailBody += "

";

                emailBody += "

";

                emailBody += "

";

                emailBody += "

";

                emailBody += "

";

                #endregion

                #region Failure Details

                emailBody += "
Failure Details
";

                emailBody += " " ;

                emailBody += "
"
;

                emailBody += "" ;

                //Check where the error happened

                switch (K2.ContextType)

                {

                    case SourceCode.KO.ContextType.ClientEvent:

                        {

                            emailBody += " " ;

                            emailBody += "
Error thrown by:
";

                            emailBody += "
"
+ K2.ContextType.ToString() + "

";

                            emailBody += "

";

                            exContext = K2.ContextObject;

                            emailBody += " " ;

                            emailBody += "
Activity Name:
";

                            emailBody += "
"
+ ((SourceCode.KO.ClientEventContext)exContext).ActivityInstanceDestination.Activity.Name + "

";

                            emailBody += "

";

                            emailBody += " " ;

                            emailBody += "
Event Name:
";

                            emailBody += "
"
+ ((SourceCode.KO.ClientEventContext)exContext).Event.Name + "

";

                            emailBody += "

";

                            break;

                        }

                    case SourceCode.KO.ContextType.DestinationRule:

                        {

                            emailBody += " " ;

                            emailBody += "
Error thrown by:
";

                            emailBody += "
"
+ K2.ContextType.ToString() + "

";

                            emailBody += "

";

                            exContext = K2.ContextObject;

                            emailBody += " " ;

                            emailBody += "
Activity Name:
";

                            emailBody += "
"
+ ((SourceCode.KO.DestinationRuleContext)exContext).ActivityInstance.Activity.Name + "

";

                            emailBody += "

";

                            emailBody += " " ;

                            emailBody += "
Destinations:
";

                            emailBody += "
"
;

                            foreach (SourceCode.KO.Destination _dest in ((SourceCode.KO.DestinationRuleContext)exContext).Destinations)

                            {

                                emailBody += " " + _dest.Name + " [" + _dest.Type.ToString() + "];";

                            }

                            emailBody += "

";

                            emailBody += "

";

                            emailBody += " " ;

                            emailBody += "
Slot Data:
";

                            emailBody += "
"
;

                            foreach (string _slotdata in ((SourceCode.KO.DestinationRuleContext)exContext).SlotInstanceData)

                            {

                                emailBody += " " + _slotdata + ";";

                            }

                            emailBody += "

";

                            emailBody += "

";

                            emailBody += " " ;

                            emailBody += "
Dynamic Queues:
";

                            emailBody += "
"
+ ((SourceCode.KO.DestinationRuleContext)exContext).DynamicQueues.ToString() + "

";

                            emailBody += "

";

                            emailBody += " " ;

                            emailBody += "
Resolve queues to users:
";

                            emailBody += "
"
+ ((SourceCode.KO.DestinationRuleContext)exContext).ResolveQueuesToUsers.ToString() + "

";

                            emailBody += "

";

                            emailBody += " " ;

                            emailBody += "
Single instance:
";

                            emailBody += "
"
+ ((SourceCode.KO.DestinationRuleContext)exContext).SingleInstance.ToString() + "

";

                            emailBody += "

";

                            emailBody += " " ;

                            emailBody += "
Number of slots:
";

                            emailBody += "
"
+ ((SourceCode.KO.DestinationRuleContext)exContext).Slots.ToString() + "

";

                            emailBody += "

";

                            break;

                        }

                    case SourceCode.KO.ContextType.EscalationAction:

                        {

                            emailBody += " " ;

                            emailBody += "
Error thrown by:
";

                            emailBody += "
"
+ K2.ContextType.ToString() + "

";

                            emailBody += "

";

                            exContext = K2.ContextObject;

                            emailBody += " " ;

                            emailBody += "
Activity Name:
";

                            emailBody += "
"
+ ((SourceCode.KO.EscalationActionContext)exContext).ActivityInstance.Activity.Name + "

";

                            emailBody += "

";

                            emailBody += " " ;

                            emailBody += "
Redirect:
";

                            emailBody += "
"
+ ((SourceCode.KO.EscalationActionContext)exContext).Redirect.ToString() + "

";

                            emailBody += "

";

                            break;

                        }

                    case SourceCode.KO.ContextType.EscalationRule:

                        {

                            emailBody += " " ;

                            emailBody += "
Error thrown by:
";

                            emailBody += "
"
+ K2.ContextType.ToString() + "

";

                            emailBody += "

";

                            exContext = K2.ContextObject;

                            emailBody += " " ;

                            emailBody += "
Activity Name:
";

                            emailBody += "
"
+ ((SourceCode.KO.EscalationRuleContext)exContext).ActivityInstance.Activity.Name + "

";

                            emailBody += "

";

                            break;

                        }

                    case SourceCode.KO.ContextType.EventEscalationAction:

                        {

                            emailBody += " " ;

                            emailBody += "
Error thrown by:
";

                            emailBody += "
"
+ K2.ContextType.ToString() + "

";

                            emailBody += "

";

                            exContext = K2.ContextObject;

                            emailBody += " " ;

                            emailBody += "
Activity Name:
";

                            emailBody += "
"
+ ((SourceCode.KO.EventEscalationActionContext)exContext).EventInstance.ActivityInstanceDestination.Activity.Name + "

";

                            emailBody += "

";

                            emailBody += " " ;

                            emailBody += "
Event Name:
";

                            emailBody += "
"
+ ((SourceCode.KO.EventEscalationActionContext)exContext).EventInstance.Event.Name + "

";

                            emailBody += "

";

                            break;

                        }

                    case SourceCode.KO.ContextType.EventEscalationRule:

                        {

                            emailBody += " " ;

                            emailBody += "
Error thrown by:
";

                            emailBody += "
"
+ K2.ContextType.ToString() + "

";

                            emailBody += "

";

                            exContext = K2.ContextObject;

                            emailBody += " " ;

                            emailBody += "
Activity Name:
";

                            emailBody += "
"
+ ((SourceCode.KO.EventEscalationRuleContext)exContext).EventInstance.ActivityInstanceDestination.Activity.Name + "

";

                            emailBody += "

";

                            emailBody += " " ;

                            emailBody += "
Event Name:
";

                            emailBody += "
"
+ ((SourceCode.KO.EventEscalationRuleContext)exContext).EventInstance.Event.Name + "

";

                            emailBody += "

";

                            break;

                        }

                    case SourceCode.KO.ContextType.EventSucceedingRule:

                        {

                            emailBody += " " ;

                            emailBody += "
Error thrown by:
";

                            emailBody += "
"
+ K2.ContextType.ToString() + "

";

                            emailBody += "

";

                            exContext = K2.ContextObject;

                            emailBody += " " ;

                            emailBody += "
Activity Name:
";

                            emailBody += "
"
+ ((SourceCode.KO.EventSucceedingRuleContext)exContext).EventInstance.ActivityInstanceDestination.Activity.Name + "

";

                            emailBody += "

";

                            emailBody += " " ;

                            emailBody += "
Event Name:
";

                            emailBody += "
"
+ ((SourceCode.KO.EventSucceedingRuleContext)exContext).EventInstance.Event.Name + "

";

                            emailBody += "

";

                            emailBody += " " ;

                            emailBody += "
Succeeding rule:
";

                            emailBody += "
"
+ ((SourceCode.KO.EventSucceedingRuleContext)exContext).SucceedingRule.ToString() + "

";

                            emailBody += "

";

                            break;

                        }

                    case SourceCode.KO.ContextType.IPCEvent:

                        {

                            emailBody += " " ;

                            emailBody += "
Error thrown by:
";

                            emailBody += "
"
+ K2.ContextType.ToString() + "

";

                            emailBody += "

";

                            exContext = K2.ContextObject;

                            emailBody += " " ;

                            emailBody += "
Activity Name:
";

                            emailBody += "
"
+ ((SourceCode.KO.IPCEventContext)exContext).ActivityInstanceDestination.Activity.Name + "

";

                            emailBody += "

";

                            emailBody += " " ;

                            emailBody += "
Event Name:
";

                            emailBody += "
"
+ ((SourceCode.KO.IPCEventContext)exContext).Event.Name + "

";

                            emailBody += "

";

                            emailBody += " " ;

                            emailBody += "
IPC process:
";

                            emailBody += "
"
+ ((SourceCode.KO.IPCEventContext)exContext).Process + "

";

                            emailBody += "

";

                            emailBody += " " ;

                            emailBody += "
IPC connection string:
";

                            emailBody += "
"
+ ((SourceCode.KO.IPCEventContext)exContext).ConnectionString + "

";

                            emailBody += "

";

                            emailBody += " " ;

                            emailBody += "
Synchronous:
";

                            emailBody += "
"
+ ((SourceCode.KO.IPCEventContext)exContext).Synchronous + "

";

                            emailBody += "

";

                            break;

                        }

                    case SourceCode.KO.ContextType.LineRule:

                        {

                            emailBody += " " ;

                            emailBody += "
Error thrown by:
";

                            emailBody += "
"
+ K2.ContextType.ToString() + "

";

                            emailBody += "

";

                            exContext = K2.ContextObject;

                            emailBody += " " ;

                            emailBody += "
Start activity name:
";

                            emailBody += "
"
+ ((SourceCode.KO.LineRuleContext)exContext).LineInstance.StartActivityInstance.Activity.Name + "

";

                            emailBody += "

";

                            //The folllowing throws error as it does not have finish activity details

                            //_emailBody += " ";

                            //_emailBody += "
Finish activity:
";

                            //_emailBody += "
" + ((SourceCode.KO.LineRuleContext)_exContext).LineInstance.FinishActivityInstance.Activity.Name + "
";

                            //_emailBody += "

";

                            emailBody += " " ;

                            emailBody += "
Line name:
";

                            emailBody += "
"
+ ((SourceCode.KO.LineRuleContext)exContext).LineInstance.Line.Name + "

";

                            emailBody += "

";

                            emailBody += " " ;

                            emailBody += "
Line rule:
";

                            emailBody += "
"
+ ((SourceCode.KO.LineRuleContext)exContext).LineRule.ToString() + "

";

                            emailBody += "

";

                            break;

                        }

                    case SourceCode.KO.ContextType.PrecedingRule:

                        {

                            emailBody += " " ;

                            emailBody += "
Error thrown by:
";

                            emailBody += "
"
+ K2.ContextType.ToString() + "

";

                            emailBody += "

";

                            exContext = K2.ContextObject;

                            emailBody += " " ;

                            emailBody += "
Activity name:
";

                            emailBody += "
"
+ ((SourceCode.KO.PrecedingRuleContext)exContext).ActivityInstance.Activity.Name + "

";

                            emailBody += "

";

                            emailBody += " " ;

                            emailBody += "
Preceeding rule:
";

                            emailBody += "
"
+ ((SourceCode.KO.PrecedingRuleContext)exContext).PrecedingRule.ToString() + "

";

                            emailBody += "

";

                            break;

                        }

                    case SourceCode.KO.ContextType.ProcessEscalationAction:

                    case SourceCode.KO.ContextType.ProcessEscalationRule:

                    case SourceCode.KO.ContextType.ProcessFinishRule:

                        {

                            emailBody += " " ;

                            emailBody += "
Error thrown by:
";

                            emailBody += "
"
+ K2.ContextType.ToString() + "

";

                            emailBody += "

";

                            break;

                        }

                    case SourceCode.KO.ContextType.ProcessStartRule:

                        {

                            emailBody += " " ;

                            emailBody += "
Error thrown by:
";

                            emailBody += "
"
+ K2.ContextType.ToString() + "

";

                            emailBody += "

";

                            exContext = K2.ContextObject;

                            emailBody += " " ;

                            emailBody += "
Message:
";

                            emailBody += "
"
+ ((SourceCode.KO.ProcessStartRuleContext)exContext).Message + "

";

                            emailBody += "

";

                            emailBody += " " ;

                            emailBody += "
Start rule:
";

                            emailBody += "
"
+ ((SourceCode.KO.ProcessStartRuleContext)exContext).Start.ToString() + "

";

                            emailBody += "

";

                            break;

                        }

                    case SourceCode.KO.ContextType.ServerEvent:

                        {

                            emailBody += " " ;

                            emailBody += "
Error thrown by:
";

                            emailBody += "
"
+ K2.ContextType.ToString() + "

";

                            emailBody += "

";

                            exContext = K2.ContextObject;

                            emailBody += " " ;

                            emailBody += "
Activity Name:
";

                            emailBody += "
"
+ ((SourceCode.KO.ServerEventContext)exContext).ActivityInstanceDestination.Activity.Name + "

";

                            emailBody += "

";

                            emailBody += " " ;

                            emailBody += "
Event Name:
";

                            emailBody += "
"
+ ((SourceCode.KO.ServerEventContext)exContext).Event.Name + "

";

                            emailBody += "

";

                            break;

                        }

                    case SourceCode.KO.ContextType.StartRule:

                        {

                            emailBody += " " ;

                            emailBody += "
Error thrown by:
";

                            emailBody += "
"
+ K2.ContextType.ToString() + "

";

                            emailBody += "

";

                            exContext = K2.ContextObject;

                            emailBody += " " ;

                            emailBody += "
Activity Name:
";

                            emailBody += "
"
+ ((SourceCode.KO.StartRuleContext)exContext).ActivityInstance.Activity.Name + "

";

                            emailBody += "

";

                            break;

                        }

                    case SourceCode.KO.ContextType.SucceedingRule:

                        {

                            emailBody += " " ;

                            emailBody += "
Error thrown by:
";

                            emailBody += "
"
+ K2.ContextType.ToString() + "

";

                            emailBody += "

";

                            exContext = K2.ContextObject;

                            emailBody += " " ;

                            emailBody += "
Activity Name:
";

                            emailBody += "
"
+ ((SourceCode.KO.SucceedingRuleContext)exContext).ActivityInstance.Activity.Name + "

";

                            emailBody += "

";

                            emailBody += " " ;

                            emailBody += "
Succeeding rule:
";

                            emailBody += "
"
+ ((SourceCode.KO.SucceedingRuleContext)exContext).SucceedingRule.ToString() + "

";

                            emailBody += "

";

                            break;

                        }

                    default:

                        {

                            emailBody += "
colspan=\"2\">No details available
";

                            break;

                        }

                }

                emailBody += "

";

                emailBody += "

";

                emailBody += "

";

                emailBody += "

";

                #endregion

                #region Exception Details

                emailBody += "
Exception Details
";

                emailBody += " " ;

                emailBody += "
"
;

                emailBody += "" ;

                ex = new Exception("NOTHING");

                ex = (Exception)K2.ExceptionObject;

                bFlag = true;

                while (bFlag == true)

                {

                    if (ex.InnerException != null)

                    {

                        ex = ex.InnerException;

                    }

                    else

                    {

                        emailBody += " " ;

                        emailBody += "
Message:
";

                        emailBody += "
"
+ ex.Message + "

";

                        emailBody += "

";

                        emailBody += " " ;

                        emailBody += "
Stack Trace:
";

                        emailBody += "
"
+ ex.StackTrace + "

";

                        emailBody += "

";

                        bFlag = false;

                    }

                }

               

                emailBody += "

";

                emailBody += "

";

                emailBody += "

";

              

                #endregion

                

                #region View Flow link

                string K2ServerName = string.Empty;

                //Workflow Management Server

                string strWorkflowServer = K2.StringTable["Workflow Server"]; //Integrated=True;IsPrimaryLogin=True;Authenticate=True;EncryptedPassword=False;Host=dlx;Port=5252

                string[] workflowServerDetails = strWorkflowServer.Split(';');

                foreach (string strWorkflowServerDetail in workflowServerDetails)

                {

                    if (strWorkflowServerDetail.Contains("Host"))

                    {

                        K2ServerName = strWorkflowServerDetail.Substring(strWorkflowServerDetail.IndexOf('=') + 1);

                    }

                }

                string strViewFlowURL = @"http://###K2Server###:81/ViewFlow/ViewFlow.aspx?ViewTypeName=ProcessView&K2Server=###K2Server###:5252&HostServerName=###K2Server###&HostServerPort=5555&ProcessID=###ProcinstID###";

                strViewFlowURL = strViewFlowURL.Replace("###K2Server###", K2ServerName);

                strViewFlowURL = strViewFlowURL.Replace("###ProcinstID###", K2.ProcessInstance.ID.ToString());

                string strViewFlowLink = "<" + "a href='" + strViewFlowURL + "' target=_blank>Click Here

";

                emailBody += "

";

                emailBody += "
To open the K2 View Flow, "
+ strViewFlowLink + ".

";

                emailBody += "

";

                #endregion

                emailBody += "
Regards,
";

                emailBody += "
K2 Exception Handler
";

                emailBody += "

";

                emailBody += "

";

                emailBody += "

";

                expMail.Body = emailBody;

                #region Send Email

                string smtpMailServer = K2.StringTable["Mail Server"]; //Get mail server from String table

                using (smtpClient as IDisposable)

                {

                    if (smtpMailServer.IndexOf(":") == -1)

                    {

                        smtpClient.Host = smtpMailServer;

                    }

                    else

                    {

                        string[] connection = smtpMailServer.Split(new Char[] { ':' });

                        Int32 I = 0;

                        if (string.IsNullOrEmpty(connection[0]) || string.IsNullOrEmpty(connection[1]))

                        {

                            throw new Exception("Invalid SMTP Server / Port arguments supplied.");

                        }

                        // PORT 2ND PARM ONLY!

                        if (Int32.TryParse(connection[1], out I))

                        {

                            smtpClient.Host = connection[0];

                            smtpClient.Port = Int32.Parse(connection[1]);

                        }

                        else

                        {

                            throw new Exception("Invalid SMTP Server / Port arguments supplied.");

                        }

                    }

                    using (expMail)

                    {

                        smtpClient.DeliveryMethod = System.Net.Mail.SmtpDeliveryMethod.Network;

                        smtpClient.UseDefaultCredentials = true;

                        smtpClient.Send(expMail);                       

                    }

                }

                #endregion

            }

            catch (Exception expMail)

            {

                //Console.WriteLine("[Process Error Notify] Error sending email: " + exMail.Message); //todo Log error to Sharepoint Logs

            }

            finally

            {

                expMail = null;

                smtpClient = null;

                mailAddressFrom = null;

                throw ((Exception)K2.ExceptionObject);

            }

        }

    }