public void CoBox()
{
String q, f;
q = "SELECT * FROM tbl_barang";
f = "NamaBarang";
qr.ShowBox(q, f, cb);
}
public UserData()
{
InitializeComponent();
Kelas.Query qr = new Kelas.Query();
String q = "SELECT * FROM users WHERE users.UseId=detail.UseId";
qr.ShowAll(q, "users", dg_user);
dg_user.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
dg_user.AllowUserToAddRows = false;
dg_user.Refresh();
qr.ShowBox(q, "UseId", cb1);
}
public TransactionReport()
{
InitializeComponent();
SetLabel();
qr.ShowBox("SELECT * FROM TypeKamar", "NamaTypeKamar", rt);
qr.ShowRep("select a.TglPemesanan,b.TglPembayaran ,b.TotalPembayaran from Pemesanan a,Pembayaran b,TypeKamar c,Kamar d where b.IDPemesanan=a.IDPemesanan and a.IDKamar=d.IDKamar and d.IDTypeKamar=c.IDTypeKamar", "All", chart1);
qr.ShowRep("select a.TglPemesanan,b.TglPembayaran ,b.TotalPembayaran from Pemesanan a,Pembayaran b,TypeKamar c,Kamar d where b.IDPemesanan=a.IDPemesanan and a.IDKamar=d.IDKamar and d.IDTypeKamar=c.IDTypeKamar and c.NamaTypeKamar='Standar'", "Standar", chart1);
qr.ShowRep("select a.TglPemesanan,b.TglPembayaran ,b.TotalPembayaran from Pemesanan a,Pembayaran b,TypeKamar c,Kamar d where b.IDPemesanan=a.IDPemesanan and a.IDKamar=d.IDKamar and d.IDTypeKamar=c.IDTypeKamar and c.NamaTypeKamar='Super'", "Super", chart1);
qr.ShowRep("select a.TglPemesanan,b.TglPembayaran ,b.TotalPembayaran from Pemesanan a,Pembayaran b,TypeKamar c,Kamar d where b.IDPemesanan=a.IDPemesanan and a.IDKamar=d.IDKamar and d.IDTypeKamar=c.IDTypeKamar and c.NamaTypeKamar='Deluxe Room'", "Deluxe", chart1);
qr.ShowRep("select a.TglPemesanan,b.TglPembayaran ,b.TotalPembayaran from Pemesanan a,Pembayaran b,TypeKamar c,Kamar d where b.IDPemesanan=a.IDPemesanan and a.IDKamar=d.IDKamar and d.IDTypeKamar=c.IDTypeKamar and c.NamaTypeKamar='Superior Room'", "Deluxe", chart1);
qr.ShowRep("select a.TglPemesanan,b.TglPembayaran ,b.TotalPembayaran from Pemesanan a,Pembayaran b,TypeKamar c,Kamar d where b.IDPemesanan=a.IDPemesanan and a.IDKamar=d.IDKamar and d.IDTypeKamar=c.IDTypeKamar and c.NamaTypeKamar='Excekutif Room'", "Excekutif", chart1);
}
public Employee()
{
InitializeComponent();
qr = new Kelas.Query();
String q = "SELECT * from Employee";
tampil(q);
qr.ShowBox("SELECT * FROM Job", "Name", cm_job);
clear();
button(1);
id.Visible = false;
}
public void Box()
{
qr.ShowBox("SELECT * FROM TypeKamar", "NamaTypeKamar", rt);
qr.ShowBox("SELECT * FROM JenisPemesanan", "NamaJenisPemesanan", rt2);
qr.ShowBox("SELECT * FROM FasilitasTambahan", "NamaFailitasTambahan", af);
qr.ShowBox("select NamaPenghuni+' - '+Email as 'n' from Penghuni", "n", nm);
}
public void Box()
{
qr.ShowBox("SELECT * FROM TypeKamar", "NamaTypeKamar", rmtyp);
}
public void Box()
{
qr.ShowBox("SELECT * FROM TypeKamar", "NamaTypeKamar", rm);
qr.ShowBox("SELECT * FROM Fasilitas", "NamaFasilitas", fn);
}
public void Box()
{
qr.ShowBox("SELECT * FROM Kamar", "NomorKamar", rm);
}
public void Box()
{
qr.ShowBox("SELECT * FROM TypeKendaraan", "NamaTypeKendaraan", vt);
}
public void Box()
{
qr.ShowBox("SELECT * FROM Pemesanan", "IDPemesanan", bk);
}
