private void Btnsearchreseridcheckout_Click(object sender, EventArgs e) { koneksi kon = new koneksi(); Data.Reservation dr = new Data.Reservation(); dr.No_reservasi = tbxreservationidcheckout.Text; try { if (new Controller.ClientReservation().searchreservid(dr)) { binding(); kon.openConnection(); dr.No_reservasi = tbxreservationidcheckout.Text; string query = "select date_in, date_out, checkin from tb_reservation where no_reservation='" + dr.No_reservasi + "'"; MySqlDataReader dre = kon.DataReader(query); dre.Read(); tbxdateincheckout.Text = dre["date_in"].ToString(); tbxdateoutcheckout.Text = dre["date_out"].ToString(); tbxcheckincheckout.Text = dre["checkin"].ToString(); kon.closeConnection(); } else { MessageBox.Show("Reservation ID belum terdaftar!"); } } catch (Exception ex) { MessageBox.Show("Masukan Reserv. ID"); } }
private void Btnsearchreservbilpay_Click(object sender, EventArgs e) { koneksi kon = new koneksi(); Data.Reservation dr = new Data.Reservation(); dr.No_reservasi = tbxreservationidbilpay.Text; try { if (new Controller.ClientReservation().searchreservid(dr)) { binding(); Data.Reservation drv = new Data.Reservation(); kon.openConnection(); drv.No_reservasi = tbxreservationidbilpay.Text; string query = "select billing, cara_bayar from tb_reservation where no_reservation='" + drv.No_reservasi + "'"; MySqlDataReader dre = kon.DataReader(query); dre.Read(); tbxbilling.Text = dre["billing"].ToString(); tbxcarabayarbilpay.Text = dre["cara_bayar"].ToString(); kon.closeConnection(); } else { MessageBox.Show("Reservation ID belum terdaftar!"); } } catch (Exception ex) { MessageBox.Show("Masukan Reserv. ID"); } }
public string generateKode() { string query = "Select Max(no_reservation) as ReservID from tb_reservation"; koneksi k = new koneksi(); k.openConnection(); MySqlDataReader dr = k.DataReader(query); dr.Read(); string kode = dr["ReservID"].ToString(); int angka; if (kode == "") { angka = 0; } else { angka = int.Parse(kode.Substring(3, 3)); } angka += 1; string id = "RV-" + (string.Format("{0:00}", angka.ToString().PadLeft(3, '0'))); k.closeConnection(); return(id); }
public void lemparidentity(string no_identity) { Data.Client dc = new Data.Client(); koneksi konek = new koneksi(); dc.No_identity = label6.Text; konek.openConnection(); string query = "select no_identity from tb_client where no_identity='" + no_identity + "'"; MySqlDataReader dr = konek.DataReader(query); dr.Read(); label6.Text = dr["no_identity"].ToString(); konek.closeConnection(); }