public void CreateHewan(Hewan H)
{
string sql = "INSERT INTO hewan(ID_PEGAWAI, ID_PELANGGAN, ID_JENISHEWAN, NAMA_HEWAN, TGL_LAHIR_HEWAN) "
+ "VALUES('"
+ H.ID_Pegawai
+ "',(SELECT ID_PELANGGAN FROM pelanggan WHERE NAMA_PELANGGAN = '"
+ H.Nama_Pelanggan
+ "'),(SELECT ID_JENISHEWAN FROM jenis_hewan WHERE JENISHEWAN = '"
+ H.JenisHewan
+ "'),'"
+ H.Nama_Hewan
+ "','"
+ H.Tgl_Lahir_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());
}
}
public List <Hewan> ShowHewan()
{
string sql = "SELECT * FROM hewan";
List <Hewan> HewanList = new List <Hewan>();
try
{
MySqlCommand cmd = new MySqlCommand(sql, conn);
MySqlDataReader result = cmd.ExecuteReader();
if (result != null)
{
while (result.Read())
{
Hewan H = new Hewan(
result.GetInt32("ID_Hewan"),
result.GetInt32("ID_JenisHewan"),
//result.GetInt32("ID_Ukuran"),
result.GetInt32("ID_Pelanggan"),
result.GetInt32("ID_Pegawai"),
result.GetString("Nama_Hewan"),
result.GetString("Tgl_Lahir_Hewan"),
result.GetDateTime("Create_At_Hewan"),
result.GetDateTime("Update_At_Hewan"),
result.GetDateTime("Delete_At_Hewan"));
HewanList.Add(H);
}
}
}
catch (Exception ex)
{
Console.WriteLine("Failed to read...");
Console.WriteLine(ex.ToString());
}
return(HewanList);
}
private void buttonTambah_Click(object sender, EventArgs e)
{
try
{
if (string.IsNullOrEmpty(txtNamaHewan.Text.Trim()))
{
MessageBox.Show("Nama Hewan Tidak Boleh Kosong");
throw null;
}
if (!Regex.Match(txtNamaHewan.Text, @"^[a-zA-Z]+$").Success)
{
MessageBox.Show("Nama Hewan Tidak Boleh Mengandung Angka");
throw null;
}
if (string.IsNullOrEmpty(comboBoxNamaPelanggan.Text.Trim()))
{
MessageBox.Show("Nama Pelanggan Tidak Boleh Kosong");
throw null;
}
if (string.IsNullOrEmpty(comboBoxJenisHewan.Text.Trim()))
{
MessageBox.Show("Jenis Hewan Tidak Boleh Kosong");
throw null;
}
var list = new HewanControl();
hewan = new Hewan(comboBoxNamaPelanggan.Text, comboBoxJenisHewan.Text, FormLogin.id_pegawai, txtNamaHewan.Text, dateTimePickerHewan.Text);
list.CreateHewan(hewan);
MessageBox.Show("Data Berhasil Ditambah");
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
}
public Hewan SearchHewan(String namaHewan)
{
string sql = "SELECT * FROM hewan WHERE NAMA_HEWAN = '" + namaHewan + "';";
Hewan hewan = null;
try
{
MySqlCommand cmd = new MySqlCommand(sql, conn);
MySqlDataReader result = cmd.ExecuteReader();
if (result != null)
{
while (result.Read())
{
hewan = new Hewan(
result.GetInt32("ID_Hewan"),
result.GetInt32("ID_JenisHewan"),
//result.GetInt32("ID_Ukuran"),
result.GetInt32("ID_Pelanggan"),
result.GetInt32("ID_Pegawai"),
result.GetString("Nama_Hewan"),
result.GetString("Tgl_Lahir_Hewan"),
result.GetDateTime("Create_At_Hewan"),
result.GetDateTime("Update_At_Hewan"),
result.GetDateTime("Delete_At_Hewan"));
}
}
}
catch (Exception ex)
{
Console.WriteLine("Failed to search...");
Console.WriteLine(ex.ToString());
}
return(hewan);
}
public Hewan SearchHewan(String nama)
{
Hewan hewan = null;
hDAO.makeConnection();
hewan = hDAO.SearchHewan(nama);
hDAO.closeConnection();
return(hewan);
}
public void UpdateHewan(Hewan H, String namaHewan)
{
string sql = "UPDATE hewan SET NAMA_HEWAN = '" + H.Nama_Hewan + "',TGL_LAHIR_HEWAN ='" + H.Tgl_Lahir_Hewan
+ "',ID_PELANGGAN = (SELECT ID_PELANGGAN FROM pelanggan WHERE NAMA_PELANGGAN = '" + H.Nama_Pelanggan
+ "') ,ID_JENISHEWAN = (SELECT ID_JENISHEWAN FROM jenis_hewan WHERE JENISHEWAN = '" + H.JenisHewan + "')"
+ " WHERE NAMA_HEWAN = '" + namaHewan + "';";
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 UpdateHewan(Hewan hewan, String namaHewan)
{
hDAO.makeConnection();
hDAO.UpdateHewan(hewan, namaHewan);
hDAO.closeConnection();
}
public void CreateHewan(Hewan hewan)
{
hDAO.makeConnection();
hDAO.CreateHewan(hewan);
hDAO.closeConnection();
}
private void btnCari_Click(object sender, EventArgs e)
{
var list = new HewanControl();
try
{
if (txtCari.Text != null && list.SearchHewan(txtCari.Text) != null)
{
buttonHapus.Enabled = true;
hewan = list.SearchHewan(txtCari.Text);
txtNamaHewan.Text = hewan.Nama_Hewan;
dateTimePickerHewan.Value = DateTime.Parse(hewan.Tgl_Lahir_Hewan);
string connStr = "datasource=127.0.0.1;port=3306;username=root;password=;database=kouvee;Convert Zero Datetime=True;";
MySqlConnection conn = new MySqlConnection(connStr);
string sqlpelanggan = "SELECT * FROM pelanggan WHERE ID_PELANGGAN = '" + hewan.ID_Pelanggan + "';";
string sqljenishewan = "SELECT * FROM jenis_hewan WHERE ID_JENISHEWAN = '" + hewan.ID_Jenis + "';";
conn.Open();
try
{
MySqlCommand cmd1 = new MySqlCommand(sqlpelanggan, conn);
MySqlDataReader result1 = cmd1.ExecuteReader();
if (result1 != null)
{
while (result1.Read())
{
comboBoxNamaPelanggan.Text = result1.GetString("Nama_Pelanggan");
}
}
}
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();
}
else
{
MessageBox.Show("Pencarian Tidak Ditemukan");
throw null;
}
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
}
