public List <Layanan> ShowLayanan()
{
string sql = "SELECT * FROM layanan";
List <Layanan> LayananList = new List <Layanan>();
try
{
MySqlCommand cmd = new MySqlCommand(sql, conn);
MySqlDataReader result = cmd.ExecuteReader();
if (result != null)
{
while (result.Read())
{
Layanan L = new Layanan(
result.GetInt32("ID_Layanan"),
result.GetInt32("ID_Ukuran"),
result.GetInt32("ID_Pegawai"),
result.GetInt32("ID_JenisHewan"),
result.GetString("Nama_Layanan"),
result.GetInt32("Harga_Layanan"),
result.GetDateTime("Create_At_Layanan"),
result.GetDateTime("Update_At_Layanan"),
result.GetDateTime("Delete_At_Layanan"));
LayananList.Add(L);
}
}
}
catch (Exception ex)
{
Console.WriteLine("Failed to read...");
Console.WriteLine(ex.ToString());
}
return(LayananList);
}
public void CreateLayanan(Layanan L)
{
string sql = "INSERT INTO layanan(ID_PEGAWAI, ID_JENISHEWAN, ID_UKURAN, NAMA_LAYANAN, HARGA_LAYANAN) "
+ "VALUES('"
+ L.ID_Pegawai
+ "',(SELECT ID_JENISHEWAN FROM jenis_hewan WHERE JENISHEWAN = '"
+ L.JenisHewan
+ "'),(SELECT ID_UKURAN FROM ukuran WHERE UKURAN = '"
+ L.Ukuran
+ "'),'"
+ L.Nama_Layanan
+ "','"
+ L.Harga_Layanan
+ "');";
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 Layanan SearchLayanan(String namaLayanan)
{
string sql = "SELECT * FROM layanan WHERE Nama_Layanan = '" + namaLayanan + "';";
Layanan layanan = null;
try
{
MySqlCommand cmd = new MySqlCommand(sql, conn);
MySqlDataReader result = cmd.ExecuteReader();
if (result != null)
{
while (result.Read())
{
layanan = new Layanan(
result.GetInt32("ID_Layanan"),
result.GetInt32("ID_Ukuran"),
result.GetInt32("ID_Pegawai"),
result.GetInt32("ID_JenisHewan"),
result.GetString("Nama_Layanan"),
result.GetInt32("Harga_Layanan"),
result.GetDateTime("Create_At_Layanan"),
result.GetDateTime("Update_At_Layanan"),
result.GetDateTime("Delete_At_Layanan"));
}
}
}
catch (Exception ex)
{
Console.WriteLine("Failed to search...");
Console.WriteLine(ex.ToString());
}
return(layanan);
}
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());
}
}
public Layanan SearchLayanan(String nama)
{
Layanan layanan = null;
lDAO.makeConnection();
layanan = lDAO.SearchLayanan(nama);
lDAO.closeConnection();
return(layanan);
}
public override Layanan pilihLayanan(string pilihObject, string strategi)
{
Layanan layanan = new Layanan();
if (pilihObject == "1")
{
layanan = new AntarBarang(strategi);
}
else if (pilihObject == "2")
{
layanan = new AntarJemput(strategi);
}
return(layanan);
}
public void UpdateLayanan(Layanan L, String namaLayanan)
{
string sql = "UPDATE layanan SET Nama_Layanan = '" + L.Nama_Layanan + "',HARGA_LAYANAN ='" + L.Harga_Layanan
+ "',ID_UKURAN = (SELECT ID_UKURAN FROM ukuran WHERE UKURAN = '" + L.Ukuran
+ "') ,ID_JENISHEWAN = (SELECT ID_JENISHEWAN FROM jenis_hewan WHERE JENISHEWAN = '" + L.JenisHewan + "')"
+ " WHERE Nama_Layanan = '" + namaLayanan + "';";
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());
}
}
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());
}
}
public void UpdateLayanan(Layanan layanan, String namaLayanan)
{
lDAO.makeConnection();
lDAO.UpdateLayanan(layanan, namaLayanan);
lDAO.closeConnection();
}
public void CreateLayanan(Layanan layanan)
{
lDAO.makeConnection();
lDAO.CreateLayanan(layanan);
lDAO.closeConnection();
}
public Layanan getLayanan(string pilihObject, string strategi)
{
Layanan layanan = pilihLayanan(pilihObject, strategi);
return(layanan);
}
