public OBJSQL UpdatePelanggan(MPelanggan MPelanggan, string kode) { OBJSQL obj = null; List <MySqlParameter> sqlParam = new List <MySqlParameter>(); sqlParam.Add(new MySqlParameter() { ParameterName = "@kode", MySqlDbType = MySqlDbType.VarChar, Value = MPelanggan.kode }); sqlParam.Add(new MySqlParameter() { ParameterName = "@nama", MySqlDbType = MySqlDbType.VarChar, Value = MPelanggan.nama }); sqlParam.Add(new MySqlParameter() { ParameterName = "@alamat", MySqlDbType = MySqlDbType.VarChar, Value = MPelanggan.alamat }); sqlParam.Add(new MySqlParameter() { ParameterName = "@tlp", MySqlDbType = MySqlDbType.VarChar, Value = MPelanggan.tlp }); sqlParam.Add(new MySqlParameter() { ParameterName = "@email", MySqlDbType = MySqlDbType.VarChar, Value = MPelanggan.email }); sqlParam.Add(new MySqlParameter() { ParameterName = "@keterangan", MySqlDbType = MySqlDbType.VarChar, Value = MPelanggan.keterangan }); string SQLQuery = "UPDATE m_pelanggan set kode=@kode, nama=@nama, alamat=@alamat, tlp=@tlp, email=@email, keterangan=@keterangan where kode= " + kode; obj = h.InsertQuery(SQLQuery, sqlParam); return(obj); }
public OBJSQL Delete(string table, string id, string idWhere) { String SQLQuery = "DELETE FROM " + table + " WHERE " + id + " = " + idWhere; OBJSQL obj = h.DeleteQuery(SQLQuery); return(obj); }
private void updatePelanggan(string _kode, string _nama, string _alamat, string _tlp, string _email, string _keterangan) { InsertController ic = new InsertController(); ListController lc = new ListController(); MPelanggan i = new MPelanggan() { kode = _kode, nama = _nama, alamat = _alamat, tlp = _tlp, email = _email, keterangan = _keterangan, }; OBJSQL obj = ic.UpdatePelanggan(i, kode); }
private void saveSupplier(string _kode, string _nama, string _alamat, string _tlp, string _email, string _kontak, string _keterangan) { InsertController ic = new InsertController(); ListController lc = new ListController(); MSupplier i = new MSupplier() { kode = _kode, nama = _nama, alamat = _alamat, tlp = _tlp, email = _email, kontak = _kontak, keterangan = _keterangan, }; OBJSQL obj = ic.SaveNewSupplier(i); }
private void btnDelete_Click(object sender, EventArgs e) { string _menus = GlobalVar.TabSelected; DeleteController ic = new DeleteController(); DialogResult result1; OBJSQL obj = null; switch (_menus) { case "Barang": result1 = XtraMessageBox.Show("Are you sure you want to delete ? ", "Important Question", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (result1 == DialogResult.Yes) { obj = ic.Delete("m_barang", "kode", _Barang.kodeBarang); _Barang.loadBarang(); } break; case "Supplier": result1 = XtraMessageBox.Show("Are you sure you want to delete ? ", "Important Question", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (result1 == DialogResult.Yes) { obj = ic.Delete("m_supplier", "kode", _Supplier.kodeSupplier); _Supplier.loadSupplier(); } break; case "Pelanggan": result1 = XtraMessageBox.Show("Are you sure you want to delete ? ", "Important Question", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (result1 == DialogResult.Yes) { obj = ic.Delete("m_pelanggan", "kode", _Pelanggan.kodePelanggan); _Pelanggan.loadPelanggan(); } break; } }
private void saveBarang(string _kode, string _nama, Decimal _jumlah, Decimal _hargabeli, Decimal _hargajual, Decimal _diskon, Int32 _id_kategori_barang, Int32 _id_satuan_barang) { InsertController ic = new InsertController(); ListController lc = new ListController(); MBarang i = new MBarang() { kode = _kode, nama = _nama, jumlah = _jumlah, harga_beli = _hargabeli, harga_jual = _hargajual, diskon = _diskon, id_kategori_barang = _id_kategori_barang, id_satuan_barang = _id_satuan_barang }; OBJSQL obj = ic.SaveNewBarang(i); }
/* TABEL BARANG */ #region Tabel Barang public OBJSQL SaveNewBarang(MBarang MBarang) { OBJSQL obj = null; List <MySqlParameter> sqlParam = new List <MySqlParameter>(); sqlParam.Add(new MySqlParameter() { ParameterName = "@kode", MySqlDbType = MySqlDbType.VarChar, Value = MBarang.kode }); sqlParam.Add(new MySqlParameter() { ParameterName = "@nama", MySqlDbType = MySqlDbType.VarChar, Value = MBarang.nama }); sqlParam.Add(new MySqlParameter() { ParameterName = "@jumlah", MySqlDbType = MySqlDbType.Int32, Value = MBarang.jumlah }); sqlParam.Add(new MySqlParameter() { ParameterName = "@harga_beli", MySqlDbType = MySqlDbType.Decimal, Value = MBarang.harga_beli }); sqlParam.Add(new MySqlParameter() { ParameterName = "@harga_jual", MySqlDbType = MySqlDbType.Decimal, Value = MBarang.harga_jual }); sqlParam.Add(new MySqlParameter() { ParameterName = "@diskon", MySqlDbType = MySqlDbType.Int32, Value = MBarang.diskon }); sqlParam.Add(new MySqlParameter() { ParameterName = "@id_satuan_barang", MySqlDbType = MySqlDbType.Int32, Value = MBarang.id_satuan_barang }); sqlParam.Add(new MySqlParameter() { ParameterName = "@id_kategori_barang", MySqlDbType = MySqlDbType.Int32, Value = MBarang.id_kategori_barang }); String SQLQuery = "INSERT INTO m_barang (kode, nama, jumlah, harga_beli, harga_jual, diskon, id_satuan_barang, id_kategori_barang) " + "VALUES (@kode, @nama, @jumlah, @harga_beli, @harga_jual, @diskon, @id_satuan_barang, @id_kategori_barang); "; obj = h.InsertQuery(SQLQuery, sqlParam); return(obj); }
public OBJSQL UpdateBarang(MBarang MBarang, string kode) { OBJSQL obj = null; List <MySqlParameter> sqlParam = new List <MySqlParameter>(); sqlParam.Add(new MySqlParameter() { ParameterName = "@kode", MySqlDbType = MySqlDbType.VarChar, Value = MBarang.kode }); sqlParam.Add(new MySqlParameter() { ParameterName = "@nama", MySqlDbType = MySqlDbType.VarChar, Value = MBarang.nama }); sqlParam.Add(new MySqlParameter() { ParameterName = "@jumlah", MySqlDbType = MySqlDbType.Int32, Value = MBarang.jumlah }); sqlParam.Add(new MySqlParameter() { ParameterName = "@harga_beli", MySqlDbType = MySqlDbType.Decimal, Value = MBarang.harga_beli }); sqlParam.Add(new MySqlParameter() { ParameterName = "@harga_jual", MySqlDbType = MySqlDbType.Decimal, Value = MBarang.harga_jual }); sqlParam.Add(new MySqlParameter() { ParameterName = "@diskon", MySqlDbType = MySqlDbType.Int32, Value = MBarang.diskon }); sqlParam.Add(new MySqlParameter() { ParameterName = "@id_satuan_barang", MySqlDbType = MySqlDbType.Int32, Value = MBarang.id_satuan_barang }); sqlParam.Add(new MySqlParameter() { ParameterName = "@id_kategori_barang", MySqlDbType = MySqlDbType.Int32, Value = MBarang.id_kategori_barang }); string SQLQuery = "UPDATE m_barang set kode=@kode, nama=@nama, jumlah=@jumlah, harga_beli=@harga_beli, harga_jual=@harga_jual, diskon=@diskon, id_satuan_barang=@id_satuan_barang, id_kategori_barang=@id_kategori_barang where kode= " + kode; obj = h.InsertQuery(SQLQuery, sqlParam); return(obj); }
/* ============================================================= */ /* TABEL Supplier */ #region Tabel Supplier public OBJSQL SaveNewSupplier(MSupplier MSupplier) { OBJSQL obj = null; List <MySqlParameter> sqlParam = new List <MySqlParameter>(); sqlParam.Add(new MySqlParameter() { ParameterName = "@kode", MySqlDbType = MySqlDbType.VarChar, Value = MSupplier.kode }); sqlParam.Add(new MySqlParameter() { ParameterName = "@nama", MySqlDbType = MySqlDbType.VarChar, Value = MSupplier.nama }); sqlParam.Add(new MySqlParameter() { ParameterName = "@alamat", MySqlDbType = MySqlDbType.VarChar, Value = MSupplier.alamat }); sqlParam.Add(new MySqlParameter() { ParameterName = "@tlp", MySqlDbType = MySqlDbType.VarChar, Value = MSupplier.tlp }); sqlParam.Add(new MySqlParameter() { ParameterName = "@email", MySqlDbType = MySqlDbType.VarChar, Value = MSupplier.email }); sqlParam.Add(new MySqlParameter() { ParameterName = "@kontak", MySqlDbType = MySqlDbType.VarChar, Value = MSupplier.kontak }); sqlParam.Add(new MySqlParameter() { ParameterName = "@keterangan", MySqlDbType = MySqlDbType.VarChar, Value = MSupplier.keterangan }); String SQLQuery = "INSERT INTO m_supplier (kode, nama, alamat, tlp, email, kontak, keterangan) " + "VALUES (@kode, @nama, @alamat, @tlp, @email, @kontak, @keterangan); "; obj = h.InsertQuery(SQLQuery, sqlParam); return(obj); }
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); }