//public GarmentShippingLocalSalesNotePdfTemplatePageEvent(IIdentityProvider identityProvider, GarmentShippingLocalSalesNoteViewModel viewModel, GarmentLocalCoverLetterViewModel cl, Buyer buyer, int timeoffset)
public GarmentShippingLocalSalesNotePdfTemplatePageEvent(GarmentShippingLocalSalesNoteViewModel viewModel, GarmentLocalCoverLetterViewModel cl, Buyer buyer, int timeoffset)
{
//this.identityProvider = identityProvider;
this.viewModel = viewModel;
this.timeoffset = timeoffset;
this.buyer = buyer;
}
public async Task <int> Create(GarmentShippingLocalSalesNoteViewModel viewModel)
{
var model = MapToModel(viewModel);
int Created = await _repository.InsertAsync(model);
return(Created);
}
private string GenerateNo(GarmentShippingLocalSalesNoteViewModel vm)
{
var year = DateTime.Now.ToString("yy");
var prefix = $"{year}/{(vm.transactionType.code ?? "").Trim().ToUpper()}/";
var lastInvoiceNo = _repository.ReadAll().Where(w => w.NoteNo.StartsWith(prefix))
.OrderByDescending(o => o.NoteNo)
.Select(s => int.Parse(s.NoteNo.Replace(prefix, "")))
.FirstOrDefault();
var invoiceNo = $"{prefix}{(lastInvoiceNo + 1).ToString("D5")}";
return(invoiceNo);
}
private GarmentShippingLocalSalesNoteModel MapToModel(GarmentShippingLocalSalesNoteViewModel vm)
{
var items = (vm.items ?? new List<GarmentShippingLocalSalesNoteItemViewModel>()).Select(i =>
{
i.product = i.product ?? new ProductViewModel();
i.uom = i.uom ?? new UnitOfMeasurement();
i.packageUom = i.packageUom ?? new UnitOfMeasurement();
return new GarmentShippingLocalSalesNoteItemModel(i.localSalesContractItemId, i.product.id, i.product.code, i.product.name, i.quantity, i.uom.Id.GetValueOrDefault(), i.uom.Unit, i.price,i.packageQuantity,i.packageUom.Id.GetValueOrDefault(), i.packageUom.Unit) { Id = i.Id };
}).ToList();
vm.transactionType = vm.transactionType ?? new TransactionType();
vm.buyer = vm.buyer ?? new Buyer();
vm.vat = vm.vat ?? new Vat();
return new GarmentShippingLocalSalesNoteModel(vm.salesContractNo, vm.localSalesContractId, vm.paymentType, GenerateNo(vm), vm.date.GetValueOrDefault(), vm.transactionType.id, vm.transactionType.code, vm.transactionType.name, vm.buyer.Id, vm.buyer.Code, vm.buyer.Name, vm.buyer.npwp, vm.buyer.KaberType, vm.tempo, vm.expenditureNo, vm.dispositionNo, vm.useVat, vm.vat.id, vm.vat.rate, vm.remark, vm.isUsed, vm.isApproveShipping, vm.isApproveFinance, vm.approveShippingBy, vm.approveFinanceBy, vm.approveShippingDate, vm.approveFinanceDate, vm.isRejectedShipping, vm.isRejectedFinance, vm.rejectedReason, items) { Id = vm.Id };
}
public MemoryStream GeneratePdfTemplate(GarmentShippingLocalSalesNoteViewModel viewModel, GarmentLocalCoverLetterViewModel cl, Buyer buyer, int timeoffset)
{
const int MARGIN = 20;
Font header_font_bold_big = FontFactory.GetFont(BaseFont.COURIER_BOLD, BaseFont.CP1250, BaseFont.NOT_EMBEDDED, 12);
Font header_font_bold = FontFactory.GetFont(BaseFont.COURIER_BOLD, BaseFont.CP1250, BaseFont.NOT_EMBEDDED, 9);
Font header_font_bold_underlined = FontFactory.GetFont(BaseFont.COURIER_BOLD, BaseFont.CP1250, BaseFont.NOT_EMBEDDED, 10, Font.UNDERLINE);
Font header_font = FontFactory.GetFont(BaseFont.COURIER, BaseFont.CP1250, BaseFont.NOT_EMBEDDED, 11);
Font normal_font = FontFactory.GetFont(BaseFont.COURIER, BaseFont.CP1250, BaseFont.NOT_EMBEDDED, 8);
Font normal_font_underlined = FontFactory.GetFont(BaseFont.COURIER, BaseFont.CP1250, BaseFont.NOT_EMBEDDED, 8, Font.UNDERLINE);
Font normal_font_bold = FontFactory.GetFont(BaseFont.COURIER_BOLD, BaseFont.CP1250, BaseFont.NOT_EMBEDDED, 8);
Document document = new Document(PageSize.A5.Rotate(), MARGIN, MARGIN, MARGIN, MARGIN);
MemoryStream stream = new MemoryStream();
PdfWriter writer = PdfWriter.GetInstance(document, stream);
document.Open();
#region header
PdfPTable tableHeader = new PdfPTable(2);
tableHeader.WidthPercentage = 100;
tableHeader.SetWidths(new float[] { 3f, 2f });
PdfPCell cellHeaderContent1 = new PdfPCell()
{
Border = Rectangle.NO_BORDER
};
PdfPCell cellHeaderContent2 = new PdfPCell()
{
Border = Rectangle.NO_BORDER
};
cellHeaderContent1.AddElement(new Phrase("\n", normal_font));
cellHeaderContent1.AddElement(new Phrase("PT. DAN LIRIS", header_font_bold));
cellHeaderContent1.AddElement(new Phrase("Jl. Merapi No. 23, Kel. Banaran Kec.Grogol Kab. Sukoharjo", normal_font));
cellHeaderContent1.AddElement(new Phrase("Telp : 0271-714400, Fax. 0271-717178", normal_font));
cellHeaderContent1.AddElement(new Phrase("PO. Box. 166 Solo-57100 Indonesia", normal_font));
//cellHeaderContent1.AddElement(new Phrase("\n", normal_font));
tableHeader.AddCell(cellHeaderContent1);
cellHeaderContent2.AddElement(new Phrase("Sukoharjo, " + viewModel.date.GetValueOrDefault().ToOffset(new TimeSpan(timeoffset, 0, 0)).ToString("dd MMMM yyyy", new System.Globalization.CultureInfo("id-ID")), normal_font));
cellHeaderContent2.AddElement(new Phrase("\n", normal_font));
//cellHeaderContent2.AddElement(new Phrase("\n", normal_font));
cellHeaderContent2.AddElement(new Phrase(viewModel.buyer.Code + " - " + viewModel.buyer.Name + " - " + viewModel.buyer.KaberType, normal_font));
cellHeaderContent2.AddElement(new Phrase(buyer.Address, normal_font));
tableHeader.AddCell(cellHeaderContent2);
document.Add(tableHeader);
#endregion
#region title
Paragraph title = new Paragraph("NOTA PENJUALAN GARMENT", header_font_bold);
title.Alignment = Element.ALIGN_CENTER;
document.Add(title);
Paragraph no = new Paragraph(viewModel.noteNo, header_font_bold);
no.Alignment = Element.ALIGN_CENTER;
document.Add(no);
if (viewModel.buyer.KaberType == "KABER")
{
Paragraph location = new Paragraph("PPN BERFASILITAS", normal_font_bold);
location.Alignment = Element.ALIGN_RIGHT;
document.Add(location);
}
PdfPTable tableTitle = new PdfPTable(3);
tableTitle.WidthPercentage = 40;
tableTitle.SetWidths(new float[] { 3f, 0.5f, 4f });
PdfPCell cellTitle1 = new PdfPCell()
{
Border = Rectangle.NO_BORDER, HorizontalAlignment = Element.ALIGN_LEFT
};
cellTitle1.Phrase = new Phrase("NPWP Penjual", normal_font);
tableTitle.AddCell(cellTitle1);
cellTitle1.Phrase = new Phrase(":", normal_font);
tableTitle.AddCell(cellTitle1);
cellTitle1.Phrase = new Phrase("01.139.907.8-532.000", normal_font);
tableTitle.AddCell(cellTitle1);
cellTitle1.Phrase = new Phrase("NPWP Pembeli", normal_font);
tableTitle.AddCell(cellTitle1);
cellTitle1.Phrase = new Phrase(":", normal_font);
tableTitle.AddCell(cellTitle1);
cellTitle1.Phrase = new Phrase(buyer.npwp, normal_font);
tableTitle.AddCell(cellTitle1);
cellTitle1.Phrase = new Phrase("NIK Pembeli", normal_font);
tableTitle.AddCell(cellTitle1);
cellTitle1.Phrase = new Phrase(":", normal_font);
tableTitle.AddCell(cellTitle1);
cellTitle1.Phrase = new Phrase(buyer.NIK, normal_font);
tableTitle.AddCell(cellTitle1);
tableTitle.SpacingAfter = 5;
tableTitle.HorizontalAlignment = Element.ALIGN_LEFT;
document.Add(tableTitle);
#endregion
#region bodyTable
PdfPTable tableBody = new PdfPTable(7);
tableBody.WidthPercentage = 100;
tableBody.SetWidths(new float[] { 1.2f, 1f, 5f, 2f, 1f, 2f, 2f });
PdfPCell cellBodyLeft = new PdfPCell()
{
Border = Rectangle.BOTTOM_BORDER | Rectangle.TOP_BORDER | Rectangle.LEFT_BORDER | Rectangle.RIGHT_BORDER, HorizontalAlignment = Element.ALIGN_LEFT
};
PdfPCell cellBodyLeftNoBorder = new PdfPCell()
{
Border = Rectangle.BOTTOM_BORDER | Rectangle.TOP_BORDER | Rectangle.RIGHT_BORDER, HorizontalAlignment = Element.ALIGN_LEFT
};
PdfPCell cellBodyRight = new PdfPCell()
{
Border = Rectangle.BOTTOM_BORDER | Rectangle.TOP_BORDER | Rectangle.LEFT_BORDER | Rectangle.RIGHT_BORDER, HorizontalAlignment = Element.ALIGN_RIGHT
};
PdfPCell cellBodyRightNoBorder = new PdfPCell()
{
Border = Rectangle.BOTTOM_BORDER | Rectangle.TOP_BORDER | Rectangle.LEFT_BORDER, HorizontalAlignment = Element.ALIGN_RIGHT
};
PdfPCell cellBodyCenter = new PdfPCell()
{
Border = Rectangle.BOTTOM_BORDER | Rectangle.TOP_BORDER | Rectangle.LEFT_BORDER | Rectangle.RIGHT_BORDER, HorizontalAlignment = Element.ALIGN_CENTER
};
cellBodyCenter.Phrase = new Phrase("Banyak", normal_font);
tableBody.AddCell(cellBodyCenter);
cellBodyCenter.Phrase = new Phrase("Satuan", normal_font);
tableBody.AddCell(cellBodyCenter);
cellBodyCenter.Phrase = new Phrase("Nama Barang", normal_font);
tableBody.AddCell(cellBodyCenter);
cellBodyCenter.Phrase = new Phrase("Quantity", normal_font);
cellBodyCenter.Colspan = 2;
tableBody.AddCell(cellBodyCenter);
cellBodyCenter.Phrase = new Phrase("Harga Sat.", normal_font);
cellBodyCenter.Colspan = 1;
tableBody.AddCell(cellBodyCenter);
cellBodyCenter.Phrase = new Phrase("Jumlah", normal_font);
cellBodyCenter.Colspan = 1;
tableBody.AddCell(cellBodyCenter);
foreach (var item in viewModel.items)
{
cellBodyRight.Phrase = new Phrase(string.Format("{0:n2}", item.packageQuantity), normal_font);
tableBody.AddCell(cellBodyRight);
cellBodyLeft.Phrase = new Phrase(item.packageUom.Unit, normal_font);
tableBody.AddCell(cellBodyLeft);
cellBodyLeft.Phrase = new Phrase(item.product.code + " - " + item.product.name, normal_font);
tableBody.AddCell(cellBodyLeft);
cellBodyRightNoBorder.Phrase = new Phrase(string.Format("{0:n2}", item.quantity), normal_font);
tableBody.AddCell(cellBodyRightNoBorder);
cellBodyLeftNoBorder.Phrase = new Phrase(item.uom.Unit, normal_font);
tableBody.AddCell(cellBodyLeftNoBorder);
cellBodyRight.Phrase = new Phrase(string.Format("{0:n2}", item.price), normal_font);
tableBody.AddCell(cellBodyRight);
cellBodyRight.Phrase = new Phrase(string.Format("{0:n2}", item.price * item.quantity), normal_font);
tableBody.AddCell(cellBodyRight);
}
double totalPrice = viewModel.items.Sum(a => a.quantity * a.price);
double ppn = 0;
if (viewModel.useVat)
{
ppn = totalPrice * 0.1;
}
double finalPrice = totalPrice + ppn;
cellBodyRight.Phrase = new Phrase("Dasar Pengenaan Pajak...............Rp.", normal_font);
cellBodyRight.Border = Rectangle.NO_BORDER;
cellBodyRight.Colspan = 6;
tableBody.AddCell(cellBodyRight);
cellBodyRightNoBorder.Phrase = new Phrase(string.Format("{0:n2}", totalPrice), normal_font);
cellBodyRightNoBorder.Border = Rectangle.NO_BORDER;
tableBody.AddCell(cellBodyRightNoBorder);
cellBodyRight.Phrase = new Phrase("PPN = 10% X Dasar Pengenaan Pajak...Rp.", normal_font);
tableBody.AddCell(cellBodyRight);
cellBodyRightNoBorder.Phrase = new Phrase(string.Format("{0:n2}", ppn), normal_font);
cellBodyRightNoBorder.Border = Rectangle.BOTTOM_BORDER;
tableBody.AddCell(cellBodyRightNoBorder);
cellBodyRight.Phrase = new Phrase("Jumlah..............................Rp.", normal_font);
tableBody.AddCell(cellBodyRight);
cellBodyRightNoBorder.Phrase = new Phrase(string.Format("{0:n2}", finalPrice), normal_font);
cellBodyRightNoBorder.Border = Rectangle.NO_BORDER;
tableBody.AddCell(cellBodyRightNoBorder);
tableBody.SpacingAfter = 10;
document.Add(tableBody);
#endregion
#region footer
PdfPTable tableFooter = new PdfPTable(4);
tableFooter.WidthPercentage = 100;
tableFooter.SetWidths(new float[] { 2f, 3f, 2f, 3f });
PdfPCell cellFooterContent1 = new PdfPCell()
{
Border = Rectangle.NO_BORDER
};
PdfPCell cellFooterContent2 = new PdfPCell()
{
Border = Rectangle.NO_BORDER
};
PdfPCell cellFooterContent3 = new PdfPCell()
{
Border = Rectangle.NO_BORDER
};
PdfPCell cellFooterContent4 = new PdfPCell()
{
Border = Rectangle.NO_BORDER
};
cellFooterContent1.Phrase = new Phrase("No Sales Contract :", normal_font);
tableFooter.AddCell(cellFooterContent1);
cellFooterContent2.Phrase = new Phrase(viewModel.salesContractNo, normal_font);
tableFooter.AddCell(cellFooterContent2);
cellFooterContent3.Phrase = new Phrase("No Bon Keluar :", normal_font);
tableFooter.AddCell(cellFooterContent3);
cellFooterContent4.Phrase = new Phrase(viewModel.expenditureNo, normal_font);
tableFooter.AddCell(cellFooterContent4);
cellFooterContent1.Phrase = new Phrase("No Disposisi :", normal_font);
tableFooter.AddCell(cellFooterContent1);
cellFooterContent2.Phrase = new Phrase(string.IsNullOrWhiteSpace(viewModel.dispositionNo) ? "-" : viewModel.dispositionNo, normal_font);
tableFooter.AddCell(cellFooterContent2);
cellFooterContent3.Phrase = new Phrase("No Bea Cukai :", normal_font);
tableFooter.AddCell(cellFooterContent3);
cellFooterContent4.Phrase = new Phrase(cl == null ? "-" : cl.bcNo, normal_font);
tableFooter.AddCell(cellFooterContent4);
cellFooterContent1.Phrase = new Phrase("Tempo Pembayaran :", normal_font);
tableFooter.AddCell(cellFooterContent1);
cellFooterContent2.Phrase = new Phrase(viewModel.tempo + " Hari", normal_font);
tableFooter.AddCell(cellFooterContent2);
cellFooterContent3.Phrase = (new Phrase("Tanggal J/T :", normal_font));
tableFooter.AddCell(cellFooterContent3);
cellFooterContent4.Phrase = (new Phrase(viewModel.date.GetValueOrDefault().AddDays(viewModel.tempo).ToOffset(new TimeSpan(timeoffset, 0, 0)).ToString("dd MMMM yyyy", new System.Globalization.CultureInfo("id-ID")), normal_font));
tableFooter.AddCell(cellFooterContent4);
document.Add(tableFooter);
#endregion
#region footer1
PdfPTable tableFooter1 = new PdfPTable(2);
tableFooter1.WidthPercentage = 100;
tableFooter1.SetWidths(new float[] { 1.5f, 9f });
PdfPCell cellFooterContent11 = new PdfPCell()
{
Border = Rectangle.NO_BORDER
};
PdfPCell cellFooterContent21 = new PdfPCell()
{
Border = Rectangle.NO_BORDER
};
string terbilang = NumberToTextIDN.terbilang(Math.Round(finalPrice, 2));
cellFooterContent11.Phrase = (new Phrase("Terbilang :", normal_font));
tableFooter1.AddCell(cellFooterContent11);
cellFooterContent21.Phrase = (new Phrase(terbilang + " rupiah", normal_font));
tableFooter1.AddCell(cellFooterContent21);
cellFooterContent11.Phrase = (new Phrase("Catatan :", normal_font));
tableFooter1.AddCell(cellFooterContent11);
cellFooterContent21.Phrase = (new Phrase(viewModel.remark, normal_font));
tableFooter1.AddCell(cellFooterContent21);
tableFooter1.SpacingAfter = 4;
document.Add(tableFooter1);
#endregion
document.Add(new Paragraph("HARAP TRANSFER PEMBAYARAN DIATAS KEPADA BANK KORESPONDEN KAMI SEBAGAI BERIKUT :", normal_font));
document.Add(new Paragraph("MAYBANK INDONESIA - CABANG SLAMET RIYADI", normal_font));
document.Add(new Paragraph("ACC NO. : 2105010887 A/N : PT. DAN LIRIS", normal_font));
document.Add(new Paragraph(" ", normal_font));
#region sign
PdfPTable tableSign = new PdfPTable(5);
tableSign.WidthPercentage = 80;
tableSign.SetWidths(new float[] { 1f, 1f, 1f, 1f, 1f });
PdfPCell cellBodySign = new PdfPCell()
{
Border = Rectangle.BOTTOM_BORDER | Rectangle.TOP_BORDER | Rectangle.LEFT_BORDER | Rectangle.RIGHT_BORDER, HorizontalAlignment = Element.ALIGN_CENTER
};
PdfPCell cellBodySignNoBorder = new PdfPCell()
{
Border = Rectangle.NO_BORDER, HorizontalAlignment = Element.ALIGN_CENTER
};
cellBodySign.Phrase = new Phrase("Diterima Oleh", normal_font);
tableSign.AddCell(cellBodySign);
cellBodySignNoBorder.Phrase = new Phrase("", normal_font);
tableSign.AddCell(cellBodySignNoBorder);
cellBodySign.Phrase = new Phrase("Dibuat Oleh", normal_font);
tableSign.AddCell(cellBodySign);
cellBodySign.Phrase = new Phrase("Diperiksa Oleh", normal_font);
tableSign.AddCell(cellBodySign);
cellBodySign.Phrase = new Phrase("Disetujui Oleh", normal_font);
tableSign.AddCell(cellBodySign);
cellBodySign.Phrase = new Phrase("\n\n\n", normal_font);
tableSign.AddCell(cellBodySign);
cellBodySignNoBorder.Phrase = new Phrase("\n\n\n", normal_font);
tableSign.AddCell(cellBodySignNoBorder);
cellBodySign.Phrase = new Phrase("\n\n\n", normal_font);
tableSign.AddCell(cellBodySign);
cellBodySign.Phrase = new Phrase("\n\n\n", normal_font);
tableSign.AddCell(cellBodySign);
cellBodySign.Phrase = new Phrase("\n\n\n", normal_font);
tableSign.AddCell(cellBodySign);
document.Add(tableSign);
#endregion
//document.Add(new Phrase("Model DL1",normal_font));
document.Close();
byte[] byteInfo = stream.ToArray();
stream.Write(byteInfo, 0, byteInfo.Length);
stream.Position = 0;
return(stream);
}
private GarmentShippingLocalSalesNoteViewModel MapToViewModel(GarmentShippingLocalSalesNoteModel model)
{
GarmentShippingLocalSalesNoteViewModel viewModel = new GarmentShippingLocalSalesNoteViewModel
{
Active = model.Active,
Id = model.Id,
CreatedAgent = model.CreatedAgent,
CreatedBy = model.CreatedBy,
CreatedUtc = model.CreatedUtc,
DeletedAgent = model.DeletedAgent,
DeletedBy = model.DeletedBy,
DeletedUtc = model.DeletedUtc,
IsDeleted = model.IsDeleted,
LastModifiedAgent = model.LastModifiedAgent,
LastModifiedBy = model.LastModifiedBy,
LastModifiedUtc = model.LastModifiedUtc,
noteNo = model.NoteNo,
date = model.Date,
transactionType = new TransactionType
{
id = model.TransactionTypeId,
code = model.TransactionTypeCode,
name = model.TransactionTypeName
},
buyer = new Buyer
{
Id = model.BuyerId,
Code = model.BuyerCode,
Name = model.BuyerName,
npwp = model.BuyerNPWP,
KaberType = model.KaberType
},
tempo = model.Tempo,
expenditureNo = model.ExpenditureNo,
dispositionNo = model.DispositionNo,
useVat = model.UseVat,
remark = model.Remark,
isUsed = model.IsUsed,
localSalesContractId = model.LocalSalesContractId,
salesContractNo = model.SalesContractNo,
paymentType = model.PaymentType,
isRejectedFinance = model.IsRejectedFinance,
isRejectedShipping = model.IsRejectedShipping,
isApproveFinance = model.IsApproveFinance,
isApproveShipping = model.IsApproveShipping,
rejectedReason = model.RejectedReason,
approveFinanceBy = model.ApproveFinanceBy,
approveFinanceDate = model.ApproveFinanceDate,
approveShippingBy = model.ApproveShippingBy,
approveShippingDate = model.ApproveShippingDate,
items = (model.Items ?? new List <GarmentShippingLocalSalesNoteItemModel>()).Select(i => new GarmentShippingLocalSalesNoteItemViewModel
{
Active = i.Active,
Id = i.Id,
CreatedAgent = i.CreatedAgent,
CreatedBy = i.CreatedBy,
CreatedUtc = i.CreatedUtc,
DeletedAgent = i.DeletedAgent,
DeletedBy = i.DeletedBy,
DeletedUtc = i.DeletedUtc,
IsDeleted = i.IsDeleted,
LastModifiedAgent = i.LastModifiedAgent,
LastModifiedBy = i.LastModifiedBy,
LastModifiedUtc = i.LastModifiedUtc,
product = new ProductViewModel
{
id = i.ProductId,
code = i.ProductCode,
name = i.ProductName
},
quantity = i.Quantity,
uom = new UnitOfMeasurement
{
Id = i.UomId,
Unit = i.UomUnit
},
packageQuantity = i.PackageQuantity,
packageUom = new UnitOfMeasurement
{
Id = i.PackageUomId,
Unit = i.PackageUomUnit
},
price = i.Price,
localSalesContractItemId = i.LocalSalesContractItemId
}).ToList()
};
return(viewModel);
}
public async Task <int> RejectedFinance(int id, GarmentShippingLocalSalesNoteViewModel viewModel)
{
var model = MapToModel(viewModel);
return(await _repository.RejectFinanceAsync(id, model));
}
public async Task <int> Update(int id, GarmentShippingLocalSalesNoteViewModel viewModel)
{
var model = MapToModel(viewModel);
return(await _repository.UpdateAsync(id, model));
}
