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;
}
}
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);
}
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;
}