public String GetQuery(int opsi) { String id, q, idrm, jm, sr; idrm = qr.GetData("SELECT * FROM TypeKamar Where NamaTypeKamar='" + rm.Text + "'", "IDTypeKamar"); id = qr.GetData("SELECT * FROM Fasilitas Where NamaFasilitas='" + fn.Text + "'", "IDFasilitas"); jm = jml.Text; sr = tsrc.Text; if (opsi == 1)//insert { q = "INSERT INTO FasilitasBerdasarkanTypeKamar Values('" + idrm + "','" + id + "','" + jm + "')"; } else if (opsi == 3)//select { q = "select TypeKamar.IDTypeKamar,Fasilitas.IDFasilitas,TypeKamar.NamaTypeKamar,Fasilitas.NamaFasilitas,FasilitasBerdasarkanTypeKamar.JumlahFasilitas FROM FasilitasBerdasarkanTypeKamar,Fasilitas,TypeKamar where FasilitasBerdasarkanTypeKamar.IDFasilitas=Fasilitas.IDFasilitas and FasilitasBerdasarkanTypeKamar.IDTypeKamar=TypeKamar.IDTypeKamar"; } else if (opsi == 4)//serch { q = "select TypeKamar.IDTypeKamar,Fasilitas.IDFasilitas,TypeKamar.NamaTypeKamar,Fasilitas.NamaFasilitas,FasilitasBerdasarkanTypeKamar.JumlahFasilitas FROM FasilitasBerdasarkanTypeKamar,Fasilitas,TypeKamar,Kamar where FasilitasBerdasarkanTypeKamar.IDFasilitas=Fasilitas.IDFasilitas and FasilitasBerdasarkanTypeKamar.IDTypeKamar=TypeKamar.IDTypeKamar and Kamar.IDTypeKamar=TypeKamar.IDTypeKamar and TypeKamar.NamaTypeKamar like '%" + sr + "%' OR TypeKamar.IDTypeKamar like '%" + sr + "%' OR kamar.NomorKamar like '%" + sr + "%'"; } else//delete { q = "DELETE FROM FasilitasBerdasarkanTypeKamar Where IDFasilitas='" + id + "'"; } return(q); }
public String GetQuery(int opsi) { String q, id, mn, rid, lf, sr; rid = rmid.Text; mn = rmn.Text; lf = fl.Text; sr = tsrc.Text; id = qr.GetData("SELECT * FROM TypeKamar Where NamaTypeKamar='" + rmtyp.Text + "'", "IDTypeKamar"); if (opsi == 1)//insert { q = "INSERT INTO Kamar Values('" + mn + "','" + lf + "','" + id + "')"; } else if (opsi == 2)//update { q = "UPDATE Kamar SET NomorKamar='" + mn + "',Lantai='" + lf + "',IDTypeKamar='" + id + "'"; } else if (opsi == 3)//select { q = "SELECT Kamar.IDKamar as 'Id',Kamar.NomorKamar as 'Nomor',Kamar.Lantai as 'Lantai',TypeKamar.NamaTypeKamar as 'Tipe' from Kamar,TypeKamar where Kamar.IDTypeKamar=TypeKamar.IDTypeKamar"; } else if (opsi == 4)//serch { q = "SELECT Kamar.IDKamar as 'Id',Kamar.NomorKamar as 'Nomor',Kamar.Lantai as 'Lantai',TypeKamar.NamaTypeKamar as 'Tipe' from Kamar,TypeKamar where Kamar.IDTypeKamar=TypeKamar.IDTypeKamar and Kamar.NomorKamar like '%" + sr + "%' OR TypeKamar.NamaTypeKamar like '%" + sr + "%' OR Kamar.IDKamar like '%" + sr + "%'"; } else//delete { q = "DELETE FROM Kamar Where IDKamar='" + rid + "'"; } return(q); }
public String GetQuery(int opsi) { String q, id, id2, pb, pr, sr; sr = tsrc.Text; pb = bp.Text; pr = rp.Text; id = qr.GetData("SELECT * FROM TypeKamar Where NamaTypeKamar='" + rmtyp.Text + "'", "IDTypeKamar"); id2 = qr.GetData("SELECT * FROM TypeHari Where NamaTypeHari='" + dytyp.Text + "'", "IDTypeHari"); if (opsi == 1)//insert { q = "INSERT INTO HargaKamar Values('" + id + "','" + id2 + "','" + pr + "','" + pb + "')"; } else if (opsi == 2)//update { q = "UPDATE HargaKamar SET IDTypeKamar='" + id + "',IDTypeHari='" + id2 + "',HargaKamar='" + pr + "',HargaSarapan='" + pb + "'"; } else if (opsi == 3)//select { q = "SELECT a.IDHargaKamar,b.NamaTypeKamar,d.NamaTypeHari,a.HargaKamar,a.HargaSarapan from HargaKamar a,TypeKamar b,TypeHari d where a.IDTypeKamar=b.IDTypeKamar and a.IDTypeHari=d.IDTypeHari"; } else if (opsi == 4)//serch { q = "SELECT distinct a.IDHargaKamar,b.NamaTypeKamar,d.NamaTypeHari,a.HargaKamar,a.HargaSarapan from HargaKamar a,TypeKamar b,Kamar c,TypeHari d where a.IDTypeKamar=b.IDTypeKamar and c.IDTypeKamar=b.IDTypeKamar and a.IDTypeHari=d.IDTypeHari and b.NamaTypeKamar like '%" + sr + "%' or c.Lantai like '%+" + sr + "%' OR c.NomorKamar like '%" + sr + "%' OR b.IDTypeKamar like '%" + sr + "%'"; } else//delete { q = "DELETE FROM HargaKamar Where IDTypeKamar='" + id + "'"; } Console.WriteLine(q); return(q); }
public String GetQuery(int opsi) { String q, id, td, td2, rp, sr, rid; sr = tsrc.Text; td = dt1.Text; td2 = dt2.Text; rp = pr.Text; rid = label8.Text; id = qr.GetData("SELECT * FROM TypeKamar Where NamaTypeKamar='" + rmtyp.Text + "'", "IDTypeKamar"); if (opsi == 1)//insert { q = "INSERT INTO HargaFluktuatif Values('" + id + "','" + rp + "','" + td + "','" + td2 + "')"; } else if (opsi == 2)//update { q = "UPDATE HargaFluktuatif set IDTypeKamar='" + id + "',Persentase='" + rp + "',TglMulai='" + td + "',TglSelesai='" + td2 + "' where IDHargaFluktuatif='" + rid + "'"; } else if (opsi == 3)//select { q = "select distinct c.IDHargaFluktuatif,a.NamaTypeKamar,b.HargaKamar,c.Persentase,b.HargaKamar+b.HargaSarapan as 'Final Price',c.TglMulai,c.TglSelesai from TypeKamar a,HargaKamar b,HargaFluktuatif c where c.IDTypeKamar=a.IDTypeKamar and b.IDTypeKamar=c.IDTypeKamar"; } else if (opsi == 4)//serch { q = "select distinct c.IDHargaFluktuatif,a.NamaTypeKamar,b.HargaKamar,c.Persentase,b.HargaKamar + b.HargaSarapan as 'Final Price',c.TglMulai,c.TglSelesai from TypeKamar a, HargaKamar b,HargaFluktuatif c, Kamar d where c.IDTypeKamar = a.IDTypeKamar and b.IDTypeKamar = c.IDTypeKamar and d.IDKamar = a.IDTypeKamar and d.NomorKamar like '%" + sr + "%' or d.Lantai like '%" + sr + "%' or a.IDTypeKamar like '%" + sr + "%'"; } else//delete { q = "DELETE FROM Kamar Where IDKamar='" + rid + "'"; } Console.WriteLine(q); return(q); }
public String GetQuery(int opsi) { String td, idd, q, idrm, dt1, sr; idrm = qr.GetData("SELECT * FROM Kamar Where NomorKamar='" + rm.Text + "'", "IDKamar"); td = dt.Text; dt1 = dt2.Text; idd = label8.Text; sr = tsrc.Text; if (opsi == 1)//insert { q = "INSERT INTO PerbaikanKamar Values('" + idrm + "','" + td + "','" + dt1 + "','" + not.Text + "','" + label9.Text + "')"; Console.WriteLine(q); } else if (opsi == 3)//select { q = "select c.IDPerbaikanKamar as 'ID', a.NamaTypeKamar as 'Type',b.NomorKamar as 'No Kamar',b.Lantai,c.TglMulai,c.TglSelesai,d.NamaKariawan,c.Catatan from TypeKamar a,Kamar b,PerbaikanKamar c,Kariawan d where a.IDTypeKamar=b.IDTypeKamar and c.IDKamar=b.IDKamar and c.IDKariawan=d.IDKariawan"; } else if (opsi == 4)//serch { q = "select c.IDPerbaikanKamar as 'ID', a.NamaTypeKamar as 'Type',b.NomorKamar as 'No Kamar',b.Lantai,c.TglMulai,c.TglSelesai,d.NamaKariawan,c.Catatan from TypeKamar a, Kamar b,PerbaikanKamar c, Kariawan d where a.IDTypeKamar = b.IDTypeKamar and c.IDKamar = b.IDKamar and c.IDKariawan = d.IDKariawan and a.NamaTypeKamar like '%" + sr + "%' OR b.Lantai like '%" + sr + "%' OR b.NomorKamar like '%" + sr + "%' OR b.IDKamar like '%" + sr + "%'"; } else//delete { q = "DELETE FROM PerbaikanKamar Where IDPerbaikanKamar='" + idd + "'"; } Console.WriteLine(q); return(q); }
public void Showid() { String id; id = qr.GetData("SELECT * FROM TypeKamar Order by IDTypeKamar desc", "IDTypeKamar"); int inid = int.Parse(id) + 1; rmid.Text = inid.ToString(); }
public void Showid() { String id; id = qr.GetData("SELECT * FROM Kariawan Order by IDKariawan desc", "IDKariawan"); int inid = int.Parse(id) + 1; empid.Text = inid.ToString(); }
private void button1_Click(object sender, EventArgs e) { if (psw.Text != "" && user.Text != "") { if (qr.GetData(GetQuery(), "IDKariawan") != null) { String id = qr.GetData(GetQuery(), "IDKariawan"); MainForm mn = new MainForm(); mn.Show(); mn.idk.Text = id; mn.logout.Enabled = false; this.Hide(); } else { MessageBox.Show("Please Try Again, Your Data Is not Valid!", "INFO", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { MessageBox.Show("Fild not null!", "INFO", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public String GetQuery(int opsi) { String q, id, mn, me, ci, np, nl, tv, idp, sr; mn = nm.Text; me = em.Text; ci = ic.Text; np = pn.Text; nl = ln.Text; tv = vt.Text; id = qr.GetData("SELECT * FROM TypeKendaraan Where NamaTypeKendaraan='" + tv + "'", "IDTypeKendaraan"); q = "INSERT INTO Penghuni Values('" + mn + "','" + ci + "','" + me + "','" + np + "','" + nl + "','" + id + "')"; return(q); }
private void button1_Click(object sender, EventArgs e) { if (psw.Text != "" && old.Text != "" && confirm.Text != "") { if (qr.GetData(GetQuery(1), "IDKariawan") != null) { if (psw.Text == confirm.Text) { qr.InUpDel(GetQuery(2), "Password is Change!"); } else { MessageBox.Show("Password Not Match!"); } } else { MessageBox.Show("Your Password Not registed!"); } } }
public String GetQuery(int opsi) { String q, id, mn, me, ci, np, nl, tv, idp, sr; mn = nm.Text; me = em.Text; ci = ic.Text; np = pn.Text; nl = ln.Text; sr = tsrc.Text; tv = vt.Text; idp = idd.Text; id = qr.GetData("SELECT * FROM TypeKendaraan Where NamaTypeKendaraan='" + tv + "'", "IDTypeKendaraan"); if (opsi == 1)//insert { q = "INSERT INTO Penghuni Values('" + mn + "','" + ci + "','" + me + "','" + np + "','" + nl + "','" + id + "')"; } else if (opsi == 2)//update { q = "UPDATE Penghuni SET NamaPenghuni='" + mn + "',NomorKTP='" + ci + "',Email='" + me + "',NomorHP='" + np + "',PlatNoKendaraan='" + nl + "',IDTypeKendaraan='" + id + "' where IDPenghuni='" + idp + "'"; } else if (opsi == 3)//select { q = "SELECT Penghuni.IDPenghuni as 'Id',Penghuni.NamaPenghuni as 'Nama',Penghuni.NomorKTP as 'KTP',Penghuni.Email,Penghuni.NomorHP as 'Nomor HP',Penghuni.PlatNoKendaraan as 'Nomor Kendaraan',TypeKendaraan.NamaTypeKendaraan as 'Kendaraan' from Penghuni,TypeKendaraan where Penghuni.IDTypeKendaraan=TypeKendaraan.IDTypeKendaraan"; } else if (opsi == 4)//serch { q = "SELECT Penghuni.IDPenghuni as 'Id',Penghuni.NamaPenghuni as 'Nama',Penghuni.NomorKTP as 'KTP',Penghuni.Email,Penghuni.NomorHP as 'Nomor HP',Penghuni.PlatNoKendaraan as 'Nomor Kendaraan',TypeKendaraan.NamaTypeKendaraan as 'Kendaraan' from Penghuni,TypeKendaraan where Penghuni.IDTypeKendaraan=TypeKendaraan.IDTypeKendaraan and Penghuni.NamaPenghuni like '%" + sr + "%' OR Penghuni.Email like '%" + sr + "%' OR Penghuni.NomorHP like '%" + sr + "%'"; } else//delete { q = "DELETE FROM Penghuni Where IDPenghuni='" + idp + "'"; } return(q); }
private void nm_SelectedIndexChanged(object sender, EventArgs e) { gid.Text = qr.GetData("select * FROM penghuni where NamaPenghuni+' - '+Email='" + nm.Text + "'", "IDPenghuni"); }
private void bk_SelectedIndexChanged(object sender, EventArgs e) { bl.Text = qr.GetData("select Pemesanan.HargaPerMalam*Pemesanan.LamaTinggal+HargaKamar.HargaKamar+HargaKamar.HargaSarapan*Pemesanan.LamaTinggal+PemesananDetil.JumlahFasilitasTambahan as 'Harga Bayar' from Pemesanan,Kamar,TypeKamar,HargaKamar,PemesananDetil where Pemesanan.IDKamar=Kamar.IDKamar and Kamar.IDTypeKamar=TypeKamar.IDTypeKamar and HargaKamar.IDTypeKamar=Kamar.IDKamar and PemesananDetil.IDPemesanan=Pemesanan.IDPemesanan and Pemesanan.IDPemesanan='" + bk.Text + "'", "Harga Bayar"); }