Пример #1
0
        private void button1_Click(object sender, EventArgs e)
        {
            OpenFileDialog dialog = new OpenFileDialog();

            dialog.Filter      = "CSV files | *.csv";   // file types, that will be allowed to upload
            dialog.Filter     += "| TXT files | *.txt";
            dialog.Multiselect = false;                 // allow/deny user to upload more than one file at a time
            if (dialog.ShowDialog() == DialogResult.OK) // if user clicked OK
            {
                Application.DoEvents();
                Cursor = Cursors.WaitCursor;
                var myCompany = connectSap();

                string path  = dialog.FileName; // get name of file
                bool   check = SAPHelper.insActFromCSV(myCompany, path, ',');

                if (check)
                {
                    MessageBox.Show("All records are imported in SAP B1", "Import from CSV", MessageBoxButtons.OK, MessageBoxIcon.Information);
                }
                else
                {
                    MessageBox.Show("Somethings goes wrong, check the CSV format", "Import from CSV", MessageBoxButtons.OK, MessageBoxIcon.Error);
                }

                SAPHelper.destroyCom(myCompany);
                Cursor = Cursors.Default;
            }
        }
Пример #2
0
        public Company connectSap(bool destroy = false, bool popup = false)
        {
            string server = textBox1.Text;
            string port   = textBox2.Text;

            string dbUser     = textBox4.Text;
            string dbPassword = textBox5.Text;

            string b1User    = textBox6.Text;
            string b1Pass    = textBox7.Text;
            string b1Company = textBox8.Text;

            var serverType = comboBox1.Text;

            SAPHelper.tipoServer tipo;
            switch (serverType)
            {
            case "hana":
                tipo = SAPHelper.tipoServer.hana;
                break;

            case "mssql2012":
                tipo = SAPHelper.tipoServer.mssql2012;
                break;

            case "mssql2014":
                tipo = SAPHelper.tipoServer.mssql2014;
                break;

            default:
                tipo = SAPHelper.tipoServer.hana;
                break;
            }

            //connetti a DB

            Company myCompany = SAPHelper.getSocieta(server, port, tipo, dbUser, dbPassword, b1User, b1Pass, b1Company);

            if (popup)
            {
                if (myCompany != null)
                {
                    MessageBox.Show("Correct configuration", "Connection Test", MessageBoxButtons.OK, MessageBoxIcon.Information);
                }
                else
                {
                    MessageBox.Show("Some data is missing or wrong", "Connection Test", MessageBoxButtons.OK, MessageBoxIcon.Error);
                }
            }


            //SAPHelper.getAct(myCompany);
            if (destroy)
            {
                SAPHelper.destroyCom(myCompany);
                return(null);
            }

            return(myCompany);
        }
Пример #3
0
        private void button2_Click(object sender, EventArgs e)
        {
            Application.DoEvents();
            Cursor = Cursors.WaitCursor;
            var myCompany = connectSap();

            SAPHelper.getActToXML(myCompany);
            SAPHelper.destroyCom(myCompany);
            Cursor = Cursors.Default;
        }