private void SaveBtn_Click(object sender, EventArgs e)
{
if (isEdit)
{
if (crud.con_open())
{
using (crud.Perintah = new MySqlCommand("update tbl_kategori set kategori = @kategori WHERE id_kategori = @id", crud.Koneksi))
{
crud.Perintah.Parameters.Clear();
crud.Perintah.Parameters.AddWithValue("@kategori", kategoriTxt.Text);
crud.Perintah.Parameters.AddWithValue("@id", primaryKey);
crud.Perintah.ExecuteNonQuery();
crud.con_close();
}
}
IsEdit = false;
Pengaturan();
this.Close();
}
else
{
crud.Insert("tbl_kategori", "kategori = '" + kategoriTxt.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 (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)
{
crud.Dt = crud.ExecuteQuery("SELECT tgl_expired FROM tbl_obat_stock WHERE id_obat = '" + kdObatTxt.Text + "' AND tgl_expired = '" + expiredDT.Value.Date.ToString("yyyy-MM-dd") + "'");
if (crud.Dt.Rows.Count == 0)
{
if (isKosong)
{
crud.Delete("tbl_obat_stock", "id_obat ='" + kdObatTxt.Text + "'");
}
crud.Insert("tbl_obat_stock", "No = '" + setControl.GenerateNumber("tbl_obat_stock", "No") + "'," +
"id_obat = '" + kdObatTxt.Text + "'," +
"satuan_utama = '" + satuanUtamaTxt.Text + "'," +
"satuan_turunan = '" + satuanTurunanTxT.Text + "'," +
"stock_utama = '" + stockUtamaTxt.Text + "'," +
"stock_turunan = '" + stockTurunanTxt.Text + "'," +
"tgl_expired = '" + expiredDT.Value.Date.ToString("yyyy-MM-dd") + "'");
}
else
{
crud.ExecuteNonQuery("UPDATE tbl_obat_stock SET stock_utama = '" + stockUtamaTxt.Text + "'," +
"stock_turunan = '" + stockTurunanTxt.Text + "' WHERE id_obat = '" + kdObatTxt.Text + "' AND tgl_expired = '" + expiredDT.Value.Date.ToString("yyyy-MM-dd") + "'");
}
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();
}
