private void pictSave_Click(object sender, EventArgs e)
{
string noktpText = boxKtp.Text.ToString();
string namaPmsnText = cmbBoxNama.Text.ToString();
string emailText = boxEmail.Text.ToString();
string tlpText = boxTelp.Text.ToString();
string JnsRntalText = cmbJnisSound.Text.ToString();
string almtText = boxAlmt.Text.ToString();
string hargaText = boxHrg.Text.ToString();
string TglText = boxDateTgl.Text.ToString();
DialogResult rs = MessageBox.Show("Apakah anda yakin ingin menghapus?", "Peringatan!", MessageBoxButtons.YesNo);
if (rs == DialogResult.Yes)
{
string namaText = cmbBoxNama.SelectedItem.ToString();
admin cre = new admin();
cre.delete(namaText);
MessageBox.Show("Pesanan anda berhasil dihapus");
Menu_Admin balik = new Menu_Admin();
this.Hide();
balik.ShowDialog();
this.Close();
}
else
{
MessageBox.Show("Silahkan pilih Data yang akan dihapus");
}
}
private void btnPictBack_Click(object sender, EventArgs e)
{
Menu_Admin balik = new Menu_Admin();
this.Hide();
balik.ShowDialog();
this.Close();
}
private void btnLogin_Click(object sender, EventArgs e)
{
if (BoxUser.Text == "")
{
MessageBox.Show("username harus diisi!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
BoxUser.Focus();
return;
}
if (BoxPass.Text == "")
{
MessageBox.Show("password harus diisi!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
BoxPass.Focus();
return;
}
try
{
SqlConnection con = new SqlConnection();
con.ConnectionString = "Data Source=ASUS-X555U-TDC;Initial Catalog=Rental-sound;User ID=sa;Password=1976";
con.Open();
string query = ("select * from Register where username = '******' and password = '******'");
SqlDataAdapter sda = new SqlDataAdapter(query, con);
DataTable dtbl = new DataTable();
sda.Fill(dtbl);
string queryadmin = ("select * from LoginAdmin where username = '******' and password = '******'");
SqlDataAdapter admin = new SqlDataAdapter(queryadmin, con);
DataTable dataadmin = new DataTable();
admin.Fill(dataadmin);
if (dtbl.Rows.Count == 1)
{
MessageBox.Show("Login Sukses");
MENU go = new MENU();
this.Hide();
go.ShowDialog();
this.Close();
}
else if (dataadmin.Rows.Count == 1)
{
MessageBox.Show("Login Admin Sukses");
Menu_Admin go = new Menu_Admin();
this.Hide();
go.ShowDialog();
this.Close();
}
else
{
MessageBox.Show("Username atau password salah!");
}
}
catch (SqlException f)
{
Console.WriteLine(f.Message);
}
}