private void btnDeleteObat_Click(object sender, RoutedEventArgs e) { object item = dgObat.SelectedItem; string temp_id = (dgObat.SelectedCells[0].Column.GetCellContent(item) as TextBlock).Text; int id = Convert.ToInt32(temp_id); MEDICINE obat = SearchByIdObat(id); et.Entry(obat).State = System.Data.Entity.EntityState.Deleted; et.SaveChanges(); clearTextObat(); this.ViewObat(dgObat); MessageBox.Show("Delete Data Obat Berhasil !", "Informasi", MessageBoxButton.OK, MessageBoxImage.Information); }
private void btnEditObat_Click(object sender, RoutedEventArgs e) { object item = dgObat.SelectedItem; string temp_id = (dgObat.SelectedCells[0].Column.GetCellContent(item) as TextBlock).Text; int id = Convert.ToInt32(temp_id); MEDICINE obat = SearchByIdObat(id); obat.NAME = txtNamaObat.Text; obat.TYPE_MEDICINE_ID = Convert.ToInt32(cmbTipeObat.SelectedValue); obat.EXP = Convert.ToDateTime(dtObat.Text); obat.STOCK = Convert.ToInt32(txtStockObat.Text); obat.PRICE = Convert.ToDouble(txtHargaObat.Text); et.Entry(obat).State = System.Data.Entity.EntityState.Modified; et.SaveChanges(); clearTextObat(); this.ViewObat(dgObat); MessageBox.Show("Update Data Obat Berhasil !", "Informasi", MessageBoxButton.OK, MessageBoxImage.Information); }
private void btnTambahObat_Click(object sender, RoutedEventArgs e) { MEDICINE obat = new MEDICINE() { NAME = txtNamaObat.Text, PRICE = Convert.ToDouble(txtHargaObat.Text), STOCK = Convert.ToInt32(txtStockObat.Text), EXP = Convert.ToDateTime(dtObat.Text), TYPE_MEDICINE_ID = Convert.ToInt32(cmbTipeObat.SelectedValue) }; try { et.MEDICINEs.Add(obat); et.SaveChanges(); clearTextObat(); this.ViewObat(dgObat); MessageBox.Show("Tambah Data Obat Berhasil !", "Informasi", MessageBoxButton.OK, MessageBoxImage.Information); } catch (Exception ex) { } }
private void btnTambahTransaksi_Click(object sender, RoutedEventArgs e) { try { TRANSACTION transaksi = new TRANSACTION() { PATIENT_ID = Convert.ToInt32(txtIdPasienTransaksi.Text), TRANSACTION_DATE = Convert.ToDateTime(dtTanggalTransaksi.Text), }; et.TRANSACTIONs.Add(transaksi); et.SaveChanges(); PATIENT pasien = SearchByIdPasienTransaksi(Convert.ToInt32(txtIdPasienTransaksi.Text)); pasien.STATUS = 1; et.Entry(pasien).State = System.Data.Entity.EntityState.Modified; et.SaveChanges(); ROOM ruangan = SearchByIdRoomTransaksi(Convert.ToInt32(cmbNamaRuanganTransaksi.SelectedValue)); MEDICINE obat = SearchByIdObatTransaksi(Convert.ToInt32(cmbNamaObatTransaksi.SelectedValue)); DOCTOR dokter = SearchByIdDokterTransaksi(Convert.ToInt32(cmbNamaDokterTransaksi.SelectedValue)); NURSE perawat = SearchByIdPerawatTransaksi(Convert.ToInt32(cmbNamaPerawatTransaksi.SelectedValue)); TRANSACTION_DETAIL detil_transaksi = new TRANSACTION_DETAIL() { ARRIVAL_DATE = Convert.ToDateTime(dtKedatanganTransaksi.Text), LEAVING_DATE = Convert.ToDateTime(dtKepergianTransaksi.Text), ROOM_ID = Convert.ToInt32(cmbNamaRuanganTransaksi.SelectedValue), TRANSACTION_ID = Convert.ToInt32(transaksi.TRANSACTION_ID), PRICE_ROOM = Convert.ToDouble(ruangan.TYPE_ROOM.PRICE), QTY_MEDICINE = Convert.ToInt32(txtQtyObat.Text), TOTAL_PRICE = totalPrice() }; et.TRANSACTION_DETAIL.Add(detil_transaksi); /*detil_transaksi.MEDICINEs.Add(new MEDICINE { MEDICINE_ID = SearchByIdObatTransaksi(Convert.ToInt32(cmbNamaObatTransaksi.SelectedValue)).MEDICINE_ID }); * detil_transaksi.DOCTORs.Add(new DOCTOR { DOCTOR_ID = SearchByIdDokterTransaksi(Convert.ToInt32(cmbNamaDokterTransaksi.SelectedValue)).DOCTOR_ID }); * detil_transaksi.NURSEs.Add(new NURSE { NURSE_ID = SearchByIdPerawatTransaksi(Convert.ToInt32(cmbNamaPerawatTransaksi.SelectedValue)).NURSE_ID });*/ TRANSACTION_DETAIL detil_transaksi1 = new TRANSACTION_DETAIL { TRANSACTION_DETAIL_ID = detil_transaksi.TRANSACTION_DETAIL_ID }; et.TRANSACTION_DETAIL.Add(detil_transaksi1); et.TRANSACTION_DETAIL.Attach(detil_transaksi1); MEDICINE obat1 = new MEDICINE { MEDICINE_ID = obat.MEDICINE_ID }; et.MEDICINEs.Add(obat1); //et.MEDICINEs.Attach(obat1); DOCTOR dokter1 = new DOCTOR { DOCTOR_ID = dokter.DOCTOR_ID }; et.DOCTORs.Add(dokter1); //et.DOCTORs.Attach(dokter1); NURSE perawat1 = new NURSE { NURSE_ID = perawat.NURSE_ID }; et.NURSEs.Add(perawat1); //et.NURSEs.Attach(perawat1); detil_transaksi1.MEDICINEs.Add(obat1); detil_transaksi1.DOCTORs.Add(dokter1); detil_transaksi1.NURSEs.Add(perawat1); et.SaveChanges(); MEDICINE mEDICINE = SearchByIdObatTransaksi(Convert.ToInt32(cmbNamaObatTransaksi.SelectedValue)); mEDICINE.STOCK = obat.STOCK - detil_transaksi.QTY_MEDICINE; et.Entry(mEDICINE).State = System.Data.Entity.EntityState.Modified; et.SaveChanges(); clearTextTransaksi(); this.viewBlmTransaksiPasien(dgTransaksiPasien); MessageBox.Show("Transaksi Berhasil !", "Informasi", MessageBoxButton.OK, MessageBoxImage.Information); } catch (Exception ex) { } //TRANSACTION_DETAIL detil_transaksi1 = new TRANSACTION_DETAIL { TRANSACTION_DETAIL_ID = detil_transaksi.TRANSACTION_DETAIL_ID }; //detil_transaksi1.MEDICINEs.Add(new MEDICINE { MEDICINE_ID = obat.MEDICINE_ID }); //et.TRANSACTION_DETAIL.Add(detil_transaksi1); //et.SaveChanges(); }