HYTOS

#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;

using AVEVA.PID.CustomizationUtility.DB;

using AVEVA.PID.CustomizationUtility.Model;

using AVEVA.PID.CustomizationUtility.Properties;

#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

        }

        public static void GetProjectInfo()

        {

            Project_Info _ProjectInfo = Project_Info.GetInstance();

            _ProjectInfo.DefaultPath = Settings.Default.ProjectPath;

            _ProjectInfo.DBType = (ID2DB_Type)Settings.Default.ProjectDBType;

            _ProjectInfo.ServerIP = Settings.Default.ProjectServerIP;

            _ProjectInfo.Port = Settings.Default.ProjectPort;

            _ProjectInfo.DBUser = Settings.Default.ProjectDBUser;

            _ProjectInfo.DBPassword = Settings.Default.ProjectDBPassword;

            if (Project_DB.ConnTestAndCreateTable())

            {

                _ProjectInfo.Enable = true;

            }

            else

            {

                _ProjectInfo.Enable = false;

                MessageBox.Show("Fail project setting", "APID Converter", MessageBoxButtons.OK, MessageBoxIcon.Error);

            }

        }

        #region Command

        /// <summary>

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

        /// </summary>

        [CommandMethod("APIDConverter")]

        public static void APIDConverter()

        {

            GetInstance();

            GetProjectInfo();

            APIDUtils.SetAvevaExplorer();

        }

        [CommandMethod("AC")]

        public static void AC()

        {

            GetInstance();

            GetProjectInfo();

            APIDUtils.SetAvevaExplorer();

        }

        [CommandMethod("ConverterForm")]

        public static void ConverterForm()

        {

            APIDConverter form = new APIDConverter();

            if (AcadApp.ShowModalDialog(form) == DialogResult.OK)

            {

            }

        }

        [CommandMethod("ProjectForm")]

        public static void ProjectForm()

        {

            ProjectForm form = new ProjectForm();

            if (AcadApp.ShowModalDialog(form) == DialogResult.OK)

            {

                Project_Info _ProjectInfo = Project_Info.GetInstance();

                _ProjectInfo.DefaultPath = Settings.Default.ProjectPath;

                _ProjectInfo.DBType = (ID2DB_Type)Settings.Default.ProjectDBType;

                _ProjectInfo.ServerIP = Settings.Default.ProjectServerIP;

                _ProjectInfo.Port = Settings.Default.ProjectPort;

                _ProjectInfo.DBUser = Settings.Default.ProjectDBUser;

                _ProjectInfo.DBPassword = Settings.Default.ProjectDBPassword;

                if (Project_DB.ConnTestAndCreateTable())

                {

                    _ProjectInfo.Enable = true;

                    MessageBox.Show("Success project setting", "APID Converter", MessageBoxButtons.OK, MessageBoxIcon.Information);

                }

                else

                {

                    _ProjectInfo.Enable = false;

                    MessageBox.Show("Fail project setting", "APID Converter", MessageBoxButtons.OK, MessageBoxIcon.Error);

                }

            }

        }

        [CommandMethod("MappingForm")]

        public static void MappingForm()

        {

            MappingForm form = new MappingForm();

            if (AcadApp.ShowModalDialog(form) == DialogResult.OK)

            {

            }

        }

        #endregion

        #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 GetConnectionString_Admin()

        {

            string strConn = string.Empty;

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

            {

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

            }

            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.strSQLAdminDatabaseName + ";" + 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)

                {

                    Autodesk.AutoCAD.ApplicationServices.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

        #region TEST

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

        public static void TestSelection()

        {

            APIDUtils.CreateDrawingAndOpen("testA1", "1", "Aveva-Metric", "1");

        }

        #endregion

    }

}