private void Save() { var kasBon = new KasBonModel { KasBonID = BiayaIDText.Text, Tgl = TglText.Value.ToString("dd-MM-yyyy"), Jam = JamText.Text, PihakKeduaID = PihakKeduaCombo.SelectedValue.ToString(), JenisKasID = JenisKasCombo.SelectedValue.ToString(), Keterangan = KeteranganText.Text, NilaiKasBon = NilIText.Value }; using (var trans = TransHelper.NewScope()) { var result = _kasBonBL.Save(kasBon); try { _bpKasBL.Generate(result); _bpPiutangBL.GenPiutang(result); } catch (ArgumentException ex) { MessageBox.Show(ex.Message); } trans.Complete(); } }
public void Update(KasBonModel model) { var sSql = @" UPDATE KasBon SET Tgl = @Tgl, Jam = @Jam, Keterangan = @Keterangan, PihakKeduaID = @PihakKeduaID, JenisKasID = @JenisKasID, NilaiKasBon = @NilaiKasBon WHERE KasBonID = @KasBonID "; using (var conn = new SqlConnection(_connString)) using (var cmd = new SqlCommand(sSql, conn)) { cmd.AddParam("@KasBonID", model.KasBonID); cmd.AddParam("@Tgl", model.Tgl.ToTglYMD()); cmd.AddParam("@Jam", model.Jam); cmd.AddParam("@Keterangan", model.Keterangan); cmd.AddParam("@PihakKeduaID", model.PihakKeduaID); cmd.AddParam("@JenisKasID", model.JenisKasID); cmd.AddParam("@NilaiKasBon", model.NilaiKasBon); conn.Open(); cmd.ExecuteNonQuery(); } }
public void Insert(KasBonModel model) { var sSql = @" INSERT INTO KasBon ( KasBonID, Tgl, Jam, Keterangan, PihakKeduaID, JenisKasID, NilaiKasBon) VALUES ( @KasBonID, @Tgl, @Jam, @Keterangan, @PihakKeduaID, @JenisKasID, @NilaiKasBon) "; using (var conn = new SqlConnection(_connString)) using (var cmd = new SqlCommand(sSql, conn)) { cmd.AddParam("@KasBonID", model.KasBonID); cmd.AddParam("@Tgl", model.Tgl.ToTglYMD()); cmd.AddParam("@Jam", model.Jam); cmd.AddParam("@Keterangan", model.Keterangan); cmd.AddParam("@PihakKeduaID", model.PihakKeduaID); cmd.AddParam("@JenisKasID", model.JenisKasID); cmd.AddParam("@NilaiKasBon", model.NilaiKasBon); conn.Open(); cmd.ExecuteNonQuery(); } }
public BPPiutangModel GenPiutang(KasBonModel kasBon) { if (kasBon == null) { throw new ArgumentNullException(nameof(kasBon)); } var bpPiutang = (BPPiutangModel)kasBon; var result = Save(bpPiutang); return result; }
public BPKasModel Generate(KasBonModel kasBon) { if (kasBon == null) { throw new ArgumentNullException(nameof(kasBon)); } var bpKas = (BPKasModel)kasBon; var result = Save(bpKas); return(result); }
public IEnumerable <KasBonModel> ListData(string tgl1, string tgl2) { List <KasBonModel> result = null; var sSql = @" SELECT aa.KasBonID, aa.Tgl, aa.Jam, aa.Keterangan, aa.PihakKeduaID, aa.JenisKasID, aa.NilaiKasBon, ISNULL(bb.PihakKeduaName, '') PihakKeduaName, ISNULL(cc.JenisKasName, '') JenisKasName FROM KasBon aa LEFT JOIN PihakKedua bb ON aa.PihakKeduaID = bb.PihakKeduaID LEFT JOIN JenisKas cc ON aa.JenisKasID = cc.JenisKasID WHERE Tgl BETWEEN @Tgl1 AND @Tgl2 "; using (var conn = new SqlConnection(_connString)) using (var cmd = new SqlCommand(sSql, conn)) { cmd.AddParam("@Tgl1", tgl1.ToTglYMD()); cmd.AddParam("@Tgl2", tgl2.ToTglYMD()); conn.Open(); using (var dr = cmd.ExecuteReader()) { if (!dr.HasRows) { return(null); } result = new List <KasBonModel>(); while (dr.Read()) { var item = new KasBonModel { KasBonID = dr["KasBonID"].ToString(), Tgl = dr["Tgl"].ToString().ToTglDMY(), Jam = dr["Jam"].ToString(), Keterangan = dr["Keterangan"].ToString(), PihakKeduaID = dr["PihakKeduaID"].ToString(), PihakKeduaName = dr["PihakKeduaName"].ToString(), JenisKasID = dr["JenisKasID"].ToString(), JenisKasName = dr["JenisKasName"].ToString(), NilaiKasBon = Convert.ToDecimal(dr["NilaiKasBon"]) }; result.Add(item); } } } return(result); }
public KasBonModel Save(KasBonModel model) { if (model == null) { throw new ArgumentNullException(nameof(model)); } if (model.NilaiKasBon <= 0) { throw new ArgumentException("Nilai KasBon invalid"); } var jenisKasBon = _jenisKasBonBL.GetData(model.PihakKeduaID); if (jenisKasBon == null) { throw new ArgumentException("PihakKeduaID invalid"); } var jenisKas = _jenisKasBL.GetData(model.JenisKasID); if (jenisKas == null) { throw new ArgumentException("JenisKasID invalid"); } bool isNew = false; if (model.KasBonID.Trim() == "") { isNew = true; } using (var trans = TransHelper.NewScope()) { if (isNew) { model.KasBonID = GenNewID(); _kasBonDal.Insert(model); } else { _kasBonDal.Update(model); } trans.Complete(); } return(model); }
private KasBonModel KasBonDataFactory() { var result = new KasBonModel { KasBonID = "A1", Tgl = "11-02-2019", Jam = "01:38:00", Keterangan = "B1", PihakKeduaID = "C1", PihakKeduaName = "", JenisKasID = "D1", JenisKasName = "", NilaiKasBon = 300000 }; return(result); }
public BPKasModel Generate(LunasKasBonModel lunasKasBon, KasBonModel kasBon) { if (lunasKasBon == null) { throw new ArgumentNullException(nameof(lunasKasBon)); } if (kasBon == null) { throw new ArgumentNullException(nameof(kasBon)); } if (lunasKasBon.KasBonID != kasBon.KasBonID) { throw new ArgumentException("KasBonID invalid"); } // convert lunasKasBon menjadi object kasBon BPKasModel bpKas = new BPKasModel { BPKasID = lunasKasBon.LunasKasBonID, Tgl = lunasKasBon.Tgl, Jam = lunasKasBon.Jam, Keterangan = "Lunas KasBon " + kasBon.Keterangan, NilaiTotalKas = 0, }; BPKasDetilModel detil = new BPKasDetilModel { BPKasID = bpKas.BPKasID, BPKasDetilID = bpKas.BPKasID + '-' + "01", JenisKasID = "K01", NilaiKasMasuk = lunasKasBon.ListLunas .Where(x => x.JenisLunasID == "KAS") .Sum(x => x.NilaiLunas) }; bpKas.ListDetil = new List <BPKasDetilModel> { detil }; var result = Save(bpKas); return(result); }
public void GenPiutangDelete(KasBonModel kasBon) { if (kasBon == null) { throw new ArgumentNullException(nameof(kasBon)); } // jika sudah ada pelunasan, tidak bisa di hapus var bpPiutang = GetData(kasBon.KasBonID); if (bpPiutang == null) throw new ArgumentException("KasBon invalid"); if (bpPiutang.NilaiLunas > 0) throw new ArgumentException("KasBon sudah ada pelunasan, tidak dapat di hapus"); _bpPiutangDetilDal.Delete(kasBon.KasBonID); _bpPiutangDal.Delete(kasBon.KasBonID); }
public KasBonModel GetData(string id) { KasBonModel result = null; var sSql = @" SELECT aa.KasBonID, aa.Tgl, aa.Jam, aa.Keterangan, aa.PihakKeduaID, aa.JenisKasID, aa.NilaiKasBon, ISNULL(bb.PihakKeduaName, '') PihakKeduaName, ISNULL(cc.JenisKasName, '') JenisKasName FROM KasBon aa LEFT JOIN PihakKedua bb ON aa.PihakKeduaID = bb.PihakKeduaID LEFT JOIN JenisKas cc ON aa.JenisKasID = cc.JenisKasID WHERE KasBonID = @KasBonID "; using (var conn = new SqlConnection(_connString)) using (var cmd = new SqlCommand(sSql, conn)) { cmd.AddParam("@KasBonID", id); conn.Open(); using (var dr = cmd.ExecuteReader()) { if (!dr.HasRows) { return(null); } dr.Read(); result = new KasBonModel { KasBonID = id, Tgl = dr["Tgl"].ToString().ToTglDMY(), Jam = dr["Jam"].ToString(), Keterangan = dr["Keterangan"].ToString(), PihakKeduaID = dr["PihakKeduaID"].ToString(), PihakKeduaName = dr["PihakKeduaName"].ToString(), JenisKasID = dr["JenisKasID"].ToString(), JenisKasName = dr["JenisKasName"].ToString(), NilaiKasBon = Convert.ToDecimal(dr["NilaiKasBon"]) }; } } return(result); }
public BPPiutangModel GenPiutang(LunasKasBonModel lunasKasBon, KasBonModel kasBon) { // ambil data piutang berdasarkan kasBon var bpPiutang = GetData(kasBon.KasBonID); if(bpPiutang == null) { var errMsg = string.Format("Piutang {0} tidak ditemukan ", kasBon.KasBonID); throw new ArgumentException(errMsg); } // hapus detil lunas yang id-nya = lunasKasBonID List<BPPiutangDetilModel> newListLunas = ( from c in bpPiutang.ListLunas where c.ReffID != lunasKasBon.LunasKasBonID select c ).ToList(); // tambahkan pelunasan dari lunasKasBon int noUrut = newListLunas.Count + 1; foreach(var item in lunasKasBon.ListLunas) { newListLunas.Add(new BPPiutangDetilModel { BPPiutangID = bpPiutang.BPPiutangID, BPPiutangDetilID = bpPiutang.BPPiutangID + '-' + noUrut.ToString().PadLeft(2, '0'), Tgl = lunasKasBon.Tgl, Jam = lunasKasBon.Jam, ReffID = item.LunasKasBonID, Keterangan = " Pelunasan " + item.Keterangan, NilaiPiutang = 0, NilaiLunas = item.NilaiLunas }); noUrut++; } bpPiutang.ListLunas = newListLunas; // simpan var result = Save(bpPiutang); return result; }