コード例 #1
0
        private void buttonTambah_Click(object sender, EventArgs e)
        {
            try
            {
                if (string.IsNullOrEmpty(txtUkuranHewan.Text.Trim()))
                {
                    MessageBox.Show("Ukuran Hewan Tidak Boleh Kosong");
                    throw null;
                }
                if (!Regex.Match(txtUkuranHewan.Text, @"^[a-zA-Z]+$").Success)
                {
                    MessageBox.Show("Ukuran Hewan Tidak Boleh Mengandung Angka");
                    throw null;
                }

                var list = new UkuranHewanControl();
                ukuranHewan = new UkuranHewan(FormLogin.id_pegawai, txtUkuranHewan.Text);
                list.CreateUkuranHewan(ukuranHewan);
                MessageBox.Show("Data Berhasil Ditambah");
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.ToString());
            }
        }
コード例 #2
0
ファイル: UkuranHewanDAO.cs プロジェクト: aldiero141/Kouvee
        public List <UkuranHewan> ShowUkuranHewan()
        {
            string             sql             = "SELECT * FROM ukuran";
            List <UkuranHewan> UkuranHewanList = new List <UkuranHewan>();

            try
            {
                MySqlCommand    cmd    = new MySqlCommand(sql, conn);
                MySqlDataReader result = cmd.ExecuteReader();
                if (result != null)
                {
                    while (result.Read())
                    {
                        UkuranHewan UH = new UkuranHewan(
                            result.GetInt32("ID_Ukuran"),
                            result.GetInt32("ID_Pegawai"),
                            result.GetString("Ukuran"),
                            result.GetDateTime("Create_At_Ukuran"),
                            result.GetDateTime("Update_At_Ukuran"),
                            result.GetDateTime("Delete_At_Ukuran"));
                        UkuranHewanList.Add(UH);
                    }
                }
            }
            catch (Exception ex)
            {
                Console.WriteLine("Failed to read...");
                Console.WriteLine(ex.ToString());
            }
            return(UkuranHewanList);
        }
コード例 #3
0
ファイル: UkuranHewanDAO.cs プロジェクト: aldiero141/Kouvee
        public UkuranHewan SearchUkuran(String namaUkuran)
        {
            string      sql         = "SELECT * FROM ukuran WHERE Ukuran = '" + namaUkuran + "';";
            UkuranHewan ukuranHewan = null;

            try
            {
                MySqlCommand    cmd    = new MySqlCommand(sql, conn);
                MySqlDataReader result = cmd.ExecuteReader();
                if (result != null)
                {
                    while (result.Read())
                    {
                        ukuranHewan = new UkuranHewan(
                            result.GetInt32("ID_Ukuran"),
                            result.GetInt32("ID_Pegawai"),
                            result.GetString("Ukuran"),
                            result.GetDateTime("Create_At_Ukuran"),
                            result.GetDateTime("Update_At_Ukuran"),
                            result.GetDateTime("Delete_At_Ukuran"));
                    }
                }
            }
            catch (Exception ex)
            {
                Console.WriteLine("Failed to search...");
                Console.WriteLine(ex.ToString());
            }
            return(ukuranHewan);
        }
コード例 #4
0
        public UkuranHewan SearchUkuran(String nama)
        {
            UkuranHewan ukuranHewan = null;

            ukDAO.makeConnection();
            ukuranHewan = ukDAO.SearchUkuran(nama);
            ukDAO.closeConnection();
            return(ukuranHewan);
        }
コード例 #5
0
ファイル: UkuranHewanDAO.cs プロジェクト: aldiero141/Kouvee
        public void CreateUkuranHewan(UkuranHewan uH)
        {
            string sql = "INSERT INTO ukuran(ID_PEGAWAI, UKURAN) " +
                         "VALUES('" + uH.ID_Pegawai + "','" + uH.Ukuran + "');";

            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());
            }
        }
コード例 #6
0
ファイル: UkuranHewanDAO.cs プロジェクト: aldiero141/Kouvee
        public void UpdateUkuranHewan(UkuranHewan uH, String namaUkuran)
        {
            string sql = "UPDATE ukuran SET UKURAN = '" + uH.Ukuran + "'"
                         + " WHERE UKURAN = '" + namaUkuran + "';";

            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());
            }
        }
コード例 #7
0
        private void btnCari_Click(object sender, EventArgs e)
        {
            var list = new UkuranHewanControl();

            try
            {
                if (txtCari.Text != null && list.SearchUkuran(txtCari.Text) != null)
                {
                    buttonHapus.Enabled = true;

                    ukuranHewan         = list.SearchUkuran(txtCari.Text);
                    txtUkuranHewan.Text = ukuranHewan.Ukuran;
                }
                else
                {
                    MessageBox.Show("Pencarian Tidak Ditemukan");
                    throw null;
                }
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.ToString());
            }
        }
コード例 #8
0
 public void UpdateUkuranHewan(UkuranHewan ukuranHewan, String ukuran)
 {
     ukDAO.makeConnection();
     ukDAO.UpdateUkuranHewan(ukuranHewan, ukuran);
     ukDAO.closeConnection();
 }
コード例 #9
0
 public void CreateUkuranHewan(UkuranHewan ukuranHewan)
 {
     ukDAO.makeConnection();
     ukDAO.CreateUkuranHewan(ukuranHewan);
     ukDAO.closeConnection();
 }