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