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 toolStripButton4_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)
{
crud.Dt = crud.ExecuteQuery("SELECT distinct stock_utama, stock_turunan FROM tbl_obat_stock WHERE id_obat = '" + row.Cells[0].Value.ToString() + "' ORDER BY tgl_expired ASC");
if (crud.Dt.Rows.Count > 0)
{
decimal stockUtama = Convert.ToDecimal(crud.Dt.Rows[0]["stock_utama"]);
decimal stockTurunan = Convert.ToDecimal(crud.Dt.Rows[0]["stock_turunan"]);
if (stockUtama == 0 && stockTurunan == 0)
{
crud.Delete("tbl_obat", "id_obat ='" + row.Cells[0].Value.ToString() + "'");
crud.Delete("tbl_konversi", "id_item ='" + row.Cells[0].Value.ToString() + "'");
crud.Delete("tbl_obat_stock", "id_obat ='" + row.Cells[0].Value.ToString() + "'");
// MessageBox.Show(crud.Dt.Rows[0]["stock_utama"].ToString() + crud.Dt.Rows[0]["stock_turunan"].ToString());
}
else
{
MessageBox.Show("Terdapat Stock Dalam Tabel, Pastikan Stock sudah kosong !", "Error Penghapusan", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
BgWorkerDoWork();
}
}
public void Pengaturan()
{
if (isEdit == false)
{
Kontrol.EmptyText(this, tipeCBX);
kdObatTxt.Text = Kontrol.GenerateNumber("tbl_obat", "id_obat");
kdObatTxt.Enabled = true;
hargaJualTxt.Value = 0;
hargaPokokTxt.Value = 0;
selisihTXT.Value = 1;
marginTxt.Value = 1;
}
else
{
//Kontrol.EmptyText(this, tipeCBX);
kdObatTxt.Text = primaryKey;
kdObatTxt.Enabled = false;
crud.ExecuteQuery("SELECT Qty FROM tbl_konversi WHERE id_Item = '" + kdObatTxt.Text + "' AND isDefault = 0");
selisihTXT.Value = Convert.ToDecimal(crud.Dt.Rows[0]["Qty"]);
}
kdObatTxt.Focus();
crud.Dt = crud.Select("tbl_kategori", "kategori");
kategoriCBX.DataSource = crud.Dt;
kategoriCBX.DisplayMember = "kategori";
crud.Dt = crud.Select("tbl_tipe", "tipe");
tipeCBX.DataSource = crud.Dt;
tipeCBX.DisplayMember = "tipe";
crud.Dt = crud.Select("tbl_satuan", "satuan");
satuanStockCBX.DataSource = crud.Dt;
satuanStockCBX.DisplayMember = "satuan";
crud.Dt = crud.Select("tbl_satuan", "satuan");
satuanJualCBX.DataSource = crud.Dt;
satuanJualCBX.DisplayMember = "satuan";
}
private void FrmStock_Load(object sender, EventArgs e)
{
crud.Dt = crud.ExecuteQuery("SELECT merek,nama_obat FROM tbl_obat WHERE id_obat = '" + kdObatTxt.Text + "' ");
merekTxt.Text = crud.Dt.Rows[0]["merek"].ToString();
nmObatTxt.Text = crud.Dt.Rows[0]["nama_obat"].ToString();
}
