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