public void updatePasien(Patient upd) { Patient PasienUpddate = (from bUpdate in context.Patients where bUpdate.Id_Pasien == upd.Id_Pasien select bUpdate).FirstOrDefault(); if (PasienUpddate != null) { //PasienUpddate.Id_Pasien = upd.Id_Pasien; PasienUpddate.ID_Pegawai = upd.ID_Pegawai; PasienUpddate.ID_Room = upd.ID_Room; PasienUpddate.Nama_Pasien = upd.Nama_Pasien; PasienUpddate.Penyakit = upd.Penyakit; PasienUpddate.Jenis_Kelamin = upd.Jenis_Kelamin; PasienUpddate.Golongan_Darah = upd.Golongan_Darah; PasienUpddate.Jenis_Kelamin = upd.Jenis_Kelamin; PasienUpddate.Tgl_Lahir = upd.Tgl_Lahir; PasienUpddate.Alamat_Pasien = upd.Alamat_Pasien; PasienUpddate.Kota_Pasien = upd.Kota_Pasien; PasienUpddate.No_KTP = upd.No_KTP; PasienUpddate.No_Hp = upd.No_Hp; PasienUpddate.Pekerjaan = upd.Pekerjaan; PasienUpddate.Tgl_Masuk = upd.Tgl_Masuk; PasienUpddate.Tgl_Keluar = upd.Tgl_Keluar; PasienUpddate.Tarif_total = upd.Tarif_total; //PasienUpddate.Id_Pasien = upd.Id_Pasien; context.SaveChanges(); } else { Console.WriteLine("no Update"); } }
private void button2_Click(object sender, EventArgs e) { using (HospitalEntities context = new HospitalEntities()) { int result = (int)(context.GetNewPatientId().FirstOrDefault()); if (result > -1) { try { Patient p = new Patient() { Id_Pasien = result, Nama_Pasien = textBox3.Text, Penyakit = textBox9.Text, Jenis_pasien = comboBox3.Text, Golongan_Darah = comboBox2.Text, Jenis_Kelamin = comboBox1.Text, Tgl_Lahir = dateTimePicker2.Value, Alamat_Pasien = textBox4.Text, Kota_Pasien = textBox5.Text, No_KTP = System.Convert.ToInt32(textBox8.Text), No_Hp = System.Convert.ToInt32(textBox7.Text), Pekerjaan = textBox6.Text, Tgl_Masuk = dateTimePicker3.Value, ID_Room = System.Convert.ToInt32(textBox1.Text) }; PasienController pc = new PasienController(); pc.AddPasien(p); //int stat = System.Convert.ToInt32(textBox1.Text); //if (System.Convert.ToInt32(textBox1.Text) != null) //{ /* Kamar k = new Kamar() { Id_Room = System.Convert.ToInt32(textBox1.Text), Status_Kamar = 1 }; * */ RoomController rc = new RoomController(); rc.updateStatus(p); //} MessageBox.Show(textBox1.Text); } catch (FormatException fe) { MessageBox.Show("Data harus terisi semua"); } } } }
public void updateFreeStatus(Patient pa) { Kamar updateStats = (from b in context.Kamars where b.Id_Room == pa.ID_Room select b).FirstOrDefault(); if (updateStats != null) { //byte bit = System.Convert.ToByte(a); updateStats.Status_Kamar = System.Convert.ToByte(0); context.SaveChanges(); } }
public int HargaKamar(Patient pat) { Patient idr = (from i in context.Patients where i.Id_Pasien == pat.Id_Pasien select i).FirstOrDefault(); Kamar result = (from b in context.Kamars where b.Id_Room == idr.ID_Room select b).FirstOrDefault(); int harga; harga = result.Harga_Sewa; return harga; }
public int TotalPeriksa(Patient a) { IEnumerable<Periksa> harga = from b in context.Periksas where b.id_Pasien == a.Id_Pasien select b; int total = 0; foreach(var ax in harga) { total = total + ax.Tarif; } return total; }
public void AddPasien(Patient pasien) { try { context.Patients.Add(pasien); context.SaveChanges(); } catch (Exception ex) { Console.WriteLine("Error on inserting..."); Console.WriteLine(ex.InnerException. InnerException.Message); } }
public int HariKamar(Patient pa) { Patient result = (from b in context.Patients where b.Id_Pasien == pa.Id_Pasien select b).FirstOrDefault(); /*int hari; hari = result.Tgl_Masuk.Value.Date - result.Tgl_Masuk.Value.Date; int hari1 = hari + 1;*/ int masuk = (int)result.Tgl_Masuk.Value.ToOADate(); int keluar = (int)result.Tgl_Keluar.Value.ToOADate(); int hari = (keluar - masuk) + 1; return hari; }
public void updateTarifPasien(Patient upd) { Patient PasienUpddate = (from bUpdate in context.Patients where bUpdate.Id_Pasien == upd.Id_Pasien select bUpdate).FirstOrDefault(); if (PasienUpddate != null) { //PasienUpddate.Id_Pasien = upd.Id_Pasien; PasienUpddate.Tarif_total = upd.Tarif_total; //PasienUpddate.Id_Pasien = upd.Id_Pasien; context.SaveChanges(); } else { Console.WriteLine("no Update"); } }
private void button2_Click(object sender, EventArgs e) { try { Patient p = new Patient() { Id_Pasien = System.Convert.ToInt32(textBox1.Text) }; PeriksaController pc = new PeriksaController(); int hargaPeriksa = pc.TotalPeriksa(p); PasienController pac = new PasienController(); int hari = pac.HariKamar(p); RoomController rc = new RoomController(); int harga = rc.HargaKamar(p); int total = hargaPeriksa + (harga * hari); textBox2.Text = total.ToString(); Patient a = new Patient() { Id_Pasien = System.Convert.ToInt32(textBox1.Text), Tarif_total = System.Convert.ToInt32(textBox2.Text) }; //PasienController pc = new PasienController(); pac.updateTarifPasien(a); } catch (FormatException) { MessageBox.Show("Id Harus Terisi"); } }
public void TarifPasien() { //arrange int expectedHarga = 470012; Patient p = new Patient() { Id_Pasien = 2 }; PeriksaController pc = new PeriksaController(); int hargaPeriksa = pc.TotalPeriksa(p); PasienController pac = new PasienController(); int hari = pac.HariKamar(p); RoomController rc = new RoomController(); int harga = rc.HargaKamar(p); //act int total = hargaPeriksa + (harga * hari); //assert Assert.AreEqual(expectedHarga, total, "Should be: 470012"); }
private void button4_Click(object sender, EventArgs e) { try { Patient p = new Patient() { Id_Pasien = System.Convert.ToInt32(textBox2.Text), ID_Pegawai = System.Convert.ToInt32(textBox10.Text), Nama_Pasien = textBox9.Text, Penyakit = textBox9.Text, Jenis_pasien = comboBox3.Text, Golongan_Darah = comboBox2.Text, Jenis_Kelamin = comboBox1.Text, Tgl_Lahir = dateTimePicker2.Value, Alamat_Pasien = textBox4.Text, Kota_Pasien = textBox5.Text, No_KTP = System.Convert.ToInt32(textBox8.Text), No_Hp = System.Convert.ToInt32(textBox7.Text), Pekerjaan = textBox6.Text, Tgl_Masuk = dateTimePicker3.Value, Tgl_Keluar = dateTimePicker4.Value, ID_Room = System.Convert.ToInt32(textBox1.Text), Tarif_total = System.Convert.ToInt32(textBox11.Text) }; PasienController pc = new PasienController(); pc.updatePasien(p); } catch (FormatException fe) { MessageBox.Show("semua data harus terisi"); } }
private void button6_Click(object sender, EventArgs e) { try { Patient p = new Patient() { Id_Pasien = System.Convert.ToInt32(textBox2.Text), ID_Room = System.Convert.ToInt32(textBox1.Text) }; RoomController rc = new RoomController(); rc.updateFreeStatus(p); } catch (FormatException fe) { MessageBox.Show("Pilih Pasien yang akan dikeluarkan"); } }