public List <JenisHewan> ShowJenisHewan() { string sql = "SELECT * FROM jenis_hewan"; List <JenisHewan> JenisHewanList = new List <JenisHewan>(); try { MySqlCommand cmd = new MySqlCommand(sql, conn); MySqlDataReader result = cmd.ExecuteReader(); if (result != null) { while (result.Read()) { JenisHewan JH = new JenisHewan( result.GetInt32("ID_JenisHewan"), result.GetInt32("ID_Pegawai"), result.GetString("JenisHewan"), result.GetDateTime("Create_At_Jhewan"), result.GetDateTime("Update_At_Jhewan"), result.GetDateTime("Delete_At_Jhewan")); JenisHewanList.Add(JH); } } } catch (Exception ex) { Console.WriteLine("Failed to read..."); Console.WriteLine(ex.ToString()); } return(JenisHewanList); }
private void buttonTambah_Click(object sender, EventArgs e) { try { if (string.IsNullOrEmpty(txtJenisHewan.Text.Trim())) { MessageBox.Show("Jenis Hewan Tidak Boleh Kosong"); throw null; } if (!Regex.Match(txtJenisHewan.Text, @"^[a-zA-Z]+$").Success) { MessageBox.Show("Jenis Hewan Tidak Boleh Mengandung Angka"); throw null; } var list = new JenisHewanControl(); jenisHewan = new JenisHewan(FormLogin.id_pegawai, txtJenisHewan.Text); list.CreateJenisHewan(jenisHewan); MessageBox.Show("Data Berhasil Ditambah"); } catch (Exception ex) { Console.WriteLine(ex.ToString()); } }
public JenisHewan SearchJenisHewan(String namaJenis) { string sql = "SELECT * FROM jenis_hewan WHERE JENISHEWAN = '" + namaJenis + "';"; JenisHewan jenisHewan = null; try { MySqlCommand cmd = new MySqlCommand(sql, conn); MySqlDataReader result = cmd.ExecuteReader(); if (result != null) { while (result.Read()) { jenisHewan = new JenisHewan( result.GetInt32("ID_JenisHewan"), result.GetInt32("ID_Pegawai"), result.GetString("JenisHewan"), result.GetDateTime("Create_At_Jhewan"), result.GetDateTime("Update_At_Jhewan"), result.GetDateTime("Delete_At_Jhewan")); } } } catch (Exception ex) { Console.WriteLine("Failed to search..."); Console.WriteLine(ex.ToString()); } return(jenisHewan); }
public JenisHewan SearchJenisHewan(String nama) { JenisHewan jenisHewan = null; jhDAO.makeConnection(); jenisHewan = jhDAO.SearchJenisHewan(nama); jhDAO.closeConnection(); return(jenisHewan); }
public void UpdateJenisHewan(JenisHewan jH, String namaJenis) { string sql = "UPDATE jenis_hewan SET JENISHEWAN = '" + jH.Jenis_Hewan + "'" + " WHERE JENISHEWAN = '" + namaJenis + "';"; try { MySqlCommand cmd = new MySqlCommand(sql, conn); cmd.ExecuteReader(); Console.WriteLine("Data Updated..."); } catch (Exception ex) { Console.WriteLine("Failed to update..."); Console.WriteLine(ex.ToString()); } }
public void CreateJenisHewan(JenisHewan jH) { string sql = "INSERT INTO jenis_hewan(ID_PEGAWAI,JENISHEWAN) " + "VALUES('" + jH.ID_Pegawai + "','" + jH.Jenis_Hewan + "');"; try { MySqlCommand cmd = new MySqlCommand(sql, conn); cmd.ExecuteReader(); Console.WriteLine("Data Created..."); } catch (Exception ex) { Console.WriteLine("Failed to create..."); Console.WriteLine(ex.ToString()); } }
private void btnCari_Click(object sender, EventArgs e) { var list = new JenisHewanControl(); try { if (txtCari.Text != null && list.SearchJenisHewan(txtCari.Text) != null) { buttonUbah.Enabled = true; jenisHewan = list.SearchJenisHewan(txtCari.Text); txtJenisHewan.Text = jenisHewan.Jenis_Hewan; txtJenisHewan.Enabled = true; } else { MessageBox.Show("Pencarian Tidak Ditemukan"); throw null; } } catch (Exception ex) { Console.WriteLine(ex.ToString()); } }
public void UpdateJenisHewan(JenisHewan jenisHewan, String namaJenis) { jhDAO.makeConnection(); jhDAO.UpdateJenisHewan(jenisHewan, namaJenis); jhDAO.closeConnection(); }
public void CreateJenisHewan(JenisHewan jenisHewan) { jhDAO.makeConnection(); jhDAO.CreateJenisHewan(jenisHewan); jhDAO.closeConnection(); }