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 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(); }
public void addRoom(Kamar room) { context.Kamars.Add(room); context.SaveChanges(); }