public static string TambahData(Penerimaan pPenerimaan)
{
using (var tranScope = new TransactionScope(TransactionScopeOption.RequiresNew))
{
//sql1 untuk menambahkan data ke tabel nota penjualan
string sql = "Insert into penerimaan(kodePenerimaan, jenispengiriman, biayakirim,tglTerima,nama,keterangan,noNotaPembelian) values ('" +
pPenerimaan.KodePenerimaan + "', '" +
pPenerimaan.JenisPengiriman + "'," +
pPenerimaan.BiayaKirim + ",'" +
pPenerimaan.TglTerima.ToString("yyyy-MM-dd hh:mm:ss") + "', '" +
pPenerimaan.Nama + "','" +
pPenerimaan.Keterangan + "','" +
pPenerimaan.NotaPembelian.NoNotaPembelian + "')";
try
{
//jalankan perintah sql untuk menambahkan ke tabel
Koneksi.JalankanPerintahDML(sql);
tranScope.Complete();
return("1");
}
catch (MySqlException ex)
{
//jika ada kegagalan perintah
tranScope.Dispose();
return(ex.Message);
}
}
}
public static string BacaData(string pKriteria, string pNilaiKriteria, List <Penerimaan> listHasilData)
{
string sql = "";
if (pKriteria == "")
{
sql = " select * from penerimaan order by kodepenerimaan desc";
}
else
{
sql = " select * from penerimaan where " + pKriteria + " LIKE '%" + pNilaiKriteria + "%' order by kodepenerimaan desc";
}
try
{
MySqlDataReader hasilData = Koneksi.JalankanPerintahQuery(sql);
listHasilData.Clear();
while (hasilData.Read() == true)
{
NotaPembelian nota = new NotaPembelian();
nota.NoNotaPembelian = hasilData.GetValue(6).ToString();
string kodePen = hasilData.GetValue(0).ToString();
string pJenis = hasilData.GetValue(1).ToString();
int biaya = int.Parse(hasilData.GetValue(2).ToString());
DateTime tanggal = DateTime.Parse(hasilData.GetValue(3).ToString());
string nama = hasilData.GetValue(4).ToString();
string ket = hasilData.GetValue(5).ToString();
Penerimaan pen = new Penerimaan(kodePen, pJenis, nama, ket, biaya, tanggal, nota);
listHasilData.Add(pen);
}
return("1");
}
catch (MySqlException ex)
{
return(ex.Message + ". Perintah sql : " + sql);
}
}
