public static string UbahData(Jabatan j) { string sql = "UPDATE jabatan SET Nama = '" + j.NamaJabatan.Replace("'", "\\'") + "' WHERE Id = '" + j.IdJabatan + "'"; try { Koneksi.JalankanPerintahDML(sql); return("1"); } catch (MySqlException exc) { return(exc.Message + ". Perintah sql : " + sql); } }
public static string TambahData(Jabatan j) { string sql = "INSERT INTO jabatan (Id, Nama) VALUES ('" + j.IdJabatan + "', '" + j.NamaJabatan.Replace("'", "\\'") + "')"; try { Koneksi.JalankanPerintahDML(sql); return("1"); } catch (MySqlException exc) { return(exc.Message + ". Perintah SQL: " + sql); } }
public static string HapusData(Jabatan j) { string sql = "DELETE FROM jabatan WHERE Id = '" + j.IdJabatan + "'"; try { Koneksi.JalankanPerintahDML(sql); return("1"); } catch (MySqlException exc) { return(exc.Message + ". Perintah sql : " + sql); } }
public static string BacaData(string kriteria, string nilaiKriteria, List <Pekerja> listHasilData) { string sql = ""; if (kriteria == "") { sql = "SELECT P.Id, P.Nama, P.Alamat, P.nomer_hp, J.Id AS IdJabatan, J.Nama AS NamaJabatan, P.Username, P.Password" + " FROM pekerja P INNER JOIN jabatan J ON P.id_jabatan = J.id"; } else { sql = "SELECT P.Id, P.Nama, P.Alamat, P.nomer_hp, J.Id AS IdJabatan, J.Nama AS NamaJabatan, P.Username, P.Password" + " FROM pekerja P INNER JOIN jabatan J ON P.id_jabatan = J.id" + " WHERE " + kriteria + " LIKE '%" + nilaiKriteria + "%'"; } try { MySqlDataReader hasilData = Koneksi.JalankanPerintahQuery(sql); listHasilData.Clear(); while (hasilData.Read() == true) { Pekerja p = new Pekerja(); p.IdPekerja = int.Parse(hasilData.GetValue(0).ToString()); p.Nama = hasilData.GetValue(1).ToString(); p.Alamat = hasilData.GetValue(2).ToString(); p.NomerHp = hasilData.GetValue(3).ToString(); p.Username = hasilData.GetValue(6).ToString(); p.Password = hasilData.GetValue(7).ToString(); Jabatan jabatan = new Jabatan(hasilData.GetValue(4).ToString(), hasilData.GetValue(5).ToString()); p.Jabatan = jabatan; listHasilData.Add(p); } return("1"); } catch (MySqlException exc) { return(exc.Message + ". Perintah sql : " + sql); } }
public static string BacaData(string kriteria, string nilaiKriteria, List <Jabatan> listHasilData) { string sql = ""; // JIka tidak ada kriteria yang diisikan if (kriteria == "") { sql = "SELECT * FROM jabatan"; } else { sql = "SELECT * FROM jabatan WHERE " + kriteria + " LIKE '%" + nilaiKriteria + "%'"; } try { MySqlDataReader hasilData = Koneksi.JalankanPerintahQuery(sql); while (hasilData.Read() == true) // selama masih ada data atau selama masih bisa membaca data { // Baca hasil dari MySqlDataReader dan simpan di objek Jabatan j = new Jabatan(); j.IdJabatan = hasilData.GetValue(0).ToString(); j.NamaJabatan = hasilData.GetValue(1).ToString(); // Simpan ke list listHasilData.Add(j); } return("1"); } catch (MySqlException exc) { return(exc.Message + ". Perintah sql : " + sql); } }
public Pekerja(int pIdPekerja, string pNama, string pAlamat, string pNomerHp, Jabatan pJabatan, string pUsername, string pPassword) { this.IdPekerja = pIdPekerja; this.Nama = pNama; this.Alamat = pAlamat; this.NomerHp = pNomerHp; this.Jabatan = pJabatan; this.Username = pUsername; this.Password = pPassword; }