public MemoryStream PdfBuktiBank(TranshView trans)
{
var buktibank = _context.CbTransHs.Include(p => p.CbTransDs).Where(x => x.DocNo == trans.DocNo).FirstOrDefaultAsync();
if (buktibank == null)
{
throw new ArgumentNullException("Transaksi cannot be null");
}
using (PdfDocument pdfDocument = new PdfDocument())
{
// int paragraphAfterSpacing = 8;
// int cellMargin = 8;
//Add page to the PDF document
PdfPage page = pdfDocument.Pages.Add();
//Create a new font
PdfStandardFont font = new PdfStandardFont(PdfFontFamily.TimesRoman, 16);
//Create a text element to draw a text in PDF page
PdfTextElement title = new PdfTextElement("BUKTI KAS/BANK", font, PdfBrushes.Black);
PdfLayoutResult result = title.Draw(page, new PointF(0, 0));
using (MemoryStream stream = new MemoryStream())
{
//Saving the PDF document into the stream
pdfDocument.Save(stream);
//Closing the PDF document
pdfDocument.Close(true);
return(stream);
}
}
}
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 <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;
}
}
