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