public MemoryStream CreatePdfDocument(CbTransH trans) { string Title = "BUKTI KAS/BANK"; string Tanggal = "Tanggal"; string NoDoc = "No."; // var cetak = JsonConvert.DeserializeObject(trans); // Console.WriteLine(trans); //Create a new PDF document PdfDocument document = new PdfDocument(); // document.PageSettings = new PdfPageSettings(new SizeF(300, 400)); //Add a page document.PageSettings.Margins.All = 0; PdfPage page = document.Pages.Add(); //Create Pdf graphics for the page PdfGraphics g = page.Graphics; //Create a solid brush PdfBrush brush = new PdfSolidBrush(new PdfColor(0, 0, 0)); PdfBrush tintamerah = new PdfSolidBrush(Color.Red); //Set the font PdfFont fontJudul = new PdfStandardFont(PdfFontFamily.TimesRoman, 16); PdfFont fontField = new PdfStandardFont(PdfFontFamily.TimesRoman, 10); //Draw Kotak RectangleF rectangle = new RectangleF(20, 120, 50, 50); g.DrawRectangle(brush, rectangle); g.TranslateTransform(60, 0); // Judul //Draw the text g.DrawString(Title, fontJudul, tintamerah, new PointF(150, 20)); g.DrawString(Tanggal, fontField, brush, new PointF(0, 50)); g.DrawString(trans.Tanggal.ToShortDateString(), fontField, brush, new PointF(50, 50)); g.DrawString(NoDoc, fontField, brush, new PointF(0, 80)); g.DrawString(trans.DocNo, fontField, brush, new PointF(50, 80)); //Saving the PDF to the MemoryStream MemoryStream ms = new MemoryStream(); document.Save(ms); //If the position is not set to '0' then the PDF will be empty. ms.Position = 0; return(ms); }
public async Task <CbTransH> AddTransH(TranshView trans) { //string test = codeview.SrcCode.ToUpper(); //var cekFirst = _context.CbSrcCodes.Where(x => x.SrcCode == test).ToList(); CbTransH transH = new CbTransH { DocNo = GetNumber(trans.KodeDoc.ToUpper()), KodeBank = trans.KodeBank.ToUpper(), Tanggal = trans.Tanggal, Keterangan = trans.Keterangan, Kurs = trans.Kurs, Saldo = trans.Saldo, KSaldo = trans.KSaldo, CbTransDs = new List <CbTransD>() }; foreach (var item in trans.TransDs) { transH.CbTransDs.Add(new CbTransD() { SrcCode = item.SrcCode, Keterangan = item.Keterangan, Terima = item.Terima, Bayar = item.Bayar, KTerima = item.KTerima, KBayar = item.KBayar, KValue = item.KValue, Jumlah = item.Jumlah, KJumlah = item.KJumlah, Kurs = item.Kurs }); } var bank = (from e in _context.Banks where e.KodeBank == trans.KodeBank select e).FirstOrDefault(); bank.Saldo += trans.Saldo; bank.KSaldo += trans.KSaldo; _context.Banks.Update(bank); _context.CbTransHs.Add(transH); await _context.SaveChangesAsync(); var TempTrans = GetTransDoc(transH.DocNo); return(await TempTrans); // return true; }
public async Task <bool> AddTransH(ArTransHView trans) { //string test = codeview.SrcCode.ToUpper(); //var cekFirst = _context.CbSrcCodes.Where(x => x.SrcCode == test).ToList(); string KdSrc = "AR"; ArTransH transH = new ArTransH { Bukti = GetNumber(), Customer = trans.Customer.ToUpper(), Tanggal = trans.Tanggal, Keterangan = trans.Keterangan, Jumlah = trans.JumBayar, Discount = trans.JumDiskon, Unapplied = trans.UpdateUnapplied, Piutang = trans.JumPiutang, KdBank = trans.KdBank, PPn = 0, PPh = 0, JumPPh = 0, JumPPn = 0, Bruto = 0, Netto = 0, Pajak = false, Kode = "14", ArCustId = trans.ArCustId, ArTransDs = new List <ArTransD>() }; List <ArPiutng> transaksi = new List <ArPiutng>(); transaksi = _context.ArPiutngs.Where(x => x.Customer == trans.Customer && x.Sisa != 0).ToList(); foreach (var item in trans.ArTransDs) { transH.ArTransDs.Add(new ArTransD() { Jumlah = item.Jumlah, Kode = "14", KodeTran = item.KodeTran, Lpb = transH.Bukti, Tanggal = trans.Tanggal, Discount = item.Discount, Bayar = item.Bayar, Sisa = item.UpdateSisa }); transaksi.Where(x => x.Dokumen == item.Lpb).ToList() .ForEach(s => { s.Bayar = item.Bayar + item.Discount; s.Discount = item.Discount; s.Sisa = item.UpdateSisa; }); } transH.ArTransDs.RemoveAll(x => x.Bayar == 0 && x.Discount == 0); transaksi.RemoveAll(x => x.Bayar == 0 && x.Discount == 0); var customer = (from e in _context.ArCusts where e.Customer == trans.Customer select e).FirstOrDefault(); customer.Piutang -= trans.Jumlah; ArPiutng Newtransaksi = new ArPiutng { Kode = "CA", Dokumen = transH.Bukti, Tanggal = transH.Tanggal, Customer = transH.Customer, Keterangan = transH.Keterangan, KodeTran = "14", Jumlah = -1 * trans.JumPiutang, SldSisa = -1 * trans.JumPiutang, Bayar = -1 * trans.JumBayar, Discount = 0, UnApplied = -1 * trans.UpdateUnapplied, Sisa = -1 * trans.UpdateUnapplied, Dpp = 0, PPn = 0, PPh = 0, SldBayar = 0, SldDisc = 0, SldUnpl = 0 }; _context.ArCusts.Update(customer); _context.ArTransHs.Add(transH); _context.ArPiutngs.UpdateRange(transaksi); _context.ArPiutngs.Add(Newtransaksi); await _context.SaveChangesAsync(); var cekBukti = (from e in _context.CbTransHs where e.DocNo == transH.Bukti select e).FirstOrDefault(); if (cekBukti == null) { if (transH.KdBank != null && transH.KdBank.Length != 0) { CbTransH transBank = new CbTransH { DocNo = transH.Bukti, KodeBank = trans.KdBank, Tanggal = trans.Tanggal, Keterangan = trans.Keterangan, Saldo = trans.JumBayar, CbTransDs = new List <CbTransD>() }; foreach (var item in trans.ArTransDs) { transBank.CbTransDs.Add(new CbTransD() { SrcCode = KdSrc, Keterangan = "Pembayaran Piutang" + trans.Customer.ToUpper(), Terima = item.Bayar, Jumlah = item.Bayar, }); } var bank = (from e in _context.Banks where e.KodeBank == trans.KdBank select e).FirstOrDefault(); bank.Saldo += trans.JumBayar; _context.Banks.Update(bank); _context.CbTransHs.Add(transBank); await _context.SaveChangesAsync(); } } return(true); }
public async Task <CbTransH> EditTransH(TranshView trans) { //string test = codeview.SrcCode.ToUpper(); //var cekFirst = _context.CbSrcCodes.Where(x => x.SrcCode == test).ToList(); try { var ExistingTrans = _context.CbTransHs.Where(x => x.CbTransHId == trans.CbTransHId).FirstOrDefault(); if (ExistingTrans != null) { _context.CbTransHs.Remove(ExistingTrans); var bank = (from e in _context.Banks where e.KodeBank == trans.KodeBank select e).FirstOrDefault(); bank.Saldo -= ExistingTrans.Saldo; bank.KSaldo -= ExistingTrans.KSaldo; _context.Banks.Update(bank); /* update */ CbTransH transH = new CbTransH { // transH.DocNo = ExistingTrans.DocNo; DocNo = ExistingTrans.DocNo, KodeBank = trans.KodeBank.ToUpper(), Tanggal = trans.Tanggal, Keterangan = trans.Keterangan, Kurs = trans.Kurs, Saldo = trans.Saldo, KSaldo = trans.KSaldo, CbTransDs = new List <CbTransD>() }; foreach (var item in trans.TransDs) { transH.CbTransDs.Add(new CbTransD() { SrcCode = item.SrcCode, Keterangan = item.Keterangan, Terima = item.Terima, Bayar = item.Bayar, KTerima = item.KTerima, KBayar = item.KBayar, KValue = item.KValue, Jumlah = item.Jumlah, KJumlah = item.KJumlah, Kurs = item.Kurs }); } bank.Saldo += trans.Saldo; bank.KSaldo += trans.KSaldo; _context.Banks.Update(bank); _context.CbTransHs.Add(transH); await _context.SaveChangesAsync(); return(transH); // return true; } else { return(ExistingTrans); } } catch (Exception ex) { throw ex; } }
public async Task <CbTransfer> AddTransfer(TransferView trans) { //string test = codeview.SrcCode.ToUpper(); //var cekFirst = _context.CbSrcCodes.Where(x => x.SrcCode == test).ToList(); CbTransfer transfer = new CbTransfer { DocNo = GetNumberTrf("TRF"), Tanggal = trans.Tanggal, Keterangan = trans.Keterangan, Kurs = trans.Kurs, Saldo = trans.Saldo, KSaldo = trans.KSaldo, KodeBank1 = trans.KodeBank1.ToUpper(), KodeBank2 = trans.KodeBank2.ToUpper() }; CbTransH transH = new CbTransH { DocNo = GetNumber('T' + trans.KodeBank1.ToUpper().Trim()), KodeBank = trans.KodeBank1.ToUpper(), Tanggal = trans.Tanggal, Keterangan = trans.Keterangan, Kurs = trans.Kurs, Saldo = trans.Saldo, KSaldo = trans.KSaldo, CbTransDs = new List <CbTransD>() }; transH.CbTransDs.Add(new CbTransD() { SrcCode = "CB", Keterangan = trans.Keterangan, Terima = 0, Bayar = trans.Saldo, KTerima = 0, KBayar = trans.KSaldo, KValue = trans.KValue, Jumlah = -1 * trans.Saldo, KJumlah = -1 * trans.KSaldo, Kurs = trans.Kurs }); var bank = (from e in _context.Banks where e.KodeBank == trans.KodeBank1 select e).FirstOrDefault(); bank.Saldo -= trans.Saldo; bank.KSaldo -= trans.KSaldo; _context.Banks.Update(bank); _context.CbTransHs.Add(transH); /* ke bank */ CbTransH transHd = new CbTransH { DocNo = GetNumber('T' + trans.KodeBank2.ToUpper().Trim()), KodeBank = trans.KodeBank1.ToUpper(), Tanggal = trans.Tanggal, Keterangan = trans.Keterangan, Kurs = trans.Kurs, Saldo = trans.Saldo, KSaldo = trans.KSaldo, CbTransDs = new List <CbTransD>() }; transH.CbTransDs.Add(new CbTransD() { SrcCode = "CB", Keterangan = trans.Keterangan, Terima = trans.Saldo, Bayar = 0, KTerima = trans.KSaldo, KBayar = 0, KValue = trans.KValue, Jumlah = trans.Saldo, KJumlah = trans.KSaldo, Kurs = trans.Kurs }); var bankd = (from e in _context.Banks where e.KodeBank == trans.KodeBank2 select e).FirstOrDefault(); bankd.Saldo += trans.Saldo; bankd.KSaldo += trans.KSaldo; _context.Banks.Update(bankd); _context.CbTransHs.Add(transHd); await _context.SaveChangesAsync(); var TempTrans = GetTransferDoc(transfer.DocNo); return(await TempTrans); // return true; }
public async Task <bool> AddTransH(ApTransHView trans) { //string test = codeview.SrcCode.ToUpper(); //var cekFirst = _context.CbSrcCodes.Where(x => x.SrcCode == test).ToList(); string KdSrc = "AP"; ApTransH transH = new ApTransH { Bukti = GetNumber(), Supplier = trans.Supplier.ToUpper(), Tanggal = trans.Tanggal, Keterangan = trans.Keterangan, Jumlah = trans.JumBayar, Discount = 0, Unapplied = trans.UpdateUnapplied, Hutang = 0, KdBank = trans.KdBank, PPn = 0, PPh = 0, JumPPh = 0, JumPPn = 0, Bruto = 0, Netto = 0, Pajak = false, Kode = "23", ApSupplId = trans.ApSupplId // ApTransDs = new List<ApTransD>() }; #region detailTrans //List<ApHutang> transaksi = new List<ApHutang>(); //transaksi = _context.ApHutangs.Where(x => x.supplier == trans.supplier && x.Sisa != 0).ToList(); //foreach (var item in trans.ApTransDs) //{ // transH.ApTransDs.Add(new ApTransD() // { // Jumlah = item.Jumlah, // Kode = "14", // KodeTran = item.KodeTran, // Lpb = transH.Bukti, // Tanggal = trans.Tanggal, // Discount = item.Discount, // Bayar = item.Bayar, // Sisa = item.UpdateSisa // }); // transaksi.Where(x => x.Dokumen == item.Lpb).ToList() // .ForEach(s => // { // s.Bayar = item.Bayar + item.Discount; // s.Discount = item.Discount; // s.Sisa = item.UpdateSisa; // }); //} //transH.ApTransDs.RemoveAll(x => x.Bayar == 0 && x.Discount == 0); //transaksi.RemoveAll(x => x.Bayar == 0 && x.Discount == 0); #endregion ApHutang transaksi = new ApHutang { Kode = "CA", Dokumen = transH.Bukti, Tanggal = transH.Tanggal, Supplier = transH.Supplier, Keterangan = transH.Keterangan, KodeTran = "23", Jumlah = -1 * transH.Jumlah, SldSisa = -1 * transH.Jumlah, Bayar = -1 * transH.Jumlah, Discount = 0, UnApplied = -1 * transH.Unapplied, Sisa = -1 * transH.Unapplied, Dpp = 0, PPn = 0, PPh = 0, SldBayar = 0, SldDisc = 0, SldUnpl = 0 }; var supplier = (from e in _context.ApSuppls where e.Supplier == trans.Supplier select e).FirstOrDefault(); supplier.Hutang -= transH.Jumlah; _context.ApSuppls.Update(supplier); _context.ApTransHs.Add(transH); _context.ApHutangs.Add(transaksi); await _context.SaveChangesAsync(); var cekBukti = (from e in _context.CbTransHs where e.DocNo == transH.Bukti select e).FirstOrDefault(); if (cekBukti == null) { if (transH.KdBank != null && transH.KdBank.Length != 0) { CbTransH transBank = new CbTransH { DocNo = transH.Bukti, KodeBank = trans.KdBank, Tanggal = trans.Tanggal, Keterangan = trans.Keterangan, Saldo = -1 * trans.JumBayar, CbTransDs = new List <CbTransD>() }; transBank.CbTransDs.Add(new CbTransD() { SrcCode = KdSrc, Keterangan = "Pembayaran Uang Muka " + trans.Supplier.ToUpper(), Bayar = trans.JumBayar, Jumlah = -1 * trans.JumBayar }); var bank = (from e in _context.Banks where e.KodeBank == trans.KdBank select e).FirstOrDefault(); bank.Saldo -= trans.JumBayar; _context.Banks.Update(bank); _context.CbTransHs.Add(transBank); await _context.SaveChangesAsync(); } } return(true); }