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