private void deleteBtn_Click(object sender, EventArgs e)
{
var pesan = MessageBox.Show("Apakah Anda Yakin Ingin Menghapus ? ", "Penghapusan", MessageBoxButtons.YesNo, MessageBoxIcon.Exclamation);
if (pesan == DialogResult.Yes)
{
foreach (DataGridViewRow row in dataGridView1.SelectedRows)
{
valueFromDG += row.Cells[0].Value + ",";
idObat += row.Cells[1].Value + ",";
}
string[] valuesDG = valueFromDG.Split(',');
string[] idObats = idObat.Split(',');
//int counter;
for (byte i = 0; i < valuesDG.Count(); i++)
{
crud.Dt = crud.ExecuteQuery("SELECT id_obat FROM tbl_obat_stock WHERE id_obat = '" + idObats[i] + "'");
if (crud.Dt.Rows.Count == 1)
{
crud.Update("tbl_obat_stock", "stock_utama = '0', stock_turunan = '0'", "id_obat = '" + idObats[i] + "'");
}
else
{
crud.Delete("tbl_obat_stock", "no = '" + valuesDG[i] + "'");
}
}
MessageBox.Show(valueFromDG);
valueFromDG = null;
recordLoad();
}
}
private void SaveBtn_Click(object sender, EventArgs e)
{
if (isEdit)
{
crud.Update("tbl_satuan", " satuan = '" + satuanTxt.Text + "'", "id_satuan = '" + primaryKey + "'");
this.Close();
}
else
{
crud.Insert("tbl_satuan", "satuan = '" + satuanTxt.Text + "'");
}
IsEdit = false;
Pengaturan();
}
private void SaveBtn_Click(object sender, EventArgs e)
{
if (isEdit)
{
crud.Update("tbl_tipe", "tipe = '" + tipeTXT.Text + "', keterangan = '" + ketTXT.Text + "'", "id_tipe = '" + primaryKey + "'");
this.Close();
}
else
{
crud.Insert("tbl_tipe", "tipe = '" + tipeTXT.Text + "', keterangan = '" + ketTXT.Text + "'");
}
isEdit = false;
Pengaturan();
}
private void SaveBtn_Click(object sender, EventArgs e)
{
if (statusResepCBX.Text == "Ya")
{
isResep = 1;
}
else
{
isResep = 0;
}
// MessageBox.Show(isResep.ToString());
crud.Dt = crud.ExecuteQuery("SELECT id_satuan FROM tbl_satuan WHERE satuan = '" + satuanJualCBX.Text + "'");
idSatuanUtama = crud.Dt.Rows[0]["id_satuan"].ToString();
crud.Dt = crud.ExecuteQuery("SELECT id_satuan FROM tbl_satuan WHERE satuan = '" + satuanStockCBX.Text + "'");
idSatuanTurunan = crud.Dt.Rows[0]["id_satuan"].ToString();
if (IsEdit)
{
crud.Update("tbl_obat", "merek = '" + merekTxt.Text + "', " +
"nama_obat = '" + nmObatTxt.Text + "', " +
"tipe = '" + tipeCBX.Text + "'," +
"kategori = '" + kategoriCBX.Text + "', " +
"status_resep = " + isResep + " , " +
"satuan_stock = '" + satuanStockCBX.Text + "', " +
"harga_pokok = '" + hargaPokokTxt.Value + "'," +
"satuan_jual = '" + satuanJualCBX.Text + "'," +
"harga_jual = '" + hargaJualTxt.Value + "', " +
"margin_jual = '" + marginTxt.Value + "'," +
"keterangan = '" + keteranganTXT.Text + "'", "id_obat = '" + kdObatTxt.Text + "'");
crud.Update("tbl_obat_stock", "satuan_utama = '" + satuanStockCBX.Text + "'," +
"satuan_turunan = '" + satuanJualCBX.Text + "'", "id_obat = '" + kdObatTxt.Text + "'");
if (idSatuanTurunan != idSatuanUtama)
{
crud.ExecuteNonQuery("UPDATE tbl_konversi SET id_satuan = '" + idSatuanUtama + "', " +
"Qty = '" + selisihTXT.Value + "', " +
"isDefault = 0 WHERE id_item = '" + kdObatTxt.Text + "' AND id_satuan = '" + idSatuanTurunan + "'");
}
crud.ExecuteNonQuery("UPDATE tbl_konversi SET id_satuan = '" + idSatuanTurunan + "', " +
"Qty = '" + selisihTXT.Value + "', " +
"isDefault = 1 WHERE id_item = '" + kdObatTxt.Text + "' AND id_satuan = '" + idSatuanTurunan + "'");
this.Close();
}
else
{
crud.Insert("tbl_obat", "id_obat = '" + kdObatTxt.Text + "', " +
"merek = '" + merekTxt.Text + "', " +
"nama_obat = '" + nmObatTxt.Text + "', " +
"tipe = '" + tipeCBX.Text + "'," +
"kategori = '" + kategoriCBX.Text + "', " +
"status_resep = " + isResep + " , " +
"satuan_stock = '" + satuanStockCBX.Text + "', " +
"harga_pokok = '" + hrgPokok + "'," +
"satuan_jual = '" + satuanJualCBX.Text + "'," +
"harga_jual = '" + hrgJual + "', " +
"margin_jual = '" + marginTxt.Value + "'," +
"keterangan = '" + keteranganTXT.Text + "'");
crud.Insert("tbl_obat_stock", "id_obat = '" + kdObatTxt.Text + "'," +
"satuan_utama = '" + satuanStockCBX.Text + "'," +
"satuan_turunan = '" + satuanJualCBX.Text + "'");
if (idSatuanTurunan != idSatuanUtama)
{
if (idSatuanTurunan != idSatuanUtama)
{
crud.Insert("tbl_konversi", "id_Item = '" + kdObatTxt.Text + "'," +
"id_satuan = '" + idSatuanTurunan + "', " +
"Qty = '" + selisihTXT.Value + "', " +
"isDefault = 0");
}
}
crud.Insert("tbl_konversi", "id_Item = '" + kdObatTxt.Text + "'," +
"id_satuan = '" + idSatuanUtama + "', " +
"Qty = '1', " +
"isDefault = 1");
//MessageBox.Show(idSatuanTurunan + " / " + idSatuanUtama);
}
IsEdit = false;
Pengaturan();
}
