Пример #1
0
        public async Task <int> Create(GarmentShippingLocalSalesDOViewModel viewModel)
        {
            GarmentShippingLocalSalesDOModel garmentShippingLocalSalesDOModel = MapToModel(viewModel);

            int Created = await _repository.InsertAsync(garmentShippingLocalSalesDOModel);

            return(Created);
        }
Пример #2
0
        private string GenerateNo(GarmentShippingLocalSalesDOViewModel viewModel)
        {
            var year = DateTime.Now.ToString("yy");

            var prefix = $"DL/DOPL/{year}";

            var lastNo = _repository.ReadAll().Where(w => w.LocalSalesDONo.StartsWith(prefix))
                         .OrderByDescending(o => o.LocalSalesDONo)
                         .Select(s => int.Parse(s.LocalSalesDONo.Replace(prefix, "")))
                         .FirstOrDefault();
            var invoiceNo = $"{prefix}{(lastNo + 1).ToString("D5")}";

            return(invoiceNo);
        }
Пример #3
0
        private GarmentShippingLocalSalesDOModel MapToModel(GarmentShippingLocalSalesDOViewModel viewModel)
        {
            var items = (viewModel.items ?? new List <GarmentShippingLocalSalesDOItemViewModel>()).Select(i =>
            {
                i.uom     = i.uom ?? new UnitOfMeasurement();
                i.product = i.product ?? new ProductViewModel();
                return(new GarmentShippingLocalSalesDOItemModel(i.localSalesDOId, i.localSalesNoteItemId, i.product.id, i.product.code, i.product.name, i.description, i.quantity, i.uom.Id.GetValueOrDefault(), i.uom.Unit, i.packQuantity, i.packUom.Id.GetValueOrDefault(), i.packUom.Unit, i.grossWeight, i.nettWeight)
                {
                    Id = i.Id
                });
            }).ToList();

            viewModel.buyer          = viewModel.buyer ?? new Buyer();
            viewModel.localSalesDONo = GenerateNo(viewModel);
            GarmentShippingLocalSalesDOModel garmentPackingListModel = new GarmentShippingLocalSalesDOModel(viewModel.localSalesDONo, viewModel.localSalesNoteNo, viewModel.localSalesNoteId, viewModel.date, viewModel.buyer.Id, viewModel.buyer.Code, viewModel.buyer.Name, viewModel.to, viewModel.storageDivision, viewModel.remark, items);

            return(garmentPackingListModel);
        }
Пример #4
0
        private GarmentShippingLocalSalesDOViewModel MapToViewModel(GarmentShippingLocalSalesDOModel model)
        {
            var vm = new GarmentShippingLocalSalesDOViewModel()
            {
                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,

                localSalesDONo = model.LocalSalesDONo,

                buyer = new Buyer
                {
                    Id   = model.BuyerId,
                    Code = model.BuyerCode,
                    Name = model.BuyerName,
                },
                date             = model.Date,
                localSalesNoteNo = model.LocalSalesNoteNo,
                localSalesNoteId = model.LocalSalesNoteId,
                to = model.To,
                storageDivision = model.StorageDivision,
                remark          = model.Remark,
                items           = model.Items == null ? new List <GarmentShippingLocalSalesDOItemViewModel>() : model.Items.Select(i => new GarmentShippingLocalSalesDOItemViewModel
                {
                    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
                    },
                    description = i.Description,
                    quantity    = i.Quantity,
                    uom         = new UnitOfMeasurement
                    {
                        Id   = i.UomId,
                        Unit = i.UomUnit
                    },
                    packQuantity = i.PackQuantity,
                    packUom      = new UnitOfMeasurement
                    {
                        Id   = i.PackUomId,
                        Unit = i.PackUomUnit
                    },
                    localSalesDOId       = i.LocalSalesDOId,
                    grossWeight          = i.GrossWeight,
                    nettWeight           = i.NettWeight,
                    localSalesNoteItemId = i.LocalSalesNoteItemId
                }).ToList()
            };

            return(vm);
        }
Пример #5
0
        public async Task <int> Update(int id, GarmentShippingLocalSalesDOViewModel viewModel)
        {
            GarmentShippingLocalSalesDOModel garmentShippingLocalSalesDOModel = MapToModel(viewModel);

            return(await _repository.UpdateAsync(id, garmentShippingLocalSalesDOModel));
        }
        public MemoryStream GeneratePdfTemplate(GarmentShippingLocalSalesDOViewModel viewModel, int timeoffset)
        {
            const int MARGIN = 20;

            Font header_font_bold_big        = FontFactory.GetFont(BaseFont.HELVETICA_BOLD, BaseFont.CP1250, BaseFont.NOT_EMBEDDED, 12);
            Font header_font_bold            = FontFactory.GetFont(BaseFont.HELVETICA_BOLD, BaseFont.CP1250, BaseFont.NOT_EMBEDDED, 9);
            Font header_font_bold_underlined = FontFactory.GetFont(BaseFont.HELVETICA_BOLD, BaseFont.CP1250, BaseFont.NOT_EMBEDDED, 10, Font.UNDERLINE);
            Font header_font            = FontFactory.GetFont(BaseFont.HELVETICA, BaseFont.CP1250, BaseFont.NOT_EMBEDDED, 11);
            Font normal_font            = FontFactory.GetFont(BaseFont.HELVETICA, BaseFont.CP1250, BaseFont.NOT_EMBEDDED, 8);
            Font normal_font_underlined = FontFactory.GetFont(BaseFont.HELVETICA, BaseFont.CP1250, BaseFont.NOT_EMBEDDED, 8, Font.UNDERLINE);
            Font bold_font             = FontFactory.GetFont(BaseFont.HELVETICA_BOLD, BaseFont.CP1250, BaseFont.NOT_EMBEDDED, 8);
            Font small_font            = FontFactory.GetFont(BaseFont.HELVETICA, BaseFont.CP1250, BaseFont.NOT_EMBEDDED, 7);
            Font small_font_underlined = FontFactory.GetFont(BaseFont.HELVETICA, BaseFont.CP1250, BaseFont.NOT_EMBEDDED, 7, Font.UNDERLINE);
            //Font body_bold_font = FontFactory.GetFont(BaseFont.HELVETICA_BOLD, BaseFont.CP1250, BaseFont.NOT_EMBEDDED, 8);

            Document     document = new Document(PageSize.A5, 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[] { 2f, 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_big));
            cellHeaderContent1.AddElement(new Phrase("Head Office : Jl. Merapi No 23", small_font));
            cellHeaderContent1.AddElement(new Phrase("Banaran, Grogol, Sukoharjo, 57193", small_font));
            cellHeaderContent1.AddElement(new Phrase("Central Java, Indonesia", small_font));
            cellHeaderContent1.AddElement(new Phrase("Phone : (+62 271) 740888, 714400", small_font));
            cellHeaderContent1.AddElement(new Phrase("Fax : (+62 271) 740777, 735222", small_font));
            cellHeaderContent1.AddElement(new Phrase("PO BOX 166 Solo, 57100", small_font));
            cellHeaderContent1.AddElement(new Phrase("www.danliris.com", small_font));
            cellHeaderContent1.AddElement(new Phrase("\n", normal_font));
            cellHeaderContent1.AddElement(new Phrase(viewModel.localSalesDONo, bold_font));
            tableHeader.AddCell(cellHeaderContent1);

            cellHeaderContent2.AddElement(new Phrase("Surakarta, " + viewModel.date.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("Kepada", normal_font));
            cellHeaderContent2.AddElement(new Phrase("Yth. Sdr. " + viewModel.to, small_font));
            cellHeaderContent2.AddElement(new Phrase("Bag. Gudang " + viewModel.storageDivision, small_font));
            cellHeaderContent2.AddElement(new Phrase("Export/Banaran ", small_font));
            cellHeaderContent2.AddElement(new Phrase("\n", normal_font));
            cellHeaderContent2.AddElement(new Phrase("D.O. Penjualan Lokal", header_font_bold_underlined));
            cellHeaderContent2.AddElement(new Phrase("\n", normal_font));
            cellHeaderContent2.AddElement(new Phrase("Untuk melengkapi nota No. ", small_font));
            cellHeaderContent2.AddElement(new Phrase("Harap dikeluarkan barang-barang tersebut dibawah ini.", small_font));
            tableHeader.AddCell(cellHeaderContent2);

            tableHeader.SpacingAfter = 15;
            document.Add(tableHeader);
            #endregion

            #region tableBody
            PdfPTable tableBody = new PdfPTable(8);
            tableBody.WidthPercentage = 100;
            tableBody.SetWidths(new float[] { 1f, 5f, 3f, 2.5f, 2.5f, 3f, 2.5f, 2.5f });

            PdfPCell cellBodyLeft = new PdfPCell()
            {
                Border = Rectangle.BOTTOM_BORDER | Rectangle.TOP_BORDER | Rectangle.LEFT_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 cellBodyCenter = new PdfPCell()
            {
                Border = Rectangle.BOTTOM_BORDER | Rectangle.TOP_BORDER | Rectangle.LEFT_BORDER | Rectangle.RIGHT_BORDER, HorizontalAlignment = Element.ALIGN_CENTER
            };

            cellBodyCenter.Phrase  = new Phrase("No", normal_font);
            cellBodyCenter.Rowspan = 3;
            tableBody.AddCell(cellBodyCenter);

            cellBodyCenter.Phrase = new Phrase("NAMA", normal_font);
            tableBody.AddCell(cellBodyCenter);

            cellBodyCenter.Phrase = new Phrase("Jenis/Kode", normal_font);
            tableBody.AddCell(cellBodyCenter);

            cellBodyCenter.Phrase  = new Phrase("BANYAKNYA", normal_font);
            cellBodyCenter.Rowspan = 1;
            cellBodyCenter.Colspan = 5;
            tableBody.AddCell(cellBodyCenter);

            cellBodyCenter.Phrase  = new Phrase("Jumlah", normal_font);
            cellBodyCenter.Rowspan = 2;
            cellBodyCenter.Colspan = 1;
            tableBody.AddCell(cellBodyCenter);

            cellBodyCenter.Phrase = new Phrase("Satuan", normal_font);
            tableBody.AddCell(cellBodyCenter);

            cellBodyCenter.Phrase = new Phrase("Jumlah\nKemasan", normal_font);
            tableBody.AddCell(cellBodyCenter);

            cellBodyCenter.Phrase  = new Phrase("Weight", normal_font);
            cellBodyCenter.Rowspan = 1;
            cellBodyCenter.Colspan = 2;
            tableBody.AddCell(cellBodyCenter);

            cellBodyCenter.Phrase  = new Phrase("Gross", normal_font);
            cellBodyCenter.Rowspan = 1;
            cellBodyCenter.Colspan = 1;
            tableBody.AddCell(cellBodyCenter);

            cellBodyCenter.Phrase = new Phrase("Nett", normal_font);
            tableBody.AddCell(cellBodyCenter);

            int index = 0;
            foreach (var item in viewModel.items)
            {
                index++;
                cellBodyLeft.Phrase = new Phrase($"{index}", normal_font);
                tableBody.AddCell(cellBodyLeft);

                cellBodyLeft.Phrase = new Phrase(item.product.name, normal_font);
                tableBody.AddCell(cellBodyLeft);

                cellBodyLeft.Phrase = new Phrase(item.description, normal_font);
                tableBody.AddCell(cellBodyLeft);

                cellBodyRight.Phrase = new Phrase(string.Format("{0:n2}", item.quantity), normal_font);
                tableBody.AddCell(cellBodyRight);

                cellBodyLeft.Phrase = new Phrase(item.uom.Unit, normal_font);
                tableBody.AddCell(cellBodyLeft);

                cellBodyRight.Phrase = new Phrase(string.Format("{0:n2}", item.packQuantity) + " " + item.packUom.Unit, normal_font);
                tableBody.AddCell(cellBodyRight);

                cellBodyRight.Phrase = new Phrase(string.Format("{0:n2}", item.grossWeight), normal_font);
                tableBody.AddCell(cellBodyRight);

                cellBodyRight.Phrase = new Phrase(string.Format("{0:n2}", item.nettWeight), normal_font);
                tableBody.AddCell(cellBodyRight);
            }

            double totalQty = viewModel.items.Sum(a => a.quantity);
            double totalCtn = viewModel.items.Sum(a => a.packQuantity);
            double totalGW  = viewModel.items.Sum(a => a.grossWeight);
            double totalNW  = viewModel.items.Sum(a => a.nettWeight);

            cellBodyRight.Phrase  = new Phrase("Jumlah", normal_font);
            cellBodyRight.Colspan = 3;
            tableBody.AddCell(cellBodyRight);

            cellBodyRight.Phrase  = new Phrase(string.Format("{0:n2}", totalQty), normal_font);
            cellBodyRight.Colspan = 1;
            tableBody.AddCell(cellBodyRight);

            cellBodyRight.Phrase = new Phrase("", normal_font);
            tableBody.AddCell(cellBodyRight);

            cellBodyRight.Phrase = new Phrase(string.Format("{0:n2}", totalCtn), normal_font);
            tableBody.AddCell(cellBodyRight);

            cellBodyRight.Phrase = new Phrase(string.Format("{0:n2}", totalGW), normal_font);
            tableBody.AddCell(cellBodyRight);

            cellBodyRight.Phrase = new Phrase(string.Format("{0:n2}", totalNW), normal_font);
            tableBody.AddCell(cellBodyRight);

            tableBody.SpacingAfter = 15;
            document.Add(tableBody);
            #endregion

            document.Add(new Paragraph("Untuk bagian / dikirim kepada " + viewModel.buyer.Name, normal_font));

            document.Add(new Paragraph("Keterangan : \n" + viewModel.remark, normal_font));
            document.Add(new Paragraph("\n", normal_font));
            #region sign
            PdfPTable tableSign = new PdfPTable(4);
            tableSign.WidthPercentage = 100;
            tableSign.SetWidths(new float[] { 1f, 1f, 1f, 3f });

            PdfPCell cellSignBorder = new PdfPCell()
            {
                Border = Rectangle.BOTTOM_BORDER | Rectangle.TOP_BORDER | Rectangle.LEFT_BORDER | Rectangle.RIGHT_BORDER, HorizontalAlignment = Element.ALIGN_CENTER
            };
            PdfPCell cellSignNoBorder = new PdfPCell()
            {
                Border = Rectangle.LEFT_BORDER, HorizontalAlignment = Element.ALIGN_CENTER
            };

            cellSignBorder.Phrase = new Phrase("Penjualan", normal_font);
            tableSign.AddCell(cellSignBorder);

            cellSignBorder.Phrase = new Phrase("Bag.Akuntansi", normal_font);
            tableSign.AddCell(cellSignBorder);

            cellSignBorder.Phrase = new Phrase("Gudang", normal_font);
            tableSign.AddCell(cellSignBorder);

            cellSignNoBorder.Phrase = new Phrase("Terima Kasih", normal_font);
            tableSign.AddCell(cellSignNoBorder);

            cellSignBorder.Phrase = new Phrase("\n\n\n\n", normal_font);
            tableSign.AddCell(cellSignBorder);

            cellSignBorder.Phrase = new Phrase("\n\n\n\n", normal_font);
            tableSign.AddCell(cellSignBorder);

            cellSignBorder.Phrase = new Phrase("\n\n\n\n", normal_font);
            tableSign.AddCell(cellSignBorder);

            cellSignNoBorder.Phrase = new Phrase("Bagian Shipping\n\n\n", normal_font);
            tableSign.AddCell(cellSignNoBorder);

            cellSignBorder.Phrase = new Phrase("", normal_font);
            tableSign.AddCell(cellSignBorder);

            cellSignBorder.Phrase = new Phrase("", normal_font);
            tableSign.AddCell(cellSignBorder);

            cellSignBorder.Phrase = new Phrase("", normal_font);
            tableSign.AddCell(cellSignBorder);

            cellSignNoBorder.Phrase = new Phrase("(___________________________)", normal_font);
            tableSign.AddCell(cellSignNoBorder);

            document.Add(tableSign);

            document.Add(new Phrase("Model DL 3b", normal_font));
            #endregion

            document.Close();
            byte[] byteInfo = stream.ToArray();
            stream.Write(byteInfo, 0, byteInfo.Length);
            stream.Position = 0;

            return(stream);
        }