public int inputcheckout() { bool stat = false; int v = 0; DateTime checkin = DateTime.Now; checkin = dtcheckoutcheckout.Value; koneksi kon = new koneksi(); Data.Reservation dre = new Data.Reservation(); dre.Check_out = dtcheckoutcheckout.Value.ToString("yyyy-MM-dd hh:mm:ss"); dre.Check_in = tbxcheckincheckout.Text; dre.No_reservasi = tbxreservationidcheckout.Text; try { //MySqlCommand cmd = new MySqlCommand("update tb_reservation set check_in='" + dre.Check_in + "' where no_reservation='" + dre.No_reservasi + "'", conn); //checkin = Convert.ToDateTime(tbxcheckinadmin.Text); kon.openConnection(); string query = "update tb_reservation set checkout='" + dre.Check_out + "' where no_reservation='" + dre.No_reservasi + "'"; kon.ExecuteQueries(query); v = 1; kon.closeConnection(); } catch (Exception ex) { } return(v); }
private void Btnbsysrreserv_Click(object sender, EventArgs e) { bool stat = false; Data.Reservation dr = new Data.Reservation(); try { if (Convert.ToInt32(tbxpembayaranbilpay.Text) > Convert.ToInt32(tbxbilling.Text)) { dr.No_reservasi = tbxreservationidbilpay.Text; dr.Pembayaran = Convert.ToInt32(tbxpembayaranbilpay.Text); dr.Kembali = Convert.ToInt32(tbxkembalianbilpay.Text); dr.Keterangan = tbxketeranganbilpay.Text; koneksi kon = new koneksi(); kon.openConnection(); string query = "update tb_reservation set pembayaran='" + dr.Pembayaran + "', kembalian='" + dr.Kembali + "', keterangan='" + dr.Keterangan + "' where no_reservation='" + dr.No_reservasi + "'"; kon.ExecuteQueries(query); stat = true; kon.closeConnection(); MessageBox.Show("Pembayaran berhasil!"); binding(); } else { MessageBox.Show("Uang anda tidak mencukupi!"); } } catch (Exception ex) { MessageBox.Show("Anda belum memasukan nominal pembayaran"); } }
public bool readbilpay() { bool stat = false; koneksi kon = new koneksi(); try { kon.openConnection(); string query = "select * from tb_reservation where client_id='" + label6 + "' and keterangan=Belum Lunas"; kon.ExecuteQueries(query); stat = true; kon.closeConnection(); } catch (Exception ex) { } return(stat); }