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