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");
}
}
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 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");
}
}
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");
}
}
private void Btnloginfrmlogin_Click(object sender, EventArgs e)
{
koneksi kon = new koneksi();
Data.Client dc = new Data.Client();
dc.No_identity = tbxnoidentitylogin.Text;
dc.Phone = tbxphonelogin.Text;
kon.openConnection();
string query = "select no_identity, phone from tb_client where no_identity='" + dc.No_identity + "' and phone='" + dc.Phone + "'";
if (kon.loginreader(query) == 1)
{
Client_Menu cp = new Client_Menu();
MessageBox.Show("'" + dc.No_identity + "' Login berhasil!");
cp.Show();
cp.lemparidentity(tbxnoidentitylogin.Text);
this.Hide();
}
else if (tbxnoidentitylogin.Text == "admin" && tbxphonelogin.Text == "admin")
{
Menu mn = new Menu();
MessageBox.Show("Login sebagai admin berhasil!");
mn.Show();
this.Hide();
}
else if (tbxnoidentitylogin.Text == "" && tbxphonelogin.Text == "")
{
MessageBox.Show("Masukan No. Identity dan Phone!");
}
else
{
MessageBox.Show("No. Identity atau Phone salah!");
}
kon.closeConnection();
}
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 linkcbx()
{
koneksi kon = new koneksi();
kon.openConnection();
adapter = new MySqlDataAdapter("select type_room from tb_room order by room_id asc", conn);
DataTable dt = new DataTable();
adapter.Fill(dt);
tbxroomtypefrmroom.DisplayMember = "type_room";
tbxroomtypefrmroom.DataSource = dt;
kon.closeConnection();
}
public void pilihtipe()
{
Data.Reservation dr = new Data.Reservation();
koneksi kon = new koneksi();
kon.openConnection();
string query = "select price_room from tb_room where type_room = '" + cbxroomtypereserv.Text + "'";
MySqlDataReader dre = kon.DataReader1(query);
dre.Read();
tbxroompricereserv.Text = dre["price_room"].ToString();
kon.closeConnection();
}
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();
}
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);
}
public void checkid()
{
bool stat = false;
Data.Client dc = new Data.Client();
koneksi kon = new koneksi();
dc.No_identity = tbxnoidentityregis.Text;
kon.openConnection();
string query = "select no_identity from tb_client where no_identity = '" + dc.No_identity + "'";
if (kon.checkidreader(query) == 1)
{
lblcheckidclient.Text = "'" + tbxnoidentityregis.Text + "' sudah terpakai!";
}
else
{
lblcheckidclient.Text = "'" + tbxnoidentityregis.Text + "' bisa digunakan!";
}
kon.closeConnection();
//return stat;
}