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