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