/*****************************************************************************/
        public static void Run(Tekla.Technology.Akit.IScript akit)
        {
            Model     model     = new Model();
            ModelInfo modelinfo = model.GetInfo();

            string[] split; split = model.GetCurrentProgramVersion().Split(new char[] { ' ' });
            bool     boolResult; double dblVersion; boolResult = double.TryParse(split[0], out dblVersion);

            dblVersion = dblVersion * 10;
            string strVersion = dblVersion.ToString();

            string modelDir;
            string spreadsheet;

            /** Get model directory **/
            modelDir = new System.IO.DirectoryInfo("./").FullName;
            //test for the file path
            //System.Windows.Forms.MessageBox.Show(modelDir);

            akit.Callback("acmd_display_report_dialog", "", "main_frame");
            akit.ListSelect("xs_report_dialog", "xs_report_list", "ga_register");
            akit.TabChange("xs_report_dialog", "Container_516", "Container_519");
            akit.ValueChange("xs_report_dialog", "display_created_report", "0");
            akit.TabChange("xs_report_dialog", "Container_516", "Container_517");
            akit.ModalDialog(1);
            akit.PushButton("xs_report_selected", "xs_report_dialog");
            akit.ListSelect("xs_report_dialog", "xs_report_list", "rev-iss-dates");
            akit.ModalDialog(1);
            akit.PushButton("xs_report_selected", "xs_report_dialog");

            akit.PushButton("xs_report_cancel", "xs_report_dialog");

            /** Check for existence of a file -  **/
            if (System.IO.File.Exists(@modelDir + "Reports/" + file))
            {
                System.Windows.Forms.MessageBox.Show("file exists, opening the one in the model folder", "Kennedy Watts");
            }

            else
            {
                /** Copy a file to the model folder **/
                new System.IO.FileInfo("X:/data2/TeklaStructures/KWP-settings" + strVersion + "/Spreadsheets/GA-Drawing-Register.xls").CopyTo(@modelDir + @"Reports\" + file, true);
            }

            spreadsheet = @modelDir + @"Reports\" + file;

            System.Diagnostics.Process Process2 = new System.Diagnostics.Process();
            Process2.EnableRaisingEvents = false;
            Process2.StartInfo.FileName  = "EXCEL";
            Process2.StartInfo.Arguments = "\"" + @spreadsheet + "\"";
            Process2.Start();
        }
        public static void Run(Tekla.Technology.Akit.IScript akit)
        {
            Model     model     = new Model();
            ModelInfo modelinfo = model.GetInfo();

            string[] split; split = model.GetCurrentProgramVersion().Split(new char[] { ' ' });
            bool     boolResult; double dblVersion; boolResult = double.TryParse(split[0], out dblVersion);

            dblVersion = dblVersion * 10;
            string strVersion  = dblVersion.ToString();
            string uelFilePath = @"X:\data2\TeklaStructures\KWP-settings" + strVersion + @"\CustomComponents\" + strVersion + @"-CC-Package.uel";

            akit.FileSelection(uelFilePath);
            akit.ModalDialog(1);
            akit.Callback("acmdDisplayImportCustomComponentDialog", "", "main_frame");
        }
        public static void Run(Tekla.Technology.Akit.IScript akit)
        {
            Model     model        = new Model();
            ModelInfo modelinfo    = model.GetInfo();
            string    modelPath    = model.GetInfo().ModelPath;
            string    modelxlsFile = modelPath + @"\PLATE_GIRDER_CREATION.xls";

            string[] split; split = model.GetCurrentProgramVersion().Split(new char[] { ' ' });
            bool     boolResult; double dblVersion; boolResult = double.TryParse(split[0], out dblVersion);

            dblVersion = dblVersion * 10;
            string strVersion = dblVersion.ToString();
            string xlsFile    = @"X:\data2\TeklaStructures\KWP-settings" + strVersion + @"\Spreadsheets\PLATE_GIRDER_CREATION.xls";

            if (!File.Exists(@modelxlsFile))
            {
                new FileInfo(@xlsFile).CopyTo(@modelxlsFile, true);
            }

            string uelFilePath = @"X:\data2\TeklaStructures\KWP-settings" + strVersion + @"\CustomComponents\BOXPG.uel";

            akit.FileSelection(uelFilePath);
            akit.ModalDialog(1);
            akit.Callback("acmdDisplayImportCustomComponentDialog", "", "main_frame");

            OpenFileDialog OpenFileDialog = new OpenFileDialog();

            OpenFileDialog.Filter           = "Excel Files|*.xls";
            OpenFileDialog.InitialDirectory = modelPath;
            if (OpenFileDialog.ShowDialog() == DialogResult.OK)
            {
                string XLSfileName = @"""" + OpenFileDialog.FileName + @""""; // format required to open .xls file
                int    LenFileName = OpenFileDialog.FileName.Length;
                string LISfileName = OpenFileDialog.FileName.Remove(LenFileName - 4) + ".lis";

                FileInfo FileInfo = new FileInfo(LISfileName);
                if (FileInfo.Exists)
                {
                    File.Delete(LISfileName); // deletes existing .lis file if it exists
                }
                Process OpenSpreadsheetProcess = new Process();
                OpenSpreadsheetProcess.EnableRaisingEvents = false;
                OpenSpreadsheetProcess.StartInfo.FileName  = "EXCEL";
                OpenSpreadsheetProcess.StartInfo.Arguments = XLSfileName;
                OpenSpreadsheetProcess.Start();
            }
        }