private void button3_Click(object sender, EventArgs e)
{
try
{
using (HospitalEntities context = new HospitalEntities())
{
int result = (int)(context.GetNewKamarId().FirstOrDefault());
if (result > -1)
{
Kamar p = new Kamar()
{
Id_Room = result,
Nama_Kamar = textBox2.Text,
Harga_Sewa = System.Convert.ToInt32(textBox5.Text),
Status_Kamar = System.Convert.ToByte(comboBox1.Text)
};
RoomController rc = new RoomController();
rc.addRoom(p);
}
}
}
catch (FormatException fe)
{
MessageBox.Show("Data Harus Terisi semua");
}
textBox1.Clear();
textBox2.Clear();
textBox5.Clear();
comboBox1.ResetText();
}
private void button3_Click(object sender, EventArgs e)
{
try
{
using (HospitalEntities context = new HospitalEntities())
{
int result = (int)(context.GetNewKamarId().FirstOrDefault());
if (result > -1)
{
Kamar p = new Kamar()
{
Id_Room = result,
Nama_Kamar = textBox2.Text,
Harga_Sewa = System.Convert.ToInt32(textBox5.Text),
Status_Kamar = System.Convert.ToByte(comboBox1.Text)
};
RoomController rc = new RoomController();
rc.addRoom(p);
}
}
}
catch (FormatException fe)
{
MessageBox.Show("Data Harus Terisi semua");
}
textBox1.Clear();
textBox2.Clear();
textBox5.Clear();
comboBox1.ResetText();
}
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 void Update(Kamar r)
{
Kamar updateRoom = (from b in context.Kamars
where b.Id_Room == r.Id_Room
select b).FirstOrDefault();
if (updateRoom != null)
{
//updateRoom.Id_Room = r.Id_Room;
updateRoom.Nama_Kamar = r.Nama_Kamar;
updateRoom.Harga_Sewa = r.Harga_Sewa;
updateRoom.Status_Kamar = r.Status_Kamar;
context.SaveChanges();
}
else
{
Console.WriteLine("No update");
}
}
public void Update(Kamar r)
{
Kamar updateRoom = (from b in context.Kamars
where b.Id_Room == r.Id_Room
select b).FirstOrDefault();
if (updateRoom != null)
{
//updateRoom.Id_Room = r.Id_Room;
updateRoom.Nama_Kamar = r.Nama_Kamar;
updateRoom.Harga_Sewa = r.Harga_Sewa;
updateRoom.Status_Kamar = r.Status_Kamar;
context.SaveChanges();
}
else
{
Console.WriteLine("No update");
}
}
public void Delete(int id)
{
try
{
Kamar roomDelete = context.Kamars.Find(id);
if (roomDelete != null)
{
context.Kamars.Remove(roomDelete);
context.SaveChanges();
}
else
{
Console.WriteLine("No delete");
}
}
catch (Exception ex)
{
Console.WriteLine("Error on deleting...");
Console.WriteLine(ex.InnerException.
InnerException.Message);
}
}
private void button4_Click(object sender, EventArgs e)
{
try
{
Kamar p = new Kamar()
{
Id_Room = System.Convert.ToInt32(textBox1.Text),
Nama_Kamar = textBox2.Text,
Harga_Sewa = System.Convert.ToInt32(textBox5.Text),
Status_Kamar = System.Convert.ToByte(comboBox1.Text)
};
RoomController rc = new RoomController();
rc.Update(p);
}
catch (FormatException fe)
{
MessageBox.Show("Data harus teriisi semua");
}
textBox1.Clear();
textBox2.Clear();
textBox5.Clear();
comboBox1.ResetText();
}
private void button4_Click(object sender, EventArgs e)
{
try
{
Kamar p = new Kamar()
{
Id_Room = System.Convert.ToInt32(textBox1.Text),
Nama_Kamar = textBox2.Text,
Harga_Sewa = System.Convert.ToInt32(textBox5.Text),
Status_Kamar = System.Convert.ToByte(comboBox1.Text)
};
RoomController rc = new RoomController();
rc.Update(p);
}
catch (FormatException fe)
{
MessageBox.Show("Data harus teriisi semua");
}
textBox1.Clear();
textBox2.Clear();
textBox5.Clear();
comboBox1.ResetText();
}
public void addRoom(Kamar room)
{
context.Kamars.Add(room);
context.SaveChanges();
}
public void addRoom(Kamar room)
{
context.Kamars.Add(room);
context.SaveChanges();
}
