private void button1_Click(object sender, EventArgs e) { custglobal = ""; poglobal = ""; plnoglobal = cbexistingpl.Text; MainMenu frm = new MainMenu(); List <object[]> data = new List <object[]>(); data = frm.get_data_table_string("shipping_unit", "packingslipno", plnoglobal); if (data.Count > 0) { custglobal = data[0][3].ToString(); poglobal = data[0][2].ToString(); } //var current = sender as Button; //this.Hide(); //var frmStuffing = new frmStuffing(); //frmStuffing.Closed += (s, args) => this.Close(); frmStuffing fc = new frmStuffing(); fc.setInitial(plnoglobal, custglobal, poglobal); fc.loadpackingdetails(plnoglobal); fc.ShowDialog(); }
private void save_pl() { if (cbpo.Text.Equals("")) { MessageBox.Show("Please fill PO"); return; } if (txtcustomer.Text.Equals("")) { MessageBox.Show("Please fill Customer"); txtcustomer.Focus(); return; } if (cbshipterms.Text.Equals("")) { MessageBox.Show("Please fill Ship Terms"); return; } if (txtorigin.Text.Equals("")) { MessageBox.Show("Please fill Origin"); txtorigin.Focus(); return; } if (checkBox1.Checked) { if (txtlocalpl.Text.Equals("")) { MessageBox.Show("Please fill PL Number"); txtlocalpl.Focus(); return; } else { MainMenu frm1 = new MainMenu(); List <object[]> data1 = new List <object[]>(); data1 = frm1.get_data_table_string("shipping_unit", "packingslipno", txtlocalpl.Text.Trim()); if (data1.Count > 0) { MessageBox.Show("PL Number " + txtlocalpl.Text.Trim() + " sudah ada, silahkan input PL# yang lain"); txtlocalpl.Focus(); return; } } } String plno = ""; if (checkBox1.Checked == false) { plno = generatePL(); } else { plno = txtlocalpl.Text.Trim(); } //save in plnoglobal plnoglobal = plno; String cust = txtcustomer.Text.Trim(); custglobal = cust; String po = cbpo.Text.Trim(); poglobal = po; String shipterm = cbshipterms.Text.Trim(); String blno = txtblno.Text.Trim(); DateTime shipdate = dateTimePicker1.Value.Date; String origin = txtorigin.Text.Trim(); String vessel = txtvessel.Text.Trim(); String voyage = txtvoyage.Text.Trim(); String container = txtcontainer.Text.Trim(); String signer = txtsigner.Text.Trim(); String sealno = txtseal.Text.Trim(); DateTime etd = dateTimePicker2.Value.Date; String shipment = txtshipment.Text.Trim(); String username = Properties.Settings.Default.username; MainMenu frm = new MainMenu(); //get data from table List <object[]> data = new List <object[]>(); String connString = Konek(); MySqlConnection conn5 = new MySqlConnection(connString); conn5.Open(); try { MySqlCommand mySql3 = conn5.CreateCommand(); mySql3.CommandText = "Insert into shipping_unit(packingslipno, po_number,customerid,bill_of_lading,vessel_name,container_number,shipping_unit_number,seal_number,country_origin,shipdate,username, moddatetime,incoterms,voyage,signer,etd,shipment)"+ " values(@packingslipno,@po_number,@customerid,@bill_of_lading,@vessel_name,@container_number,@shipping_unit_number,@seal_number,@country_origin,@shipdate,@username, @moddatetime,@incoterms,@voyage,@signer,@etd,@shipment)"; mySql3.Parameters.AddWithValue("@packingslipno", plno); mySql3.Parameters.AddWithValue("@po_number", po); mySql3.Parameters.AddWithValue("@customerid", cust); mySql3.Parameters.AddWithValue("@bill_of_lading", blno); mySql3.Parameters.AddWithValue("@vessel_name", vessel); mySql3.Parameters.AddWithValue("@container_number", container); mySql3.Parameters.AddWithValue("@shipping_unit_number", plno); mySql3.Parameters.AddWithValue("@seal_number", sealno); mySql3.Parameters.AddWithValue("@country_origin", origin); mySql3.Parameters.AddWithValue("@shipdate", shipdate); mySql3.Parameters.AddWithValue("@etd", etd); mySql3.Parameters.AddWithValue("@username", username); DateTime dt = DateTime.Now; mySql3.Parameters.AddWithValue("@moddatetime", frm.get_server_time()); mySql3.Parameters.AddWithValue("@incoterms", shipterm); mySql3.Parameters.AddWithValue("@voyage", voyage); mySql3.Parameters.AddWithValue("@signer", signer); mySql3.Parameters.AddWithValue("@shipment", shipment); mySql3.ExecuteNonQuery(); } catch (Exception ex) { MessageBox.Show("Error message " + ex.Message); } conn5.Close(); frmStuffing fc = new frmStuffing(); fc.setInitial(plnoglobal, custglobal, poglobal); fc.ShowDialog(); }