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