Ejemplo n.º 1
0
        private void FillNadalLists()
        {
            JO_ListBox_Nadal1.DataSource = ExcelQueries.GetNadalValues(connection);
            JO_ListBox_Nadal2.DataSource = ExcelQueries.GetNadalValues(connection);

            JO_ListBox_Nadal1.SelectedIndexChanged += JO_ListBox_Nadal1_SelectedIndexChanged;
            JO_ListBox_Nadal2.SelectedIndexChanged += JO_ListBox_Nadal1_SelectedIndexChanged;
        }
Ejemplo n.º 2
0
        private void JO_ToolBtn_ReadHinnakiri_Click(object sender, EventArgs e)
        {
            List <ExcelPage> pages = DbConnection.OpenExcel();

            ExcelQueries.ClearGrupidTable(connection);
            ExcelQueries.ClearTootjadTable(connection);
            ExcelQueries.ClearTootedTable(connection);
            ExcelQueries.ClearNadalTable(connection);


            JO_Progress_Load.Maximum = pages.Count * 3000;
            foreach (var page in pages)
            {
                WriteExcelToDB(page);
            }
            MessageBox.Show("Successfully imported excel to database ");
        }
Ejemplo n.º 3
0
        private void WriteExcelToDB(ExcelPage page)
        {
            Stopwatch watch = new Stopwatch();

            watch.Start();

            xlApp       = page.xlApp;
            xlWorkbook  = page.xlWorkbook;
            xlWorksheet = page.xlWorksheet;

            xlRange = xlWorksheet.Cells[3, 4];
            string nadalString = Convert.ToString(xlRange.Value);
            int    nadal       = Convert.ToInt32(nadalString.Split(' ')[1]);

            watch.Stop();
            int SetupTime = watch.Elapsed.Milliseconds;

            watch.Reset();

            watch.Start();

            int arv = 0;

            for (int rn = 12; rn < 3000; rn++)
            {
                xlRange = xlWorksheet.Cells[rn, 4];
                if (xlRange.Value != null)
                {
                    //xlRange -- Get information about a certain cell
                    Ex_mas[arv, 3] = Convert.ToString(xlRange.Value);
                    xlRange        = xlWorksheet.Cells[rn, 1];
                    Ex_mas[arv, 0] = xlRange.Value;
                    xlRange        = xlWorksheet.Cells[rn, 2];
                    Ex_mas[arv, 1] = xlRange.Value;
                    xlRange        = xlWorksheet.Cells[rn, 3];
                    Ex_mas[arv, 2] = xlRange.Value;
                    if (Ex_mas[arv, 2] != null)
                    {
                        arv++;
                    }
                }
                JO_Progress_Load.Value++;
            }

            watch.Stop();
            int ExcelTime = watch.Elapsed.Milliseconds;

            watch.Reset();
            watch.Start();

            for (int i = 0; i < arv; i++)
            {
                //Add Grupp and get ID of it
                int GruppID = ExcelQueries.GetGruppID(Ex_mas[i, 0], connection);
                if (GruppID == -1)
                {
                    ExcelQueries.InsertGruppToDatbase(Ex_mas[i, 0], connection);
                    GruppID = ExcelQueries.GetGruppID(Ex_mas[i, 0], connection);
                }

                //Add Tootja and get ID of it
                int TootjaID = ExcelQueries.GetTootjaID(Ex_mas[i, 1], connection);
                if (TootjaID == -1)
                {
                    ExcelQueries.InsertTootjaToDatabase(Ex_mas[i, 1], connection);
                    TootjaID = ExcelQueries.GetTootjaID(Ex_mas[i, 1], connection);
                }

                //Send toode to database
                int TooteID = ExcelQueries.GetTooteID(Ex_mas[i, 2], connection);
                if (TooteID == -1)
                {
                    ExcelQueries.InsertToodeToDatabase(Ex_mas[i, 2], GruppID, TootjaID, connection);
                    TooteID = ExcelQueries.GetTooteID(Ex_mas[i, 2], connection);
                }


                ExcelQueries.InsertNadalToDatabase(nadal, TooteID, Ex_mas[i, 3], connection);
            }
            watch.Stop();
            int QueriesTime = watch.Elapsed.Milliseconds;
        }