private void bsimpan_Click(object sender, RoutedEventArgs e)
{
koneksi c = new koneksi();
c.IntCon();
try
{
string QuerySelect = "insert into barang values('" + Tbarcode.Text + "', ('" + s + "'),'" + tnama.Text + "', '" + tmodal.Text + "','" + tharga.Text + "','" + tstok.Text + "')";
SQLiteCommand createCommend = new SQLiteCommand(QuerySelect, c.cn);
createCommend.ExecuteNonQuery();
MessageBox.Show("penyimpana sukses");
}
catch (SyntaxErrorException)
{
MessageBox.Show("Save has been failed");
}
}
public void load()
{
koneksi c = new koneksi();
c.IntCon();
string QuerySelect = " Select * from barang ";
SQLiteCommand createCommend = new SQLiteCommand(QuerySelect, c.cn);
createCommend.ExecuteNonQuery();
SQLiteDataAdapter MysqlDtA = new SQLiteDataAdapter(createCommend);
DataTable dt = new DataTable("barang");
MysqlDtA.Fill(dt);
dataGrid.ItemsSource = dt.DefaultView;
MysqlDtA.Update(dt);
}
private void TCari_TextChanged(object sender, TextChangedEventArgs e)
{
koneksi c = new koneksi();
c.IntCon();
string QuerySelect = "Select * from barang where barcode like '%" + TCari.Text + "%'";
SQLiteCommand createCommend = new SQLiteCommand(QuerySelect, c.cn);
createCommend.ExecuteNonQuery();
SQLiteDataAdapter MysqlDtA = new SQLiteDataAdapter(createCommend);
DataTable dt = new DataTable("barang");
MysqlDtA.Fill(dt);
dataGrid.ItemsSource = dt.DefaultView;
MysqlDtA.Update(dt);
}
private void button_Click_1(object sender, RoutedEventArgs e)
{
koneksi c = new koneksi();
c.IntCon();
string QuerySelect = "Select * from barang where barcode= '" + TCari.Text + "'";
SQLiteCommand createCommend = new SQLiteCommand(QuerySelect, c.cn);
createCommend.ExecuteNonQuery();
SQLiteDataReader re;
re = createCommend.ExecuteReader();
while (re.Read())
{
string base64 = re.GetString(1);
image.Source = ByteToImage(Convert.FromBase64String(base64));
}
}
private void bCari_Click(object sender, RoutedEventArgs e)
{
try
{
koneksi c = new koneksi();
c.IntCon();
string QuerySelect = "Select * from barang where nama_barang like '%" + TCari.Text + "%'";
SQLiteCommand createCommend = new SQLiteCommand(QuerySelect);
createCommend.ExecuteNonQuery();
SQLiteDataAdapter MysqlDtA = new SQLiteDataAdapter(createCommend);
DataTable dt = new DataTable("barang");
MysqlDtA.Fill(dt);
dataGrid.ItemsSource = dt.DefaultView;
MysqlDtA.Update(dt);
c.IntCon();
}
catch (SQLiteException ex)
{
MessageBox.Show(ex.Message);
}
}
private void BTest_Click(object sender, RoutedEventArgs e)
{
koneksi cn = new koneksi();
cn.IntCon();
}
