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();
}
