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