private void saveSupplier(string _faktur, DateTime _tanggal, Int32 _id_kredit_pembelian, Int32 _id_supplier_pembelian, DateTime?_jatuhtempo, double _subtotal, Int32 _diskon, double _grandtotal, double _tunai, double _kembali, GridView _gridview) { GlobalVar.Success = false; InsertController ic = new InsertController(); ListController lc = new ListController(); MPembelian i = new MPembelian() { faktur = _faktur, tanggal = _tanggal, id_kredit_pembelian = _id_kredit_pembelian, id_supplier_pembelian = _id_supplier_pembelian, jatuhtempo = _jatuhtempo, subtotal = _subtotal, diskon = _diskon, grandtotal = _grandtotal, tunai = _tunai, kembali = _kembali }; OBJSQL obj = ic.SaveNewPembelian(i, _gridview); if (GlobalVar.Success) { textFaktur.Text = ""; searchLookKode.Text = ""; spinJumlah.Value = 0; textNama.Text = ""; spinBeli.Value = 0; spinDisc.Value = 0; spinNetto.Value = 0; spinSubTotal.Value = 0; spinTotal.Value = 0; spinGrandTotal.Value = 0; spinTunai.Value = 0; spinKembalian.Value = 0; gridPembelian.DataSource = null; gridPembelian.DataSource = CreateTable(1); dateJatuhTempo.Enabled = false; } }
/* ============================================================= */ /* TABEL Pembelian */ #region Tabel Pembelian public OBJSQL SaveNewPembelian(MPembelian MPembelian, GridView _gridview) { OBJSQL obj = null; List <MySqlParameter> sqlParam = new List <MySqlParameter>(); sqlParam.Add(new MySqlParameter() { ParameterName = "@faktur", MySqlDbType = MySqlDbType.VarChar, Value = MPembelian.faktur }); sqlParam.Add(new MySqlParameter() { ParameterName = "@tanggal", MySqlDbType = MySqlDbType.DateTime, Value = MPembelian.tanggal.Date }); sqlParam.Add(new MySqlParameter() { ParameterName = "@id_kredit_pembelian", MySqlDbType = MySqlDbType.Int32, Value = MPembelian.id_kredit_pembelian }); sqlParam.Add(new MySqlParameter() { ParameterName = "@jatuhtempo", MySqlDbType = MySqlDbType.DateTime, Value = MPembelian.jatuhtempo?.Date }); sqlParam.Add(new MySqlParameter() { ParameterName = "@id_supplier_pembelian", MySqlDbType = MySqlDbType.Int32, Value = MPembelian.id_supplier_pembelian }); sqlParam.Add(new MySqlParameter() { ParameterName = "@subtotal", MySqlDbType = MySqlDbType.Double, Value = MPembelian.subtotal }); sqlParam.Add(new MySqlParameter() { ParameterName = "@diskon", MySqlDbType = MySqlDbType.Int32, Value = MPembelian.diskon }); sqlParam.Add(new MySqlParameter() { ParameterName = "@grandtotal", MySqlDbType = MySqlDbType.Double, Value = MPembelian.grandtotal }); sqlParam.Add(new MySqlParameter() { ParameterName = "@tunai", MySqlDbType = MySqlDbType.Double, Value = MPembelian.tunai }); sqlParam.Add(new MySqlParameter() { ParameterName = "@kembali", MySqlDbType = MySqlDbType.Double, Value = MPembelian.kembali }); String SQLQuery = "INSERT INTO pembelian (faktur, tanggal, id_kredit_pembelian, jatuhtempo, id_supplier_pembelian, subtotal, diskon, grandtotal, tunai, kembali) " + "VALUES (@faktur, @tanggal, @id_kredit_pembelian, @jatuhtempo, @id_supplier_pembelian, @subtotal, @diskon, @grandtotal, @tunai, @kembali); " + "SET @NEWID = LAST_INSERT_ID();"; //"DECLARE @NEWID int;" + //"SET @NEWID = @@IDENTITY;"; // String SQLQuery = ""; for (int i = 0; i < _gridview.RowCount; i++) { string brg = _gridview.GetRowCellValue(i, "id_barang_pembelian").ToString(); string jum = _gridview.GetRowCellValue(i, "Jumlah").ToString(); string sat = _gridview.GetRowCellValue(i, "id_satuan_pembelian").ToString(); string bel = _gridview.GetRowCellValue(i, "HargaBeli").ToString(); string dis = _gridview.GetRowCellValue(i, "Diskon").ToString(); string ber = _gridview.GetRowCellValue(i, "HargaBersih").ToString(); string tot = _gridview.GetRowCellValue(i, "Total").ToString(); SQLQuery += "INSERT INTO detail_pembelian (id_pembelian_detail, id_barang_detail, jumlah, id_satuan_detail, hargabeli, diskon, hargabersih, total) " + "VALUES (@NEWID, " + "'" + _gridview.GetRowCellValue(i, "id_barang_pembelian").ToString() + "'," + "'" + _gridview.GetRowCellValue(i, "Jumlah").ToString() + "'," + "'" + _gridview.GetRowCellValue(i, "id_satuan_pembelian").ToString() + "'," + "'" + _gridview.GetRowCellValue(i, "HargaBeli").ToString() + "'," + "'" + _gridview.GetRowCellValue(i, "Diskon").ToString() + "'," + "'" + _gridview.GetRowCellValue(i, "HargaBersih").ToString() + "'," + "'" + _gridview.GetRowCellValue(i, "Total").ToString() + "'" + ");"; } obj = h.InsertQuery(SQLQuery, sqlParam); return(obj); }