public static string HapusData(Penerimaan pPenerimaan)
{
string sql = "DELETE FROM nota_penerimaan WHERE nomor = '" + pPenerimaan.Nomor + "'";
try
{
Koneksi.JalankanPerintahDML(sql);
return("1");
}
catch (MySqlException exc)
{
return(exc.Message + ". Perintah sql : " + sql);
}
}
public static string UbahData(Penerimaan pPenerimaan)
{
string sql = "UPDATE INTO nota_penerimaan SET tanggal ='" + pPenerimaan.Tanggal.ToString("yyyy-MM-dd hh:mm:ss")
+ "', nomor_dokumen_pengiriman=" + pPenerimaan.NomorPengiriman.NomorDokumen
+ "', nama='" + pPenerimaan.Nama
+ "', alamat='" + pPenerimaan.Alamat
+ "', keterangan='" + pPenerimaan.keterangan
+ "' WHERE nomor = '" + pPenerimaan.Nomor + "'";
try
{
Koneksi.JalankanPerintahDML(sql);
return("1");
}
catch (MySqlException exc)
{
return(exc.Message + ". Perintah sql : " + sql);
}
}
public static string BacaData(string kriteria, string nilaiKriteria, List <Penerimaan> listHasilData)
{
string sql = "";
if (kriteria == "")
{
sql = "SELECT PT.nomor, PT.nomor_dokumen_pengiriman, PT.tanggal, PT.nama, PT.alamat, PT.keterangan FROM nota_penerimaan PT";
}
else
{
sql = "SELECT PT.nomor, PT.nomor_dokumen_pengiriman, PT.tanggal, PT.nama, PT.alamat, PT.keterangan FROM nota_penerimaan PT WHERE "
+ kriteria + " LIKE '%" + nilaiKriteria + "%'";
}
try
{
MySqlDataReader hasilData = Koneksi.JalankanPerintahQuery(sql);
while (hasilData.Read() == true)
{
Pengiriman p = new Pengiriman();
p.NomorDokumen = hasilData.GetValue(1).ToString();
Penerimaan PT = new Penerimaan();
PT.Nomor = hasilData.GetValue(0).ToString();
PT.Tanggal = DateTime.Parse(hasilData.GetValue(2).ToString());
PT.Nama = hasilData.GetValue(3).ToString();
PT.Alamat = hasilData.GetValue(4).ToString();
PT.Keterangan = hasilData.GetValue(5).ToString();
PT.NomorPengiriman = p;
listHasilData.Add(PT);
}
return("1");
}
catch (MySqlException exc)
{
return(exc.Message + ". Perintah sql : " + sql);
}
return("1");
}
public static string TambahData(Penerimaan pPenerimaan)
{
string sql = "INSERT INTO nota_penerimaan (nomor, nomor_dokumen_pengiriman, tanggal, nama, alamat, keterangan)VALUES ('" +
pPenerimaan.Nomor + "','" +
pPenerimaan.NomorPengiriman.NomorDokumen + "','" +
pPenerimaan.Tanggal.ToString("yyyy-MM-dd hh:mm:ss") + "','" +
pPenerimaan.Nama + "','" +
pPenerimaan.Alamat + "','" +
pPenerimaan.Keterangan + "')";
try
{
Koneksi.JalankanPerintahDML(sql);
return("1");
}
catch (MySqlException exc)
{
return(exc.Message + ". Perintah sql : " + sql);
}
}