public void FormDaftarNotaBeli_Load(object sender, EventArgs e)
{
comboBoxCari.Items.AddRange(new string[] { "No Nota", "ID Supplier", "Nama Supplier", "Alamat Supplier",
"Diskon", "Total Harga", "Batas Pelunasan",
"Batas Diskon", "Tanggal Pembelian", "Status", "Keterangan" });
this.Location = new Point(0, 0);
comboBoxCari.DropDownStyle = ComboBoxStyle.DropDownList;
FormatDataGrid();
string hasilBaca = NotaPembelian.BacaData("", "", listHasilData);
if (hasilBaca == "1")
{
dataGridViewNota.Rows.Clear();
for (int i = 0; i < listHasilData.Count; i++)
{
string total = listHasilData[i].TotalHarga.ToString("RP 0,###");
dataGridViewNota.Rows.Add(listHasilData[i].NoNotaPembelian, listHasilData[i].Supplier.IdSupplier,
listHasilData[i].Supplier.Nama, listHasilData[i].Supplier.Alamat, listHasilData[i].Diskon,
total, listHasilData[i].TglBatasPelunasan.ToString("dddd, dd MMMM yyyy"),
listHasilData[i].TglBatasDiskon.ToString("dddd, dd MMMM yyyy"),
listHasilData[i].TglBeli.ToString("dddd, dd MMMM yyyy"), listHasilData[i].Status, listHasilData[i].Keterangan);
}
}
}
private void buttoncetak_Click(object sender, EventArgs e)
{
string hasilCetak = NotaPembelian.CetakNota(kriteria, textBoxCari.Text, "daftar_nota_Beli.txt");
if (hasilCetak == "1")
{
MessageBox.Show("Nota telah tercetak");
}
else
{
MessageBox.Show("Nota beli gagal dicetak. Pesan kesalahan : " + hasilCetak);
}
}
private void FormTambahPenerimaan_Load(object sender, EventArgs e)
{
comboBoxJenisPengiriman.Items.AddRange(new string[] { "Shipping Point", "Destination Point" });
string noNotaBaru;
textBoxIdPengiriman.Enabled = false;
dateTimePickerTerima.Enabled = false;
dateTimePickerTerima.Value = DateTime.Now;
comboBoxNoNotaBeli.DropDownStyle = ComboBoxStyle.DropDownList;
comboBoxJenisPengiriman.DropDownStyle = ComboBoxStyle.DropDownList;
string hasilGenerate = Penerimaan.GenerateNoNota(out noNotaBaru);
textBoxIdPengiriman.Clear();
if (hasilGenerate == "1")
{
textBoxIdPengiriman.Text = noNotaBaru;
}
else
{
MessageBox.Show("Gagal melakukan generate code. Pesan kesalahan: " + hasilGenerate);
}
string hasilBaca = NotaPembelian.BacaData("", "", listHasilNota);
if (hasilBaca == "1")
{
comboBoxNoNotaBeli.Items.Clear();
for (int i = 0; i < listHasilNota.Count; i++)
{
comboBoxNoNotaBeli.Items.Add(listHasilNota[i].NoNotaPembelian);
}
}
else
{
comboBoxNoNotaBeli.Items.Clear();
}
if (comboBoxNoNotaBeli.Items.Count != 0)
{
comboBoxNoNotaBeli.SelectedIndex = 0;
}
comboBoxJenisPengiriman.SelectedIndex = 0;
FormUtama form = (FormUtama)this.Owner.MdiParent;
labelKodePgw.Text = form.labelKodePgw.Text;
labelNamaPgw.Text = form.labelNamaPgw.Text;
}
private void comboBoxCari_TextChanged(object sender, EventArgs e)
{
string hasilBaca = NotaPembelian.BacaData("", "", listHasilData);
if (hasilBaca == "1")
{
dataGridViewNota.Rows.Clear();
for (int i = 0; i < listHasilData.Count; i++)
{
string total = listHasilData[i].TotalHarga.ToString("RP 0,###");
dataGridViewNota.Rows.Add(listHasilData[i].NoNotaPembelian, listHasilData[i].Supplier.IdSupplier,
listHasilData[i].Supplier.Nama, listHasilData[i].Supplier.Alamat, listHasilData[i].Diskon,
total, listHasilData[i].TglBatasPelunasan.ToString("dddd, dd MMMM yyyy"),
listHasilData[i].TglBatasDiskon.ToString("dddd, dd MMMM yyyy"),
listHasilData[i].TglBeli.ToString("dddd, dd MMMM yyyy"), listHasilData[i].Status, listHasilData[i].Keterangan);
}
}
}
private void buttonSimpan_Click(object sender, EventArgs e)
{
FormUtama frmUtama = (FormUtama)this.Owner.MdiParent;
FormDaftarPenerimaan form = (FormDaftarPenerimaan)this.Owner;
NotaPembelian nota = new NotaPembelian();
nota.NoNotaPembelian = comboBoxNoNotaBeli.Text;
string kode = textBoxIdPengiriman.Text;
string jenis = "";
if (comboBoxJenisPengiriman.Text == "Shipping Point")
{
jenis = "SP";
}
else
{
jenis = "DP";
}
int biaya = int.Parse(textBoxBiaya.Text);
string nama = textBoxNama.Text;
DateTime tgl = dateTimePickerTerima.Value;
string ket = textBoxKeterangan.Text;
Penerimaan peng = new Penerimaan(kode, jenis, nama, ket, biaya, tgl, nota);
string hasilTambah = Penerimaan.TambahData(peng);
if (hasilTambah == "1")
{
MessageBox.Show("Berhasil Menambahkan Penerimaan");
this.Close();
form.FormDaftarPenerimaan_Load(sender, e);
}
else
{
MessageBox.Show("pengiriman gagal tersimpan. Pesan kesalahan : " + hasilTambah, "Kesalahan");
}
}
private void FormTambahNotaBeli_Load(object sender, EventArgs e)
{
comboBoxStatus.Items.AddRange(new string[] { "L", "B" });
this.Location = new Point(500, 26);
FormatDataGrid();
pPeriode = Periode.GetPeriodeTerbaru();
textBoxKode.MaxLength = 5;
textBoxNo.Enabled = false;
textBoxAlamat.Enabled = false;
comboBoxSupplier.DropDownStyle = ComboBoxStyle.DropDownList;
comboBoxStatus.DropDownStyle = ComboBoxStyle.DropDownList;
string noNotaBaru;
string hasilGenerate = NotaPembelian.GenerateNoNota(out noNotaBaru);
textBoxNo.Clear();
if (hasilGenerate == "1")
{
textBoxNo.Text = noNotaBaru;
textBoxKode.Focus();
}
else
{
MessageBox.Show("Gagal melakukan generate code. Pesan kesalahan: " + hasilGenerate);
}
dateTimePickerDiskon.Value = DateTime.Now;
dateTimePickerTglLunas.Value = DateTime.Now;
dateTimePickerTanggalBeli.Value = DateTime.Now;
dateTimePickerTanggalBeli.Enabled = false;
string hasilBaca = Supplier.BacaData("", "", listHasilData);
if (hasilBaca == "1")
{
comboBoxSupplier.Items.Clear();
for (int i = 0; i < listHasilData.Count; i++)
{
comboBoxSupplier.Items.Add(listHasilData[i].IdSupplier + " - " + listHasilData[i].Nama);
}
}
else
{
comboBoxSupplier.Items.Clear();
}
if (comboBoxStatus.Items.Count != 0)
{
comboBoxStatus.SelectedIndex = 0;
}
if (comboBoxSupplier.Items.Count != 0)
{
comboBoxSupplier.SelectedIndex = 0;
}
FormUtama form = (FormUtama)this.Owner.MdiParent;
labelKodePgw.Text = form.labelKodePgw.Text;
labelNamaPgw.Text = form.labelNamaPgw.Text;
}
private void buttonSimpan_Click(object sender, EventArgs e)
{
FormUtama frmUtama = (FormUtama)this.Owner.MdiParent;
FormDaftarNotaBeli form = (FormDaftarNotaBeli)this.Owner;
//buat objek bertipe Supplier
Supplier supplier = new Supplier();
//format combo box supplier: X -yyyyyy (kode supplier karakter 0 sebanyak 1, nama kategori mulai karakter ke-4 s/d akhir
supplier.IdSupplier = comboBoxSupplier.Text.Substring(0, 1); //kode supplier diambil dari combobox
supplier.Nama = comboBoxSupplier.Text.Substring(4, comboBoxSupplier.Text.Length - 4); //nama supplier diambil dari combo box
supplier.Alamat = textBoxAlamat.Text;
//buat object bertipe notabeli
NotaPembelian nota = new NotaPembelian(textBoxNo.Text, comboBoxStatus.Text, textBoxKeterangan.Text, double.Parse(textBoxDiskon.Text),
HitungGrandTotal(), dateTimePickerTglLunas.Value, dateTimePickerDiskon.Value, dateTimePickerTanggalBeli.Value, supplier);
//data barang diperoleh dari data gridview
for (int i = 0; i < dataGridViewNota.Rows.Count; i++)
{
//buat object bertipe barang
Barang barang = new Barang();
//tambahkan kode, nama, jenis, satuan
//hati hati dalam menambahkan
barang.KodeBarang = dataGridViewNota.Rows[i].Cells["KodeBarang"].Value.ToString();
barang.Nama = dataGridViewNota.Rows[i].Cells["NamaBarang"].Value.ToString();
barang.Jenis = dataGridViewNota.Rows[i].Cells["jenis"].Value.ToString();
barang.Satuan = dataGridViewNota.Rows[i].Cells["satuan"].Value.ToString();
//simpan data hargabeli dan jumlah
int harga = int.Parse(dataGridViewNota.Rows[i].Cells["HargaBeli"].Value.ToString());
int jumlah = int.Parse(dataGridViewNota.Rows[i].Cells["Jumlah"].Value.ToString());
//buat object dan tambahkan
DetilNotaBeli notaDetil = new DetilNotaBeli(barang, jumlah, harga);
//simpan detil barang ke nota
nota.TambahDetilBarang(barang, jumlah, harga);
}
string hasilTambahNota = NotaPembelian.TambahData(nota);
if (hasilTambahNota == "1") //jika berhasil maka insert jurnal dan detil jurnal
{
MessageBox.Show("Data nota beli telah tersimpan", "Info");
//tambah posting ke jurnal
string idtrans = "";
string ket = "";
string idJurnal = Jurnal.GenerateIdJurnal();
if (comboBoxStatus.Text == "L")
{
idtrans = "012";
ket = "Membeli bahan baku secara Tunai";
}
else if (comboBoxStatus.Text == "B")
{
idtrans = "001";
ket = "Membeli bahan baku secara kredit";
}
Transaksi trans = new Transaksi();
trans.IdTransaksi = idtrans;
trans.Keterangan = ket;
//buat object bertipe jurnal
Jurnal jurnal = new Jurnal();
//tambahkan data
jurnal.IdJurnal = int.Parse(idJurnal);
jurnal.Tanggal = dateTimePickerTanggalBeli.Value;
jurnal.NomorBukti = textBoxNo.Text;
jurnal.Jenis = "JU";
jurnal.Periode = pPeriode;
jurnal.Transaksi = trans;
//isi detil jurnalnya
int totalharga = HitungGrandTotal(); // panggil method hitung total harga untuk mendapatkan totalharga
if (comboBoxStatus.Text == "L")
{
jurnal.TambahDetilJurnalPembelianBarangTunai(totalharga);
}
else
{
jurnal.TambahDetilJurnalPembelianBarangKredit(totalharga);
}
//simpan ke tabel _jurnal
string hasilTambahJurnal = Jurnal.TambahData(jurnal);
if (hasilTambahJurnal == "1")
{
MessageBox.Show("berhasil posting ke jurnal");
DialogResult pesan = MessageBox.Show("Apakah anda ingin mencetak nota ? ", "konformasi", MessageBoxButtons.YesNo);
if (pesan == DialogResult.Yes)
{
string hasilCetak = NotaPembelian.CetakNota("NoNotaPembelian", textBoxNo.Text, "Nota_Beli_Tambah.txt");
if (hasilCetak == "1")
{
MessageBox.Show("Nota telah tercetak");
this.Close();
form.FormDaftarNotaBeli_Load(sender, e);
}
else
{
MessageBox.Show("Nota beli gagal dicetak. Pesan kesalahan : " + hasilCetak);
}
}
else
{
this.Close();
form.FormDaftarNotaBeli_Load(sender, e);
}
}
else
{
MessageBox.Show("gagal posting ke jurnal" + hasilTambahJurnal);
}
}
else
{
MessageBox.Show("Data nota beli gagal tersimpan. Pesan kesalahan : " + hasilTambahNota, "Kesalahan");
}
}
private void buttonSimpan_Click(object sender, EventArgs e)
{
FormDaftarPembayaran form = (FormDaftarPembayaran)this.Owner;
int hutang = int.Parse(textBoxNominal.Text);
DateTime tglPemb = dateTimePickerTgl.Value;
// pngecekan apabila tanggal pembayaran sebelum tanggal batas diskon
if (tglPemb <= btsDiskon) // apabila sebelum batas diskon
{
diskon = diskon / 100;
}
else // apabila melewati tanggal batas diskon
{
diskon = 0;
}
int hargaDiskon = (int)(hutang * diskon); // hitung total yang harus dibayar
//buat object bertipe notaBeli
NotaPembelian nota = new NotaPembelian();
nota.NoNotaPembelian = comboBoxNoNotaBeli.Text;
nota.Status = "L";
Pembayaran lunas = new Pembayaran();
lunas.IdPembayaran = textBoxNoPembayaran.Text;
lunas.CaraPembayaran = comboBoxCaraPemb.Text;
lunas.Tgl = dateTimePickerTgl.Value;
lunas.Nominal = hutang - hargaDiskon;
//lunas.NotaPembelian = nota;
string hasilTambahNota = Pembayaran.TambahData(lunas, nota);
if (hasilTambahNota == "1") //jika berhasil maka insert jurnal dan detil jurnal
{
MessageBox.Show("Data Pembayaran telah tersimpan", "Info");
//tambah posting ke jurnal
string idJurnal = Jurnal.GenerateIdJurnal();
Transaksi trans = new Transaksi();
//transaksi penjualan tunai (id transkasi 008);
trans.IdTransaksi = "009";
trans.Keterangan = "Melunasi hutang secara tunai";
//buat object bertipe jurnal
Jurnal jurnal = new Jurnal();
//tambahkan data
jurnal.IdJurnal = int.Parse(idJurnal);
jurnal.Tanggal = dateTimePickerTgl.Value;
jurnal.NomorBukti = comboBoxNoNotaBeli.Text;
jurnal.Jenis = "JU";
jurnal.Periode = pPeriode;
jurnal.Transaksi = trans;
//isi detil jurnalnya
//apabila diskon tidak 0 atau tidak ada diskon
//
//apabila ada diskon
jurnal.TambahDetilJurnalPembayaranHutangTunai(hutang, hargaDiskon);
//simpan ke tabel _jurnal
string hasilTambahJurnal = Jurnal.TambahData(jurnal);
if (hasilTambahJurnal == "1")
{
MessageBox.Show("berhasil posting ke jurnal");
FormUtama frmUtama = (FormUtama)this.Owner.MdiParent;
this.Close();
form.FormDaftarPembayaran_Load(sender, e);
}
else
{
MessageBox.Show("gagal posting ke jurnal" + hasilTambahJurnal);
}
}
else
{
MessageBox.Show("Data pembayaran gagal tersimpan. Pesan kesalahan : " + hasilTambahNota, "Kesalahan");
}
}
private void buttonCari_Click(object sender, EventArgs e)
{
string nilaiKriteria = textBoxCari.Text;
if (comboBoxCari.Text == "No Nota")
{
kriteria = "noNotaPembelian";
}
else if (comboBoxCari.Text == "ID Supplier")
{
kriteria = "idSupplier";
}
else if (comboBoxCari.Text == "Nama Supplier")
{
kriteria = "namaSupplier";
}
else if (comboBoxCari.Text == "Alamat Supplier")
{
kriteria = "alamatSupplier";
}
else if (comboBoxCari.Text == "Diskon")
{
kriteria = "diskon";
}
else if (comboBoxCari.Text == "Total Harga")
{
kriteria = "totalHarga";
}
else if (comboBoxCari.Text == "Batas Pelunasan")
{
kriteria = "tglBatasPelunasan";
}
else if (comboBoxCari.Text == "Batas Diskon")
{
kriteria = "tglBatasDiskon";
}
else if (comboBoxCari.Text == "Tanggal Pembelian")
{
kriteria = "tglBeli";
}
else if (comboBoxCari.Text == "Status")
{
kriteria = "status";
}
else if (comboBoxCari.Text == "Keterangan")
{
kriteria = "keterangan";
}
string hasilBaca = NotaPembelian.BacaData(kriteria, nilaiKriteria, listHasilData);
if (hasilBaca == "1")
{
dataGridViewNota.Rows.Clear();
for (int i = 0; i < listHasilData.Count; i++)
{
string total = listHasilData[i].TotalHarga.ToString("RP 0,###");
dataGridViewNota.Rows.Add(listHasilData[i].NoNotaPembelian, listHasilData[i].Supplier.IdSupplier,
listHasilData[i].Supplier.Nama, listHasilData[i].Supplier.Alamat, listHasilData[i].Diskon,
total, listHasilData[i].TglBatasPelunasan.ToString("dddd, dd MMMM yyyy"),
listHasilData[i].TglBatasDiskon.ToString("dddd, dd MMMM yyyy"),
listHasilData[i].TglBeli.ToString("dddd, dd MMMM yyyy"), listHasilData[i].Status, listHasilData[i].Keterangan);
}
}
}
