public CompositeType booking(DateTime tanggal_check_in, DateTime tanggal_check_out, string nama, int idKamar)
{
hotel_mawar_melatiEntities2 hotel = new hotel_mawar_melatiEntities2();
kamar km = hotel.kamar.Find(idKamar);
int total = 0;
int hargaBiasa = km.harga_hari_biasa;
int hargaPekan = km.harga_akhir_pekan;
for (DateTime x = tanggal_check_in; x <= tanggal_check_out; x = x.AddDays(1))
{
if (x.DayOfWeek.ToString() == "Saturday" || x.DayOfWeek.ToString() == "Sunday")
{
total = total + hargaPekan;
}
else
{
total = total + hargaBiasa;
}
}
km.jumlah_tersedia = km.jumlah_tersedia - 1;
hotel.SaveChanges();
pemesanan pesan = new pemesanan();
pesan.id_kamar = idKamar;
pesan.nama_pemesan = nama;
pesan.tanggal_booking = DateTime.Now;
pesan.tanggal_check_in = tanggal_check_in;
pesan.tanggal_check_out = tanggal_check_out;
pesan.total_harga = total;
string path = Path.GetRandomFileName();
path = path.Replace(".", "");
pesan.kode_booking = path;
hotel.pemesanan.Add(pesan);
hotel.SaveChanges();
CompositeType rt = new CompositeType();
rt.kodeBooking = pesan.kode_booking;
rt.id = pesan.id;
return(rt);
}
// PUT: api/Kamar/5
public IHttpActionResult Put(int id, [FromBody] kamar value)
{
using (var db = new OcphDbContext())
{
try
{
var updated = db.Kamar.Update(x => new { x.Keterangan, x.Lantai, x.NomorKamar, x.Status }, value, x => x.IdKamar == value.IdKamar);
if (updated)
{
return(Ok(value));
}
throw new SystemException("Data Tidak Tersimpan");
}
catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}
}
// POST: api/Penghuni
public IHttpActionResult Post([FromBody] kamar value)
{
using (var db = new OcphDbContext())
{
try
{
value.IdKamar = db.Kamar.InsertAndGetLastID(value);
if (value.IdKamar > 0)
{
return(Ok(value));
}
throw new SystemException("Data Tidak Tersimpan");
}
catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}
}
public List <kamar> getKamar()
{
List <kamar> kamars = new List <kamar>();
kamar tmp = new kamar();
hotel_mawar_melatiEntities2 hotel = new hotel_mawar_melatiEntities2();
IEnumerable <kamar> daftar = from p in hotel.kamar select p;
foreach (var k in daftar)
{
tmp = new kamar();
tmp.id = k.id;
tmp.kategori = k.kategori;
tmp.jumlah_tersedia = k.jumlah_tersedia;
tmp.harga_akhir_pekan = k.harga_akhir_pekan;
tmp.harga_hari_biasa = k.harga_hari_biasa;
tmp.free_wifi = k.free_wifi;
tmp.free_breakfast = k.free_breakfast;
tmp.jumlah_guest = k.jumlah_guest;
kamars.Add(tmp);
}
return(kamars);
}
