Пример #1
0
        public ActionResult gen(string id) //id is purchase order number
        {
            int orderNo = Int32.Parse(id);
            Purchase_Order_Record por = pos.FindByOrderID(orderNo);

            Inventory_mvc.Models.User clerk = ctx.Users.Where(x => x.userID == por.clerkID).First();

            Supplier s = ctx.Suppliers.Where(x => x.supplierCode == por.supplierCode).First();

            ViewBag.orderNo   = id;
            ViewBag.clerkID   = por.clerkID;
            ViewBag.clerkName = clerk.name;
            ViewBag.supplier  = s.supplierName;
            ViewBag.delivery  = por.expectedDeliveryDate;

            List <Purchase_Detail> model = ctx.Purchase_Detail.Where(x => x.orderNo == orderNo).ToList();

            return(View(model));
        }
Пример #2
0
        public ActionResult GeneratePDF(string id) //id is purchase order number
        {
            int orderNo = Int32.Parse(id);
            Purchase_Order_Record por = pos.FindByOrderID(orderNo);

            Inventory_mvc.Models.User clerk = ctx.Users.Where(x => x.userID == por.clerkID).First();

            Supplier s = ctx.Suppliers.Where(x => x.supplierCode == por.supplierCode).First();

            ViewBag.orderNo   = id;
            ViewBag.clerkID   = por.clerkID;
            ViewBag.clerkName = clerk.name;
            ViewBag.supplier  = s.supplierName;
            ViewBag.delivery  = por.expectedDeliveryDate;

            List <Purchase_Detail> model = ctx.Purchase_Detail.Where(x => x.orderNo == orderNo).ToList();

            string fileName = String.Format("{0}_PO_{1}.pdf", s.supplierCode, id);

            return(new ViewAsPdf("_GeneratePDF", model)
            {
                FileName = fileName
            });
        }