using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Diagnostics;
//great for using missing.value;
using System.Reflection;
using Microsoft.Office.Core;
using System.Threading;
using System.IO;
 
 
 
namespace DeannaProj2
{
    public partial class Form1 : Form
    { 
 
        //declaring and object Called AppExcel
        private Excel.Application AppExcel = null;
 
 
        ArrayManipulator AM = new ArrayManipulator();
 
        string strSource = null;
        string strRowCount = null;
        public string [,] arrySingle = null;
 
 
 
        public Form1()
        {
            InitializeComponent();
        }
 
 
        //to take care of opening and picking the excel file
        private void btnExcel_Click(object sender, EventArgs e)
        {
 
            exceldata.ShowDialog();
            strSource = exceldata.FileName;
            lblSource.Text = strSource;
 
 
        }
 
        private void btnRow_Click(object sender, EventArgs e)
        {
 
            //to check to see if user has selected an excel file
            if (strSource == "")
            {
                MessageBox.Show("Please Pick An Excel File", "Error");
            }                                                         
 
            strRowCount = txtbxRowCount.Text;
            btnStart.Enabled = true;
            btnLabels.Enabled = true;
 
        }
 
 
        private void btnStart_Click(object sender, EventArgs e)
        {
 
 
            //to check to see if user has selected an excel file
            if ((strSource == "") || (strSource == null))
            {
                MessageBox.Show("Please Pick An Excel File", "Error");
            }
 
            //then creating and starting the application
 
            InitializeComponent();
            AppExcel = new Excel.Application();
 
            if (AppExcel == null)
            {
                MessageBox.Show("Could not start Excel");
                exceldata.ShowDialog();
            }
 
 
           //now declaring to start a new workbook                     readonly
            Excel.Workbook WB1 = AppExcel.Workbooks.Open(strSource, 0, true, 5, "", "", true, Excel.XlPlatform.xlWindows, "\t", false, false,
                0, true, 0, 0);
 
 
 
            //to get the compile a list of worksheets
            Excel.Sheets WBsheets = WB1.Worksheets;
 
            //get the first and only worksheet                    the  1 if for the first sheet in the workbook
            Excel.Worksheet sheet = (Excel.Worksheet)WBsheets.get_Item(1);
 
            //prep the row count by subtracting one cause of 0 based counting
            int intRowCount = System.Convert.ToInt32(strRowCount);
 
            strRowCount = System.Convert.ToString(intRowCount);
 
            //here to prep the rows by adding a Colum 5 ("E")
            strRowCount = "E" + strRowCount;
 
 
            //here you define your range        
            Excel.Range range = sheet.get_Range("A1", strRowCount);
            //here you pull the data out
            System.Array arryReturn = (System.Array)range.Cells.Value2;
 
 
 
 
            //good old cleanup
            arryReturn = null;
            arrySource = null;
 
             //end of dangerous code
             #endregion
 
 
             //to show excel
           // AppExcel.Visible = true;
 
 
          //going to kill excel so it removes the deadlock on the file
            KillExcel();
 
 
        }
 
        private void btnKillExcel_Click(object sender, EventArgs e)
        {
               //will call KillExcel procedure
            KillExcel();
        }
 
        private void btnLabels_Click(object sender, EventArgs e)
        {   //will build the schema for the array
            AM.arryTemp = new string[arrySingle.Length / 5, 5];
            //this will then copy the contents of the array ____MAKE NOTE_____
            Array.Copy(arrySingle, AM.arryTemp, arrySingle.Length);
            //Will start the multiplying process
            AM.Multiplexer();
            //Start the Write To Excel Process
            WriteToExcel();
 
        }
 
        public void WriteToExcel()
        {
            //then creating and starting the application
 
            InitializeComponent();
            AppExcel = new Excel.Application();
 
            if (AppExcel == null)
            {
                MessageBox.Show("Could not start Excel");
                exceldata.ShowDialog();
            }
 
 
            //now declaring to start a new workbook
            Excel.Workbook WB1 = AppExcel.Workbooks.Open(strSource, 0, false, 5, "", "", true, Excel.XlPlatform.xlWindows, "\t", false, false,
                0, true, 0, 0);
 
            //to get the compile a list of worksheets
            Excel.Sheets WBsheets = WB1.Worksheets;
 
            //get the first and only worksheet                    the  2 if for the first sheet in the workbook
            Excel.Worksheet sheet = (Excel.Worksheet)WBsheets.get_Item(2);
 
            //will take the length of arryFinal and divide by five cause multi deimension array
            int intLenght = AM.arryFinal.Length / 5;
 
 
 
 
               //now that the array has then been fed and written to excel, the WorkBook must be saved to the hard drive
            sheet.SaveAs(strSource, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value,
                                    Missing.Value, Missing.Value, Missing.Value, Missing.Value);
            try
            {
 
                //messagebox to show the process is done
                MessageBox.Show("The Multiplexing is complete.", "Completed");
            }
            catch
            {
                MessageBox.Show("Operation Cancled By User (Did Not Save Over)", "Error");
            }
        }
 
        public void KillExcel()
        {
 
            //this will fish out all the process that have excel
            //the secret is "process name w/o .exe"
            Process[] process = Process.GetProcessesByName("Excel");
            for (int i = 0; i < process.GetLength(0); i++)
            {
                //kills excel process
                process[i].Kill();
 
 
            }
        }
 
        private void Form1_Load(object sender, EventArgs e)
        {
 
            #region Licensing
            //pulls the hostname (LBMISTECH1) all caps too
            string strHostName = System.Environment.MachineName;
            // add the "\r\n" so it will match the line we will pull out of the text file
            strHostName = strHostName + "\r\n";
            //will assign where the file needs to go
            string strPath = @"c:\windows\system32\work.mul";
 
            //see if file work.mul exists in sytem32 folder
            if (File.Exists(strPath))
            {
                MessageBox.Show("Welcome To Multiplexer.", " Written By Lee Hicks");
            }
            else
            {
                //this will execute if file is not present
                MessageBox.Show("Please reinstall application", "Missing reference");
                //will close the form
                this.Close();
 
            }
 
            //this will try to open the text file to see if anything exists
            try
            {
                //create a streamreader to read the text file
                StreamReader srWorkMul = File.OpenText(strPath);
                //dumb the contents from file to the string
                string strContents = srWorkMul.ReadToEnd();
                // test to see if contents of text file match the hostname
                if (strContents == strHostName)
                {
                    //do nothing
                }
                else
                {
                    MessageBox.Show("Please reinstall application", "Missing reference");
                   //once again kill sthe app
                    this.Close();
                }
 
            }
            catch 
            {
                MessageBox.Show("Please reinstall application", "Missing reference");
                //if the applications can't find the file to open will close it again
                this.Close();
 
            }
            #endregion
 
 
        }
 
 
 
 
 
 
 
 
 
    }// end class
}// end namespace