private void RebindItems() {
string query = "SELECT *, (CASE WHEN(kondisi_alat = 1) THEN \"Baik\" ELSE \"Rusak\" END) as kondisi FROM inventory JOIN master_inventory_type ON inventralalab.inventory.id_jenis = inventralalab.master_inventory_type.id";
try {
using (MySqlCommand cmd = new MySqlCommand(query, db.ConnectionManager.Connection)) {
using (MySqlDataAdapter dataAdapter = new MySqlDataAdapter(cmd)) {
DataTable dataTable = new DataTable();
dataAdapter.Fill(dataTable);
items = new List<Alat>();
foreach (DataRow row in dataTable.Rows) {
Alat alat = new Alat(
(string)row["id"],
(string)row["id_jenis"],
(string)row["nama"],
(bool)row["kondisi_alat"],
(string)row["lokasi"]
);
items.Add(alat);
}
listBox_Alat.ItemsSource = items;
}
}
}
catch (MySqlException ex) {
MessageBox.Show(ex.Message);
}
}
public EditAlat(Alat alat)
{
InitializeComponent();
this.alat = alat;
status = new List<KV>();
status.Add(new KV("Baik", 1));
status.Add(new KV("Rusak", 0));
comboBox_Status.ItemsSource = status;
comboBox_Status.DisplayMemberPath = "Key";
comboBox_Status.SelectedValuePath = "Value";
comboBox_Status.SelectedValue = (alat.KondisiAlat) ? 1 : 0;
textbox_Laboratorium.Text = alat.Lokasi;
string query = "SELECT * FROM master_inventory_type";
using (MySqlCommand cmd = new MySqlCommand(query, db.ConnectionManager.Connection)) {
try {
DataTable dataSet = new DataTable();
using (MySqlDataAdapter dataAdapter = new MySqlDataAdapter(cmd)) {
dataAdapter.Fill(dataSet);
comboBox_Jenis_Barang.ItemsSource = dataSet.DefaultView;
comboBox_Jenis_Barang.DisplayMemberPath = dataSet.Columns["nama"].ToString();
comboBox_Jenis_Barang.SelectedValuePath = dataSet.Columns["id"].ToString();
comboBox_Jenis_Barang.SelectedValue = alat.IdJenis;
}
}
catch (MySql.Data.MySqlClient.MySqlException ex) {
MessageBox.Show(ex.Message);
}
}
}
private void RebindItems() {
string query = "SELECT * FROM inventory JOIN borrowers ON inventralalab.inventory.id_peminjam = inventralalab.borrowers.id WHERE id_peminjam IS NOT NULL";
try {
using (MySqlCommand cmd = new MySqlCommand(query, db.ConnectionManager.Connection)) {
using (MySqlDataAdapter dataAdapter = new MySqlDataAdapter(cmd)) {
DataTable dataTable = new DataTable();
dataAdapter.Fill(dataTable);
items = new List<Alat>();
foreach (DataRow row in dataTable.Rows) {
Alat alat = new Alat(
(string)row["id"],
(string)row["nama"],
(DateTime?)row["tanggal_mulai"],
(DateTime?)row["tanggal_selesai"],
(bool)row["kondisi_alat"],
(string)row["lokasi"]
);
items.Add(alat);
}
listbox_Peminjam.ItemsSource = dataTable.DefaultView;
}
}
}
catch (MySqlException ex) {
MessageBox.Show(ex.Message);
}
}