Ejemplo n.º 1
0
        //method reading .CSV source using OleDB (NOT IN USE!)
        private void prepareDefaultDataOleDB()
        {
            if (!stoper)
            {
                try
                {Response.Write(@"<script>alert('1 Please, contact administrator (mailto: [email protected]), providing following information: \n');</script>");
                    string name = "";
                    double pdi = 0,
                            idv = 0,
                            mas = 0,
                            uai = 0,
                            lto = 0,
                            ivr = 0;

                    string path = HttpContext.Current.Server.MapPath(@"~/docs/Aldunin_dimensions_clasters.xls");
                    string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + path + ";" + "Extended Properties=Excel 8.0;";
                    OleDbConnection conn = new OleDbConnection(strConn);
                    conn.Open();
                    Response.Write(@"<script>alert('2 Please, contact administrator (mailto: [email protected]), providing following information: \n');</script>");

                    Response.Write(@"<script>alert('2 " + path + " Please, contact administrator (mailto: [email protected]), providing following information: \n');</script>");
                    Response.Write(@"<script>alert('3 Please, contact administrator (mailto: [email protected]), providing following information: \n');</script>");

                    string strExcel = "";
                    OleDbDataAdapter myCommand = null;
                    strExcel = "select * from [6 dimensions$]";
                    myCommand = new OleDbDataAdapter(strExcel, strConn);
                    ds = new DataSet();

                    Response.Write(@"<script>alert('2 " + path + " Please, contact administrator (mailto: [email protected]), providing following information: \n');</script>");
                    try
                    {
                        myCommand.Fill(ds, "table");
                    }
                    catch (Exception ex)
                    {
                        Response.Write(@"<script>alert('TEST! Failed to get data about counties from Excel. Please, contact administrator (mailto: [email protected]), providing following information: \n');</script>");
                    }

                    Response.Write(@"<script>alert('TEST1 " + ds.Tables["table"].Rows.Count + " " + ds.Tables["table"].Columns.Count + " (mailto: [email protected]), providing following information: \n');</script>");

                    for (int rCnt = 0; rCnt < ds.Tables["table"].Rows.Count; rCnt++)
                    {
                        Response.Write(@"<script>alert('TEST ROW Failed to get data about counties from Excel. Please, contact administrator (mailto: [email protected]), providing following information: \n');</script>");

                        for (int cCnt = 1; cCnt < ds.Tables["table"].Columns.Count; cCnt++)
                        {
                            Response.Write(@"<script>alert('TEST COLUMN Failed to get data about counties from Excel. Please, contact administrator (mailto: [email protected]), providing following information: \n');</script>");

                            switch (cCnt)
                            {
                                case 1:
                                    name = ds.Tables["table"].Rows[rCnt][cCnt].ToString();
                                    //name = Convert.ToString((range.Cells[rCnt, cCnt] as Excel.Range).Value2);
                                    Response.Write(@"<script>alert('TEST2 Please, contact administrator (mailto: [email protected]), providing following information: \n');</script>");

                                    break;
                                case 2:
                                    try
                                    {
                                        pdi = double.Parse(ds.Tables["table"].Rows[rCnt][cCnt].ToString());
                                    }
                                    catch
                                    {
                                        Response.Write(@"<script>alert('TEST3Please, contact administrator (mailto: [email protected]), providing following information: \n');</script>");

                                        pdi = -1;
                                    }
                                    break;
                                case 3:
                                    try
                                    {
                                        idv = double.Parse(ds.Tables["table"].Rows[rCnt][cCnt].ToString());
                                    }
                                    catch
                                    {
                                        idv = -1;
                                    }
                                    break;
                                case 4:
                                    try
                                    {
                                        mas = double.Parse(ds.Tables["table"].Rows[rCnt][cCnt].ToString());
                                    }
                                    catch
                                    {
                                        mas = -1;
                                    }
                                    break;
                                case 5:
                                    try
                                    {
                                        uai = double.Parse(ds.Tables["table"].Rows[rCnt][cCnt].ToString());
                                    }
                                    catch
                                    {
                                        uai = -1;
                                    }
                                    break;
                                case 6:
                                    try
                                    {
                                        lto = double.Parse(ds.Tables["table"].Rows[rCnt][cCnt].ToString());
                                    }
                                    catch
                                    {
                                        Response.Write(@"<script>alert('Test4 Please, contact administrator (mailto: [email protected]), providing following information: \n');</script>");

                                        lto = -1;
                                    }
                                    break;
                                case 7:
                                    try
                                    {
                                        ivr = double.Parse(ds.Tables["table"].Rows[rCnt][cCnt].ToString());
                                    }
                                    catch
                                    {
                                        ivr = -1;
                                    }
                                    break;
                            }
                        }
                        Country c = new Country(name, pdi, idv, mas, uai, lto, ivr);
                        countries.Add(c);
                    }

                    Label1.Text = "Data delivered!";
                    this.Session["arrow1state"] = false;
                    this.Session["arrow2state"] = true;
                    this.Session["arrow3state"] = false;
                    arrowsCheck((bool)this.Session["arrow1state"], (bool)this.Session["arrow2state"], (bool)this.Session["arrow2state"]);
                }
                catch (Exception ex)
                {
                    Response.Write(@"<script>alert('Failed to get data about counties from Excel. Please, contact administrator (mailto: [email protected]), providing following information: \n" + ex.Message.ToString().Substring(0, ex.Message.Length - 3) + "');</script>");
                    Label1.Text = "Data delivery failed!";
                    //Response.Write("<script>alert('Failed to get data about counties from Excel. Please, contact administrator (mailto: [email protected]), providing following information: \\n" + ex.Message + "');</script>");
                    //Response.Write("<script>function window.onload() {  alert( 'Hi!');}</script>");
                    //Response.Write("<script>function window.onload() {  alert( 'Failed to get data about counties from Excel. Please, contact administrator (mailto: [email protected]), providing following information: \n');}</script>");
                    //MessageBox.Show("Failed to get data about counties from Excel. Please, contact administrator (mailto: [email protected]), providing following information: \n" + ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
                }

                //filling listbox with countries
                //this.Dispatcher.Invoke(new ThreadStart(delegate
                //{
                this.DropDownList1.AutoPostBack = true;
                this.DropDownList1.Items.Clear();

                foreach (Country country in countries)
                {
                    this.DropDownList1.Items.Add(country._name);
                }

            }
        }
Ejemplo n.º 2
0
        //method reading .CSV source using Excel driver (NOT IN USE!)
        private void prepareDefaultData()
        {
            //Thread t = new Thread(new ThreadStart(delegate
            // {
            //Preparing countries
            if (!stoper)
            {
                try
                {
                    Label1.Text = "Waiting for data preparation...";
                    Recomendation.SetToDefault();

                    Excel.Application xlApp;
                    Excel.Workbook xlWorkBook;
                    Excel.Worksheet xlWorkSheet;
                    Excel.Range range;

                    string name = "";
                    double pdi = 0,
                            idv = 0,
                            mas = 0,
                            uai = 0,
                            lto = 0,
                            ivr = 0;
                    int rCnt = 0;
                    int cCnt = 0;
                    xlApp = new Excel.Application();

                    //string path = HttpContext.Current.Server.MapPath("~/docs/Aldunin_dimensions_clasters.xls"­);
                    //xlWorkBook = xlApp.Workbooks.Open(HttpContext.Current.Server.MapPath(@"~/docs/Aldunin_dimensions_clasters.xls"));//, 0, true, 5, "", "", true, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "\t", false, false, 0, true, 1, 0);

                    xlWorkBook = xlApp.Workbooks.Open(HttpContext.Current.Server.MapPath(@"~/docs/Aldunin_dimensions_clasters.xls"), 0, true, 5, "", "", true, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "\t", false, false, 0, true, 1, 0);

                    //xlWorkBook = xlApp.Workbooks.Open(@"liti.somee.com/www.liti.somee.com/v4/docs/Aldunin_dimensions_clasters.xls", 0, true, 5, "", "", true, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "\t", false, false, 0, true, 1, 0);
                    xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1);
                    range = xlWorkSheet.UsedRange;
                    double progressStep = range.Rows.Count / 20;
                    int progressStepCounter = 0;
                    for (rCnt = 2; rCnt <= range.Rows.Count; rCnt++)
                    {
                        progressStepCounter++;
                        if (progressStep < progressStepCounter)
                        {
                            //this.Dispatcher.Invoke(new ThreadStart(delegate
                            //{
                            //    progressBar1.Value += 5;
                            //}));
                            //progressStepCounter = 0;
                        }

                        for (cCnt = 2; cCnt <= range.Columns.Count; cCnt++)
                        {
                            switch (cCnt)
                            {
                                case 2:
                                    name = Convert.ToString((range.Cells[rCnt, cCnt] as Excel.Range).Value2);
                                    break;
                                case 3:
                                    pdi = double.Parse(Convert.ToString(((range.Cells[rCnt, cCnt] as Excel.Range).Value2)));
                                    if (pdi < 0)
                                        pdi = -1;
                                    break;
                                case 4:
                                    idv = double.Parse(Convert.ToString(((range.Cells[rCnt, cCnt] as Excel.Range).Value2)));
                                    if (idv < 0)
                                        idv = -1;
                                    break;
                                case 5:
                                    mas = double.Parse(Convert.ToString(((range.Cells[rCnt, cCnt] as Excel.Range).Value2)));
                                    if (mas < 0)
                                        mas = -1;
                                    break;
                                case 6:
                                    uai = double.Parse(Convert.ToString(((range.Cells[rCnt, cCnt] as Excel.Range).Value2)));
                                    if (uai < 0)
                                        uai = -1;
                                    break;
                                case 7:
                                    lto = double.Parse(Convert.ToString(((range.Cells[rCnt, cCnt] as Excel.Range).Value2)));
                                    if (lto < 0)
                                        lto = -1;
                                    break;
                                case 8:
                                    ivr = double.Parse(Convert.ToString(((range.Cells[rCnt, cCnt] as Excel.Range).Value2)));
                                    if (ivr < 0)
                                        ivr = -1;
                                    break;
                            }
                        }
                        Country c = new Country(name, pdi, idv, mas, uai, lto, ivr);
                        countries.Add(c);
                    }
                    xlWorkBook.Close(true, null, null);
                    xlApp.Quit();
                    releaseObject(xlWorkSheet);
                    releaseObject(xlWorkBook);
                    releaseObject(xlApp);

                    Label1.Text = "Data delivered!";
                    this.Session["arrow1state"] = false;
                    this.Session["arrow2state"] = true;
                    this.Session["arrow3state"] = false;
                    arrowsCheck((bool)this.Session["arrow1state"], (bool)this.Session["arrow2state"], (bool)this.Session["arrow2state"]);
                }
                catch (Exception ex)
                {
                    Response.Write(@"<script>alert('Failed to get data about counties from Excel. Please, contact administrator (mailto: [email protected]), providing following information: \n" + ex.Message.ToString().Substring(0, ex.Message.Length - 3) + "');</script>");
                    Label1.Text = "Data delivery failed!";
                    //Response.Write("<script>alert('Failed to get data about counties from Excel. Please, contact administrator (mailto: [email protected]), providing following information: \\n" + ex.Message + "');</script>");
                    //Response.Write("<script>function window.onload() {  alert( 'Hi!');}</script>");
                    //Response.Write("<script>function window.onload() {  alert( 'Failed to get data about counties from Excel. Please, contact administrator (mailto: [email protected]), providing following information: \n');}</script>");
                    //MessageBox.Show("Failed to get data about counties from Excel. Please, contact administrator (mailto: [email protected]), providing following information: \n" + ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
                }

                //filling listbox with countries
                //this.Dispatcher.Invoke(new ThreadStart(delegate
                //{
                this.DropDownList1.AutoPostBack = true;
                this.DropDownList1.Items.Clear();

                foreach (Country country in countries)
                {
                    this.DropDownList1.Items.Add(country._name);
                }

                //this.waitingLabel.Content = "Data is ready!";
                //progressBar1.Value = progressBar1.Maximum;
                //}));
                //}));

                //t.Start();
            }
        }
Ejemplo n.º 3
0
        //method reading .CSV source using IOstream (IN USE)
        private void prepareDefaultDataCSV()
        {
            try
            {
                countries = new List<Country>();
                string name = "";
                double pdi = 0,
                        idv = 0,
                        mas = 0,
                        uai = 0,
                        lto = 0,
                        ivr = 0;
                string path = HttpContext.Current.Server.MapPath(@"~/docs/Aldunin_dimensions_clasters.csv");    //path to .CSV - data source
                System.IO.StreamReader file = new System.IO.StreamReader(path);
                string line = file.ReadLine(); //missing 1st line
                while ((line = file.ReadLine()) != null)
                {
                    string[] cells = line.Split(';');

                    for (int i = 0; i < cells.Length; i++)
                    {
                        switch (i)
                        {
                            case 1:
                                name = cells[i];
                                break;
                            case 2:
                                try
                                {
                                    pdi = double.Parse(cells[i]);
                                }
                                catch
                                {
                                    pdi = -1;
                                }
                                break;
                            case 3:
                                try
                                {
                                    idv = double.Parse(cells[i]);
                                }
                                catch
                                {
                                    idv = -1;
                                }
                                break;
                            case 4:
                                try
                                {
                                    mas = double.Parse(cells[i]);
                                }
                                catch
                                {
                                    mas = -1;
                                }
                                break;
                            case 5:
                                try
                                {
                                    uai = double.Parse(cells[i]);
                                }
                                catch
                                {
                                    uai = -1;
                                }
                                break;
                            case 6:
                                try
                                {
                                    lto = double.Parse(cells[i]);
                                }
                                catch
                                {
                                    lto = -1;
                                }
                                break;
                            case 7:
                                try
                                {
                                    ivr = double.Parse(cells[i]);
                                }
                                catch
                                {
                                    ivr = -1;
                                }
                                break;
                        }
                    }
                        Country c = new Country(name, pdi, idv, mas, uai, lto, ivr);
                        countries.Add(c);
                }

                file.Close();
                this.DropDownList1.AutoPostBack = true;
                this.DropDownList1.Items.Clear();

                foreach (Country country in countries)
                {
                    this.DropDownList1.Items.Add(country._name);
                }

                Label1.Text = "Data delivered!";
                this.Session["arrow1state"] = false;
                this.Session["arrow2state"] = true;
                this.Session["arrow3state"] = false;
                arrowsCheck((bool)this.Session["arrow1state"], (bool)this.Session["arrow2state"], (bool)this.Session["arrow2state"]);
            }
            catch (Exception ex)
            {
                Response.Write(@"<script>alert('Failed to get data about counties from Excel. Please, contact administrator (mailto: [email protected]), providing following information: \n" + ex.Message.ToString().Substring(0, ex.Message.Length - 3) + "');</script>");
                Label1.Text = "Data delivery failed!";
            }
        }
Ejemplo n.º 4
0
        private void prepareDefaultData()
        {
            //Thread t = new Thread(new ThreadStart(delegate
            // {
            //Preparing countries
            if (!stoper)
            {
                try
                {
                    Label1.Text = "Waiting for data preparation...";
                    Recomendation.SetToDefault();

                    Excel.Application xlApp;
                    Excel.Workbook xlWorkBook;
                    Excel.Worksheet xlWorkSheet;
                    Excel.Range range;

                    string name = "";
                    double pdi = 0,
                            idv = 0,
                            mas = 0,
                            uai = 0,
                            lto = 0,
                            ivr = 0;
                    int rCnt = 0;
                    int cCnt = 0;
                    xlApp = new Excel.Application();
                    xlWorkBook = xlApp.Workbooks.Open(@"C:\ВШЭ\4 курс\Диплом\Hofstede's Dimensions Analysier\Hofstede's Dimensions Analysier\bin\Debug\Aldunin_dimensions_clasters.xls", 0, true, 5, "", "", true, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "\t", false, false, 0, true, 1, 0);
                    xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1);
                    range = xlWorkSheet.UsedRange;
                    double progressStep = range.Rows.Count / 20;
                    int progressStepCounter = 0;
                    for (rCnt = 2; rCnt <= range.Rows.Count; rCnt++)
                    {
                        progressStepCounter++;
                        if (progressStep < progressStepCounter)
                        {
                            //this.Dispatcher.Invoke(new ThreadStart(delegate
                            //{
                            //    progressBar1.Value += 5;
                            //}));
                            //progressStepCounter = 0;
                        }

                        for (cCnt = 2; cCnt <= range.Columns.Count; cCnt++)
                        {
                            switch (cCnt)
                            {
                                case 2:
                                    name = Convert.ToString((range.Cells[rCnt, cCnt] as Excel.Range).Value2);
                                    break;
                                case 3:
                                    pdi = double.Parse(Convert.ToString(((range.Cells[rCnt, cCnt] as Excel.Range).Value2)));
                                    if (pdi < 0)
                                        pdi = -1;
                                    break;
                                case 4:
                                    idv = double.Parse(Convert.ToString(((range.Cells[rCnt, cCnt] as Excel.Range).Value2)));
                                    if (idv < 0)
                                        idv = -1;
                                    break;
                                case 5:
                                    mas = double.Parse(Convert.ToString(((range.Cells[rCnt, cCnt] as Excel.Range).Value2)));
                                    if (mas < 0)
                                        mas = -1;
                                    break;
                                case 6:
                                    uai = double.Parse(Convert.ToString(((range.Cells[rCnt, cCnt] as Excel.Range).Value2)));
                                    if (uai < 0)
                                        uai = -1;
                                    break;
                                case 7:
                                    lto = double.Parse(Convert.ToString(((range.Cells[rCnt, cCnt] as Excel.Range).Value2)));
                                    if (lto < 0)
                                        lto = -1;
                                    break;
                                case 8:
                                    ivr = double.Parse(Convert.ToString(((range.Cells[rCnt, cCnt] as Excel.Range).Value2)));
                                    if (ivr < 0)
                                        ivr = -1;
                                    break;
                            }
                        }
                        Country c = new Country(name, pdi, idv, mas, uai, lto, ivr);
                        countries.Add(c);
                    }
                    xlWorkBook.Close(true, null, null);
                    xlApp.Quit();
                    releaseObject(xlWorkSheet);
                    releaseObject(xlWorkBook);
                    releaseObject(xlApp);
                }
                catch (Exception ex)
                {
                    MessageBox.Show("Failed to get data about counties from Excel. Please, contact administrator (mailto: [email protected]), providing following information: \n" + ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
                }

                //filling listbox with countries
                //this.Dispatcher.Invoke(new ThreadStart(delegate
                //{
                this.DropDownList1.AutoPostBack = true;
                this.DropDownList1.Items.Clear();

                foreach (Country country in countries)
                {
                    this.DropDownList1.Items.Add(country._name);
                }

                Label1.Text = "Data delivered!";
                //this.waitingLabel.Content = "Data is ready!";
                //progressBar1.Value = progressBar1.Maximum;
                //}));
                //}));

                //t.Start();
            }
        }