private void buttonUbah_Click(object sender, EventArgs e) { try { if (string.IsNullOrEmpty(txtCari.Text.Trim())) { MessageBox.Show("Text Pencarian Kosong"); throw null; } if (string.IsNullOrEmpty(comboBoxUkuran.Text.Trim())) { MessageBox.Show("Ukuran Kosong"); throw null; } if (string.IsNullOrEmpty(comboBoxJenisHewan.Text.Trim())) { MessageBox.Show("Jenis Hewan Kosong"); throw null; } if (string.IsNullOrEmpty(txtNamaLayanan.Text.Trim())) { MessageBox.Show("Nama Layanan Kosong"); throw null; } if (!Regex.Match(txtNamaLayanan.Text, @"^[a-zA-Z]+$").Success) { MessageBox.Show("Nama Hewan Tidak Boleh Mengandung Angka"); throw null; } if (string.IsNullOrEmpty(txtHargaLayanan.Text.Trim())) { MessageBox.Show("Harga Layanan Kosong"); throw null; } var list = new LayananControl(); ValidateNumberOnly(txtHargaLayanan.Text); layanan = new Layanan(comboBoxUkuran.Text, comboBoxJenisHewan.Text, FormLogin.id_pegawai, txtNamaLayanan.Text, Int32.Parse(txtHargaLayanan.Text)); list.UpdateLayanan(layanan, txtCari.Text); txtNamaLayanan.Enabled = false; txtHargaLayanan.Enabled = false; comboBoxUkuran.Enabled = false; comboBoxJenisHewan.Enabled = false; MessageBox.Show("Data Berhasil Diubah"); buttonUbah.Enabled = false; } catch (NumberOnlyException ex) { Console.WriteLine(ex.ToString()); } catch (Exception ex) { Console.WriteLine(ex.ToString()); } }
private void buttonTampilLayanan_Click(object sender, EventArgs e) { txtCari.Enabled = true; btnCari.Enabled = true; stat = "layanan"; var ctrl = new LayananControl(); dataGridViewTampil.DataSource = ctrl.ShowLayanan(); for (int i = 0; i < dataGridViewTampil.Columns.Count; i++) { string str = dataGridViewTampil.Columns[i].HeaderText; if (str == "Ukuran" || str == "JenisHewan") { dataGridViewTampil.Columns[i].Visible = false; } } }
private void buttonHapus_Click(object sender, EventArgs e) { try { if (string.IsNullOrEmpty(txtCari.Text.Trim())) { MessageBox.Show("Text Pencarian Kosong"); throw null; } var list = new LayananControl(); list.DeleteLayanan(txtCari.Text); MessageBox.Show("Data Berhasil Dihapus"); buttonHapus.Enabled = false; } catch (Exception ex) { Console.WriteLine(ex.ToString()); } }
private void btnCari_Click(object sender, EventArgs e) { var list = new LayananControl(); try { if (txtCari.Text != null && list.SearchLayanan(txtCari.Text) != null) { buttonUbah.Enabled = true; layanan = list.SearchLayanan(txtCari.Text); txtNamaLayanan.Text = layanan.Nama_Layanan; txtHargaLayanan.Text = System.Convert.ToString(layanan.Harga_Layanan); string connStr = "datasource=127.0.0.1;port=3306;username=root;password=;database=kouvee;Convert Zero Datetime=True;"; MySqlConnection conn = new MySqlConnection(connStr); string sqlukuran = "SELECT * FROM ukuran WHERE ID_UKURAN = '" + layanan.ID_Ukuran + "';"; string sqljenishewan = "SELECT * FROM jenis_hewan WHERE ID_JENISHEWAN = '" + layanan.ID_JenisHewan + "';"; conn.Open(); try { MySqlCommand cmd1 = new MySqlCommand(sqlukuran, conn); MySqlDataReader result1 = cmd1.ExecuteReader(); if (result1 != null) { while (result1.Read()) { comboBoxUkuran.Text = result1.GetString("Ukuran"); } } } catch (Exception ex) { Console.WriteLine("Failed to read..."); Console.WriteLine(ex.ToString()); } conn.Close(); conn.Open(); try { MySqlCommand cmd2 = new MySqlCommand(sqljenishewan, conn); MySqlDataReader result2 = cmd2.ExecuteReader(); if (result2 != null) { while (result2.Read()) { comboBoxJenisHewan.Text = result2.GetString("Jenishewan"); } } } catch (Exception ex) { Console.WriteLine("Failed to read..."); Console.WriteLine(ex.ToString()); } conn.Close(); txtNamaLayanan.Enabled = true; txtHargaLayanan.Enabled = true; comboBoxUkuran.Enabled = true; comboBoxJenisHewan.Enabled = true; } else { MessageBox.Show("Pencarian Tidak Ditemukan"); throw null; } } catch (Exception ex) { Console.WriteLine(ex.ToString()); } }
private void btnCari_Click(object sender, EventArgs e) { try { if (string.IsNullOrEmpty(txtCari.Text.Trim())) { MessageBox.Show("Text Pencarian Kosong"); throw null; } if (stat == "customer") { var ctrl = new CustomerControl(); if (ctrl.SearchCustomer(txtCari.Text) == null) { MessageBox.Show("Pencarian Tidak Ditemukan"); throw null; } else { List <Customer> CustomerList = new List <Customer>(); CustomerList.Add(ctrl.SearchCustomer(txtCari.Text)); dataGridViewTampil.DataSource = CustomerList; } } else if (stat == "hewan") { var ctrl = new HewanControl(); if (ctrl.SearchHewan(txtCari.Text) == null) { MessageBox.Show("Pencarian Tidak Ditemukan"); throw null; } else { List <Hewan> HewanList = new List <Hewan>(); HewanList.Add(ctrl.SearchHewan(txtCari.Text)); dataGridViewTampil.DataSource = HewanList; } } else if (stat == "jenishewan") { var ctrl = new JenisHewanControl(); if (ctrl.SearchJenisHewan(txtCari.Text) == null) { MessageBox.Show("Pencarian Tidak Ditemukan"); throw null; } else { List <JenisHewan> JenisHewanList = new List <JenisHewan>(); JenisHewanList.Add(ctrl.SearchJenisHewan(txtCari.Text)); dataGridViewTampil.DataSource = JenisHewanList; } } else if (stat == "layanan") { var ctrl = new LayananControl(); if (ctrl.SearchLayanan(txtCari.Text) == null) { MessageBox.Show("Pencarian Tidak Ditemukan"); throw null; } else { List <Layanan> LayananList = new List <Layanan>(); LayananList.Add(ctrl.SearchLayanan(txtCari.Text)); dataGridViewTampil.DataSource = LayananList; } } else if (stat == "pegawai") { var ctrl = new PegawaiControl(); if (ctrl.SearchPegawai(txtCari.Text) == null) { MessageBox.Show("Pencarian Tidak Ditemukan"); throw null; } else { List <Pegawai> PegawaiList = new List <Pegawai>(); PegawaiList.Add(ctrl.SearchPegawai(txtCari.Text)); dataGridViewTampil.DataSource = PegawaiList; } } else if (stat == "produk") { string connStr = "datasource=127.0.0.1;port=3306;username=root;password=;database=kouvee;Convert Zero Datetime=True;"; MySqlConnection conn = new MySqlConnection(connStr); string selectQuery = "SELECT * FROM produk WHERE NAMA_PRODUK = '" + txtCari.Text + "'"; MySqlCommand command = new MySqlCommand(selectQuery, conn); MySqlDataAdapter da = new MySqlDataAdapter(command); DataTable table = new DataTable(); da.Fill(table); if (table.Rows.Count == 0) { MessageBox.Show("Pencarian Tidak Ditemukan"); da.Dispose(); throw null; } else { dataGridViewTampil.DataSource = table; DataGridViewImageColumn imageColumn = new DataGridViewImageColumn(); imageColumn = (DataGridViewImageColumn)dataGridViewTampil.Columns[9]; dataGridViewTampil.Columns[8].Visible = false; imageColumn.ImageLayout = DataGridViewImageCellLayout.Stretch; da.Dispose(); } } else if (stat == "supplier") { var ctrl = new SupplierControl(); if (ctrl.SearchSupplier(txtCari.Text) == null) { MessageBox.Show("Pencarian Tidak Ditemukan"); throw null; } else { List <Supplier> SupplierList = new List <Supplier>(); SupplierList.Add(ctrl.SearchSupplier(txtCari.Text)); dataGridViewTampil.DataSource = SupplierList; } } else if (stat == "ukuranhewan") { var ctrl = new UkuranHewanControl(); if (ctrl.SearchUkuran(txtCari.Text) == null) { MessageBox.Show("Pencarian Tidak Ditemukan"); throw null; } else { List <UkuranHewan> UkuranHewanList = new List <UkuranHewan>(); UkuranHewanList.Add(ctrl.SearchUkuran(txtCari.Text)); dataGridViewTampil.DataSource = UkuranHewanList; } } } catch (Exception ex) { Console.WriteLine(ex.ToString()); } }