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