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();
}
}
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 button4_Click(object sender, EventArgs e)
{
CRUD crud = new CRUD();
crud.Delete("table_admin", "username = '******'");
refreshGrid();
}
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 + ",";
}
string[] valuesDG = valueFromDG.Split(',');
for (byte i = 0; i < valuesDG.Count(); i++)
{
crud.Delete("tbl_satuan", "id_satuan = '" + valuesDG[i] + "'");
}
MessageBox.Show(valueFromDG);
valueFromDG = null;
recordLoad();
}
}
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();
}
