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