HYTOS

<?xml version="1.0" encoding="utf-8"?>

<Project ToolsVersion="12.0" DefaultTargets="Build" xmlns="http://schemas.microsoft.com/developer/msbuild/2003">

  <PropertyGroup>

    <Configuration Condition=" '$(Configuration)' == '' ">Debug</Configuration>

    <Platform Condition=" '$(Platform)' == '' ">AnyCPU</Platform>

    <ProductVersion>8.0.30703</ProductVersion>

    <SchemaVersion>2.0</SchemaVersion>

    <ProjectGuid>{3D03D577-7689-46ED-829D-1152B1180706}</ProjectGuid>

    <OutputType>Library</OutputType>

    <AppDesignerFolder>Properties</AppDesignerFolder>

    <RootNamespace>AVEVA.PID.CustomizationUtility</RootNamespace>

    <AssemblyName>AVEVA.PID.CustomizationUtility</AssemblyName>

    <TargetFrameworkVersion>v4.7.2</TargetFrameworkVersion>

    <FileAlignment>512</FileAlignment>

    <SccProjectName>SAK</SccProjectName>

    <SccLocalPath>SAK</SccLocalPath>

    <SccAuxPath>SAK</SccAuxPath>

    <SccProvider>SAK</SccProvider>

    <TargetFrameworkProfile />

  </PropertyGroup>

  <PropertyGroup Condition="'$(Configuration)|$(Platform)' == 'Debug|x64'">

    <DebugSymbols>true</DebugSymbols>

    <OutputPath>C:\Program Files\AVEVA\P&amp;ID 12.2.SP1\Install\Exe\</OutputPath>

    <DefineConstants>DEBUG;TRACE</DefineConstants>

    <DebugType>full</DebugType>

    <PlatformTarget>x64</PlatformTarget>

    <ErrorReport>prompt</ErrorReport>

    <CodeAnalysisRuleSet>MinimumRecommendedRules.ruleset</CodeAnalysisRuleSet>

  </PropertyGroup>

  <PropertyGroup Condition="'$(Configuration)|$(Platform)' == 'Release|x64'">

    <OutputPath>bin\Release\</OutputPath>

    <DefineConstants>TRACE</DefineConstants>

    <Optimize>true</Optimize>

    <DebugType>pdbonly</DebugType>

    <PlatformTarget>x64</PlatformTarget>

    <ErrorReport>prompt</ErrorReport>

    <CodeAnalysisRuleSet>MinimumRecommendedRules.ruleset</CodeAnalysisRuleSet>

  </PropertyGroup>

  <ItemGroup>

    <Reference Include="accoremgd">

      <HintPath>C:\Program Files\Autodesk\AutoCAD 2018\accoremgd.dll</HintPath>

    </Reference>

    <Reference Include="acdbmgd">

      <HintPath>C:\Program Files\Autodesk\AutoCAD 2018\acdbmgd.dll</HintPath>

    </Reference>

    <Reference Include="acmgd">

      <HintPath>C:\Program Files\Autodesk\AutoCAD 2018\acmgd.dll</HintPath>

    </Reference>

    <Reference Include="Autodesk.AutoCAD.Interop">

      <HintPath>C:\Program Files\Autodesk\AutoCAD 2018\Autodesk.AutoCAD.Interop.dll</HintPath>

      <EmbedInteropTypes>True</EmbedInteropTypes>

    </Reference>

    <Reference Include="Autodesk.AutoCAD.Interop.Common">

      <HintPath>C:\Program Files\Autodesk\AutoCAD 2018\Autodesk.AutoCAD.Interop.Common.dll</HintPath>

      <EmbedInteropTypes>True</EmbedInteropTypes>

    </Reference>

    <Reference Include="Microsoft.VisualBasic" />

    <Reference Include="System" />

    <Reference Include="System.Core" />

    <Reference Include="System.Windows.Forms" />

    <Reference Include="System.Xml.Linq" />

    <Reference Include="System.Data.DataSetExtensions" />

    <Reference Include="System.Data" />

    <Reference Include="System.Xml" />

  </ItemGroup>

  <ItemGroup>

    <Compile Include="Aveva.PID.AssemblyInfo.cs" />

    <Compile Include="PIDCustomization.cs" />

    <Compile Include="Properties\AssemblyInfo.cs" />

    <Compile Include="Utilities.cs" />

  </ItemGroup>

  <Import Project="$(MSBuildToolsPath)\Microsoft.CSharp.targets" />

  <!-- To modify your build process, add your task inside one of the targets below and uncomment it. 

       Other similar extension points exist, see Microsoft.Common.targets.

  <Target Name="BeforeBuild">

  </Target>

  <Target Name="AfterBuild">

  </Target>

  -->

</Project>

using System.Reflection;

using System.Runtime.CompilerServices;

using System.Runtime.InteropServices;

[assembly: AssemblyCompany("AVEVA Solutions Limited")]

[assembly: AssemblyProduct("AVEVA P&ID")]

[assembly: AssemblyCopyright("Copyright 2015 to current year. AVEVA Solutions Limited and its subsidiaries. All rights reserved.")]

[assembly: AssemblyTrademark("")]

[assembly: AssemblyCulture("")]

[assembly: AssemblyVersion("12.1.3.4")]

[assembly: AssemblyFileVersion("12.1.3.4")]

#region namespaces

using System;

using System.Collections.Generic;

using System.Configuration;

using System.Data;

using System.Data.Common;

using System.Data.SqlClient;

using System.IO;

using System.Linq;

using System.Runtime.InteropServices;

using System.Text;

using System.Threading;

using System.Windows.Forms;

using Autodesk.AutoCAD.ApplicationServices;

using Autodesk.AutoCAD.DatabaseServices;

using Autodesk.AutoCAD.EditorInput;

using Autodesk.AutoCAD.Geometry;

using Autodesk.AutoCAD.Interop;

using Autodesk.AutoCAD.Interop.Common;

using Autodesk.AutoCAD.Runtime;

using Autodesk.AutoCAD.Windows;

using AcadApp = Autodesk.AutoCAD.ApplicationServices.Application;

#endregion using namespaces

namespace AVEVA.PID.CustomizationUtility

{

    /// <summary>

    /// Singleton class used for customization of P&ID application

    /// </summary>

    public class PIDCustomization

    {

        public string ProjectName   { get; set; }

        public string DrawingID     { get; set; }

        public string DrawingName   { get; set; }

        public string MajorRevision { get; set; }

        public string MinorRevision { get; set; }

        public string Description   { get; set; }

        public string NameOfUser    { get; set; }

        public string ClientDwgNo   { get; set; }

        public string RevisedBy     { get; set; }

        public string CheckedBy     { get; set; }

        public string ApprovedBy    { get; set; }

        public string ApprovedBy2   { get; set; }

        public string ApprovedBy3   { get; set; }

        public string ClientApprovedBy { get; set; }

        public byte[] DrawingData   { get; set; }

        private static PIDCustomization _instance;

        /// <summary>

        /// private Constructor make it singleton

        /// </summary>

        private PIDCustomization()

        {

            DrawingData = null;

        }

        public static PIDCustomization GetInstance()

        {

            if (_instance == null)

            {

                _instance = new PIDCustomization();

            }

            return _instance;           

        }

        /// <summary>

        /// Public method called on issue drawing in P&ID

        /// </summary>

        /// <param name="strRecordId">unique database table id for revision</param>

        public void ProcessIssueDrawing(string strRecordId)

        {            

            if (!string.IsNullOrEmpty(strRecordId))

            {

                ReadDrawingDetails(strRecordId);

                SaveBinaryDrawing();

            }

        }

        /// <summary>

        /// public method used for processing block

        /// </summary>

        /// <param name="BlockId"></param>

        public void ProcessBlock(ObjectId BlockId)

        {

            SetColorForEntity(BlockId,0);// white color

        }

        /// <summary>

        /// This is test command which gives the idea regarding selection of an entity and assigning different color to it

        /// </summary>

        [CommandMethod("TestS", Autodesk.AutoCAD.Runtime.CommandFlags.UsePickSet)]

        public static void TestSelection()

        {

            // Get the current document and database, and start a transaction

            Document acDoc = Autodesk.AutoCAD.ApplicationServices.Application.DocumentManager.MdiActiveDocument;

            Database acCurDb = acDoc.Database;

            Editor acDocEd = acDoc.Editor;

            // Request for objects to be selected in the drawing area

            PromptSelectionResult acSSPrompt = acDocEd.GetSelection();

            // If the prompt status is OK, objects were selected

            if (acSSPrompt.Status == PromptStatus.OK)

            {

                ObjectId[] selectedObjectIds = acSSPrompt.Value.GetObjectIds();

                // Get the last selected entity

                if (selectedObjectIds.Length > 0)

                {

                    ObjectId objIdBlock = selectedObjectIds[0];

                    using (Transaction acTrans = acCurDb.TransactionManager.StartTransaction())

                    {

                        DBObject objDB = acTrans.GetObject(objIdBlock, OpenMode.ForRead, true);

                        if (objDB != null)

                        {

                            // check if the selected entity is of Type BlockReference

                            if (objDB.GetType() == typeof(BlockReference))

                            {

                                // open an entity in write mode so that we can modify its color

                                Entity objDb = (Entity)acTrans.GetObject(objIdBlock, OpenMode.ForWrite);

                                if (objDb != null)

                                {

                                    objDb.ColorIndex = 0;// white color

                                }

                            }

                        }

                        acTrans.Commit();

                    }

                }

            }

        }

        #region private methods

        private string SaveBinaryDrawing()

        {

            FileStream fs = null;

            string strDrawing = string.Empty;

            try

            {

                if (!string.IsNullOrEmpty(this.DrawingName))

                {

                    string strDrawingname = this.DrawingName;

                    //if(!string.IsNullOrEmpty(this.MajorRevision))

                    //{

                    //    strDrawingname = strDrawingname + "_" + this.MajorRevision;

                    //}

                    byte[] drawingData = this.DrawingData;

                    if (null != drawingData)

                    {

                        try

                        {                            

                            if (File.Exists(strDrawingname) == true)

                            {

                                Microsoft.VisualBasic.FileSystem.Kill(strDrawingname);

                            }

                        }

                        catch (System.Exception )

                        {

                        }

                        strDrawing = strDrawingname;

                        string path = GetDrawingSavePath();                        

                        if (!string.IsNullOrEmpty(path))

                        {

                            strDrawing = path + "\\" + strDrawingname;

                        }

                        strDrawing += ".dwg";

                        fs = new FileStream(strDrawing, FileMode.Create, FileAccess.Write);

                        int ArraySize = new int();

                        ArraySize = drawingData.GetUpperBound(0);

                        fs.Write(drawingData, 0, ArraySize);

                    }

                }

            }

            catch (System.Exception )

            { }

            finally

            {

                if (fs != null)

                    fs.Close();

            }

            return strDrawing;

        }

        private void ReadDrawingDetails(string strRecordId)

        {

            SqlConnection connection = null;

            try

            {

                int ID = 0;

                int.TryParse(strRecordId, out ID);

                if (ID > 0)

                {

                    connection = new SqlConnection();

                    connection.ConnectionString = GetConnectionString_Reports(); // GetConnectionString();

                    connection.Open();

                    string strQry = "Select * from SynchroniseDetails where ID = " + ID;

                    SqlCommand cmd = new SqlCommand();

                    cmd.Connection = connection;

                    cmd.CommandText = strQry;

                    cmd.CommandType = CommandType.Text;

                    SqlDataReader reader = cmd.ExecuteReader();

                    if (null != reader && reader.HasRows)

                    {

                        while (reader.Read())

                        {

                            ProjectName     = reader["ProjectName"].ToString();

                            DrawingID       = reader["DrawingId"].ToString();

                            DrawingName     = reader["DrawingName"].ToString();

                            MajorRevision   = reader["Revision"].ToString();

                            MinorRevision   = reader["MinorRevision"].ToString();

                            Description     = reader["Description"].ToString();

                            NameOfUser      = reader["NameOfUser"].ToString();

                            ClientDwgNo     = reader["ClientDwgNo"].ToString();

                            RevisedBy       = reader["RevisedBy"].ToString();

                            CheckedBy       = reader["CheckedBy"].ToString();

                            ApprovedBy      = reader["ApprovedBy"].ToString();

                            ApprovedBy2     = reader["ApprovedBy2"].ToString();

                            ApprovedBy3     = reader["ApprovedBy3"].ToString();

                            ClientApprovedBy= reader["ClientApprovedBy"].ToString();

                            DrawingData     = reader["DrawingData"] != null ? (byte[])reader["DrawingData"] : null;

                        }

                    }

                }

            }

            catch (System.Exception )

            { }

            finally

            {

                if (connection != null)

                    connection.Close();

            }

        }

        private string GetRecordId()

        {

            string strRecordId = string.Empty;

            SqlConnection connection = null;

            try

            {

                connection = new SqlConnection();

                connection.ConnectionString = GetConnectionString_Reports(); // GetConnectionString();

                connection.Open();

                string strQry = "Select Max(ID) from SynchroniseDetails";

                SqlCommand cmd = new SqlCommand();

                cmd.Connection = connection;

                cmd.CommandText = strQry;

                cmd.CommandType = CommandType.Text;

                SqlDataReader reader = cmd.ExecuteReader();

                if (null != reader && reader.HasRows)

                {

                    strRecordId = reader.GetString(0).ToString();

                }

            }

            catch (System.Exception )

            { }

            finally

            {

                if (connection != null)

                    connection.Close();

            }

            return strRecordId;

        }

        private string GetConnectionString()

        {

            string strConn = string.Empty;            

            if (Utilities.strSQLWinAuthentication.ToUpper() == "YES")

            {

                strConn = String.Format("Data Source=" + Utilities.strSQLServerName + ";Integrated Security=SSPI;Initial Catalog={0};", Utilities.strSQLDatabaseName);               

            }

            else if (Utilities.strSQLWinAuthentication.ToUpper() == "NO")

            {

                string strAccessString = "User ID=" + Utilities.strSQLUserName + ";Password=" + Utilities.strSQLPassword;

                strConn = String.Format("Data Source=" + Utilities.strSQLServerName + ";Initial Catalog=" + Utilities.strSQLDatabaseName + ";" + strAccessString);

            }           

            return strConn;            

        }

        private string GetConnectionString_Reports()

        {

            string strConn = string.Empty;

            if (Utilities.strSQLWinAuthentication.ToUpper() == "YES")

            {

                strConn = String.Format("Data Source=" + Utilities.strSQLServerName + ";Integrated Security=SSPI;Initial Catalog={0};", Utilities.strSQLReportsDatabaseName);

            }

            else if (Utilities.strSQLWinAuthentication.ToUpper() == "NO")

            {

                string strAccessString = "User ID=" + Utilities.strSQLUserName + ";Password=" + Utilities.strSQLPassword;

                strConn = String.Format("Data Source=" + Utilities.strSQLServerName + ";Initial Catalog=" + Utilities.strSQLReportsDatabaseName + ";" + strAccessString);

            }

            return strConn;

        }

        private string GetDrawingSavePath()

        {

            return System.Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments);

        }

        /// <summary>

        /// Sets the color of the entity

        /// </summary>

        /// <param name="objIdBlockId">block id</param>

        /// <param name="iColor">color to be assigned</param>

        private void SetColorForEntity(ObjectId objIdBlockId, short iColor)

        {

            Transaction trans = null;

            try

            {

                if (objIdBlockId != ObjectId.Null)

                {

                    Document doc = AcadApp.DocumentManager.MdiActiveDocument;

                    Database db = HostApplicationServices.WorkingDatabase;

                    trans = doc.TransactionManager.StartTransaction();

                    using (doc.LockDocument())

                    {

                        using (trans)

                        {

                            if (objIdBlockId.IsErased == false)

                            {

                                Entity objDb = (Entity)trans.GetObject(objIdBlockId, OpenMode.ForWrite);

                                if (objDb != null)

                                {

                                    objDb.ColorIndex = iColor;                                    

                                }

                            }

                            trans.Commit();

                        }

                    }

                }

            }

            catch (System.Exception )

            {       

            }

            finally

            {

                if (trans != null)

                {

                    trans.Dispose();

                }

            }

        }

        #endregion

    }

}

using System.Reflection;

using System.Runtime.CompilerServices;

using System.Runtime.InteropServices;

// General Information about an assembly is controlled through the following 

// set of attributes. Change these attribute values to modify the information

// associated with an assembly.

[assembly: AssemblyTitle("AVEVA.PID.CustomizationUtility")]

[assembly: AssemblyDescription("")]

[assembly: AssemblyConfiguration("")]

// Setting ComVisible to false makes the types in this assembly not visible 

// to COM components.  If you need to access a type in this assembly from 

// COM, set the ComVisible attribute to true on that type.

[assembly: ComVisible(false)]

// The following GUID is for the ID of the typelib if this project is exposed to COM

[assembly: Guid("096dda9e-fdd0-44b8-9908-9e07688212da")]

// Version information for an assembly consists of the following four values:

//

//      Major Version

//      Minor Version 

//      Build Number

//      Revision

//

// You can specify all the values or you can default the Build and Revision Numbers 

// by using the '*' as shown below:

// [assembly: AssemblyVersion("1.0.*")]

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

namespace AVEVA.PID.CustomizationUtility

{

    public static class Utilities

    {

        public static string strSQLServerName = string.Empty;        

        public static string strSQLWinAuthentication = string.Empty;

        public static string strSQLUserName = string.Empty;

        public static string strSQLPassword = string.Empty;

        public static string strSQLDatabaseName = string.Empty;

        public static string strSQLAdminDatabaseName = string.Empty;

        public static string strSQLReportsDatabaseName = string.Empty;

    }

}

Project("{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}") = "SPPIDConverter", "SPPIDConverter\SPPIDConverter.csproj", "{81BFB56B-05FE-4674-93C5-DDB2D3437F77}"

EndProject

Project("{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}") = "AVEVA.PID.CustomizationUtility_ACAD2018_x64", "APIDConverter\AVEVA.PID.CustomizationUtility_ACAD2018_x64.csproj", "{3D03D577-7689-46ED-829D-1152B1180706}"

		Debug|x64 = Debug|x64

		Release|x64 = Release|x64

		{7C2E55A3-2B16-4B4F-867F-F16E2EF6F2F0}.Debug|x64.ActiveCfg = Debug|Any CPU

		{7C2E55A3-2B16-4B4F-867F-F16E2EF6F2F0}.Release|x64.ActiveCfg = Release|Any CPU

		{B7B8B0AE-9F03-4543-BC05-813A25E9D584}.Debug|x64.ActiveCfg = Debug|Any CPU

		{B7B8B0AE-9F03-4543-BC05-813A25E9D584}.Debug|x64.Build.0 = Debug|Any CPU

		{B7B8B0AE-9F03-4543-BC05-813A25E9D584}.Release|x64.ActiveCfg = Release|Any CPU

		{B7B8B0AE-9F03-4543-BC05-813A25E9D584}.Release|x64.Build.0 = Release|Any CPU

		{81BFB56B-05FE-4674-93C5-DDB2D3437F77}.Debug|Any CPU.ActiveCfg = Debug|Any CPU

		{81BFB56B-05FE-4674-93C5-DDB2D3437F77}.Debug|Any CPU.Build.0 = Debug|Any CPU

		{81BFB56B-05FE-4674-93C5-DDB2D3437F77}.Debug|x64.ActiveCfg = Debug|Any CPU

		{81BFB56B-05FE-4674-93C5-DDB2D3437F77}.Debug|x64.Build.0 = Debug|Any CPU

		{81BFB56B-05FE-4674-93C5-DDB2D3437F77}.Debug|x86.ActiveCfg = Debug|x86

		{81BFB56B-05FE-4674-93C5-DDB2D3437F77}.Debug|x86.Build.0 = Debug|x86

		{81BFB56B-05FE-4674-93C5-DDB2D3437F77}.Release|Any CPU.ActiveCfg = Release|Any CPU

		{81BFB56B-05FE-4674-93C5-DDB2D3437F77}.Release|Any CPU.Build.0 = Release|Any CPU

		{81BFB56B-05FE-4674-93C5-DDB2D3437F77}.Release|x64.ActiveCfg = Release|Any CPU

		{81BFB56B-05FE-4674-93C5-DDB2D3437F77}.Release|x64.Build.0 = Release|Any CPU

		{81BFB56B-05FE-4674-93C5-DDB2D3437F77}.Release|x86.ActiveCfg = Release|x86

		{81BFB56B-05FE-4674-93C5-DDB2D3437F77}.Release|x86.Build.0 = Release|x86

		{3D03D577-7689-46ED-829D-1152B1180706}.Debug|Any CPU.ActiveCfg = Debug|x64

		{3D03D577-7689-46ED-829D-1152B1180706}.Debug|x64.ActiveCfg = Debug|x64

		{3D03D577-7689-46ED-829D-1152B1180706}.Debug|x64.Build.0 = Debug|x64

		{3D03D577-7689-46ED-829D-1152B1180706}.Debug|x86.ActiveCfg = Debug|x64

		{3D03D577-7689-46ED-829D-1152B1180706}.Release|Any CPU.ActiveCfg = Release|x64

		{3D03D577-7689-46ED-829D-1152B1180706}.Release|x64.ActiveCfg = Release|x64

		{3D03D577-7689-46ED-829D-1152B1180706}.Release|x64.Build.0 = Release|x64

		{3D03D577-7689-46ED-829D-1152B1180706}.Release|x86.ActiveCfg = Release|x64