private void NewBarangForm_Load(object sender, EventArgs e) { this.ActiveControl = tbNama; tbuid.Text = mForm._code; cpb = mForm.FindIdInList(mForm._code); //jika ada data sebelumnya di list if (cpb.isFound) { status = "edit"; labelJudul.Text = "Barang Edit"; ItemBarang brg = mForm.getItmBarangs(cpb.posisi); tbNama.Text = brg.nama; tbMerk.Text = brg.merk; tbStock.Text = brg.stok.ToString(); tbhargakulak.Text = brg.hargakulak.ToString(); tbHargaa.Text = brg.hargaecer.ToString(); tbHargab.Text = brg.hargabakul.ToString(); } // jika tidak ada di list cari di DB //find in db first else { MySqlConnection myConn = new MySqlConnection("server=localhost; username=root; password=; port=3306; database=db_posmiew"); try { myConn.Open(); MySqlCommand myCommand = new MySqlCommand("SELECT * FROM barang left JOIN tbl_kulakan on barang.bid=tbl_kulakan.bid where tbl_kulakan.bid=" + mForm._code + " ORDER BY tbl_kulakan.tanggal DESC LIMIT 1", myConn); MySqlDataAdapter myAdapter = new MySqlDataAdapter(myCommand); myAdapter.SelectCommand.CommandType = CommandType.Text; DataTable dt = new DataTable(); myAdapter.Fill(dt); //end myConn.Close(); if (dt.Rows.Count == 0) { Debug.WriteLine("TidaK ADA"); } else { grSebelum.Visible = true; Debug.WriteLine("ADA"); DataRow dr = dt.Rows[0]; tbNama.Text = dr["nama"].ToString(); tbMerk.Text = dr["merk"].ToString(); hargasebelum.Text = "Rp " + dr["harga_k"].ToString(); } } catch (Exception ex) { Debug.WriteLine("RQUEST CEK db ERROR"); Debug.WriteLine(ex); } } // Berati Data baru }
public CariPosBarang FindIdInList(string id) { CariPosBarang pBrg = new CariPosBarang(); int p = 0; foreach (ItemBarang brg in itemBarangs) { if (brg.uid.Equals(id)) { pBrg.isFound = true; pBrg.posisi = p; break; } p++; } return(pBrg); }