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(); }