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