mrgonegamer

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.IO;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;

mrgonegamer

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;

mrgonegamer

public static void ThreadingExcelFiles(int startingPoint, int endPoint, string[] allfiles, int orgcount, int thread, int division, int threadcount)
        {
            Dictionary<string, List<EquipmentList>> ExcelData = new Dictionary<string, List<EquipmentList>>();
            int file = 0;
            //string[] allfiles;
            string badExcel;
            allfiles = Directory.GetFiles("C:\\test\\", "*.*", SearchOption.AllDirectories);
            badExcel = "C:\\Test\\" + "~$";
            int close = 0;
            int count = 0;

mrgonegamer

 private void populateTreeView()
        {
            cn = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=*Removed Sensititive Information*.mdf;Integrated Security=True");
            cn.Open();
            string SqlString = "SELECT * FROM *Removed Sensititive Information*_TRACKER";

            SqlCommand command = new SqlCommand(SqlString, cn);
            SqlDataReader sReader;
            sReader = command.ExecuteReader();
            int i = 0;

mrgonegamer

        private void LoadDivLEhttp(string version)
        {
            HttpWebRequest request = (HttpWebRequest)WebRequest.Create(baselineurl + "version/contains/" + version);
            request.Accept = "application/json"; ;
            request.Headers.Add("Authorization", "Bearer " + AccessToken);
            //request.Headers.Add(HttpRequestHeader.)
            request.AutomaticDecompression = DecompressionMethods.GZip;
            using (HttpWebResponse response = (HttpWebResponse)request.GetResponse())
            using (Stream stream = response.GetResponseStream())
            using (StreamReader reader = new StreamReader(stream))