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